Adjusted Trial Balance Closing Trial Balance Accounts Payable Accounts Receivable Accrued Liabilities 72,000 70,500 103,000 90,000 171,300 154,500 Accumulated Depreciation - Buildings 51,000 45,000 Accumulated Depreciation - Equipment 18,000 16,500 Additional Paid in Capital 256,500 243,000 Allowance for Doubtful Accounts 4,500 3,000 Buildings 215,500 180,000 Cash Common Stock, $1 Par 145,800 123,000 28,500 27,000 Cost of Goods Sold 596,000 Depreciation Expense 19,500 Dividend Income 1,500 Dividends 45,000 Equipment 151,000 135,000 Gain from Discontinued Operation, net of tax 87,500 Gain on Sale of Equipment 3,000 Goodwill 60,000 60,000 Income Taxes 23,000 Insurance Expense 12,000 Interest Expense 12,500 Interest Income 4,000 Inventory 130,000 135,000 Investment in ABC Stock 21,000 Land 45,000 45,000 Loss from Discontinued Operation, net of tax 15,000 Notes Payable (due in 4 years) 135,000 150,000 Prepaid Rent 11,000 7,500 Rent Expense 101,000 Retained Earnings 66,000 66,000 Sales Revenue 1,201,000 Treasury Stock Wages Expense 31,500 362,000 Amazon Corp.'s adjusted trial balance as of 12/31/2021 is presented in the accompanying Excel document, along with the 12/31/2020 closing trial balance. NOTE: all balances are presented in their natural account balances so you have to determine which are debits/credits. The following information is available for 2021. a. Equipment was sold for $16,000 (which originally cost $25,000 and accumulated depreciation $12,000 at the time of the sale). This sale resulted in a gain of $3,000. All other changes in Property, Plant and Equipment accounts relate to purchases and depreciation expense, respectively. b. The change in Notes Payable included both $35,000 issuance of new Notes Payable and $50,000 in payments during 2021. c. There were no sales of investments (ABC stock) during the year, and no gain or loss on that investment. d. Any other changes in accounts reflect "normal" transactions for each account. Think about why an account would increase/decrease to determine how it affects the Statement of Cash Flows. Assignment Requirements: 1. Prepare the 2021 financial statements using Excel, which includes: a. Income Statement (multi-step) b. Statement of Stockholders' Equity (NOT just Retained Earnings) c. Balance Sheet (classified; also show both the 2021 and 2020 numbers) d. Statement of Cash Flow These statements should be in proper form, including formatting. See the Financial Statement Formatting document in the Assignments tab of Blackboard for details on formatting expectations. 2. Create the following Charts in Excel a. Pie Chart in Excel of 2021 Expenses, every expense except any related to Discontinued Operations b. Chart (your choice on type - whichever you think works the best!) showing the Revenue including: i. 2021 Sales Revenue from the details in Requirement 1 above ii. Previous years as follows: Year 2017 2018 2019 Sales Revenue $864,000 $901,500 $973,000 $1,035,000 2020 2021 Per Income Statement iii. Insert an approximate Trendline (you can manually insert a line if that's easier). If future Sales Revenue amounts are in line with the trendline for the past 5 years, what do you predict Revenue will be for 2022? Here are the formatting expectations: a. Put the Charts in a separate Sheet within your Excel document. i. You can create a separate Table/summary of the expenses if that helps you create your Chart. b. Play with the different options to show the following information on the chart: i. Pie Chart: the 1) account name and 2) percentage (not dollar amount) ii. Chart 2: Year rinto Title for each chart