Present Value Calc

I feel like I’m missing something simple here but have not been able to figure this out. Thanks in advance for any help.

Level 1 Volume 5 2013 Curriculum

Page 646, Reading 56 section 4.1 “Valuation Using Treasury Spot Rates”

At the bottom of Exhibit 5 it gives the formula for present value of the cash flow as

PV = CF/(1 + spot rate/2) period

Starting in Exhibit 5 with Period 2 here is what I am doing calculation wise

CF = 4

spot rate = 3.3 and spot rate/2 = 1.65

period = 2

denominator = 1 + 1.65 x 2 = 7.02

numerator = 4

calculation I get (4/7.02) = 0.57

I have tried multiple combinations and cannot get this to work. What am I missing? Thanks in advance!!

I don’t have the 2013 curriculum to check, but I can tell your denominator is off. You’re not treating your spot rate as a percent; use 1 + 0.0165. Your denominator should be about 1.0333 = (1.0165)^2. Also you wrote it out as multiplying by two, but working it out you did correctly use 2 as an exponent, just be careful you don’t make that mistake on the exam.

jwn566, that was the exact issue!! I was entering the spot rate as a nonpercentage. (I should have known from the readings to treat it AS a percent (rate–doh!!), but am just getting familiar with using it). Going down exhibit 5 I am now able to come up with the same PV as in the table. Yes, I was using the “period” as an exponent but couldn’t figure out how to demonstrate that in the question–there is probably a mathematical symbol I’m not familiar with.

This was really helpful. The Fixed Income section has been going really really well for me up to this point–I think it is the best written of all the Level 1 books–and this was the first true wall I hit–always hard for me to let myself just move on when I hit walls, so now it’s full steam ahead!! Thanks again for the quick and detailed reply.

Chip

No problem ChipM. And FYI the symbol ^ (Shift+6 on your keyboard), is how you perform exponent operations in Excel.