The Unadjusted Trial Balance of Leonardo DaVinci business for the year ending on Dec 31, 2021 is provided in the excel sheet 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.

For year ended Dec 31, 2021 Cr 20,86,536 2,10,000 4,90,500 Dr Cash 14,60,971 Short Term Investments 2,18,823 Accounts Receivable 2,12,525 Prepaid Rent 84,000 Prepaid Insurance 23,208 Prepaid Printing 78,000 - Supplies 19,354 : Plant 29,80,765 Accoumulated Depreciation - Plant Building 12,00,000 Accoumulated Depreciation - Building Equipment 9,81,000 Accoumulated Depreciation - Equipment Trademark 28,976 Bank Loan - Short Term Bank Loan - Long Term Notes Payable Accounts Payable Salaries Payable Bonus Payable - Unearned Revenue Interest Payable = Income Tax Payable Capital, DaVinci Drawings, DaVinci 1,75,000 Service Revenue Interest Revenue Rent Expense Insurance Expense Printing Expense Supplies Expense Depreciation Expense - Salaries Expense 35,496 Bonus Expense 11,000 Interest Expense Income Tax Expense 75,09,118 2,50,000 12,87,000 1,45,000 3,14,789 18,754 23,005 98,263 18,234 14,77,535 9,71,278 1,18,224 75,09,118 For year ended Dec 31, 2021 Cr 20,86,536 2,10,000 4,90,500 Dr Cash 14,60,971 Short Term Investments 2,18,823 Accounts Receivable 2,12,525 Prepaid Rent 84,000 Prepaid Insurance 23,208 Prepaid Printing 78,000 - Supplies 19,354 : Plant 29,80,765 Accoumulated Depreciation - Plant Building 12,00,000 Accoumulated Depreciation - Building Equipment 9,81,000 Accoumulated Depreciation - Equipment Trademark 28,976 Bank Loan - Short Term Bank Loan - Long Term Notes Payable Accounts Payable Salaries Payable Bonus Payable - Unearned Revenue Interest Payable = Income Tax Payable Capital, DaVinci Drawings, DaVinci 1,75,000 Service Revenue Interest Revenue Rent Expense Insurance Expense Printing Expense Supplies Expense Depreciation Expense - Salaries Expense 35,496 Bonus Expense 11,000 Interest Expense Income Tax Expense 75,09,118 2,50,000 12,87,000 1,45,000 3,14,789 18,754 23,005 98,263 18,234 14,77,535 9,71,278 1,18,224 75,09,118