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.
Wichita:
Annual net cash flow (at the end of each of 6 years)
Present value of an annuity of $1 at 20% for 6 years (Exh. 5)
Present value of annual net cash flows
Amount to be invested
Net present value
Topeka:
Annual net cash flow (at the end of each of 4 years)
Present value of an annuity of $1 at 20% for 4 years (Exh. 5)
Present value of annual net cash flows
Amount to be invested
Net present value
2.
Present
Value of
$1 at 20% Wichita Topeka Wichita Topeka
Year 1
Year 2
Year 3
3.
[Key code here]
Present Value of
Net Present Value Analysis
[Key essay answer here]
Problem 26(12)-5B
Name:
Section:
0%
Score:
Key Code:
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
Net Present Value Analysis
Net Cash Flow
Net Cash Flow
Answers are entered in the cells with gray backgrounds.
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.
Wichita:
Topeka:
2.
Present
Value of
$1 at 20% Wichita Topeka Wichita Topeka
Year 1 0.833 310,000$ 400,000$ 258,230$ 333,200$
3.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
Net Present Value Analysis
To: Investment Committee
Net Cash Flow
Net Cash Flow
ON
Present Value of
Net Present Value Analysis
Cells with non-gray backgrounds are protected and cannot be edited.
Problem 26(12)-5B
Name:
Solution
Section: