Question: Please answer the question below using excel or the formulas below with an finance calculator Thank you A firm has a WACC of 12.31% and

A firm has a WACC of 12.31% and is deciding between two mutually exclusive projects. Project A has an initial investment of $63.89. The additional cash flows for project A are: year 1=$16.34, year 2= $37.80, year 3=$45.69. Project B has an initial investment of $74.71. The cash flows for project B are: year 1=$51.23, year 2=$46.80, year 3=$37.14. Calculate the Following: A. Payback Period for Project A: B. Payback Period for Project B: C. NPV for Project A: D. NPV for Project B: If you want to use formulas, listed below are some formulas commonly used in Constant Dividend Growth Model Calculations: 1) The price of the stock today (Po) assuming a dividend of Do paid today, a constant dividend growth rate 9 , and the required rate of return R Po=RgD1=RgD0(1+g) 2) For a period of high growth rate g1 for n years, followed by a constant growth rate g, the price of the stock Po is calculated as This satsfies the constant dividend growth rate modet
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
