Answered step by step
Verified Expert Solution
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 :
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 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 !
Step 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