using the follwing infortamuon please create a Statement of Cahsflows, using excel

G 2 No Direction Distribution Corp. 3 Adjusted Trial Balance 4 December 31, 2020 and 2010 6 2010 7 2010 Dr. $274,000 C. Dr. $1,939,000 $4,079,000 6.307,000 $6,00.000 36,000 7.500,000 423,000 135,000 6.440,000 123.000 5.950.000 6.690.000 919.000 519,000 520.000 395,000 1,100,000 11,780,000 574,000 11.750,000 679,000 3,616,000 16.000 4,997.000 Accounting Expenses Accounts wable 10 Acount Revale Accrued Expenses 12 Accumulated Deprecat 13 Accumulated Other Comprehensive Income, 12/31 14 Additional Paid in Capital 15 Advertising Expense 16 Allowance for Doubtful Accounts 17 Amortization Expense 18 Bad Debits Expense 19 Buildings 20 Cash and Cash Equivalents 21 Common Stock 22 Corporate Salaries Expense 23 Current Portion of long-term Debt 24 Deferred Revenue 25 Deprecation Expense 26 Dividends Dedared 27 Equipment 2 Froght- 29 Freight-out 30 Furniture and Fixtures 31 Cain on Sale of Land General Office Expense 33 Good 7 Income Tax Expense 35 Income Taxes Payabile 36 Insurance Experts az Interest Expense 1.970,000 1,610,000 52.000 56,000 360,000 4,010,000 12,453,000 413.000 1,020,000 9.724,000 1.717.000 1.157.000 38,000 1.523,000 1.681,000 2,075.000 1.681,000 473.000 466,000 250.000 100,000 350,000 900.000 36 Insurance Expense 37. Interest Expense an Interest Payable 39 Interest Revenue 40 Inventory 4. Inventory Change 101,000 16,000 100,000 2.460.000 2,096,000 364,000 12 Land 743,000 1.300.000 10,214.000 9,933,000 1.313,000 1,250,000 1,122,000 113.000 63.000 1,710,000 238.000 1,315.000 266,000 990,000 23,989,000 326,000 375,000 522.000 4) Long-term Debt 44 Long-term investment 45 Marketing Expense 46. Miscellaneous Service Revenue 47 Other Comprehensive Income, net 48 Patents 49 Prepaid Expenses so Promotion Expense 51 Purchases 52. Purchases Discounts 53 Purchases Returns 54 Real Estate Tax Expense 55 Rent Revenue 56 Repairs and Maintenance Expense 57 Retained Earnings, 12/31 58 Sales Revenue 59 Sales Commissions Expense 60 Sales Discounts 61 Sales Office Expense 62 Sales Returns 63 Sales Salaries Expense 64 Sales Supplies 65 Sales Supplies Expense 66 Utilies Expense 278,000 366.000 4.951,000 4,951,000 54,194.000 2,225,000 656,000 939,000 85.000 749,000 3,273,000 96,000 263,000 674.000 1.098,000 $96,493,000 67 Vehicles 336.XIO $38,565.000 596,493,000 $38,565,000 67 Vehicles 1,000,000 596,493,000 68 $96.493,000 1136,000 $18,565.000 $30,565,000 70 The common stock has a par vahie of $2.00 per share 71 72 Investing and Financing Cash Flow Items: 73 Cash Dividends and 74 Cash Paid for Income Taxes 75 Cash Pad for Interest 76 Issuance of Common Stock Proceeds from New Borrowings 78 Proceeds from the sale of land 79 Purchase of Plant Assets 30 Repayment of long-term Debt Principal $4,010,000 2.060,000 983.000 1.020,000 1,891,000 598.000 3.541,000 1,470,000 33 BS 16 37 BB 30 91 92 Intro Page Trial Balances IS and CIS IS Supporting Schedules SOE 8S BS Supporting Schedules S Type here to search O RI E