- I Need Help With The Free Cash Flows Please Show Formulas 1 (176.3 KiB) Viewed 27 times
1 INCOME STATEMENT 2 Revenue 3 Cost of Goods Sold 4. Contribution Margin isles in 2017 Actual 2018 (Fcst) 2019 (Fcst) 2020 (Fcst) $ 4,700 $ 5,000 $ 5,500 $ 6,000 $ 475 $ 525 $ 575 $ 640 $ 4,225 $ 4,475 $ 4,925 $ 5,360 6 SG&A 7 Deprecation 3 Operating Expenses $ $ $ 3,350 $ 250 $ 3,600 $ 3,475 $ 250 $ 3,725 $ 3,725 $ 350 $ 4,075 $ 4,060 350 4,410 $ 625 $ 750 $ 850 $ 950 $ $ $ 150 $ 95 $ 380 $ 200 $ 110 $ 440 $ les en 50 $ 160 $ 640 $ 190 760 $ $ 850 $ 725 $ 250 1,825 $ 700 $ 1,050 $ 275 2,025 $ 940 $ 1,000 $ 300 2,240 $ 1,130 1,200 500 2,830 $ OEBIT 1 2 Interest Expense 3 Taxes (20%) 4 Net Profit 5 6 BALANCE SHEET 7 Assets 8 Cash 9 Accounts Receivable CO Inventory 1 Current Assets 2 3 Property, Plant & Equipment -4 Less: Accumulated Depreciation 5 Fixed Assets 6 7 Total Assets 8 -9 Liabilities and Equity O Accounts Payable 1 Income Tax Payable -2 Current Liabilities 3 4 Long-Term Debt Financial Statements $ $ $ 2,250 $ (250) $ 2,000 $ 2,500 $ (500) $ 2,000 $ 3,000 $ (850) $ 2,150 $ 3,000 (1,200) 1,800 $ 3,825 $ 4,025 $ 4,390 $ 4,630 $ $ $ 450 $ 95 $ 545 $ 475 $ 110 $ 585 $ 650 $ 160 $ 810 $ 190 790 $ 1,901 $ 2,000 $ 500 $ A
D E F 1,310 $ 790 2,000 $ 1,080 $ 2,000 1,840 4,390 $ 4,630 2 3 850 $ 20% 680 $ 350 $ 1,030 $ 950 20% 760 350 1,110 А B с 5 Total Liabilities $ 2,446 $ 2,585 $ 36 7 Common Stock $ 999 $ 1,000 $ 58 Retained Earnings $ 380 $ 440 $ 39 10 Total Liabilities and Equity $ 3,825 $ 4,025 $ 11 2 FREE CASH FLOWS 13 0 1 14 Calculation of Free Cash Flows 15 Cash From Operations 16 EBIT $ 750 $ 17 Tax Rate 20% 18 EBIT x (1 - tax rate) $ 600 $ 19 Depreciation Expense $ 250 $ 50 Cash From Operations $ 850 $ 51 $2 Changes to Working Capital 63 Accounts Receivable $ (325) $ 54 Inventory $ (25) $ 65 Accounts Payable $ 25 $ 56 Changes to Working Capital $ (325) $ 57 8 Capital Expenditures $ (250) $ 59 Free Cash Flows Subtotal $ 275 $ 50 51 Initial Investment $ (4,000) 52 Terminal Value 53 Total Free Cash Flows $ (4,000) $ 275 $ 54 IRR 16.9% 55 WACC 18.0% 6 NPV $ (102) 57 58 Cinancial Statomonte (200) (200) 50 $ (25) $ 175 $ 200 $ (50) (450) (500) $ 730 $ 660 $ 730 $ 4,500 5,160