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.

*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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!