Assignment-4a: Below is the Unadjusted Trial Balance of Leonardo DaVinci business for the year ending on Dec 31, 2021 with some additional information. You will have to carry out the following tasks. 1. Create 10 column worksheet for the company for the year ended on Dec 31, 2021. 2. Complete the 10 column worksheet to show adjusting entries, adjusted trial balance, income statement and balance sheet. 3. Create Adjusting Journal Entries from the adjustment column below the 10 column worksheet. Leonardo Da Vinci Unadjusted Trial Balance For year ended Dec 31, 2021 Cr Cash Short Term Investments Accounts Receivable Prepaid Rent Prepaid Insurance Prepaid Printing Supplies Plant Accoumulated Depreciation - Plant Dr 1,460,971 218,823 212,525 84,000 23,208 78,000 19,354 2,980,765 2,086,536 F 2,086,536 210,000 490,500 23 Plant 2,980,765 24 Accoumulated Depreciation - Plant 25 Building 1,200,000 26 Accoumulated Depreciation - Building 27 Equipment 981,000 28 Accoumulated Depreciation - Equipment 29 Trademark 28,976 30 Bank Loan - Short Term 31 Bank Loan - Long Term 32 Notes Payable 33 Accounts Payable 34 Salaries Payable 35 Bonus Payable 36 Unearned Revenue + 37 Interest Payable 38 Income Tax Payable 20. Conital 250,000 1,287,000 145,000 314,789 18,754 23,005 98,263 18,234 Da Vinci 1177535 10,254 1,477,535 175,000 971,278 118,224 ayable 38 Income Tax Payable 39 Capital, DaVinci 40 Drawings, DaVinci 41 Service Revenue 42 Interest Revenue 43 Rent Expense 44 Insurance Expense 45 Printing Expense 46 Supplies Expense 47 Depreciation Expense UTB D E F. . K M N O A B Printing Expense Supplies Expense Depreciation Expense Salaries Expense Bonus Expense Interest Expense Income Tax Expense 35,496 11,000 7,509,118 7,509,118 Additional Information 1. Services valued 189,000 were provided to Customer Picaso on Dec 27, 2021 which was unrecorded and uncollected at end of the year. 2. Services valued 82,455 were provided to Customer Rembrandt in October, Rembrandt made the payment for these services on Jan 9, 2021. Adjustment was not made for this service. 3. The prepaid rent was paid in May 2021 and is related to renting a warehouse. The wareshouse was rented for Sep 1, 2021 - Oct 31, 2022. 4. The prepaid insurance was purchased in Apr 2021 trd is for the period of May 1, 2021 - Apr 30, 2023 5. DaVinci often requires printing of big posters. In Feb 2021, the company made a contract with BroCan Printing. BroCan agreed to print 100,000 posters for DaVinci for $78,000 if the pay 6. A physical count of inventory was conducted on Dec 31, 2021 and it was determined the value of the remaining Supplies was 12,251 on that date. 7. Services valued 93,500 were provided to Customer Vangogh on Dec 29, 2021 which was unrecorded and uncollected at end of the year. 8. The interest expense for 2021 is 40,500 which will be paid on Jan 19, 2022. No interest was paid in 2021. 9. The income tax expense for 2021 is 42,000 which was not recorded or paid. 10. On Dec 31, 2021, Salary of 14,500 and Bonus of 3,500 was not unpaid and unrecorded. 11. Depreciation expense for 2021 was a. Plant 149,000 b. Building 30,000 c. Equipment 32,700 12. The bank will pay DaVinci Interest of 1,218 for fixed term deposit for 2021 which was not received or recorded in 2021