Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve this problem in excel step by step. Thank you. P 4-5 Overnight Auto Service Unadjusted Trial Balance 31-Dec-13 Credit Debit $18,592 6,500 1,800

image text in transcribed

image text in transcribed

Please solve this problem in excel step by step. Thank you.

P 4-5 Overnight Auto Service Unadjusted Trial Balance 31-Dec-13 Credit Debit $18,592 6,500 1,800 4,500 52,000 36,000 1,500 12,000 Cash Accounts Receivable Supplies Prepaid insurance Land Building Accumulated Depreciation: Building Equipment Accumulated Depreciation: Equipment Notes Payable Accounts Payable Income tax payble Unearned Rent Revenue Share Capital Retained Earnings Dividends Service Revenue Advertizing Expense Wages Expense Supplies Expense Depreciation Expense: Building Depreciation Expense: Equipment Utilities Expense Insurance Expense Icome tax expense 2,000 4,000 2,690 1,560 9,000 80,000 14,000 171,250 3,900 56,800 6,900 1,500 2,000 19,400 13,500 22,608 $272,000 $272,000 Adjusting Entries DATA 1 $1200 of supplies remain on hand at Dec. 31, 2013. 2 The company paid insurance premium of $4,500 at November 30 3 An additional $150 of depreciation expense is still needed on the building for December 4 An additional $200 of depreciation expense is still needed on the Equipment for December 5 On 1 December, Harbor Cab Co. agreed to rent space in Overnight's building. The agreed-upon rent is $3,000 per month. 6 At 31 December, the company owes its employees $1,950 for work performed in December 7 On November 30 2013, Overnight borrowed $4,000 by issuing an interest-bearing note payable at an annual interest of 9%. 8 Overnight entered into an agreement to perform routine maintenance by AS service for a fee of $1,500 per month. The company began rendering services on 15 December, but the first monthly payment will not be received until 15 January next year. 9 The income tax expense for 2013 is 40% of pretax income of $66,570. Requirements: 1 Present adjusting entries 2 Prepare adjusted Trial Balance 3 Prepare Balance Sheet and The Statement of Comprehensive Income 4 Present all of necessary closing entries 5 Prepare the post-closing Trial Balance

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

Internet Fraud Casebook

Authors: Joseph T. Wells

1st Edition

0470643633, 9780470643631

More Books

Students also viewed these Accounting questions

Question

4. Are there any disadvantages?

Answered: 1 week ago

Question

3. What are the main benefits of using more information technology?

Answered: 1 week ago

Question

start to review and develop your employability skills

Answered: 1 week ago