enter missing values for years 2 through 4

1) Life Period of the Equipment - 4 years 2) New equipment cost 3) Equipment ship & install cost 4) Related start up cost 5) Inventory Increase 6) Accounts Payable increase 7) Equip. salvage value before tax uuuu 8) Sales for first year (1) (200,000) 9) Sales Increase per year (35,000) 10) Operating cost (60% of Sales) (5,000) (as a percent of sales in Year 1) 25,000 11) Depreciation (Straight Line)/YR 5,000 12) Marginal Corporate Tax Rate (T) 15,000 13) Cost of Capital (Discount Rate) 200,000 5% (120,000) -60% (60,000) 21% 10% $ 2 Year 23 24 LA SA 26 Operations: I/S Revenue Operating Cost Depreciation EBIT Taxes Net Income 200,000 (120,000) (60,000) 20,000 4,200 15,800 AKAK 28 Add back Depreciation 60,000 Total Operating Cash Flow KA 75,800 - + ESTIMATING Initial Outlay Cash Flow.CFo. T=0 Sheet1 Sheet2 Sheet3 Type here to search o em a $ $