An asterisk (*) will appear to the right of an incorrect entry, or above and below formulas.
The essay answer will not be graded.
1. a.
Average annual rate of return for both projects:
1. b.
Present
Value of Tracking Tracking
$1 at 15% Warehouse Technology Warehouse Technology
Year 1
Year 2
Year 3
Year 4
Year 5
Total
Cells with non-gray backgrounds are protected and cannot be edited.
Present Value of
Net Cash Flow
Net Cash Flow
=
Net Present Value Analysis
0%
[Key code here]
Answers are entered in the cells with gray backgrounds.
Instructions
Problem 26(12)-1B
An asterisk (*) will appear to the right of an incorrect entry, or above and below in formulas.
The essay answer will not be graded.
1. a.
Average annual rate of return for both projects:
1. b.
Present
Value of Tracking Tracking
$1 at 15% Warehouse Technology Warehouse Technology
2.
Present Value of
Instructions
Answers are entered in the cells with gray backgrounds.
The report to the capital investment committee can take many forms. The report should, as a minimum,
present the following points:
Problem 26(12)-1B
Solution
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Net Present Value Analysis
Net Cash Flow
Net Cash Flow