How would I make income statement for J & L Accounting, Inc. from this adjusted trial balance? Please see the attached adjusted trial balance, general ledgers and journal entries... I would prefer to see how to with excel

5 years projections - Excel - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in E19 X V fc A B C D E F G H I J K L M IN Adjusted trial Balance Account Titles Debit Credit Cash $ 10,460.00 Accounts Receivable $ 3,750.00 Prepaid rent $ 11,000.00 Office supplies S 75.00 Accumulated Depreciation-Vehicles $ 1,000.00 Accumulated Depreciation-Equipment $ 100.00 Accounts Payable $ 2,925.00 Service Revenue 8,375.00 Rent expense $ 1,000.00 Advertising Expense S 2,350.00 Telephone expense 660.00 15 Utilities expense 2,925.00 16 Depreciation-Vehicle S 1,000.00 17 Depreciation-Equipment $ 100.00 18 19 TOTAL $ 22,860.00 $ 22,860.00 20 Activate Windows Sheet2 Sheet4 Sheet5 Sheet6 Sheet3 + Go to Settings to activate Windows. READY + 124% H Type here to search WE P 3 A B DENG 3:51 pm 23/08/2020Debit Credit 1 Date Accounts Post Ref 2 1.) 1/1/2018 Prepaid Rent 12,000 3 Cash 12,000 4 5 2.) 1/4/2018 Cash 1,900 6 Service Revenue 1,900 7 8 3.) 1/9/2018 Advertising Expense 850 9 Cash 850 10 11 4.) 1/10/2018 Office Supplies 75 12 Cash 75 13 14 5.) 1/14/2018 Cash 2,725 15 Service Revenue 2,725 16 17 6.) 8: 7.) 1/20/2018 Telephone Expense 660 18 Cash 660 19 8.) 1/20/2018 Utilies Expense 2925 Accounts Payable 2925 To record utility bill received 9.) 1/27/2018 Accounts Receivable 3750 Service Revenue 3750 Accounting services are performed on account 10.) 1/27/2018 Advertising Expense 1500 Cash 1500 To record advertisements paid 1/31/2018 Prepaid Rent 1000 Rent Expense 1000 To record prepaid rent 1/31/2018 Depreciation Expense 1000 Accumulated Depreciation 1000 To record vehicle depreciation 1/31/2019 Depreciation Expense 100 Accumulated Depreciation 100 To record equipment depreciationCash Account Service Revenue Dr. Dr. Date Particulars Amounts Date Particulars Amounts Date Particulars Amounts |Date Particulars Amounts 4-Jan-18 Service revenue 1,900 1-Jan-18 Prepaid rent 12,000 4-Jan-18 Cash 1,900 14-Jan-18 Service revenue 2,725 9-Jan-18 Advertising Expense 850 14-Jan-18 Cash 2,725 10-Jan-18 Office Supplies 75 27-Jan-18 Account receivable 3,750 20-Jan-18 Telephone Expense 660 28-Jan-18 Advertising Expense 1,500 Balance 10.460 Balance 8.375 15,085 15,085 8,375 8,375 Prepaid rent Advertising Expense Dr. Or. Dr. Or. Date Particulars Amounts Date Particulars Amounts Date Particulars Amounts Date Particulars Amounts 1-Jan-18 Cash 12,000 1-Jan-18 Cash 850 28-Jan-18 Cash 1,500 Balance 12.0 00 Balance 2,350 12,0 010 12.070 0] 2,350 2,350 Office Supplies Telephone Expense Dr. O. Dr. Or. Date Particulars Amounts |Date Particulars Amounts Date Particulars Amounts Date Particulars Amounts 1-Jan-18 Cash 75 20-Jan-18 Cash 660 Balance 75 Balance 660 15 75 560Account Payable Utilities Expense Dr. Or. Dr. Or. Date Particulars Amounts Date Particulars Amounts Date Particulars Amounts Date Particulars Amounts 20-Jan-18 Utilities Expense 2,925 20-Jan-18 Account payable 2,925 Balance 2,925 Balance 2.925 2,925 2,925 2,925 2925 Account Receivable Dr. Cr. Date Particulars Amounts Date Particulars Amounts 27-Jan-18 Service revenue 3.750 Balance 3,750 3,750 3,750Adjusting Entry For prepaid Rent is wong ; It should be: Debit Reut Expense $ 1000 credit Prepaid Rent - used For January . Prepaid Rent Rent Expanse Jon . 1-18 $ 1200 0 - 1000 Jan- 31 -18 Jan 21 - 18 $21000 1000 - Balany Balana $ 1606 1200 0 1200 0 $ 100 0 $ 10 0 0 Depreciation thehide Accommodated Depreciation - Vehicle Jan 31 - 18 $ 100 0 $ 1000 Jan . 31 - 18 $ 1000 Balance Balave $ 1000 @ 1000 1 1000 $ 1000 $ 1000 0 02 CAS 24 Depreciation = Equipment Accumulated Depreciation - Equipment Jaw - 31:48 $ 100 29 $ 100 Jan 31 = 18 s loe Balanel Balance $ 100 $ 100 $1 0 0 $ 100 002 602 29