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
Year 4
Problem 25(10)-6A
Name:
Section:
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.
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
Present value index
=
Net Present Value and Present Value Index
=
=
=
Average Rate of Return
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
Year 1 full year 90,000$ 90,000$
Proposal C: 2 -year, 0 -month cash payback period
Net Cash Cumulative
Year and Months Flow Net Cash Flows
Year 1 full year 55,000$ 55,000$
Year 2 full year 53,000 108,000
Year 3 N/A – –
Year 4 N/A – –
Proposal D: 2 -year, 3 -month cash payback period
Net Cash Cumulative
Year and Months Flow Net Cash Flows
Year 1 full year 180,000$ 180,000$
Year 4 N/A – –
Payback Period
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
Problem 25(10)-6A
Name:
Solution
Section:
ON
2.
Proposal A:
3.
Cash Payback Period Average Rate Accept for
Proposal Years Months of Return
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$
Present value index 1.57
Average Rate of Return
Net Present Value and Present Value Index
Proposal C:
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: