Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the attached adjusted trial balance, prepare the following financial statements for 12/31/2018 in an Excel document. Each item should be completed in a separate

Using the attached adjusted trial balance, prepare the following financial statements for 12/31/2018 in an Excel document. Each item should be completed in a separate tab within that one Excel document. 1. Balance Sheet ( 10 Points) 2. Income Statement ( 10 Points) 3. Statement of Retained Earnings ( 10 Points) 4. Journal Entries - these should be prepared independently of the financial statements. ( 10 Points)

image text in transcribedimage text in transcribed

Credit Balances Debit Balances 43,535 17,790 1,225 4,000 3,850 20,000 Sudduth Detailing Services, Inc. Adjusted Trial Balance December 31, 2018 Account No. Cash 11 Accounts Receivable 12 Supplies 14 Prepaid Rent 15 Prepaid Insurance 16 Equipment 18 Accumulated Depreciation Equipment 19 Accounts Payable 21 Salaries Payable 22 Unearned Fees 23 John Sudduth, Capital 31 John Sudduth, Drawing 32 Detailing Services 41 Salary Expense 51 Supplies Expense 52 Rent Expense 53 Depreciation Expense 54 Insurance Expense 55 Miscellaneous Expense 59 400 1,600 275 2,350 50,000 18,000 64,550 3,575 2,800 2,000 400 350 1,650 119,175 119,175 Sudduth Detailing, Inc. Additional Information 2. a. 1. Assume Beginning Equity at December 1, 2018 was $0. Journal Entries - please make the following entries for activity that will take place in January 2019: (1/3) Detailed a Ferrari for $308 on account b. (1/12) Received AL Power bill for $573.28, due Feb. 3rd C. (1/21) Received $1,200 in advance for a package detail to be performed in March d. (1/25) Purchased a new industrial steam cleaner for $3,000 cash e. (1/31) Record Monthly Depreciation of $450

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

Making Accountability Work Dilemmas For Evaluation And For Audit

Authors: Marie-Louise Bemelmans-Videc, Jeremy Lonsdale, Burt Perrin

1st Edition

1412865557, 978-1412865555

More Books

Students also viewed these Accounting questions