Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Below is Banner Services unadjusted trial balance at the end of December 2018. Adjusting entries have not yet been made. Use the trial balance and

Below is Banner Services unadjusted trial balance at the end of December 2018. Adjusting entries have not yet been made. Use the trial balance and the information below to complete the spreadsheet.

Dec 31 A physical count show that $410 of supplies is still on hand.
Dec 31 The equipment was purchased at the beginning of the year and is expected to last four years with no residual value.
Dec 31 Of the balance of unearned revenue, $410 has been earned.
Dec 31 The amount in prepaid insurance is for an annual policy that was paid on September 1, 2018.

Required

Using the following trial balance, complete the adjustments, the adjusted trial balance, income statement, and balance sheet in the spreadsheet.

Do not enter dollar signs or commas in the input boxes.

Banner Services Spreadsheet December 31, 2018
Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet
Account DR CR DR CR DR CR DR CR DR CR
Cash 1,300 Answer Answer Answer Answer Answer Answer Answer Answer
Accounts Receivable 2,700 Answer Answer Answer Answer Answer Answer Answer Answer
Prepaid Insurance 3,600 Answer Answer Answer Answer Answer Answer Answer Answer
Office Supplies 800 Answer Answer Answer Answer Answer Answer Answer Answer
Equipment 6,300 Answer Answer Answer Answer Answer Answer Answer Answer
Accumulated Depreciation 0 Answer Answer Answer Answer Answer Answer Answer Answer
Accounts Payable 2,700 Answer Answer Answer Answer Answer Answer Answer Answer
Unearned Revenue 700 Answer Answer Answer Answer Answer Answer Answer Answer
Notes Payable 1,600 Answer Answer Answer Answer Answer Answer Answer Answer
Banner, Capital 4,760 Answer Answer Answer Answer Answer Answer Answer Answer
Banner, Withdrawals 1,400 Answer Answer Answer Answer Answer Answer Answer Answer
Service Revenue 11,800 Answer Answer Answer Answer Answer Answer Answer Answer
Depreciation Expense 0 Answer Answer Answer Answer Answer Answer Answer Answer
Insurance Expense 0 Answer Answer Answer Answer Answer Answer Answer Answer
Interest Expense 60 Answer Answer Answer Answer Answer Answer Answer Answer
Maintenance Expense 1,200 Answer Answer Answer Answer Answer Answer Answer Answer
Rent Expense 1,400 Answer Answer Answer Answer Answer Answer Answer Answer
Salaries Expense 1,100 Answer Answer Answer Answer Answer Answer Answer Answer
Supplies Expense 0 Answer Answer Answer Answer Answer Answer Answer Answer
Telephone Expense 800 Answer Answer Answer Answer Answer Answer Answer Answer
Travel Expense 900 Answer Answer Answer Answer Answer Answer Answer Answer
Total 21,560 21,560 Answer Answer Answer Answer Answer Answer Answer Answer
Net Income Answer Answer Answer Answer Answer Answer Answer Answer
Total Answer Answer Answer Answer Answer Answer Answer Answer

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

Investing In People Financial Impact Of Human Resource Initiatives

Authors: John W. Boudreau, Wayne F. Cascio, Alexis A. Fink

3rd Edition

1586446096, 978-1586446093

More Books

Students also viewed these Accounting questions