Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete the trial balance and the financial statements in excel. Set it up so that the format is good, underlines are thee and the

image text in transcribed

Complete the trial balance and the financial statements in excel. Set it up so that the format is good, underlines are thee and the statements flow from the trial balance to the income statement then the statement of retained earnings and the balance sheet. We will go over it in class. E3.11B (LO 4) (Prepare Financial Statements) The adjusted trial balance of Decimal Co. as of December 31, 2020, contains the following: DECIMAL CO. ADJUSTED TRIAL BALANCE DECEMBER 31, 2020 Account Titles Dr. Cr. Cash $ 6,590 Accounts Receivable 15,618 Prepaid Rent Equipment 1,200 31,800 Accumulated Depreciation-Equipment $9,680 Notes Payable 12,500 Accounts Payable 11,601 Common Stock 20,000 Retained Earnings 3,619 Dividends 6,000 Service Revenue 27,600 Salaries and Wages Expense 15,600 Rent Expense 7,800 Depreciation Expense 392 Interest Expense 211 Interest Payable 211 Instructions (a) Prepare an income statement. (b) Prepare a retained earnings statement. (c) Prepare a classified balance sheet.

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

Financial Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

8th edition

978-1118953815, 978-1118953907

More Books

Students also viewed these Accounting questions

Question

Why do advocates of TQM expect to earn higher profits?

Answered: 1 week ago