Question: *Please show excel formulas on how you get the constant growth rate* The Yurdone Corporation wants to set up a private cemetery business. According to


*Please show excel formulas on how you get the constant growth rate*
The Yurdone Corporation wants to set up a private cemetery business. According to the CFO, Barry M. Deep, business is looking up". As a result, the cemetery project will provide a net cash inflow of $90,000 for the firm during the first year, and the cash flows are projected to grow at a rate of 5 percent per year forever. The project requires an initial investment of $1,430,000. The company is somewhat unsure about the assumption of a growth rate of 5 percent in its cash flows. At what constant growth rate would the company break even if it still required a return of 10 percent on investment? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
