Question: The Web site www.mhhe.com/bma contains an Excel program for calculating the profitability of the Nodhead project. Now suppose that the cash flows from Nodheads new

The Web site www.mhhe.com/bma contains an Excel program for calculating the profitability of the Nodhead project. Now suppose that the cash flows from Nodhead’s new supermarket are as follows:


The Web site www.mhhe.com/bma contains an Excel program for calc


a. Recalculate economic depreciation. Is it accelerated or decelerated?
b. Rework Tables 12.2 and 12.3 to show the relationship between
(i) The “true” rate of return and book ROI and
(ii) True EVA and forecasted EVA in each year of the project’slife.

TABLE 12.2 Year 2 3 4 5 Cash flow Book value at start of yea 1,000 Book value at end of year 834 Book Book income Book ROI EVA 100 298 834 667 167 667 167 167 167 131 167 67 -0.067 167 167 83 167 131 167 130 ation 0.263 81 0.040 0.125 0.394 0.782 TABLE 12.3 Year Cash flow PV at start of year PV at end of year Economic dep Economic income Rate of return EVA 298 740 250 1,000 1 1,000 1,000 3 740 224 246 52 0.10 0.00 0.10 0.00 0.10 0.00 0.10 0.00 0.10 0.00 0.00

Step by Step Solution

3.43 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Use the models from Tables 122 and 123 below to answer these questions TABLE 122 Forecasted book ROI ... View full answer

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

Document Format (1 attachment)

Excel file Icon

214-B-C-F-C-B (1037).xlsx

300 KBs Excel File

Students Have Also Explored These Related Corporate Finance Questions!