The first answer is 43.26 and then 11.39. Please explain in excel with formulas if...
50.1K
Verified Solution
Link Copied!
Question
Finance
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%
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!
The first answer is 43.26 and then 11.39. Please explain in excel with formulas if possible. Thank you!