Question: Show all steps in Excel with formula 1)Suppose the current one-year interest rate is 0.25%. One year from now, you believe the economy will start
Show all steps in Excel with formula 1)Suppose the current one-year interest rate is 0.25%. One year from now, you believe the economy will start to recover and the one-year interest rate increase to 0.75%. In two years, you expect the economy to be in the midst of recovery, causing the Federal Reserve to increase interest rates and the one-year interest rate to increase to 1.5%. The one-year interest rate will then rise to 3% the following year, and continue to rise by 1% per year until it returns to 5%, where it will remain from then on.
If you were certain regarding these future interest rate changes, what two-year interest rate would be consistent with these expectations? 2)If you were certain regarding these future interest rate changes, what three-year interest rate would be consistent with these expectations?
| Term | 1 year | 2 years | 3 years | 4 years | 5 years | 6 years | 7 years | 8 years | 9years |
| Rate (EAR%) | 0,25% | 0,75% | 1,5% | 3% | 4% | 5% | 5% | 5% | 5% |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
