Question
1. Use the information in the provided trial balance to create the following financial statements: a. 2022 Income Statement b. 2022 Balance Sheet c.
1. Use the information in the provided trial balance to create the following financial statements: a. 2022 Income Statement b. 2022 Balance Sheet c. 2022 Cash Flow Statement 2. Create ONE Excel Workbook with the following tabs: a. Tab 1: Trial Balance for 2021 and 2022 provided b. Tab 2: Closing Entries for 2021 C. Tab 3: 2022 Income Statement d. Tab 4: Closing entries for 2022 e. Tab 5: 2022 Balance Sheet post-closing entries (Use the 2021 Retained Earnings balance as your beginning 2022 balance) f. Tab 6: 2022 Cash Flow Statement 3. Formulas: a. Use Excel to setup the financial statements by linking the values from the trial balance. b. Use Excel formulas to calculate all totals and sub-totals.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started