Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer with all of the following : 1) 2) 3) 4) please include answer in a excel format So I can understand ! Only

Please answer with all of the following :
1)
2)
3)
4)
please include answer in a excel format So I can understand !
Only inlcude the chart of accounts listed !
Thank you!!
please please please make it as clear as possible as well as in excel form !
image text in transcribed
Penny Proud began operations as a private investigator on January 1, 2003. The trial balance cohamns of the work sheet for Proud PI at March 31 e as follows. Credit Debit 11,400 5,620 1,050 2,400 30,000 Accounts Titles Cash Accounts Recervable Supplies Prepaid Insurance Equipment Notes Payable Accounts Payable P. Proud, Capital P. Proud, Drawing Service Revenue Salaries Expense Travel Expense Rent Expense Miscellaneous Expense TOTAL 10,000 12,350 20,000 600 13,620 2,200 1,300 1,200 200 55.920 55070 OTHER DATA- a.) Supplies on hand total 3750 b.) Depreciation is $500 per quarter. c) Interest accrued on 6-month note payable, issued January 1, $300. d.) Insurance expires at the rate of $150 per month e) Services provided but unbilled at March 31 total 3750. INSTRUCTIONS: 1) Complete the worksheet 2.) Prepare an income statement and ouder's equity statement for the quarter and a classified balance sheet at March 31. P. Proud did not make any additional investments in the business during the quarter ended March 31, 2003 3.) Journalize the adjusting entries from the adjustments colarens of the work sheet 4.) Journalize the closing entries from the financial statement columns of the worksheet. CHART OF ACCOUNTS CASH NOTES PAYABLE TRAVEL EXPENSE ACCOUNTS RECEIVABLE INTEREST PAYABLE RENT EXPENSE PREPAID INSURANCE PENNY PROUD, CAPITAL MISC. EXPENSE SUPPLIES PENNY PROUD, DRAWING INTEREST EXPENSE EQUIPMENT SERVICE REVENUE DEPRECIATION EXPENSE ACCUM.DEPRE-EQUIPMT SALARIES EXPENSE INSURANCE EXPENSE ACCOUNTS PAYABLE SUPPLIES EXPENSE

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_2

Step: 3

blur-text-image_3

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

Curriculum Auditing

Authors: Fenwick W. English

1st Edition

0877625921, 978-0877625926

More Books

Students also viewed these Accounting questions

Question

Create a decision tree for Problem 12.

Answered: 1 week ago