Need a Balance Sheet, Income Statement, and Cash Statement for the below
Green Corporation is a fictitious retail garden nursery. You have been provided the December 31, 2019 balance sheet for Green Corporation, as well as a narrative of transactions that occurred during 2020. Using this information, prepare a December 31, 2020 balance sheet, and an income statement and indirect method statement of cash flows for the year ended December 31, 2020. Note that you will need to make some adjusting entries to account for what occurred with the passage of time (such as the part of the insurance policy being used up by year's end). Use the appropriate spreadsheet tabs to input your work. While not required, I recommend starting this exercise by filling in the pre-fab t-accounts in the "T-accounts" tab. For this case, it will suffice for you to turn in your completed Excel spreadsheet. Green Corporation Balance Sheet December 31, 2019 Assets Current Cash Accounts Receivable Inventory Total Current Assets Property and Equipment (net of $30,000 accumulated depreciation) 3 Total Assets 4 Liabilities and Shareholders' Equity 5 Current 7 Accounts Payable 3,000 2,000 10,000 15,000 50,000 65,000 26,000 Liabilities and Shareholders' Equity Current Accounts Payable Salary Payable Total Current Liabilities 10% Long-Term Note Payable Total Liabilities Common Stock Retained Earnings Total Liabilities and Shareholders' Equity 26,000 4,000 30,000 20,000 50,000 10,000 5,000 65,000 Relevant information for 2019 1. On June 30, 2020, Green Corp. paid $2,000 in cash for a 2-year fire insurance policy covering the period June 30, 2020 to June 30, 2022 2. On November 1, 2020, Green Company made the decision to expand into a new location and entered into a one-year rental contract covering the period November 1, 2020 to November 1, 2021. Under the new rent contract, Green agreed to pay $10,000 rent on the first day of each month. (Hint: Assume that Green Company complied with this agreement and paid the $10,000 in cash on the first day of each month.) 9 3. Green paid $50,000 in cash to purchase new equipment. 50 4. Equipment with a historical cost of $15,000 and accumulated 31 depreciation of $3,000 was sold for $14,000 in cash. B 5. Depreciation was $5,000 for the year. 6. Green made merchandising sales of $250,000 during the year All sales were on account (i.e, credit sales). 7. Collections of accounts receivable totaled $231,000 cash for the 8. Purchases of inventory totaled $113,000 for the year. Al purchases were on account (on credit). 9. The company counted inventory at year-end and determined the ending inventory balance to be $5,000. 10. Payments to suppliers for purchases on account totaled $111,000 in cash. 11. On December 31, 2020, Green repaid the 10% note, along with accrued interest, by paying the bank $22,000 cash. 12. On December 31, 2020, Green issued a new 8% note. Proceeds from the note were $11,000. 13. Also on December 31, 2020, Green issued 5,000 shares ofil common equity. Each share yielded $5 in proceeds. 14. $23,000 in cash was paid during the year for salaries to employees, and the ending balance in salaries payable on Dec. 31, 2020 was $2,000. 15. Cash payments for other operating expenses totaled $500! 16. Green paid dividends of $3,000 during the year. 17. Green operates in a tax-free jurisdiction. (Are they lucky or what?)
