Answered step by step
Verified Expert Solution
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
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 BalanceStep 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