Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Required: a. Use Excel to create an unadjusted trial balance for Post Plumbing, Inc. at January 31, 2019. b. Prepare the adjusting journal entries for

Required: a. Use Excel to create an unadjusted trial balance for Post Plumbing, Inc. at January 31, 2019. b. Prepare the adjusting journal entries for the month of January. Create additional accounts as necessary. c. Post all adjusting journal entries necessary to your Excel trial balance. d. Use Excel to create the adjusted trial balance. e. Prepare an unclassified balance sheet at January 31, 2019.The following account balances are provided for Post Plumbing, Inc. at January 31, 2019:

Cash $ 372,100

Accounts Receivable 359,000

Investments 30,000

Spare parts and supplies 38,000

Prepaid salaries expense 9,000

Prepaid rent 36,000

Equipment 721,850

Accounts payable 18,200

Interest payable 280

Unearned Revenue 22,000

Notes payable 35,000

Bank loan 426,000

Common Stock 625,000

Retained Earnings 99,150

Service Revenue 413,000

Interest Revenue 300

Parts and supplies expense 16,000

Loss on sale of investments 2,980

Salaries expense 50,000

Utilities expense 1,200

Advertising expense 2,800

The following additional information is provided for the month ending January 31, 2019:

1. Rent is paid through March 31, 2019.

2. Depreciation expense for the month was $9,950.

3. $3,800 of services paid for in December were rendered during January.

4. A physical count showed $29,000 of supplies on hand on January 31, 2019.

5. $3,500 of wages earned from January 27-31 will be paid in February.

6. The interest rate on the $35,000 note payable is 5%.

7. Received a January phone bill for $480 on February 4.

8. The investment balance includes an $18,000 note receivable with an interest rate of 2%.

9. Company purchases long-term disability insurance for its employees. The monthly premium is .25% of salaries expense and is payable quarterly.

10. The income tax rate is 21%

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

Accounting For Managers Financial Accounting

Authors: Morusu Sivasankar

1st Edition

6200624909, 978-6200624901

More Books

Students also viewed these Accounting questions

Question

define the term outplacement

Answered: 1 week ago

Question

describe the services that an outplacement consultancy may provide.

Answered: 1 week ago