Question: The first answer is 43.26 and then 11.39. Please explain in excel with formulas if possible. Thank you! 9) Last month, Lloyd's Systems analyzed the

The first answer is 43.26 and then 11.39. Please explain in excel with formulas if possible. Thank you!
9) Last month, Lloyd's Systems analyzed the project whose cash flows are shown below. However, before the decision to accept or reject the project, the Federal Reserve took actions that changed interest rates and therefore the firm's WACC. The Fed's action did not affect the forecasted cash flows. By how much did the change in the WACC affect the project's forecasted NPV? Note that a project's projected NPV can be negative, in which case it should be rejected. New WACC: 12.50% Old WACC: 10.00% Year0 Cash flows $1,000 $410 $410 $410 A. -$43.26 B. $44.12 C. $48.02 D. $39.80 E. $47.15 12) Consider the following information and then calculate the required rate of return for the Global Investment Fund, which holds 4 stocks. The market's required rate of return is 14.00%, the risk-free rate is 3.00%, and the Fund's assets are as follows: Stock Investment Beta 1.50 -0.50 200,000 300,000 500,000 $1,000,000 1.25 0.75 A. 12.64% B. 11.39% C. 11.05% D. 10.13% E. 11.73%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
