Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry, or above and below formulas.
The essay answer will not be graded.
Average annual rate of return for both projects:
Value of Tracking Tracking
$1 at 15% Warehouse Technology Warehouse Technology
Year 1
Year 2
Year 3
Year 4
Year 5
Total
Amount to be invested
Net present value
2.
Net Present Value Analysis
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry, or above and below in formulas.
The essay answer will not be graded.
Average annual rate of return for both projects:
Value of Tracking Tracking
$1 at 15% Warehouse Technology Warehouse Technology
Year 1 0.870 135,000$ 108,000$ 117,450$ 93,960$
2.
Answers are entered in the cells with gray backgrounds.
Net Present Value Analysis
Cells with non-gray backgrounds are protected and cannot be edited.