The first answer is 43.26 and then 11.39. Please explain in excel with formulas if...

50.1K

Verified Solution

Question

Finance

imageimageThe 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%

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students