P1.Valuation tuckman - learning spreadsheet

[jamesphang]

Hi forum admin/friends of bionic turtle,

I am not able to locate the learning spreadsheet for part 1 valuation tuckman.
Please direct me to the appropriate link please. Many thanks.

Cheers,
James

 

[David Harper CFA FRM]

Hi @jamesphang sorry for the delay: this spreadsheet for 2014 has not been published yet. I tagged this forum post to update you when we do publish it. Thanks,

 

[Brian_no9]

Hi David,

I am looking at the Tuckman excel spreadsheets, and the example that addresses Duration and Semi-Annual Compounding.

The calculation for the discount factor is kinda puzzling as it is given by 1/(1+Semi-Annual Yield)^n.
Where n is 1 for six months, 2 for 12 months, etc.. till 20 for year 10.

However the definition in both Hull and Tuckman defines the discount factor as 1/(1+Semi-Annual Yield)^mn
Where m = 2 and n = 10.

Will you please explain why the discount factor is not m(n) for all the cashflows?

Kind regards,
Brian

 

[David Harper CFA FRM]

Hi @Brian_no9

Sorry, I am not sure where you are getting your second reference from: "However the definition in both Hull and Tuckman defines the discount factor as 1/(1+Semi-Annual Yield)^mn"?

Perhaps sheets 4.c.3 could be better labelled but they look okay to me (as i scan them).
This is reliable: DF = 1/(1+yield/m)^(m*n)

Because it handles any k:

• if m = 1 (i.e., annual compounding), then DF = 1/(1+yield)^n
• if m = 2 (i.e., semi-annual compounding), then DF = 1/(1+yield/2)^(n*2)

So in one sheet the "semi-annual yield" refers to yield/2 (cell 15; e.g., yield is 6% such that "semi-annual yield" is 3%) and year 10 is given by 10*2 = 20, such that 1/(1+Semi-Annual Yield)^n is consistent with 1/(1+yield/2)^(n*2) but the (n) is probably confusing in that case (at the time, I think it did match the author's usage because n = 20 is true as the number of periods, when years are 10 and k = 2). So, I don't perceive there to be any fundamental definitional inconsistency. F = 1/(1+yield/m)^(m*n) is reliable it's just that:

• yields is annual but yield/m is per the period and, in that XLS, is called "semi-annual yield." This is exactly why per annum rates (volatility, yield) are the convention upon input and output, it gets easily confusing otherwise.
• And when k = 2 over T = 10 years, then n = 20, but I am relieved I use (n) and not (T). It would be wrong to use (T). I hope that explains!

 

[Brian_no9]

Thats great David. Many thanks for all your help,
Brian.

 

[NNath]

Hi David, T4.Tuckman.5 learning spreadsheet is not published ?

 

[David Harper CFA FRM]

Hi @NNath That's correct. Currently, the Tuckman spreadsheets are found under the Topic Review, specifically T4.c. @ https://learn.bionicturtle.com/frm-...rials/learning-spreadsheet-p1.t4.c-xls-bundle
... but this semester, as we record new videos, we will be locating a reading-specific XLS into the specific reading "folder" (which, as you point out, does not currently contain an XLS). Thanks,