Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Accounting

Authors: Tracie L. Miller Nobles, Brenda L. Mattison, Ella Mae Matsumura

10th edition

133117413, 978-0133129519, 133129519, 978-0133129557, 133129551, 978-0133117561, 133117561, 978-0133117417

More Books

Students also viewed these Accounting questions

Question

What have you learnt from this exercise? LO1

Answered: 1 week ago