Using Excel, please prepare the following three (3) statements.

1 - Prepare a Balance Sheet as of December 31, 2020, with proper headings and formatting, as outlined in your textbook, using the adjusted post-closing trial balance on page 2.

2 - Prepare an Income Statement for the Period January 1, 2021 to December 31, 2021, with proper headings and formatting, as outlined in your textbook, using the adjusted post-closing trial balance on page 3.

3 - Prepare a Balance Sheet as of December 31, 2021, with proper headings and formatting, as outlined in your textbook.

A few things to note: Your Income Statement format should include the various proper subtotals; you will need to determine Cost of Goods Sold using beginning and ending inventory balances and purchases; and ignore income taxes.

Pear Company Adjusted Trial Balance December 31, 2020 Credit Debit 3,463,422 1,010,560 825,347 804,752 6,600,000 1,200,000 443,499 2,584,136 10000 - Cash - Checking 12000 - Accounts Receivable 13200 - Inventory 15000 - Furniture and Equipment 15200 - Buildings and Improvements 15600 - Land 16400 - Vehicles 17000 - Accumulated Depreciation 18000 - Goodwill 18700 - Security Deposits Asset 20000 - Accounts Payable 21000 - Payroll Liabilities 23000 - Accrued Expenses 24000 - Note Payable - Current 28000 - Note Payable - Long Term 30100 - Capital Stock 32000 - Retained Earnings TOTAL 1,293,265 6,500 852,967 190,778 441,011 855,000 2,842,152 7,100,600 780,701 15,647,345 15,647,345 Pear Company Adjusted Trial Balance December 31, 2021 Debit 10000 - Cash - Checking 12000 - Accounts Receivable 13200 - Inventory 15000 - Furniture and Equipment 15300 - Buildings and Improvements 15600 - Land 16400 - Vehicles 17000 - Accumulated Depreciation 18000 - Goodwill 18700 - Security Deposits Asset 20000 - Accounts Payable 21000 - Payroll Liabilities 23000 - Accrued Expenses 24000 - Note Payable - Current 28000 - Note Payable - Long Term 30100 - Capital Stock 30200 - Dividends Paid 32000 - Retained Earnings 47900 - Sales 48300 - Sales Discounts 50000 - Beginning Inventory 51000 - Purchases 53000 - Ending Inventory 60200 - Automobile Expense 60400 - Bank Service Charges 61700 - Computer and Internet Expenses 62400 - Depreciation Expense 62600 - Equipment Rental 63300 - Insurance Expense 63400 - Interest Expense 63600 - Janitorial Expense 64300 - Meals and Entertainment Expense 64900 - Office Supplies 65600 - Payroll Expenses 66700 - Professional Fees 67200 - Repairs and Maintenance Expense 68100 - Telephone Expense 68400 - Travel Expense 68600 - Utilities Expense 70100 - Insurance Proceeds - Offr Life 70200 - Interest Income TOTAL Credit 7,587,962 854,620 784,564 1,800,524 7,500,000 2,200,000 651,875 2,859,687 1,493,265 6,500 6,748,147 192,896 328,321 745,000 2,358,456 7,100,600 580,000 780,701 17,974,159 124,521 825,347 5,634,776 784,564 536.899 3,411 89, 119 409,687 39,801 833,674 647,000 262,823 641,925 123,588 2,548,231 575,900 562,968 325,425 1,897,456 961,420 440,000 190,750 40,503,281 40,503,281