Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ACCT 305 Essentials of Financial Accounting I Practice Set, Part 3 FA19 SERIAL PROBLEM (continued) Use Excel to complete the following: 1. Prepare an unadjusted

image text in transcribed

ACCT 305 Essentials of Financial Accounting I Practice Set, Part 3 FA19 SERIAL PROBLEM (continued) Use Excel to complete the following: 1. Prepare an unadjusted trial balance as of the end of December. 2. Prepare adjusting entries to reflect a through f and post to the general ledger. 3. Prepare an adjusted trial balance as of December 31, 2017, using formulas to come up with adjusted account balances. 4. Prepare the following financial statements: a. Income statement for the three months ended December 31, 2017. b. Statement of retained earnings for the three months ended December 31, 2017. c. Balance sheet as of December 31, 2017. 5. Record and post the necessary closing entries as of December 31, 2017. 6. Prepare a post-closing trial balance as of December 31, 2017.

I only need the statement of retained earnings, closing entries and post-closing trial balance and I do not need it to be in excel form.

Amanda Moore Business Solutions December 31, 2017 Credit Debit 3723 Debit Credit Credit Closing Entries Debit Credit Debit 96,372 Rac ing Trial Balance Debit Credit A/R - Alex's Engineering Co A/R-Easy Leasing ARHIFM CO recent Quy regret 2 1. 10 2.476 826 oreciation Office equipment Rumulates beprecation Computer equipe 500 1200 13.00 31,384 400 3.375 Retained earnings Dividends Computer services revenue Sales Sales returns and allowances Sales discount Cost of goods sold Depreciation expense-office equipment Depreciation expense-Computer equipment Wages expense insurance expense Rent expense Computer supplies expense Advertising expense Mileage expense Miscellaneous expenses Repairs expense--Computer Income Summary Totals WOODE 1900 2,753 396 11.306 104,65106,84 109,03109,034 Amanda Moore Business Solutions December 31, 2017 Credit Debit 3723 Debit Credit Credit Closing Entries Debit Credit Debit 96,372 Rac ing Trial Balance Debit Credit A/R - Alex's Engineering Co A/R-Easy Leasing ARHIFM CO recent Quy regret 2 1. 10 2.476 826 oreciation Office equipment Rumulates beprecation Computer equipe 500 1200 13.00 31,384 400 3.375 Retained earnings Dividends Computer services revenue Sales Sales returns and allowances Sales discount Cost of goods sold Depreciation expense-office equipment Depreciation expense-Computer equipment Wages expense insurance expense Rent expense Computer supplies expense Advertising expense Mileage expense Miscellaneous expenses Repairs expense--Computer Income Summary Totals WOODE 1900 2,753 396 11.306 104,65106,84 109,03109,034

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

More Books

Students also viewed these Accounting questions