1. Prepare the cash flow statement for the 2020 forecast.
2. Prepare the sources and uses statement for the 2020 forecast.

c. Prepare the cash flow identity statement for the 2020 forecast.

Forecast 2020 2019 Bag XTC Co. Balance Sheet($ 000's) ASSETS 2018 Current Assets Cash 9,000 Short-term Investments 48,600 Accounts Receivable 351,200 Inventory 715,200 Total Current Assets 1,124,000 Plant & Equipment 491,000 Accumulated Depreciation 146,200 - Net Plant & Equipment 344,800 TOTAL ASSETS 1,468,800 LIABILITIES and SHAREHOLDERS' EQUITY Current Liabilities Accounts Payable 145,600 Notes Payable 200,000 Accrued Expenses 136,000 Total Current Liabilities 481,600 Long Term Debt Common Shares 460,000 Retained Earnings 203,768 Total Equity 663,768 TOTALLABILITIES AND EQUITY 1,468,800 7,282 20,000 632,160 1,287,360 1,946,802 1,202,950 263,160 939,790 2,886,592 14,000 71,632 878,000 1,716,480 2,680,112 1,220,000 383,160 836,840 3,516,952 359,800 300,000 380,000 1,039,800 324,000 720,000 284,960 1,378,960 1,000,000 460,000 97,632 557,632 500,000 1,680,936 296,216 1,977,152 2,886,592 3,516,952 Income Statement ($100's) Forecast 2018 2019 2020 3,432,000.0 5,834,400.0 7,035,6010 2,864,000.0 4,990,0000 5,800,000.0 568,000.0 854,400.0 1,235,600.0 340,000.0 720,000.0 612,960.0 18,900.0 116,960.0 120,CELLO 62,500.0 176,000.0 80,000.0 146,60LO - 158,560.0 402,640.0 58,640.0 - 63,424.0 169,056.0 Sales Revernes Cost of Goods Sold Contribution Margin Operating Expenses Depreciation Interest Earnings B4 Taxes Taxes e 40% Earnings After tax Other Data that may be helpful Stock Price Shares ofs EPS DPS Tax Rate Book Value per Share Lease Payments 87,9640 - 95,136.0 253,5840 $ $ $ 8.50 $ 100,000 0.880 $ 0.220 $ 40% 6.638 $ 40,000 $ 6.00 $ 100.000 0.951 $ 0.110 $ 40% 5.576 $ 40,000 $ 12.17 250.000 1.014 0.220 40% 7.909 40,000 $ Forecast Industry Average 27 10 2.3 15 0.5 4.8 45 6.1 37.3 16.0 2.3 Rotros Current Quick Inventory Turnover Day's Sales Outstanding Fixed Assets Turnover Total Asset Turnover Total Debt Ratio TIE Ratio Profit Margin Ratio Return on Assets Return on Equity Price Earnings Ratio Price/Cash Flow 54.8 69.6 6.2 20 80.7 0.1 -16% -3.3% -17.1% 3.3 2.6% 6.0% 13.3% 9.7 8.0 32.0 7.0 2.5 50.0 6.2 3.6% 9.6% 17.9% 16.2 7.6 N/A 27.5 Income Statement ($100's) Forecast 2018 2019 2020 3,432,000.0 5,834,400.0 7,035,6010 2,864,000.0 4,990,0000 5,800,000.0 568,000.0 854,400.0 1,235,600.0 340,000.0 720,000.0 612,960.0 18,900.0 116,960.0 120,CELLO 62,500.0 176,000.0 80,000.0 146,60LO - 158,560.0 402,640.0 58,640.0 - 63,424.0 169,056.0 Sales Revernes Cost of Goods Sold Contribution Margin Operating Expenses Depreciation Interest Earnings B4 Taxes Taxes e 40% Earnings After tax Other Data that may be helpful Stock Price Shares ofs EPS DPS Tax Rate Book Value per Share Lease Payments 87,9640 - 95,136.0 253,5840 $ $ $ 8.50 $ 100,000 0.880 $ 0.220 $ 40% 6.638 $ 40,000 $ 6.00 $ 100.000 0.951 $ 0.110 $ 40% 5.576 $ 40,000 $ 12.17 250.000 1.014 0.220 40% 7.909 40,000 $ Forecast Industry Average 27 10 2.3 15 0.5 4.8 45 6.1 37.3 16.0 2.3 Rotros Current Quick Inventory Turnover Day's Sales Outstanding Fixed Assets Turnover Total Asset Turnover Total Debt Ratio TIE Ratio Profit Margin Ratio Return on Assets Return on Equity Price Earnings Ratio Price/Cash Flow 54.8 69.6 6.2 20 80.7 0.1 -16% -3.3% -17.1% 3.3 2.6% 6.0% 13.3% 9.7 8.0 32.0 7.0 2.5 50.0 6.2 3.6% 9.6% 17.9% 16.2 7.6 N/A 27.5 Forecast 2020 2019 Bag XTC Co. Balance Sheet($ 000's) ASSETS 2018 Current Assets Cash 9,000 Short-term Investments 48,600 Accounts Receivable 351,200 Inventory 715,200 Total Current Assets 1,124,000 Plant & Equipment 491,000 Accumulated Depreciation 146,200 - Net Plant & Equipment 344,800 TOTAL ASSETS 1,468,800 LIABILITIES and SHAREHOLDERS' EQUITY Current Liabilities Accounts Payable 145,600 Notes Payable 200,000 Accrued Expenses 136,000 Total Current Liabilities 481,600 Long Term Debt Common Shares 460,000 Retained Earnings 203,768 Total Equity 663,768 TOTALLABILITIES AND EQUITY 1,468,800 7,282 20,000 632,160 1,287,360 1,946,802 1,202,950 263,160 939,790 2,886,592 14,000 71,632 878,000 1,716,480 2,680,112 1,220,000 383,160 836,840 3,516,952 359,800 300,000 380,000 1,039,800 324,000 720,000 284,960 1,378,960 1,000,000 460,000 97,632 557,632 500,000 1,680,936 296,216 1,977,152 2,886,592 3,516,952 Income Statement ($100's) Forecast 2018 2019 2020 3,432,000.0 5,834,400.0 7,035,6010 2,864,000.0 4,990,0000 5,800,000.0 568,000.0 854,400.0 1,235,600.0 340,000.0 720,000.0 612,960.0 18,900.0 116,960.0 120,CELLO 62,500.0 176,000.0 80,000.0 146,60LO - 158,560.0 402,640.0 58,640.0 - 63,424.0 169,056.0 Sales Revernes Cost of Goods Sold Contribution Margin Operating Expenses Depreciation Interest Earnings B4 Taxes Taxes e 40% Earnings After tax Other Data that may be helpful Stock Price Shares ofs EPS DPS Tax Rate Book Value per Share Lease Payments 87,9640 - 95,136.0 253,5840 $ $ $ 8.50 $ 100,000 0.880 $ 0.220 $ 40% 6.638 $ 40,000 $ 6.00 $ 100.000 0.951 $ 0.110 $ 40% 5.576 $ 40,000 $ 12.17 250.000 1.014 0.220 40% 7.909 40,000 $ Forecast Industry Average 27 10 2.3 15 0.5 4.8 45 6.1 37.3 16.0 2.3 Rotros Current Quick Inventory Turnover Day's Sales Outstanding Fixed Assets Turnover Total Asset Turnover Total Debt Ratio TIE Ratio Profit Margin Ratio Return on Assets Return on Equity Price Earnings Ratio Price/Cash Flow 54.8 69.6 6.2 20 80.7 0.1 -16% -3.3% -17.1% 3.3 2.6% 6.0% 13.3% 9.7 8.0 32.0 7.0 2.5 50.0 6.2 3.6% 9.6% 17.9% 16.2 7.6 N/A 27.5 Income Statement ($100's) Forecast 2018 2019 2020 3,432,000.0 5,834,400.0 7,035,6010 2,864,000.0 4,990,0000 5,800,000.0 568,000.0 854,400.0 1,235,600.0 340,000.0 720,000.0 612,960.0 18,900.0 116,960.0 120,CELLO 62,500.0 176,000.0 80,000.0 146,60LO - 158,560.0 402,640.0 58,640.0 - 63,424.0 169,056.0 Sales Revernes Cost of Goods Sold Contribution Margin Operating Expenses Depreciation Interest Earnings B4 Taxes Taxes e 40% Earnings After tax Other Data that may be helpful Stock Price Shares ofs EPS DPS Tax Rate Book Value per Share Lease Payments 87,9640 - 95,136.0 253,5840 $ $ $ 8.50 $ 100,000 0.880 $ 0.220 $ 40% 6.638 $ 40,000 $ 6.00 $ 100.000 0.951 $ 0.110 $ 40% 5.576 $ 40,000 $ 12.17 250.000 1.014 0.220 40% 7.909 40,000 $ Forecast Industry Average 27 10 2.3 15 0.5 4.8 45 6.1 37.3 16.0 2.3 Rotros Current Quick Inventory Turnover Day's Sales Outstanding Fixed Assets Turnover Total Asset Turnover Total Debt Ratio TIE Ratio Profit Margin Ratio Return on Assets Return on Equity Price Earnings Ratio Price/Cash Flow 54.8 69.6 6.2 20 80.7 0.1 -16% -3.3% -17.1% 3.3 2.6% 6.0% 13.3% 9.7 8.0 32.0 7.0 2.5 50.0 6.2 3.6% 9.6% 17.9% 16.2 7.6 N/A 27.5