Question
Complete the trial balance and the financial statements in excel. Set it up so that the format is good, underlines are thee and the
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
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