Using the information on the left calculate the Cash Flow Identity items on the right. Be sure to link the cells you are using on the left to the cell formulas on the right as needed. CFFA Mfg. Company Selected Financial Statement Information OCF Net Capital Spending Change in Working Capital $ L $ 1,450,000 465,000 160,000 Revenue COGS EBIT Depreciation $ Cash Flow From Assets $ 825,000 $ 11,265,000 7,235,000 1,475,000 250,000 190,000 275,000 1,010,000 1,565,000 1,725,000 2,675,000 5,675,000 5,890,000 35% 206,500 750,000 Cash Flow to Creditors Interest Expense Repayment of Debt Cash Flow to Creditors 190,000 75,000 265,000 Interest expense Taxes Net Income Beginning working capital Ending working capital Stockholders' equity ending Beginning net fixed assets Ending net fixed assets Dividend payout ratio Stock repurchased Beginning debt outstanding Ending debt outstanding $ Cash Flow to Stockholders Dividends paid Equity Raised/Repurchased Cash Flow to Stockholders (206,500) 675,000 Cash Flow to creditors/stockholders Using the information on the left calculate the Cash Flow Identity items on the right. Be sure to link the cells you are using on the left to the cell formulas on the right as needed. CFFA Mfg. Company Selected Financial Statement Information OCF Net Capital Spending Change in Working Capital $ L $ 1,450,000 465,000 160,000 Revenue COGS EBIT Depreciation $ Cash Flow From Assets $ 825,000 $ 11,265,000 7,235,000 1,475,000 250,000 190,000 275,000 1,010,000 1,565,000 1,725,000 2,675,000 5,675,000 5,890,000 35% 206,500 750,000 Cash Flow to Creditors Interest Expense Repayment of Debt Cash Flow to Creditors 190,000 75,000 265,000 Interest expense Taxes Net Income Beginning working capital Ending working capital Stockholders' equity ending Beginning net fixed assets Ending net fixed assets Dividend payout ratio Stock repurchased Beginning debt outstanding Ending debt outstanding $ Cash Flow to Stockholders Dividends paid Equity Raised/Repurchased Cash Flow to Stockholders (206,500) 675,000 Cash Flow to creditors/stockholders