Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Financial Project Part 2 For this part of the project you will use the corrected trial balance provided and perform the following tasks in
Financial Project Part 2 For this part of the project you will use the corrected trial balance provided and perform the following tasks in excel. 1. Create a multi-step Income Statement. Marge and center columns A-C for rows 1-3 and enter the statement heading properly. The use column A for account titles, Column B for numbers that need to be calculated and Column C for the totals. Double underline net income. Use accounting format for the numbers (no decimal places). Please use formulas where necessary. 2. Journalize the 2 closing entries for the company. You may do this in a separate excel sheet (tab) or on paper. 3. Create a Statement of Retained Earnings. This will be another sheet (tab) in your Excel file. It will only need to be 2 columns wide. Merge and center the top 3 rows and enter the correct heading. Use column A for account titles and column B for calculations. Double underline the ending retained earnings balance. Please use formulas where necessary. 4. Create a classified Balance Sheet. This will be another sheet (tab) in you Excel file. Use the balance sheet I provided in part 1 of this project as a template (only one account must be added). Reminder: Your retained earnings balance has changed from what the trial balance states.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started