Assume that the one-year rate (short-term) over the next 3 years are 2023: 4% 2024: 5% 2025: 6% (1) Use the expectations theory to calculate the two-year rate (long-term) and the three-year rate (long-term). (2) Draw a yield curve.

You had the following rates of return for on your portfolio for the last four years: 2019:  -10.1%2020:  15.4%2021:    7.3%2022:   12.8%Calculate the geometric average return on your portfolio.  Enter your answer as a decimal, rounded to four decimal places.

Suppose that the current 1-year rate (1-year spot rate) and expected 1-year T-bill rates over the following three years (i.e., years 2, 3, and 4, respectively) are as follows: 1R1 = 6%,  E(2r1) = 7%, E(3r1) = 7.60%, E(4r1) = 7.95% Using the unbiased expectations theory, calculate the current (long-term) rates for one-, two-, three-, and four-year-maturity Treasury securities. (Round your answers to 2 decimal places.)

DONE IN EXCEL especify how to donthe graph step by step okease 5. (a) Use rate of return analysis to decide which one will you select if your MARR is 14% per year? (b) Graph interest rate vs. present value for both option 1 and 2. (c) Discuss how your selection between option 1 and 2 will change when MARR is changed and at which interest rate the two options are the same economically. The following two alternatives are mutually exclusive. Annual Benefit Salvage Value Alternative Initial Life, Cost years 4. Option 1 Option 2 $42,000 $45,000 $10,000 $11,500 $4,000 $4,200 6.