P4-1A Thomas Magnum began operations as a private investigator on January 1, 2008
XACC 280 P4-1A Thomas Magnum began operations as a private investigator on January 1, 2008. The trial balance columns of the worksheet for Thomas Magnum, P.I. at March 31 are as follows.
Axia College of University of Phoenix (UoP) Principles of Accounting Weygandt, J. J., Kimmel, P. D., & Kieso, D. E. (2008). Financial Accounting (6th ed.). Hoboken, NJ: Wiley.
P4-1A Thomas Magnum began operations as a private investigator on January 1, 2008. The trial balance columns of the worksheet for Thomas Magnum, P.I. at March 31 are as follows.
THOMAS MAGNUM, P.I., INC.
Worksheet
For the Quarter Ended March 31, 2008
Trial Balance
Account Titles Dr. Cr. Cash 11,400 Accounts Receivable 5,620 Supplies 1,050Prepaid Insurance 2,400 Equipment 30,000 Notes Payable 10,000 Accounts Payable 12,350 Common Stock 20,000 Dividends 600 Service Revenue 13,620 Salaries Expense 2,200 Travel Expense 1,300 Rent Expense 1,200 Miscellaneous Expense 200 55,970 55,970
Other data:
1. Supplies on hand total $380.
2. Depreciation is $1,000 per quarter.
3. Interest accrued on 6-month note payable, issued January 1, $300.
4. Insurance expires at the rate of $200 per month.
5. Services provided but unbilled at March 31 total $530.
Instructions
(a) Enter the trial balance on a worksheet and complete the worksheet.
(b) Prepare an income statement and a retained earnings statement for the quarter and a classified balance sheet at March 31. No additional common stock was issued during the quarter ended March 31, 2008.
(c) Journalize the adjusting entries from the adjustments columns of the worksheet.
(d) Journalize the closing entries from the financial statement columns of the worksheet.
SOLUTION PREVIEW[EXCEL TEMPLATE]
Axia College Material
Appendix E
Preparing a Financial
Statement Worksheet
Complete the 10-column worksheet for
Thomas Magnum P.I., Inc. Your totals
will be verified.
|
Thomas
Magnum P.I., Inc
Work
Sheet
For
the Quarter Ended March 31, 2008
|
||||||||||
|
Unadjusted
Trial Balance
|
Adjustments
|
Adjusted
Trial Balance
|
Income
Statement
|
Balance
Sheet & Statement of Owner's Equity
|
||||||
|
Account
|
Debit
|
Credit
|
Debit
|
Credit
|
Debit
|
Credit
|
Debit
|
Credit
|
Debit
|
Credit
|
|
Cash
|
11,400
|
|
|
|
11,400
|
|
|
|
11,400
|
|
|
Accounts Receivable
|
5,620
|
|
530
|
|
6,150
|
|
|
|
6,150
|
|
|
Supplies
|
1,050
|
|
|
670
|
380
|
|
|
|
380
|
|
|
Prepaid Insurance
|
2,400
|
|
|
600
|
1,800
|
|
|
|
1,800
|
|
File name: xacc280-appendix-E-Thomas-Magnum-V1.xls File type: application/vnd.ms-excel Price: $6
