Compute Pro Forma Income Statement in yellow cells Compute Cash Flows on next tab Cash Flows OWN 6 Problem 4 2 3 Given Project Input Data 4 New and improved Shark Attractant Project 7 Estimated sales (cans) 60,000 8 Sales Price per can $4.00 9 Cost per can $2.50 10 Estimated life (years) 5. 11 Fixed costs (per year) $37,430 12 Initial equipment cost $100,000 13 100% depreciated over 5-year life 14 Investment in NWC $20,000 15 Tax rate 25% 16 Cost of capital 20% 17 Pro Forma Income Statement Sales (60,000 units at $4.00/unit) Variable Costs ($2.50/unit) Gross profit Fixed costs Depreciation (= $100,000/5) EBIT Taxes (25%) Net Income 10