How Do I complete this balance sheet?

CH 9 Balance Sheet B D G H K M N o P 2. 3 4 B 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Copy each of the Balance Sheet Entries into the correct category in the Pro Forma balance sheet. When complete the number in the dark blue cell E23 will be $41.682.289 . Type that numbe to the yellow cell J19. The blue cell, E23, will become SO CAUTION - Do not type or use the delete key in a red cell Pro Forma Balance Sheet (Fiscal Year 1 Jan to 31 Dec) Current date 1 October 2020 Balance Sheet Entries $381,504 Cash on hand $49,521,322 Mortgage principal balance, 10 years remaining as of 1 Jan 2021 $69,150,000 23.05 price, 3,000,000 shares outstanding $99.169 Remaining 2020 mortgage payments $18.421.778 2019 Net Income (Prior year) $32.421,331 Retained earnings as of 31 Dec 2109 Lan $63 289.111 Bonds outstanding . $11,894 543 Package handler, Marietta warehouse $98,765,896 Buildings $32,000,508 Vehicles Goodwill = 319 so $11,000 318 Unpaid 2109 Taxes (cannot be deferred) $6,421 318 Unpaid Q3 salaries Own $9 843,691 Unpaid Supplier invoices Equ $66,443,298 Inventory $9.000.000 Treasury certificates T-bills, bonds) Goodwil needed to balance the balance Sheet - Assets $0 Liabilities so Owners Equity SO =0 $0 er CH 9 Balance Sheet B D G H K M N o P 2. 3 4 B 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Copy each of the Balance Sheet Entries into the correct category in the Pro Forma balance sheet. When complete the number in the dark blue cell E23 will be $41.682.289 . Type that numbe to the yellow cell J19. The blue cell, E23, will become SO CAUTION - Do not type or use the delete key in a red cell Pro Forma Balance Sheet (Fiscal Year 1 Jan to 31 Dec) Current date 1 October 2020 Balance Sheet Entries $381,504 Cash on hand $49,521,322 Mortgage principal balance, 10 years remaining as of 1 Jan 2021 $69,150,000 23.05 price, 3,000,000 shares outstanding $99.169 Remaining 2020 mortgage payments $18.421.778 2019 Net Income (Prior year) $32.421,331 Retained earnings as of 31 Dec 2109 Lan $63 289.111 Bonds outstanding . $11,894 543 Package handler, Marietta warehouse $98,765,896 Buildings $32,000,508 Vehicles Goodwill = 319 so $11,000 318 Unpaid 2109 Taxes (cannot be deferred) $6,421 318 Unpaid Q3 salaries Own $9 843,691 Unpaid Supplier invoices Equ $66,443,298 Inventory $9.000.000 Treasury certificates T-bills, bonds) Goodwil needed to balance the balance Sheet - Assets $0 Liabilities so Owners Equity SO =0 $0 er