Need formulas for areas in red

Home Insert Draw Page Layout Formulas Date Review View Developer Help Power Piv Cut Copy- Parte Clipboard - Font Alignment G28 Cash Flow Identity Exercise Complete the CFI using the given income statements and other information below 2019 2018 11 12 13 Comparative Balance Sheets Assets 2019 2018 Liabilities Current Assets Current Liabilities Cash & Equivalents 2.500 2.550 Accounts payable Short term investments 1,834 2.400 Accruals and Other Accounts receivable 5,672 4.966 Total current liabilities inventories 2,700 2.675 Bonds Payable Other current assets 1.001 941 Other long term bites Total current assets 13,707 13,532 Total Long Term Liabilities Total liabilities Net Plant property and equipm14,500 12.850 Owner's Equity Other Long-term assets 3.400 3,350 Common Stock & APIC Total Long-term Assets 17.000 16 200 Reted Earnings Total owner's equity Total Assets 31,607 29.732 Total Liabilities and Equity 7.6.80 2425 10 105 3.800 1656 5.456 15,561 7.770 3,762 11 532 3650 1.606 5.256 16,788 15 16 17 3980 12.055 16.046 31,607 4013 .931 12 944 29.732 19 22 Income Statement: 2019 Revenue Cost of Goods Sold Gross Profit 1.602 Cash Flow From Assets 49,850 Operating Cash Flow 18 542 Net Capital Spending 31,308 Change in Net Working Capital Cash Flow from Assets 1.897 16 987 Cash Flow to Creditors: 333 Interest Expense 12.091 Net New Borowing Cash Flow to Creditors: 29 Z Depreciation Selling & Admin Expenses Other Expenses Operating income 220 Other miscellaneous Losses Other income EBIT O Cash Flow to Owners: Dividendster to our cat Interest Expense refer to your cale Taxable income Net new owner contributions Cash Flow to Owners: Total Cash Flow to investors 30 30 Income Tax Expense A Net Income Start a search Insert Dr Page Layout formules Data Review View Developer Help Power Pivot Tel X CM G28 131607 29.732 Total Liabilities and Equity Income Statement 2019 - Cost of Goods Sold Gross Pict Cash Flow From Assets 49.850. Operating Cash Flow 18.512 et Capital Spending 31.303 Change in Net Working Captal Cash Flow from Assets Direction Seung & Admin Expenses Other Expenses Operating Income 16,387 Cash Flow to Creditors: Interest Expense 12.091 Net Nes Borrowing Cash Flow to Creditors Other miscellaneous Loss Other Income 3801 Cash Flow to Owners Dividends Wer wird Net new owner contributions Cash Flow to Owners Interest Expenserwca Taxable income Total Cash Flow to investors Income Tax Expense Net Income Statement of Retained Earings Balance 12/31/2018 Add 2019 Meine Less: 2019 Dividends paid Ending Back 1231/2019 931 Average Total LTE interest rate les Sot Starta Search