An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
Fill out the table in 1a completely, even after the payback period is reached.
1. a.
Initial investment:
Net Cash Cumulative Net Net Cash Cumulative Net
Flow Cash Flows Flow Cash Flows
Year 1
Year 2
Year 3
Year 4
Year 5
The Plant Expansion project achieves payback in
The Retail Store Expansion project achieves payback in
expansion project is recommended, based on the cash payback period.
1. b.
Present
Value of
Plant Retail Store Plant Retail Store
$1 at 15% Expansion Expansion Expansion Expansion
Year 1
Year 2
Year 3
Year 4
Year 5
Total
Amount to be invested
Net present value
expansion project is recommended, based on its higher net present value.
2.
Plant Expansion
Retail Store Expansion
Net Present Value Analysis
Net Cash Flow
[Key code here]
Answers are entered in the cells with gray backgrounds.
Net Cash Flow
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
Present Value of
[Key essay answer here]
Problem 26-2A
Name:
Section:
0%
Score:
Key Code:
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
Fill out the table in 1a completely, even after the payback period is reached.
1. a.
Initial investment:
Net Cash Cumulative Net Net Cash Cumulative Net
Flow Cash Flows Flow Cash Flows
Year 1 390,000$ 390,000$ 375,000$ 375,000$
Year 2 360,000 750,000 375,000 750,000
1. b.
Present
Value of
Plant Retail Store Plant Retail Store
$1 at 15% Expansion Expansion Expansion Expansion
Year 1 0.870 390,000$ 375,000$ 339,300$ 326,250$
Plant Expansion
Retail Store Expansion
Net Cash Flow
Net Cash Flow
Present Value of
Problem 26-2A
Name:
Solution
Section:
Net Present Value Analysis
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
$750,000