NPV Valuation. 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 $109,000 for the firm during the first year, and the cash flows are projected to grow at a rate of 5.1 percent per year forever. The project requires an initial investment of $1,425,000.
a. If Yurdone requires a return of 12 percent on such undertakings, should the cemetery business be started?
b. The company is somewhat unsure about the assumption of a 5.1 percent growth rate in its cash flows. At what constant growth rate would the company just break even if it still required a return of 12 percent on its investment?.
I am having difficulties with calculations in excel for part b.
NPV(Net present value) is $154,710.14 which is positive, hence Yurdone should... View the full answer