80.2K
Verified Solution
Link Copied!
Calculate change in net working capital for year 6. The year 0 investment is $22,000,000. 
4 Year Revenues Fixed Costs Variable costs Depreciation EBIT Tax 35% Net Income 1 2 3 5 $ 8,000,000.00 $ 15,000,000.00 $ 16,000,000.00 $ 18,000,000.00 $ 10,000,000.00 $9,000,000.00 1,100,000.00 1,100,000.00 1,100,000.00 1,100,000.00 1,100,000.00 1,100,000.00 2,400,000.00 4,500,000.00 4,800,000.00 5,400,000.00 3,000,000.00 2,700,000.00 3,800,000.00 6,080,000.00 3,610,000.00 2,280,000.00 2,090,000.00 1,140,000.00 $ 700,000.00 $ 3,320,000.00 $ 6,490,000.00 $ 9,220,000.00 $ 3,810,000.00 $4,060,000.00 245,000.00 1,162,000.00 2,271,500.00 3,227,000.00 1,333,500.00 1,421,000.00 $ 455,000.00 $ 2,158,000.00 $ 4,218,500.00 $ 5,993,000.00 $ 2,476,500.00 $ 2,639,000.00 EBIT $ 700,000.00 $ 3,320,000.00 $ 6,490,000.00 $ 9,220,000.00 $ 3,810,000.00 $4,060,000.00 Depreciation $3,800,000.00 $ 6,080,000.00 $ 3,610,000.00 $ 2,280,000.00 $ 2,090,000.00 $ 1,140,000.00 Taxes $ 245,000.00 $ 1,162,000.00 $ 2,271,500.00 $ 3,227,000.00 $ 1,333,500.00 $1,421,000.00 Operating Cash Flow $4,255,000.00 $ 8,238,000.00 $ 7,828,500.00 $ 8,273,000.00 $ 4,566,500.00 $3,779,000.00
Answer & Explanation
Solved by verified expert
