Question

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

Answer 1

Please find attached formulae updated in "red" shaded fields: Excel formulae is updated in the column beside the Red shaded column.

A B C D E F G H 4 2019 2018 Assets Current Assets: Cash & Equivalents Short term investments Accounts Receivable Inventories Other current assets Total currents assets 11 Comparative Balance Sheet 2019 2018 Liabilities Current liablities 2,500.00 2,550.00 Accounts payable 1,834.00 2,400.00 Accruals and other 5,672.00 4,966.00 Total current liablities 2,700.00 2,675.00 Bonds payable 1,001.00 941.00 Other long term liablities 13,707.00 | 13,532.00 Total long term liablities Total liablities 14,500.00 12,850.00 Owner's equity 3,400.00 3,350.00 common stock & APIC 17,900.00 16,200.00 Retained Earnings Total owner's equity 31,607.00 29,732.00 Total liablities and equity 7,680.00 2,425.00 10,105.00 3,800.00 1,656.00 5,456.00 15,561.00 7,770.00 3,762.00 11,532.00 3,650.00 1,606.00 5,256.00 16,788.00 15 76/ Net plant, property and equipment Other long term assets Total long term assets 17 3,980.00 12,066.00 16,046.00 31,607.00 4,013.00 8,931.00 12,944.00 29,732.00 Total assets 27 Income statement:2019 Revenue Cost of goods sold Gross profit 23 49,850.00 18,542.00 31,308.00 Cash Flow from assets: Operating cash flow Net capital spending Change in net working capital Cash Flow from assets: 24 9,314.00 =D39+D26-624 -3,597.00 =(D17-D26)-C17 1,602.00 5,717.00 =SUM(G22:23) 26 27 Depreciation Selling & Admin Expenses Other Expenses Operating income 1,897.00 16,987.00 333.00 12,091.00 29 Cash flow to creditors: Interest Expense Net new borrowing cash flow to creditors: -225.00 --G45 425.00 =G13-H13+G45 200.00 =SUM(G28:629) 30 31 Other miscellaneous losses Other income 220.00 380.00 32 Cash flow to owners: CL11

G H 21 22 23 24 A B Income statement:2019 Revenue Cost of goods sold Gross profit 49,850.00 18,542.00 31,308.00 F Cash Flow from assets: Operating cash flow Net capital spending Change in net working capital Cash Flow from assets: 9,314.00 =D39+D26-G24 -3,597.00 =(D17-D26)-C17 1,602.00 5,717.00 =SUM(G22:623) 25 26 27 28 29 30 31 Depreciation Selling & Admin Expenses Other Expenses Operating income 1,897.00 16,987.00 333.00 12,091.00 Cash flow to creditors: Interest Expense Net new borrowing cash flow to creditors: -225.00 --G45 425.00 =G13-H13+G45 200.00 =SUM(G28:529) 32 Other miscellaneous losses Other income EBIT 220.00 380.00 12,251.00 =D29-D31+D32 Cash flow to owners: Dividends Net new owner contributions cash flow to owners: 5,884.00 --D44 33.00 =G16-H16 -5,917.00 =SUM(G33:34) 35 Interest Expense Taxable income 225.00 =G45 12,026.00 =D33-D35 37 Total cash flow investors =G25+G30+G35 38 Income tax expense Net Income 3,007.00 =ROUND(D36*G41,0) 9,019.00 =D36-D38 40 Tax rate 25.00% 41 42 43 44 Statement of retained earnings Balance @ 12/31/2018 Add: 2019 net income Less: 2019 dividend paid Ending balance 12/31/2019 8,931.00 9,019.00 =D39 5,884.00 =D42+D43-D45 12,066.00 Average total LT liablities Interest rate Interest expense 5,356.00 4.20% 225.00 =ROUND(G43*644,0) 45