Using Excel and all Formulas. Asset valuation and risk Personal Finance Problem. Laura Drake wishes to estimate the value of an asset expected to provide cash inflows of $3,200 per year at the end of years 1 through 4 and $16,097 at the end of year 5. Her research indicates that she must earn 99?% on? low-risk assets, 1313?% on?average-risk assets, and 1919?% on? high-risk assets.
a. Determine what is the most Laura should pay for the asset if it is classified as? (1) low-risk,? (2) average-risk, and? (3) high-risk.
b. Suppose Laura is unable to assess the risk of the asset and wants to be certain? she's making a good deal. On the basis of your findings in part a?, what is the most she should? pay? Why?
c. All else being the? same, what effect does increasing risk have on the value of an? asset? Explain in light of your findings in part a.