E26-9 Compute cash payback period and net present value
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment
investment of $22,000. Each project will last for 3 years and produce the following net annual cash
flows.
Year AA BB CC
1 $7,000 $10,000 $13,000
2 9,000 10,000 12,000
3 12,000 10,000 11,000
Total $28,000 $30,000 $36,000
The equipment’s salvage value is zero, and Doug uses straight-line depreciation. Doug will not
accept any project with a cash payback period over 2 years. Doug’s required rate of return is 12%.
Instructions
(a) Compute each project’s payback period, indicating the most desirable project and the least
desirable project using this method. (Round to two decimals and assume in your computations
that cash flows occur evenly throughout the year.)
(b) Compute the net present value of each project. Does your evaluation change? (Round to
nearest dollar.)
NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a “?” .
(a) Compute each project’s payback period, indicating the most desirable project and the least
desirable project using this method. (Round to two decimals and assume in your computations
that cash flows occur evenly throughout the year.)
Net Annual Cumulative
Year Cash Flow Net Cash Flow
1Value ?
2Value ?
3Value ?
Cash Payback Period:
Cost of capital investment Value
Cumulative net cash flow, year 2 Value
Remaining cost to be recovered (a) ?
Net cash flow, year 3 (b) Value
Payback period, year 3 (a) ÷ (b) Value
Total cash payback period in years ?
Cash Payback Period:
Cost of capital investment (a) Value
Net annual cash flow Value
Total cash payback period in years (a) ÷ (b) ?
Net Annual Cumulative
Year Cash Flow Net Cash Flow
1Value ?
2Value ?
3Value ?
Cash Payback Period:
Cost of capital investment Value
Cumulative net cash flow, year 1 Value