70 10 Condbonal Format Cet Formatting as Table Styles f Format 3 B A D H N DUIVIT Accounny Frapius FIVUT US METUSOR CALITUT VITTUUw by rex son nouse o P P4-18 Sherlock Holmes began operations as a private investigator on January 1, 2020. The trial balance columns of the worksheet for Sherlock Holmes PL at March 31, 2020, are as follows: Sherlock Holmes PL Work Sheet For the Quarter Ended March 31, 2020 Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance sheet Account des Dr. Cr. Dr. Cr. Dr. Gr. Cash Dr. Cr. Dr. Cr $11,400 Accounts Receivable 5,620 Supplies 1,050 Prepaid Insurance 2,400 Equipment 30.000 Notes Payable 10,000 Accounts Payable 12,350 S. Holmes, Capital 20,000 S. Holmes. Drawing 600 Service Revenue 13,620 Salaries Expense 2 200 Travel Expense 1,300 Rent Expense 1,200 Miscellaneous Expense 200 $55,970 $55.970 Supplies Expense Depreciation Expense Accumulated Depreciation Interest Expense Interest Payable Insurance Expense Totals Net Income Totals Key: (a) Supplies Used: (b) Depreciation Expense; (c) Accrued Interest on note; (d) Insurance Expired: (0) Service Revenue Earned but unbilled. Other data: 1. Supplies on hand total $680 of roofing supplies on hand. 2. Depreciation per quarter is $1,000 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 $830 Problem P4-1B + dy MacBook Pro D c F H N O P R 47 43 49 50 5 65 56 57 sa 59 60 62 63 64 05 66 (a) the worksheet above, and complete the worksheet Prepare an income statement and owner's equity statement for the quarter and a classified balance sheet of March 31. 5. Holmes make my dioral vestments in business during the quarter ended March 31, 2006 SHERLOCK HOLMES PL SHERLOCK HOLMES PA Income Statement Balance sheer For the Quarter Ended March 1, 2020 March 2020 Revens Account Amount Qurrents Expenses Cash Amount Account Amount Accounts Receivable Amount Account the Amount Supplies Amount Account title Amount Prepaid insurance Amount Account title Amount Totalcument es For Account title Amount Property, plant, and equipment Account Amount Equipment Amort Account Amount Accumulated Depreciation Amount Formula Account title Amount Totalausets Total expenses Formula Net Income Formula Labies and Owers Equy Current abilities Notes Payable Amount SHERLOCK HOLMES P.I Accounts Payable Art Owner's Equity Statement Interest Pay For the Quarter Ended March 31, 2020 Total current abilities Foru S. Holmes, Capital, Jan 1 Amount Owner's equity Title Amount S. Holmes, Capit Amor Title Amount Totallites and owners Formula Formula Amount S. Holmes, Capital, March 31 Formula 68 69 73 74 75 76 77 78 79 (c) Joumate the adjusting entries from the adjustments columns of the worksheet. Journalize the closing entries from the financial statement cons of the went sho Mar 31,05 Account Account Amount 81 82 Mar 31, 05 Account title Account Amount Amount Amount Mar 31, 05 Account title Account title BS Amour Amount Amount Mar 31. 05 Account title Account title Mar 31.06 Account title Account title Account title Accountitle Account the Account Account title Account title Account the Amount Art Amount Amount Amount Mar 31, 06 Account title Account title Amount Arount Amount 88 89 90 91 92 93 94 95 Amount Amount Mar 31, 05 Account title Account title Amount Mar 31, 05 Account title Account Amunt Mar 31, 06 Account title Account Amount 98 99 Problem P4-1B +