Question: Please help me to solve this problem in Excel using financial functions. 65. Real versus Nominal Rates. You will receive $100 from a savings bond
Please help me to solve this problem in Excel using financial functions.
65. Real versus Nominal Rates. You will receive $100 from a savings bond in 3 years. The nominal interest rate is 8%. (LO5-5)
a. What is the present value of the proceeds from the bond?
b. If the inflation rate over the next few years is expected to be 3%, what will the real value of the $100 payoff be in terms of todays dollars?
c. What is the real interest rate?
d. Show that the real payoff from the bond [from part (b)] discounted at the real interest rate [from part (c)] gives the same present value for the bond as you found in part (a).
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
