2 a Project Financials - this file Develop Combined Results - Pro from a Balance Sheet Using the appropriate column on Financing Balance Sheet spreadsheet add relevant accounting figures from the accepted Project Equipment and Project Acquisition Tabs. As an example the capital equipment tab indicates that additional investments in Accounts Receivable will occur. Place that value in the column for Equipment Project on the Accounts Receivable line. To balance - assume the net purchase amounts are addressed through the Venture Short Term loan. The Mortgage assumed in the acquisition will just be added to the existing mortgage line with the same remaining term Ensure that your Balance Sheet is Balanced - Total Assets = Total Liabilities and Equity Combined Results Earnings Impact GREENGO LTD. Balance Sheet January 31, 2023 Assets Current assets Opening Balance Sheet Equipment Project Acquisition Project Refinancing Decision Pro-forma Balance Sheet Cash $ $ 159,213 6,179,470 $ $ 159,213 4,620,000 6,338,683 4,620,000 4,620,000 Accounts receivable Inventory Prepaid expenses 4,154,920 4,154,920 4,154,920 115,000 9,049,133 115,000 9,049,133 115,000 15,228,603 6,179,470 2,010,000 Property, plant and equipment Land Buildings Equipment Vehicles 2,010,000 2,450,000 2,450,000 1,129,000 380,000 5,969,000 (435,001) 5,533,999 2,010,000 2,450,000 1,129,000 380,000 5,969,000 (435,001) 5,533,999 1,129,000 380,000 5,969,000 (870,001) 5,098,999 Less: Accumulated amortization (435,000) (435,000) Trademarks, patents and goodwill 330,000 330,000 330,000 $ 14,913,132 $ $ $ 14,913,132 $ 5,744,470 $ $ 20,657,602 Liabilities and Shareholders' Equity Current liabilities Accounts payable $ 5,248,320 $ 5,248,320 $ $ Deferred revenue 372,000 372,000 354,188 5,248,320 372,000 #DIV/0! Income taxes payable 354,188 #DIV/0! Venture short term loan - due on demand 3,133,000 3,133,000 Current portion of long term debt 195,000 9,302,508 195,000 9,302,508 #DIV/0! #DIV/0! 3,133,000 #DIV/0! #DIV/0! #DIV/0! Term loan 954,000 Less: portion due within one year 954,000 (100,000) 854,000 954,000 (100,000) 854,000 (100,000) 854,000 Refinance term loan #DIV/0! Less: portion due within one year #DIV/0! #DIV/0! #DIV/0! Mortgage Less: portion due within one year 1,150,000 (95,000) 1,055,000 1,150,000 (95,000) 1,055,000 #DIV/0! #DIV/0! 1,150,000 (95,000) 1,055,000 Total long term debt Less: portion due in one year 2,104,000 (195,000) 1,909,000 2,104,000 (195,000) 1,909,000 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Deferred income taxes payable 533,063 11,744,571 533,063 11,744,571 118,063 #DIV/0! 651,126 #DIV/0! #DIV/0! Shareholders' Equity Share capital Retained earnings 1,673,100 #DIV/0! #DIV/0! 1,673,100 1,495,461 3,168,561 14,913,132 $ 1,495,461 3,168,561 14,913,132 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! $ $ #DIV/0! #DIV/0! #DIV/0! $ Out of Balance = must be 0 - adjust cash 2 a Project Financials - this file Develop Combined Results - Pro from a Balance Sheet Using the appropriate column on Financing Balance Sheet spreadsheet add relevant accounting figures from the accepted Project Equipment and Project Acquisition Tabs. As an example the capital equipment tab indicates that additional investments in Accounts Receivable will occur. Place that value in the column for Equipment Project on the Accounts Receivable line. To balance - assume the net purchase amounts are addressed through the Venture Short Term loan. The Mortgage assumed in the acquisition will just be added to the existing mortgage line with the same remaining term Ensure that your Balance Sheet is Balanced - Total Assets = Total Liabilities and Equity Combined Results Earnings Impact GREENGO LTD. Balance Sheet January 31, 2023 Assets Current assets Opening Balance Sheet Equipment Project Acquisition Project Refinancing Decision Pro-forma Balance Sheet Cash $ $ 159,213 6,179,470 $ $ 159,213 4,620,000 6,338,683 4,620,000 4,620,000 Accounts receivable Inventory Prepaid expenses 4,154,920 4,154,920 4,154,920 115,000 9,049,133 115,000 9,049,133 115,000 15,228,603 6,179,470 2,010,000 Property, plant and equipment Land Buildings Equipment Vehicles 2,010,000 2,450,000 2,450,000 1,129,000 380,000 5,969,000 (435,001) 5,533,999 2,010,000 2,450,000 1,129,000 380,000 5,969,000 (435,001) 5,533,999 1,129,000 380,000 5,969,000 (870,001) 5,098,999 Less: Accumulated amortization (435,000) (435,000) Trademarks, patents and goodwill 330,000 330,000 330,000 $ 14,913,132 $ $ $ 14,913,132 $ 5,744,470 $ $ 20,657,602 Liabilities and Shareholders' Equity Current liabilities Accounts payable $ 5,248,320 $ 5,248,320 $ $ Deferred revenue 372,000 372,000 354,188 5,248,320 372,000 #DIV/0! Income taxes payable 354,188 #DIV/0! Venture short term loan - due on demand 3,133,000 3,133,000 Current portion of long term debt 195,000 9,302,508 195,000 9,302,508 #DIV/0! #DIV/0! 3,133,000 #DIV/0! #DIV/0! #DIV/0! Term loan 954,000 Less: portion due within one year 954,000 (100,000) 854,000 954,000 (100,000) 854,000 (100,000) 854,000 Refinance term loan #DIV/0! Less: portion due within one year #DIV/0! #DIV/0! #DIV/0! Mortgage Less: portion due within one year 1,150,000 (95,000) 1,055,000 1,150,000 (95,000) 1,055,000 #DIV/0! #DIV/0! 1,150,000 (95,000) 1,055,000 Total long term debt Less: portion due in one year 2,104,000 (195,000) 1,909,000 2,104,000 (195,000) 1,909,000 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Deferred income taxes payable 533,063 11,744,571 533,063 11,744,571 118,063 #DIV/0! 651,126 #DIV/0! #DIV/0! Shareholders' Equity Share capital Retained earnings 1,673,100 #DIV/0! #DIV/0! 1,673,100 1,495,461 3,168,561 14,913,132 $ 1,495,461 3,168,561 14,913,132 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! $ $ #DIV/0! #DIV/0! #DIV/0! $ Out of Balance = must be 0 - adjust cash