Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry.
Value of Net Cash Value of Net
$1 at 15% Flow =Cash Flow
Year 1
Year 2
Year 3
Year 4
Year 4 (residual value)
Total
Amount to be invested
Net present value
Value of Net Cash Value of Net
$1 at 15% Flow =Cash Flow
Year 1
Year 2
Year 3
Year 4
Total
Amount to be invested
Net present value
The Processing Mill is as an investment.
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
Value of Net Cash Value of Net
$1 at 15% Flow =Cash Flow
Year 1 0.870 310,000$ 269,700$
Value of Net Cash Value of Net
$1 at 15% Flow =Cash Flow
Net present value 179,690$
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.