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. rev texp 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

Step: 3

blur-text-image

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

Cost Benefit Analysis Concepts and Practice

Authors: Anthony Boardman, David Greenberg, Aidan Vining, David Weimer

4th edition

137002696, 978-1108448284, 1108448283, 978-0137002696

More Books

Students also viewed these Accounting questions

Question

(16b-2c)(25b4c-5) / 15b5c-1)(8b-7c-2) Simplify.

Answered: 1 week ago

Question

What is the effect of word war second?

Answered: 1 week ago

Question

Write a paper about medication error system 2016.

Answered: 1 week ago