I need a multi-step income statement, a statement of stockholders equity, a balance sheet, and a statement of cash flows for the above accounts.

Files Font Styles Voice Editor Reuse Files LD Corp's adjusted trial balance as of 12/31/2020 is presented in the accompanying Excel document, along with the 12/31/2019 closing trial balance. NOTE all balances are presented in their natural account balances so you have to determine which are debit/credits The following information is available for 2020 a. Equipment (cost $25,000 and accumulated depreciation $12,000) was sold for $15,000. All other changes in Property, plant and Equipment accounts relate to purchases and depreciation expense, respectively bThere was $70,000 in payments on the Notes Payable during 2020, the remaining change in account related to new loans issued There were no sales of investments (stocks and bonds) during the year C Assignment Requirements 1 Prepare the 2020 financial statements using Excel, which includes: a Income Statement (multi-step) b. Statement of stockholders' Equity (NOT just Retained Earnines) c Balance Sheet (classified; also show both the 2020 and 2019 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 Make sure to see the PowerPoint notes on Cash Flows in the Ch 5 folder in Blackboard! 2 Data Analytics - Create the following Charts Pie Chart in Excel Expenses, excluding any related to Discontinued Operations b. Chart (your choice on type - whichever you think works the best!) showing the Revenue and Income from Continuing Operations, including: 2020 into calculated in Requirement 1 above Previous years as follows Income from Continuing Year Revenue Operations 2016 $864,000 $55,000 2017 $901 500 $70 000 2018 $973,000 $79,000 2019 S1095.000 584,500 Insert a Trendline If future Revenue and Net Income amounts are in line with the trendline for the past 5 years, what do you predict Revenue and Net Income will be for 2021? Here are the formatting expectations Put the Charts in a separate Sheet within your Excel document You can create a separate Table of data, if that helps you create your Chart Play with the different options to show the 1) account name and 2 percentage (not dollar amount) on the chart Have an appropriate Title for the chart I a 116 words DS D Focus Type here to search O BI 9 D19 D C 12/31/2019 Closing Trial Balance 70,500 90,000 154,500 45,000 16,500 243,000 3,000 180,000 123,000 27,000 A 1 (All balances presented in their natural account balances) 2 3 4 Accounts Payable 5 Accounts Receivable 6 Accrued Liabilities 7 Accumulated Depreciation - Buildings 8 Accumulated Depreciation - Equipment 9 Additional Paid in Capital 10 Allowance for Doubtful Accounts 11 Buildings 12 Cash 13 Common Stock, $1 Par 14 Cost of Goods Sold 15 Depreciation Expense 16 Dividend Income 17 Dividends 18 Equipment 19 Gain from Discontinued Operation, net of tax 20 Gain on Sale of Equipment 21 Goodwill 22 Income Taxes 23 Insurance Expense 24 Interest Expense 25 Interest Income 26 Inventory 27 Investment in ABC Stock 28 Land 29 Loss from Discontinued Operation, net of tax 30 Notes Payable (due in 4 years) 31 Prepaid Rent 32 Rent Expense 33 Retained Earnings 34 Sales Revenue 35 Treasury Stock 36 Wages Expense 37 TB for Students Income Statement B 12/31/2020 Adjusted Trial Balance 68,500 104,000 196,000 51,000 18,000 256,500 4,500 220,500 148,500 28,500 585,000 19,500 1,500 45,000 148,000 87,500 3,000 60,000 25,000 12,000 12,500 4,000 133,000 24,000 45,000 15,000 135,000 10,000 93,500 66,000 1,184,000 31,500 372,000 135,000 60,000 135,000 45,000 150,000 7,500 66,000 Statemi... + Ready ra Files Font Styles Voice Editor Reuse Files LD Corp's adjusted trial balance as of 12/31/2020 is presented in the accompanying Excel document, along with the 12/31/2019 closing trial balance. NOTE all balances are presented in their natural account balances so you have to determine which are debit/credits The following information is available for 2020 a. Equipment (cost $25,000 and accumulated depreciation $12,000) was sold for $15,000. All other changes in Property, plant and Equipment accounts relate to purchases and depreciation expense, respectively bThere was $70,000 in payments on the Notes Payable during 2020, the remaining change in account related to new loans issued There were no sales of investments (stocks and bonds) during the year C Assignment Requirements 1 Prepare the 2020 financial statements using Excel, which includes: a Income Statement (multi-step) b. Statement of stockholders' Equity (NOT just Retained Earnines) c Balance Sheet (classified; also show both the 2020 and 2019 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 Make sure to see the PowerPoint notes on Cash Flows in the Ch 5 folder in Blackboard! 2 Data Analytics - Create the following Charts Pie Chart in Excel Expenses, excluding any related to Discontinued Operations b. Chart (your choice on type - whichever you think works the best!) showing the Revenue and Income from Continuing Operations, including: 2020 into calculated in Requirement 1 above Previous years as follows Income from Continuing Year Revenue Operations 2016 $864,000 $55,000 2017 $901 500 $70 000 2018 $973,000 $79,000 2019 S1095.000 584,500 Insert a Trendline If future Revenue and Net Income amounts are in line with the trendline for the past 5 years, what do you predict Revenue and Net Income will be for 2021? Here are the formatting expectations Put the Charts in a separate Sheet within your Excel document You can create a separate Table of data, if that helps you create your Chart Play with the different options to show the 1) account name and 2 percentage (not dollar amount) on the chart Have an appropriate Title for the chart I a 116 words DS D Focus Type here to search O BI 9 D19 D C 12/31/2019 Closing Trial Balance 70,500 90,000 154,500 45,000 16,500 243,000 3,000 180,000 123,000 27,000 A 1 (All balances presented in their natural account balances) 2 3 4 Accounts Payable 5 Accounts Receivable 6 Accrued Liabilities 7 Accumulated Depreciation - Buildings 8 Accumulated Depreciation - Equipment 9 Additional Paid in Capital 10 Allowance for Doubtful Accounts 11 Buildings 12 Cash 13 Common Stock, $1 Par 14 Cost of Goods Sold 15 Depreciation Expense 16 Dividend Income 17 Dividends 18 Equipment 19 Gain from Discontinued Operation, net of tax 20 Gain on Sale of Equipment 21 Goodwill 22 Income Taxes 23 Insurance Expense 24 Interest Expense 25 Interest Income 26 Inventory 27 Investment in ABC Stock 28 Land 29 Loss from Discontinued Operation, net of tax 30 Notes Payable (due in 4 years) 31 Prepaid Rent 32 Rent Expense 33 Retained Earnings 34 Sales Revenue 35 Treasury Stock 36 Wages Expense 37 TB for Students Income Statement B 12/31/2020 Adjusted Trial Balance 68,500 104,000 196,000 51,000 18,000 256,500 4,500 220,500 148,500 28,500 585,000 19,500 1,500 45,000 148,000 87,500 3,000 60,000 25,000 12,000 12,500 4,000 133,000 24,000 45,000 15,000 135,000 10,000 93,500 66,000 1,184,000 31,500 372,000 135,000 60,000 135,000 45,000 150,000 7,500 66,000 Statemi... + Ready ra