d)The owner of a cemetery plans to offer a perpetual care service for grave sites. The owner estimates that it will cost $150 pe
1 answer:
You might be interested in
Answer:
18.54%
Explanation:
The computation of the project modified IRR is shown below:
Here we use the spreadsheet for determining the IRR
but before that we need to find out the cash inflows
Years Amount (in dollars)
Year 0: = - $278,191.12
($236,000 - $48,000 ÷ 1.13^4 -$30,000 ÷ 1.13^7)
Year 1: 64000
Year 2: 87000
Year 3: 91000
Year 4: 0
Year 5: 122000
Year 6: 154000
Year 7: 0
Now we use the excel
=IRR({-$278,191.12,$64,000,$87,000,$91,000,$0,$122,000,$154,000,0})
= 18.54%
