Create a balance statement for the year 2020 accounts with this information

\begin{tabular}{|l|r|r|} \hline Accounts & 2021 & 2020 \\ \hline Accounts Payable & $1,500,000 & $2,500,000 \\ \hline Accounts Receivable & 1,753,000 & 1,940,000 \\ \hline Accumulated Depreciation - Building & 4,000,000 & 3,000,000 \\ \hline Accumulated Depreciation - Equipment & 1,150,000 & 900,000 \\ \hline Administrative Salary Expense & 4,700,000 & 3,774,000 \\ \hline Administrative Supply Expense & 499,000 & 450,000 \\ \hline Advertising Expense & 2,212,000 & 2,331,000 \\ \hline Allowance for Uncollectible Accounts & 53,000 & 40,000 \\ \hline Amortization Expense(\$200,000 - Franchise \& \$300,000 - Patents) & 500,000 & 500,000 \\ \hline Uncollectible Account Expense & 42,000 & 47,000 \\ \hline Bonds Payable & 14,000,000 & 19,500,000 \\ \hline Building & 29,000,000 & 28,987,000 \\ \hline Cash & 2,750,000 & 6,204,000 \\ \hline Common Stock, \$10 Par value, 2,000,000 Shares Authorized, 1,200,000 & 12,000,000 & 12,000,000 \\ \hline Shares Issued & & \\ \hline Delivery Expense (to our customers) & 3,036,000 & 3,000,000 \\ \hline Depreciation Expense - Building & 1,000,000 & 1,000,00 \\ \hline Depreciation Expense - Equipment* & 250,000 & 250,000 \\ \hline Dividends Declared (\$400,000 to P/S \& remainder to C/S) & 8,050,000 & 6,000,000 \\ \hline Dividends Payable & 1,000,000 & 0 \\ \hline Equipment & 15,000,000 & 14,964,000 \\ \hline Freight-in & 812,000 & 906,000 \\ \hline Franchise, net & 3,100,000 & 3,300,000 \\ \hline Income Tax Expense (see note 1) & 30% & 30% \\ \hline Insurance Expense* & 200,000 & 200,000 \\ \hline Interest Expense & 1,748,000 & 1,600,000 \\ \hline Inventory, beginning & 5,150,000 & 4,400,000 \\ \hline Inventory, ending & 4,200,000 & 5,150,000 \\ \hline Investment in Sregor Inc. Common Stock (controlling interest) & 5,000,000 & 0 \\ \hline Land (currently in use) & 1,300,000 & 1,300,000 \\ \hline Land (held for future use) & 500,000 & 0 \\ \hline Mortgage Payable (\$2,000,000 of it is current) & 12,400,000 & 14,400,000 \\ \hline Paid in Capital in Excess of Par Value, Common Stock & 700,000 & 700,000 \\ \hline Paid in Capital in Excess of Par Value, Preferred Stock & 500,000 & 0 \\ \hline Patents, net & 1,100,000 & 1,400,000 \\ \hline Preferred Stock, \$10 Par Value, 8\%, 800,000 Shares Authorized, and & 5,000,000 & 0 \\ \hline 500,000 Issued and Outstanding & 573,000 & 573,000 \\ \hline Premium on Bonds Payable & & \\ \hline \end{tabular} Additional Information: The Company's policy on Income Tax Expense is to pay the full amount when due on April 15 of the following year. Since it was not been paid in the year incurred, it is classified on the Balance Sheet as Income Tax Payable. Round to the nearest dollar. The year-end market price per share of common stock is $38 for the current year. *Depreciation on Equipment, Rent, Insurance, and Utility Expense are allocated 80% to Selling and 20% to General and Administrative. The company's policy is to use four classifications of expenses on the Income Statement Cost of Goods Sold, Selling, General and Administrative, and Income Tax. General and Administrative catch all costs that do not clearly fit in the other classifications Requirements: Create the Income Statement, Statement of Retained Earning and the Balance Sheet for the prior year. Create a formal classified Income Statement for the current year (include earnings per share) Create a formal Statement of Retained Earnings for the current year. Create a formal classified Balance Sheet for the current year Create a formal Statement of Cash Flows (Indirect Method) for the current year only. The following information relates to the Statement of Cash Flow. The preferred stock was issued to retire $5,500,000 of bonds. This was considered a non-cash financing activity. There were no other non-cash financing or investing activities In the current year the Company purchased Sregor, Stock, land for future use, building improvements, and office equipment. In the current year, the Company paid dividends, the current portion of the mortgage, and purchased treasury stock. Calculate all the ratios listed in Chapter 15 for the current year only.] \begin{tabular}{|l|r|r|} \hline Accounts & 2021 & 2020 \\ \hline Accounts Payable & $1,500,000 & $2,500,000 \\ \hline Accounts Receivable & 1,753,000 & 1,940,000 \\ \hline Accumulated Depreciation - Building & 4,000,000 & 3,000,000 \\ \hline Accumulated Depreciation - Equipment & 1,150,000 & 900,000 \\ \hline Administrative Salary Expense & 4,700,000 & 3,774,000 \\ \hline Administrative Supply Expense & 499,000 & 450,000 \\ \hline Advertising Expense & 2,212,000 & 2,331,000 \\ \hline Allowance for Uncollectible Accounts & 53,000 & 40,000 \\ \hline Amortization Expense(\$200,000 - Franchise \& \$300,000 - Patents) & 500,000 & 500,000 \\ \hline Uncollectible Account Expense & 42,000 & 47,000 \\ \hline Bonds Payable & 14,000,000 & 19,500,000 \\ \hline Building & 29,000,000 & 28,987,000 \\ \hline Cash & 2,750,000 & 6,204,000 \\ \hline Common Stock, \$10 Par value, 2,000,000 Shares Authorized, 1,200,000 & 12,000,000 & 12,000,000 \\ \hline Shares Issued & & \\ \hline Delivery Expense (to our customers) & 3,036,000 & 3,000,000 \\ \hline Depreciation Expense - Building & 1,000,000 & 1,000,00 \\ \hline Depreciation Expense - Equipment* & 250,000 & 250,000 \\ \hline Dividends Declared (\$400,000 to P/S \& remainder to C/S) & 8,050,000 & 6,000,000 \\ \hline Dividends Payable & 1,000,000 & 0 \\ \hline Equipment & 15,000,000 & 14,964,000 \\ \hline Freight-in & 812,000 & 906,000 \\ \hline Franchise, net & 3,100,000 & 3,300,000 \\ \hline Income Tax Expense (see note 1) & 30% & 30% \\ \hline Insurance Expense* & 200,000 & 200,000 \\ \hline Interest Expense & 1,748,000 & 1,600,000 \\ \hline Inventory, beginning & 5,150,000 & 4,400,000 \\ \hline Inventory, ending & 4,200,000 & 5,150,000 \\ \hline Investment in Sregor Inc. Common Stock (controlling interest) & 5,000,000 & 0 \\ \hline Land (currently in use) & 1,300,000 & 1,300,000 \\ \hline Land (held for future use) & 500,000 & 0 \\ \hline Mortgage Payable (\$2,000,000 of it is current) & 12,400,000 & 14,400,000 \\ \hline Paid in Capital in Excess of Par Value, Common Stock & 700,000 & 700,000 \\ \hline Paid in Capital in Excess of Par Value, Preferred Stock & 500,000 & 0 \\ \hline Patents, net & 1,100,000 & 1,400,000 \\ \hline Preferred Stock, \$10 Par Value, 8\%, 800,000 Shares Authorized, and & 5,000,000 & 0 \\ \hline 500,000 Issued and Outstanding & 573,000 & 573,000 \\ \hline Premium on Bonds Payable & & \\ \hline \end{tabular} Additional Information: The Company's policy on Income Tax Expense is to pay the full amount when due on April 15 of the following year. Since it was not been paid in the year incurred, it is classified on the Balance Sheet as Income Tax Payable. Round to the nearest dollar. The year-end market price per share of common stock is $38 for the current year. *Depreciation on Equipment, Rent, Insurance, and Utility Expense are allocated 80% to Selling and 20% to General and Administrative. The company's policy is to use four classifications of expenses on the Income Statement Cost of Goods Sold, Selling, General and Administrative, and Income Tax. General and Administrative catch all costs that do not clearly fit in the other classifications Requirements: Create the Income Statement, Statement of Retained Earning and the Balance Sheet for the prior year. Create a formal classified Income Statement for the current year (include earnings per share) Create a formal Statement of Retained Earnings for the current year. Create a formal classified Balance Sheet for the current year Create a formal Statement of Cash Flows (Indirect Method) for the current year only. The following information relates to the Statement of Cash Flow. The preferred stock was issued to retire $5,500,000 of bonds. This was considered a non-cash financing activity. There were no other non-cash financing or investing activities In the current year the Company purchased Sregor, Stock, land for future use, building improvements, and office equipment. In the current year, the Company paid dividends, the current portion of the mortgage, and purchased treasury stock. Calculate all the ratios listed in Chapter 15 for the current year only.]