Question: please answer fully ! Complete in a excel Format for me to understand please ! provide a income statement,Owners Equity Statement for the quarter and,

please answer fully !
Complete in a excel Format for me to understand please !
provide a
income statement,Owners Equity Statement for the quarter and, a Classified balancr sheet .
jouranalize the adjustinf entries ,Jouranlize the closing entries !
Thank you!
please answer fully !Complete in a excel Format for me to understand

Penny Prond began operations as a private investigator on January 1, 2003. The trial balance columns of the work sheet for Proud P.I at March 31 e as follows. Credit Debit 11,400 5,620 1,050 2,400 30,000 Accounts Titles Cash Accounts Receivable Supplies Prepaid Insurance Equipment Notes Payable Accounts Payable P. Proud, Capital P. Proud, Drawing Service Reveme 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.970 55.970 OTHER DATA: a.) Supplies on hand total $750 b.) Depreciation is 5500 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 5750. INSTRUCTIONS 1.) Complete the work sheet. 2.) Prepare an income statement and owner's equity statement for the quarter and a classified balance sheet at March 31. Proud did not make any additional investments in the business during the quarter ended March 31, 2003. 3.) Joumalize the adjusting entries from the adjustments columns 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!