Question: Please show correct excel formula B D E H J 2 3 4 Cash Flow Identity Exercise Complete the Cash Flow Identity calculations below referring

 Please show correct excel formula B D E H J 2

Please show correct excel formula

B D E H J 2 3 4 Cash Flow Identity Exercise Complete the Cash Flow Identity calculations below referring to the given financial statements 2019 2018 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Assets Current Assets Cash & Equivalents Short term investments Accounts receivable Inventories Other current assets Total current assets Comparative Balance Sheets 2019 2018 Liabilities Current Liabilities 2,500 2,550 Accounts payable 1,834 2,400 Accruals and Other 5,672 4,966 Total current liabilities 2,700 2,675 Bonds Payable 1,001 Other long-term liabilities 13,707 13,532 Total Long-Term Liabilities Total liabilities 14,500 12,850 Owner's Equity 3,400 3,350 Common Stock & APIC 17,900 16,200 Retained Earings Total owner's equity 31,607 29,732 Total Liabilities and Equity 7,680 2,390 10,070 3,800 1,656 5,456 15,526 7,770 3,800 11,570 3,650 1,606 5,256 16,826 941 Net Plant, property and equipment Other Long-term assets Total Long-term Assets 4,015 12,066 16,081 31,607 3,975 8,931 12,906 29,732 TRUE Total Assets TRUE Income Statement: 2019 Revenue Cost of Goods Sold Gross Profit Depreciation Selling & Admin. Expenses Other Expenses Operating Income 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Cash Flow From Assets: 52,050 Operating Cash Flow 20,950 Net Capital Spending 31,100 Change in Net Working Capital Cash Flow from Assets: 2,300 17,900 Cash Flow to Creditors: 250 Interest Expense: 10,650 Net New Borrowing Cash Flow to Creditors: 380 11,030 Cash Flow to Owners: Dividends 505 Net new owner contributions 10,525 Cash Flow to Owners: Other Income EBIT Interest Expense Taxable income Total Cash Flow to Investors Income Tax Expense (35% tax rate) Net Income 3,684 6,841 TRUE Dividends paid during year: 3,706

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!