Sapphire Gems and Minerals Co Ltd is a group of companies with six divisions within the Caribbean. Due to the illness of the companys Accountant, you have been asked to prepare the companys draft financial statements for submission to the Auditors for review and preparation of the consolidated financial reports. The trial balance for each division as of December 31, 2022, the end of the companys financial year is presented below. Having been exposed to the principles relating to Financial Accounting you are confident in your abilities to complete the task at hand. The following are the information of each division/branch along with the surnames who are required to prepare the requirements as outlined: 1. Kunzite Division - students with the surname initial (A, P, I, E, and V). 2. Pearl Division students with the surname initial (C, O, R, and Y) 3. Opal Division - students with the surname initial (K, Q, M, and F) 4. Turquoise Division -students with the surname initial (S, W, G, and Z) 5. Tourmaline Division -students with the surname initial (D, T, L, and U) 6. Garnet Division -students with the surname initial (N, B, J, X, and H) ACCT1002 Introduction to Financial Accounting Assignment # 2 Page | 3 Sapphire Gems and Minerals Co Ltd - Kunzite Division Trial Balance as of December 31, 2022 Cash 3,000,000 Accounts receivable 6,500,000 Allowance for bad debt 650,000 Other debtors Merchandise Inventory 10,000,000 Store Supplies 2,000,000 Prepaid Insurance 4,800,000 Prepaid rent 4,200,000 Furniture & Equipment 10,000,000 Accumulated deprecation-Furniture and equipment 3,960,000 Motor Truck 4,000,000 Accumulated depreciation- Motor Truck 2,951,424 Accounts payable 1,650,050 Salary payable Interest payable Unearned Sales revenue 2,800,000 Note Payable, long term 4,500,000 Capital 16,875,000 Withdrawals 150,000 Sales revenue 43,963,526 Sales discount 1,350,000 Sales returns and allowances 1,350,000 Cost of goods sold 11,500,000 Salaries expense 12,900,000 Insurance Expense Utilities Expense 1,400,000 Rent Expense 4,200,000 Depreciation Expense Furniture and Equipment Depreciation Expense Motor truck Store Supplies Expense Gain/loss on Disposal of Fixed Asset Bad-Debt Expense Interest Expense 77,350,000 77,350,000 Trial Balance ACCT1002 Introduction to Financial Accounting Assignment # 2 Page | 4 The following additional information is available December 31, 2022: 1) Store Supplies on hand on December 31, 2022, amounted to $800,000. 2) Insurance of $4,800,000 was paid on January 1, 2022, for the 15-months to March 31, 2023 3) Prepaid rent expired December 31, 2022, amounted to $3,000,000. 4) The furniture and equipment have an estimated useful life of 10 years and is being depreciated on the straight-line method down to a residual value of $100,000. 5) The motor truck cost relates to two Livi Trucks purchased for $2,000,000 each by the company on January 1, 2016. The double-declining balance method of depreciation is used to compute the trucks depreciation charges and their expected useful life is 10 years or 100,000 miles. In 2016, 10,000 miles were driven, 16,500 in 2017, 12,600 in 2018, 16,000 in 2019, 16,500 in 2020, 14,800 in 2021 and 16,800 in 2022. The residual value on both truck is $419,430 each. On September 1, 2022, the company sold one of the trucks to Daley Company for $600,000 on credit. Round off answers to the nearest dollar. 6) Salaries earned by employees and not yet paid amounted to $80,000 on Dec 31, 2022. 7) Accrued interest expense as of December 31, 2022, $80,000. 8) On Dec 31, 2022, $2,600,000 of the previously unearned sales revenue had been earned. 9) The aging of the Accounts Receivable schedule on Dec 31, 2022, indicated that the Allowance for Bad Debts should be $950,000. 10) A physical count of inventory was done on December 31, 2022, after making all the other adjustments and this revealed that there was $3,700,000 worth of inventory on hand at this point. Other data: 11) The business is expected to make principal payments totalling $400,000 towards the loan during the fiscal year to October 31,2023 Required: a) Prepare the necessary adjusting journal entries on Dec 31, 2022. [Narrations are not required] b) Prepare the Adjusted Trial balance for the period ending December 31, 2022. c) Prepare the following financial statements for the division: A Multiple-step income statement & a Statement of owners equity for the year ended December 31, 2022 A Classified balance sheet, in report format, at December 31, 2022.