Exercise
#2: Time Value of Money with Semi-Annual Compounding
|
Solution Commentary
Variable Assignments Present Value PV = 500 Rate r = 0.07 Years n = 4 Periods per Year p = 2 Future Value FV = ? Cash Flow
By convention for charting, Present Values are depicted as negative, reflecting
an initial investment outflow in return for future cash inflows.
Manual Solution FV = PV*(1+(r/p))np FV = 500*(1+(0.07/2))(4*2) FV = 500*1.0358 FV = 658.40 Excel Solution
Financial Calculator Solution
|
Solution Commentary
Variable Assignments Present Value PV = ? Payment PMT = 300 Discount Rate r = 0.08 Years n = 4 Cash Flow
By convention for charting, Present Values are depicted as negative, reflecting
an initial investment outflow in return for future cash inflows.
Manual Solution PV = (PMT/r)[1-(1/(1+r)n)] PV = (300/0.08)[1-(1/(1+0.08)4)] PV = 3,750.00*[1-(1/1.084)] PV = 3,750.00*[1-0.74] PV = 993.64 Excel Solution
Financial Calculator Solution
|
Solution Commentary
Variable Assignments Present Value PV = ? Rate r = 0.12 Years n = 5 Periods per Year p = 2 Future Value FV = 1,000 Coupon Rate = 0.10 Cash Flow By
convention for charting, Present Values are depicted as negative, reflecting an
initial investment outflow in return for future cash inflows.
Manual Solution We must separate the present value calculations for the interest payment annuity and the face value. PV of interest annuity = (PMT/(r/p))[1-(1/(1+(r/p))n*p)] PV of interest annuity = (50/(0.12/2))[1-(1/(1+(0.12/2))5*2)] PV of interest annuity = 833.33*[1-(1/1.0610.00)] PV of interest annuity = 833.33*[1-0.56] PV of interest annuity = 368.00 PV of face value = FV/(1+(r/p))np PV of face value = 1000/(1+(0.12/2))(5*2) PV of face value = 1000/1.06010 PV of face value = 558.39 PV of Bond = 926.40 Excel Solution
Financial Calculator Solution
|
|
© 2005-2010 DecisionClass, LLC |
About Us | MBA Quant Blog | Contact Us | Site Map | |||