An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
Enter a zero in cells you would otherwise leave blank.
1.
Office Expansion:
Annual net cash flow (at the end of each of 6 years)
Present value of an annuity of $1 at 12% for 6 years (Exh. 5)
Server Upgrade:
Annual net cash flow (at the end of each of 4 years)
Present value of an annuity of $1 at 12% for 4 years (Exh. 5)
Present value of annual net cash flows
Amount to be invested
Net present value
2.
Present
Value of Office Server Office Server
$1 at 12% Expansion Upgrade Expansion Upgrade
Year 1
Year 2
Year 3
Year 4
Year 4 (resid. value)
Total
Amount to be invested
Net present value
3.
[Key essay answer here]
Problem 26(12)-5A
Name:
Section:
0%
[Key code here]
Answers are entered in the cells with gray backgrounds.
Net Present Value Analysis
Net Cash Flow
Net Present Value Analysis
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Key Code:
Instructions
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
Enter a zero in cells you would otherwise leave blank.
1.
Office Expansion:
Server Upgrade:
Net present value 11,105$
2.
Present
Value of Office Server Office Server
$1 at 12% Expansion Upgrade Expansion Upgrade
3.
Problem 26(12)-5A
Name:
Solution
Section:
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
Net Present Value Analysis
To: Investment Committee
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Net Cash Flow
Net Present Value Analysis