create cash flow statement

Homework Assignment Due by 8 PM on Sunday September 20th on Canvas Comparative Balance Sheets and some additional information for Red Company are given below. All figures in the table below are in millions of dollars. Red reports on a fiscal year ending December 31" 2000 2001 Green Company Balance Shant as of Den 31 Assets Cash 25 20 Accounts Receivable 45 90 Allowance for Bad Debts (15) (20) Merchandize Inventories 160 135 Land 200 225 420 420 Plant and Equipment Accumulated Depreciation (160) (170) Total Assets 675 700 Liabilities and Equity 30 20 Accounts Payable Taxes Payable 0 15 Long term Debt 265 255 Contributed Capital 290 330 Retained Earnings 90 80 Total Liabilities and Equity 675 700 Additional Information 1. Red's net income for calendar year 2001 was S50 million 2. During 2001, Red sold plant and equipment with an original acquisition cost of $50 million at a loss of $10 million 3. Red's depreciation expense for 2001 was $25 million Prepare in good form Red's Cash Flow Statement for 2001 Selected financial statement information and additional data for Johnston Enterprises is presented below. Balance Sheet Data December 31, 2013 $119,000 320,000 (14,000) 340,000 1,122,000 (442,000) $1.445.000 December 31, 2014 $143,000 240,000 (12,000) 391,000 1,261,000 (476,000) $1.547.000 Cash Accounts Receivable Less: Allowance for Bad Debts Inventory Property, Plant, and Equipment Less: Accumulated Depreciation Total Assets Accounts Payable (merchandise suppliers) Salaries Payable Income Taxes Payable Bank Loan Common Stock Retained Earnings Total Liabilities & Stockholders' Equity $102,000 68,000 77,000 391,000 467,000 340,000 $1.445.000 $187,000 51,000 85,000 350,000 510,000 364,000 $1.547.000 Income Statement Data for Calendar Year 2014 1,615,000 (781.000) 834,000 Sales Revenue Cost of Goods Sold Gross Profit Expenses: Depreciation Expense Salaries Expense Bad Debt Expense Interest Expense Loss on Sale of Equipment Income Before Taxes Income Tax Expense Net Income (153,000) (380,000) (11,000) (34,000) 12.000) 244,000 198.000) $146.000 Additional Information: During the calendar year 2014 Johnston purchased new equipment at a cost of $272,000. Based on the Information provided on the previous page, provide your answers to the questions below In the space provided in the table below. Item $ Amount (a) Cash Collected from Customers in 2014 (b) Cash paid to merchandize suppliers in 2014 (c) Salaries paid in 2014 (d) Interest paid in 2014 (e) Taxes paid in 2014 (1) Net Cash from the Above i.e. (a) through (e) (6) 2014 Cash Flow from Operations (h) Cash from Sale of PP in 2014 (1) Dividends Paid in 2014 Also, prepare a cash flow statement for 2014 in proper format