Unlock access to all the studying documents.
View Full Document
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.
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.
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Net Present Value Analysis
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$
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$
2.
Answers are entered in the cells with gray backgrounds.
Net Present Value Analysis
Cells with non-gray backgrounds are protected and cannot be edited.
The report can take many forms and should include, as a minimum, the following points: