Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need hep with 2. out of the 4 a. ONLY use accounts that have adjusted balances for July 31, 2020 b. Include proper report

I need hep with 2. out of the 4

image text in transcribed

image text in transcribed

a. ONLY use accounts that have adjusted balances for July 31, 2020
b. Include proper report title
c. Not all rows or columns need to be used. Formulas MUST be used when necessary.
Use the following format (in order):
1. Input beginning balance (this is listed in the July, 31 2020 adjusted trial balance columns).
2. List net income (loss) and cash dividends (if applicable).
3. Subtotal items from #2 to calculate net increase or decrease in retained earnings.
4. Calculate ending balance.
1. Create multi-step Income Statement using the July 31, 2020 adjusted balances AND formatting information from IS tab. 2. Create statement of retained earnings using July 31, 2020 adjusted balances AND formatting information from stmnt of RE tab. 3. Create classified balance sheet using July 31, 2020 adjusted balances AND formatting information from BS tab. 4. Create statement of cash flows using the income statement, the "changes" columns from below, and the additional notes to the right of July 31,2020 adjusted trial balance columns. To complete the "changes" columns and the statement of cash flows: a. Input a formula in either the debit column OR the credit column to find the change in account balance from July 2019 to July 2020. b. Only complete the "changes" cells that are outlined and have 2019 beginning balances and 2020 ending balances. Do not find changes in cells that are grayed out. c. Use the "changes" amounts to create the statement of cash flows. Amounts from the income statement will also be needed. d. Pay attention to statement of cash flows additional information columns below. These give hints. to the student. Note that grades are based on organization, formula use, and clarity of financial statement. Other required items

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

Essentials Of Cost Accounting For Health Care Organizations

Authors: Steven Finkler, Judith Baker, David Ward

3rd Edition

0810235447, 9780763738136

More Books

Students also viewed these Accounting questions