Question: Please include the answer on an excel spreadsheet with step by step. Thank you!! The Yurgone Corporation wants to set up a private cemetery business.

Please include the answer on an excel spreadsheet with step by step. Thank you!!
The Yurgone 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 $127,000 for the firm during the first year, and the cash flows are projected to grow at a rate of 4 percent per year forever. The project requires an initial investment of $1,700,000. a. If Yurgone requires an 11 percent return on such undertakings, should the cemetery business be started? b. The company is somewhat unsure about the assumption of a growth rate of 4 percent in its cash flows. At what constant growth rate would the company just break even if it still required a return of 11 percent on the investment? Required: Complete the assessment of the cemetery project for Yurdone Corporation on paper or in Excel. (Hint: You will not need to find the present value of the cash flows, because of the growth rate. Think about when we discussed a constant growth rate forever in Chapter 8.]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
