Please solve the free cash flows and following statement of CF throughout. Please supply the excel formulas used. Thanks

yes please thats perfect

Fill in all Yellow highlighted cells. You are recreating the statement of Cash Flows and calculating the FCF. Tax rate 40% 40% BALANCE SHEETS - Specta Products - December 31 2014 2013 (in millions of dollars) Assets Free Cash Flow 2014 Cash and equivalents 10 $ 80 Accounts receivable 375 315 Inventories 615 415 Total current assets 1,000 $ Net plant and equipment 1,000 870 Other assets expected to last more than 1 year STATEMENT OF CF 2014 Total assets $ 2,000 $ 1,680 Operating CF 810 Liabilities and Equity Accounts payable Accruals Notes payable Total current liabilities Long-term bonds Total liabilities Common stock (50,000,000 shares) Retained earnings Total common equity Total liabilities and equity 60 $ 140 110 310 $ 750 1,060 $ 130 810 940 $ 2,000 $ 30 130 60 220 580 800 130 750 880 1,680 Investing CF $ $ Financing CF INCOME STATEMENTS - Specta Products - Years Ending December 31 (in millions of dollars) 2014 2013 $ Net CF Net sales Operating costs except depreciation and amortization Depreciation and amortization Earnings before interest and taxes (EBIT) Less interest Earnings before taxes (EBT) Taxes $ 3,000.0 $ 2,616.2 100.0 283.8 $ 88.0 195.8 $ 78.3 117.5 $ 2,850.0 2,497.0 90.0 263.0 60.0 203.0 81.2 121.8 $ Net income $ Common dividends Addition to retained earnings $ $ 57.5 60.0 $ $ 53.0 68.8 Fill in all Yellow highlighted cells. You are recreating the statement of Cash Flows and calculating the FCF. Tax rate 40% 40% BALANCE SHEETS - Specta Products - December 31 2014 2013 (in millions of dollars) Assets Free Cash Flow 2014 Cash and equivalents 10 $ 80 Accounts receivable 375 315 Inventories 615 415 Total current assets 1,000 $ Net plant and equipment 1,000 870 Other assets expected to last more than 1 year STATEMENT OF CF 2014 Total assets $ 2,000 $ 1,680 Operating CF 810 Liabilities and Equity Accounts payable Accruals Notes payable Total current liabilities Long-term bonds Total liabilities Common stock (50,000,000 shares) Retained earnings Total common equity Total liabilities and equity 60 $ 140 110 310 $ 750 1,060 $ 130 810 940 $ 2,000 $ 30 130 60 220 580 800 130 750 880 1,680 Investing CF $ $ Financing CF INCOME STATEMENTS - Specta Products - Years Ending December 31 (in millions of dollars) 2014 2013 $ Net CF Net sales Operating costs except depreciation and amortization Depreciation and amortization Earnings before interest and taxes (EBIT) Less interest Earnings before taxes (EBT) Taxes $ 3,000.0 $ 2,616.2 100.0 283.8 $ 88.0 195.8 $ 78.3 117.5 $ 2,850.0 2,497.0 90.0 263.0 60.0 203.0 81.2 121.8 $ Net income $ Common dividends Addition to retained earnings $ $ 57.5 60.0 $ $ 53.0 68.8