Please, I'm struggling on this assignment.

Use the data attached to do the following:

1: Provide a spreadsheet analyzing the changes in the account balances to prepare the statement of cash flows

Debits and credits need to be coded so I can follow the JEs. Use alpha characters, A, B, C, etc.

2: Statement of Cash Flows in Good Form - Direct Method

3: Statement of Cash Flows in Good Form - Indirect Method

MMM Company Balance Sheets At December 31, 2020 and 2019 2020 2019 Cash Investments, short term Accounts receivable, net Inventory Prepaid Insurance Total Current Assets $ 59,582 4,000 72,000 40,000 30,000 205,582 $ 55,000 8,000 48,000 120,000 20,000 251,000 Investment in Equity Method Investee Land Equipment, net Right of use asset, net Intangible assets, net Total Assets 40,000 250,000 50,000 45,000 350,000 65,163 60,653 35,000 $ 761.398 45,000 5 636.000 $ 70,000 8,000 Accounts payable Income taxes payable Unearned revenue Dividends payable Total current liabilities $ 38,000 5,000 2,000 6,000 51,000 12,000 90,000 20,000 Lease liability, long term Deferred tax liability Long term mortgage payable Note payable Bonds payable, net Total liabilities 63,398 25,000 80,000 100,000 358,398 168,000 239,000 Common stock Retained earnings 300,000 103,000 300,000 97,000 Total liabilities and stockholders' equity S761.398 $636.000 Additional Data: 1. On January 1, 2020, the fair value of the portfolio of short-term investments in debt securities, classified as available for sale, equaled cost. During 2020, investments carried at $3,000 were sold for $6,000. No securities were purchased during 2020. At December 31, 2020, the fair value of the portfolio is $4,000. 2. All sales are on account. The A/R balances are shown net of the allowance for doubtful accounts, $3000 at 12/31/20 and $2000 at 12/31/19. During 2020, A/R in the amount of $20,000 was written off and $3,000 was collected on an account written off in 2019. 3. The long term equity method investment represents a 25% interest in Ww Company. During 2020, ww paid a total of $100,000 in dividends to all of its stockholders and earned $120,000. 4. At the end of 2020, MMM acquired land for $100,000 by assuming an $80,000 mortgage and paying $20,000 in cash. 5. During 2020, Equipment with a cost of $20,000 and a book value of $8000 was sold at a gain. 6. During 2020, the company started and completed construction of equipment for its own use. The cost of the finished equipment is $50,000 and includes $5,000 of capitalized interest. No portion of this was financed. All was paid for with available cash. 7. Equipment is reported net of accumulated depreciation of $64,837 and $50,000 at 12/31/20 and 12/31/19, respectively. 8. On January 1, 2020, the company entered into a finance lease and recorded a right of use asset and a lease liability for $75,816. The interest rate used to capitalize the lease is 10%. Equal payments of $20,000 are due every December 31 for five years starting on 12/31/20. Interest expense on the income statement includes interest expense on the lease liability. 9. In 2020, the bonds were retired before maturity at a gain of $20,000. Prior to retiring the bonds, the company properly amortized discount in the amount of $4,000. At 12/31/19, the bonds are reported net of unamortized discount of $12,000. 10. During 2020, the company declared dividends to common stockholders in the amount of $70,000. 11. At the end of 2020, the company borrowed $100,000 and signed a note payable. MMM Company Balance Sheets At December 31, 2020 and 2019 2020 2019 Cash Investments, short term Accounts receivable, net Inventory Prepaid Insurance Total Current Assets $ 59,582 4,000 72,000 40,000 30,000 205,582 $ 55,000 8,000 48,000 120,000 20,000 251,000 Investment in Equity Method Investee Land Equipment, net Right of use asset, net Intangible assets, net Total Assets 40,000 250,000 50,000 45,000 350,000 65,163 60,653 35,000 $ 761.398 45,000 5 636.000 $ 70,000 8,000 Accounts payable Income taxes payable Unearned revenue Dividends payable Total current liabilities $ 38,000 5,000 2,000 6,000 51,000 12,000 90,000 20,000 Lease liability, long term Deferred tax liability Long term mortgage payable Note payable Bonds payable, net Total liabilities 63,398 25,000 80,000 100,000 358,398 168,000 239,000 Common stock Retained earnings 300,000 103,000 300,000 97,000 Total liabilities and stockholders' equity S761.398 $636.000 Additional Data: 1. On January 1, 2020, the fair value of the portfolio of short-term investments in debt securities, classified as available for sale, equaled cost. During 2020, investments carried at $3,000 were sold for $6,000. No securities were purchased during 2020. At December 31, 2020, the fair value of the portfolio is $4,000. 2. All sales are on account. The A/R balances are shown net of the allowance for doubtful accounts, $3000 at 12/31/20 and $2000 at 12/31/19. During 2020, A/R in the amount of $20,000 was written off and $3,000 was collected on an account written off in 2019. 3. The long term equity method investment represents a 25% interest in Ww Company. During 2020, ww paid a total of $100,000 in dividends to all of its stockholders and earned $120,000. 4. At the end of 2020, MMM acquired land for $100,000 by assuming an $80,000 mortgage and paying $20,000 in cash. 5. During 2020, Equipment with a cost of $20,000 and a book value of $8000 was sold at a gain. 6. During 2020, the company started and completed construction of equipment for its own use. The cost of the finished equipment is $50,000 and includes $5,000 of capitalized interest. No portion of this was financed. All was paid for with available cash. 7. Equipment is reported net of accumulated depreciation of $64,837 and $50,000 at 12/31/20 and 12/31/19, respectively. 8. On January 1, 2020, the company entered into a finance lease and recorded a right of use asset and a lease liability for $75,816. The interest rate used to capitalize the lease is 10%. Equal payments of $20,000 are due every December 31 for five years starting on 12/31/20. Interest expense on the income statement includes interest expense on the lease liability. 9. In 2020, the bonds were retired before maturity at a gain of $20,000. Prior to retiring the bonds, the company properly amortized discount in the amount of $4,000. At 12/31/19, the bonds are reported net of unamortized discount of $12,000. 10. During 2020, the company declared dividends to common stockholders in the amount of $70,000. 11. At the end of 2020, the company borrowed $100,000 and signed a note payable