An asterisk (*) will appear to the right, immediately above, or immediately below an incorrect entry.
The essay answer will not be graded.
Enter a zero in cells you would otherwise leave blank.
1.
Proposal A: -year, -month cash payback period
Net Cash Cumulative
Year and Months Flow Net Cash Flows
Year 1
Year 2
Year 3
Year 4
Proposal B: -year, -month cash payback period
Net Cash Cumulative
Year and Months Flow Net Cash Flows
Year 1
Year 2
Year 3
Year 4
Proposal C: -year, -month cash payback period
Net Cash Cumulative
Year and Months Flow Net Cash Flows
Year 1
Year 2
Year 3
Year 4
Proposal D: -year, -month cash payback period
Net Cash Cumulative
Year and Months Flow Net Cash Flows
Year 1
Year 2
Year 3
Payback Period
0%
[Key code here]
Answers are entered in the cells with gray backgrounds.
Score:
Key Code:
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
Problem 26-6A
Name:
Section:
Year 4
2.
Proposal A:
Proposal B:
Proposal C:
Proposal D:
3.
Cash Payback Period Average Rate Accept for
Proposal Years Months of Return
A
B
C
D
4., 5.
Present Present
Value of Net Cash Value of Net
$1 at 15% Flow =Cash Flow
Year 1
Year 2
Year 3
Year 4
Year 5
Total
Amount to be invested
Net present value
Average Rate of Return
=
=
Net Present Value and Present Value Index
=
=
Present value index
Present Present
Value of Net Cash Value of Net
$1 at 15% Flow =Cash Flow
Year 1
Year 2
Year 3
Year 4
Year 5
Total
Amount to be invested
Net present value
Present value index
6., 7.
Based on net present value calculated in Part 4, the proposals should be ranked as follows:
Rank 1
Rank 2
Based on present value index calculated in Part 5, the proposals should be ranked as follows:
Rank 1
Rank 2
8.
[Key essay answer here]
An asterisk (*) will appear to the right, immediately above, or immediately below an incorrect entry.
The essay answer will not be graded.
Enter a zero in cells you would otherwise leave blank.
1.
Proposal A: 3 -year, 6 -month cash payback period
Net Cash Cumulative
Year and Months Flow Net Cash Flows
Year 1 full year 200,000$ 200,000$
Proposal B: 4 -year, 0 -month cash payback period
Net Cash Cumulative
Year and Months Flow Net Cash Flows
Answers are entered in the cells with gray backgrounds.
Problem 26-6A
Name:
Solution
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Payback Period
2.
Proposal A:
3.
Cash Payback Period Average Rate Accept for
Proposal Years Months of Return
A 3 6 14.1% Reject
4., 5.
Present Present
Value of Net Cash Value of Net
$1 at 15% Flow =Cash Flow
Year 1 0.870 55,000$ 47,850$
Net Present Value and Present Value Index
Proposal C:
Average Rate of Return
Present Present
Value of Net Cash Value of Net
$1 at 15% Flow
=Cash Flow
Year 1 0.870 180,000$ 156,600$
6., 7.
Based on net present value calculated in Part 4, the proposals should be ranked as follows:
Proposal D: