What is the answer to this balance sheet
D F G H 1 K L M N O 2 . 17 9 10 Copy each of the lance Sheet Entries into the correct category in the Pro Forma bal csheet When complete the number in the dark blue cell E23 will be $41.682.289. Type that number into the yellow cell J19. The blue cell, E?? will become so CAUTION - Do not type or use the delete say 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 is of 1 Jan 2021 $69,150,000 23 05 prien, 3,000,000 shares outstanding $99 169 Remaining 2020 mortgage payments $18.421.778 2019 Net Income (Prior year) $32.421,331 Retained eamings as of 31 Dec 2109 $63,289,111 Bonds outstanding $11 894,543 Package handler, Marietta warehouse $98.765 896 Buldings $32,000 508 Vehicles Goodwill - 19 50 511 000,318 Unpaid 2109 Taxes cannot be deferred) $6,421 318 Unpaid Q3 salaries Own 59.843,691 Unpaid Supplier invoices 566,443 298 Inventory $9.000.000 Treasury certificates (T-bills, bonds) Goodwill needed to balance the balance Sheet Assets 50 - Liabilities Owners Equity SO =0 a. y 18 14 15 16 17 18 19 20 21 22 23 24 25 D F G H 1 K L M N P 2 9 10 Copy each of the lance Sheet Entries into the correct category in the Pro Forma bal sheet. When complete the number in the dark blue cell E23 will be $41.682.289. Type that number into the yellow cell J19. The blue cell, E27, will become so CAUTION - Do not type or use the delete say 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 2305 prien, 3.000.000 shares outstanding $99 169 Remaining 2020 mortgage payments $18.421.778 2019 Net Income (Prior year) $32.421,331 Retained Gamings as of 31 Dec 2109 $63,289,111 Bonds outstanding $11.894,543 Package handler, Marietta warehouse $98.765 896 Buldings $32,000 508 Vehicles Goodwill J19 SO $11 000,318 Unpaid 2109 Taxes cannot be deferred) $6,421 318 Unpaid Q3 salaries Owe $9.843 691 Unpaid Supplier invoices $66.443 298 Inventory $9.000.000 Treasury certificates (T-bills, bonds) Goodwill needed to "balance the balance Sheet Assets $0 - Liabilities 90 Owners Equity SO =0 La a2=28BBBB) 18 14 15 16 17 18 19 20 21 22 Ty D F G H 1 K L M N O 2 . 17 9 10 Copy each of the lance Sheet Entries into the correct category in the Pro Forma bal csheet When complete the number in the dark blue cell E23 will be $41.682.289. Type that number into the yellow cell J19. The blue cell, E?? will become so CAUTION - Do not type or use the delete say 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 is of 1 Jan 2021 $69,150,000 23 05 prien, 3,000,000 shares outstanding $99 169 Remaining 2020 mortgage payments $18.421.778 2019 Net Income (Prior year) $32.421,331 Retained eamings as of 31 Dec 2109 $63,289,111 Bonds outstanding $11 894,543 Package handler, Marietta warehouse $98.765 896 Buldings $32,000 508 Vehicles Goodwill - 19 50 511 000,318 Unpaid 2109 Taxes cannot be deferred) $6,421 318 Unpaid Q3 salaries Own 59.843,691 Unpaid Supplier invoices 566,443 298 Inventory $9.000.000 Treasury certificates (T-bills, bonds) Goodwill needed to balance the balance Sheet Assets 50 - Liabilities Owners Equity SO =0 a. y 18 14 15 16 17 18 19 20 21 22 23 24 25 D F G H 1 K L M N P 2 9 10 Copy each of the lance Sheet Entries into the correct category in the Pro Forma bal sheet. When complete the number in the dark blue cell E23 will be $41.682.289. Type that number into the yellow cell J19. The blue cell, E27, will become so CAUTION - Do not type or use the delete say 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 2305 prien, 3.000.000 shares outstanding $99 169 Remaining 2020 mortgage payments $18.421.778 2019 Net Income (Prior year) $32.421,331 Retained Gamings as of 31 Dec 2109 $63,289,111 Bonds outstanding $11.894,543 Package handler, Marietta warehouse $98.765 896 Buldings $32,000 508 Vehicles Goodwill J19 SO $11 000,318 Unpaid 2109 Taxes cannot be deferred) $6,421 318 Unpaid Q3 salaries Owe $9.843 691 Unpaid Supplier invoices $66.443 298 Inventory $9.000.000 Treasury certificates (T-bills, bonds) Goodwill needed to "balance the balance Sheet Assets $0 - Liabilities 90 Owners Equity SO =0 La a2=28BBBB) 18 14 15 16 17 18 19 20 21 22 Ty
