Residual Income; Performance Evaluation Time Horizon; Spreadsheet Application; Review of Chapter 12 As referenced in the five-step process presented at the beginning of this chapter, one issue that...

Residual Income; Performance Evaluation Time Horizon; Spreadsheet Application; Review of Chapter 12 As referenced in the five-step process presented at the beginning of this chapter, one issue that confronts top management is selection of an appropriate time period for evaluating the financial performance of the company’s investment centers. This exercise demonstrates why, in conjunction with residual income (RI), it is desirable to evaluate financial performance over a multiyear period. The primary point is that, by doing so, top management is better able to align manager goals and incentives with organizational goals. Assume, as covered in Chapter 12, that your company uses the net present value (NPV) method to evaluate capital investment opportunities. Generally speaking, this means that a long-term investment project will be undertaken if the present value of future net cash flows (after tax) is positive when discounted at the firm’s weighted-average cost of capital (WACC). The following facts pertain to an investment opportunity that is available to the manager of one of the investment centers in your company. Investment outlay cost, at time period 0, is $800,000. This amount relates to an asset with a 5-year life, with no salvage value, that will be depreciated using the straight-line (SL) method. The investment is expected to increase cash inflows by $300,000 per year. Assume a discount rate of 10%, both for purposes of calculating NPV and for calculating annual residual income (RI) figures.

Required

1. Use Excel to prepare a schedule that contains annual cash-flow data, annual operating income amounts, and annual residual income (RI) figures. Use beginning-of-year net book values (NBV) to calculate RI. What is the estimated NPV of the proposed investment? What is the present value (PV) of the stream of expected residual incomes (RIs) from this investment? 2. From a behavioral perspective, what is the primary implication of the analysis you conducted in requirement 1?