Problem 25-2 A Worksheet [Read-Only] - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VEW Sign in XProblem 25(11)-2A A B CD E 13 14 1. A. Initial investment 16 17 18 Plant Expansion Retail Store Expansion Net Cash Cumulative Net Net Cash Cumulative Net Cash Flows Cash FlowS 20 21 Year 1 Year 2 Year 3 Year 4 Year 5 25 26 21 The Plant Expansion project achie ves payback in The Retail Store Expansion project achieves payback in ### expansion project is recommended, based on the cash payback period 31 33 B. Net Present Value Analysis 35 36 37 Present Value of Net Cash Flow Net Cash Flow Value of $1 at 15% Plant Expansion Retail Store Expansion Plant Expansion Retail Store Expansion 43 Year 5 Total Amount to be invested Net present value 45 47 ### expansion project is recommended, based on its higher net present value 49 512. 52 [Key essay answer here] Pr. 25(11)-2A READY 11 100% 11:51 AM 11/27/2018