a Develop Combined Results - Pro from a Balance Sheet Using the appropriate column on Financing...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
a 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 GREENGO LTD. Opening Balance Sheet Equipment Project Acquisition Project Combined Results Earnings Impact Refinancing Decision Balance Sheet January 31, 2023 Assets Current assets Cash $ 159,213 Accounts receivable 4,620,000 Inventory Prepaid expenses Property, plant and equipment 4,154,920 115,000 9,049,133 $ 159,213 4,620,000 6,179,470 $ 4,154,920 115,000 9,049,133 6,179,470 Pro-forma Balance Sheet $ 6,338,683 4,620,000 4,154,920 115,000 15,228,603 Land Buildings 2,010,000 2,450,000 2,010,000 2,450,000 Equipment Vehicles 1,129,000 1,129,000 380,000 380,000 2,010,000 2,450,000 1,129,000 380,000 5,969,000 5,969,000 5,969,000 Less: Accumulated amortization (435,001) (435,001) 5,533,999 5,533,999 (435,000) (435,000) (870,001) 5,098,999 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 $ $ 5,248,320 Deferred revenue 372,000 372,000 372,000 Income taxes payable 354,188 354,188 #DIV/O! #DIV/0! Venture short term loan - due on demand 3,133,000 3,133,000 3,133,000 Current portion of long term debt 195,000 195,000 #DIV/0! #DIV/0! 9,302,508 9,302,508 #DIV/O! #DIV/O! #DIV/0! Term loan 954,000 954,000 954,000 Less: portion due within one year (100,000) (100,000) (100,000) 854,000 854,000 854,000 Refinance term loan #DIV/0! #DIV/O! Less: portion due within one year #DIV/0! #DIV/O! #DIV/O! #DIV/0! Mortgage 1,150,000 1,150,000 1,150,000 Less: portion due within one year (95,000) (95,000) (95,000) 1,055,000 1,055,000 1,055,000 Total long term debt 2,104,000 2,104,000 #DIV/0! #DIV/0! Less: portion due in one year (195,000) (195,000) #DIV/O! #DIV/O! 1,909,000 1,909,000 #DIV/0! #DIV/0! Deferred income taxes payable 533,063 533,063 118,063 651,126 11,744,571 11,744,571 #DIV/0! #DIV/0! #DIV/0! Shareholders' Equity Share capital 1,673,100 1,673,100 #DIV/0! #DIV/O! Retained earnings 1,495,461 1,495,461 #DIV/0! #DIV/O! 3,168,561 3,168,561 #DIV/0! #DIV/0! #DIV/O! $ 14,913,132 $ $ $ 14,913,132 #DIV/O! #DIV/O! #DIV/O! Out of Balance = must be 0 - adjust cash #DIV/0! #DIV/0! #DIV/O! a 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 GREENGO LTD. Opening Balance Sheet Equipment Project Acquisition Project Combined Results Earnings Impact Refinancing Decision Balance Sheet January 31, 2023 Assets Current assets Cash $ 159,213 Accounts receivable 4,620,000 Inventory Prepaid expenses Property, plant and equipment 4,154,920 115,000 9,049,133 $ 159,213 4,620,000 6,179,470 $ 4,154,920 115,000 9,049,133 6,179,470 Pro-forma Balance Sheet $ 6,338,683 4,620,000 4,154,920 115,000 15,228,603 Land Buildings 2,010,000 2,450,000 2,010,000 2,450,000 Equipment Vehicles 1,129,000 1,129,000 380,000 380,000 2,010,000 2,450,000 1,129,000 380,000 5,969,000 5,969,000 5,969,000 Less: Accumulated amortization (435,001) (435,001) 5,533,999 5,533,999 (435,000) (435,000) (870,001) 5,098,999 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 $ $ 5,248,320 Deferred revenue 372,000 372,000 372,000 Income taxes payable 354,188 354,188 #DIV/O! #DIV/0! Venture short term loan - due on demand 3,133,000 3,133,000 3,133,000 Current portion of long term debt 195,000 195,000 #DIV/0! #DIV/0! 9,302,508 9,302,508 #DIV/O! #DIV/O! #DIV/0! Term loan 954,000 954,000 954,000 Less: portion due within one year (100,000) (100,000) (100,000) 854,000 854,000 854,000 Refinance term loan #DIV/0! #DIV/O! Less: portion due within one year #DIV/0! #DIV/O! #DIV/O! #DIV/0! Mortgage 1,150,000 1,150,000 1,150,000 Less: portion due within one year (95,000) (95,000) (95,000) 1,055,000 1,055,000 1,055,000 Total long term debt 2,104,000 2,104,000 #DIV/0! #DIV/0! Less: portion due in one year (195,000) (195,000) #DIV/O! #DIV/O! 1,909,000 1,909,000 #DIV/0! #DIV/0! Deferred income taxes payable 533,063 533,063 118,063 651,126 11,744,571 11,744,571 #DIV/0! #DIV/0! #DIV/0! Shareholders' Equity Share capital 1,673,100 1,673,100 #DIV/0! #DIV/O! Retained earnings 1,495,461 1,495,461 #DIV/0! #DIV/O! 3,168,561 3,168,561 #DIV/0! #DIV/0! #DIV/O! $ 14,913,132 $ $ $ 14,913,132 #DIV/O! #DIV/O! #DIV/O! Out of Balance = must be 0 - adjust cash #DIV/0! #DIV/0! #DIV/O! a 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 GREENGO LTD. Opening Balance Sheet Equipment Project Acquisition Project Combined Results Earnings Impact Refinancing Decision Balance Sheet January 31, 2023 Assets Current assets Cash $ 159,213 Accounts receivable 4,620,000 Inventory Prepaid expenses Property, plant and equipment 4,154,920 115,000 9,049,133 $ 159,213 4,620,000 6,179,470 $ 4,154,920 115,000 9,049,133 6,179,470 Pro-forma Balance Sheet $ 6,338,683 4,620,000 4,154,920 115,000 15,228,603 Land Buildings 2,010,000 2,450,000 2,010,000 2,450,000 Equipment Vehicles 1,129,000 1,129,000 380,000 380,000 2,010,000 2,450,000 1,129,000 380,000 5,969,000 5,969,000 5,969,000 Less: Accumulated amortization (435,001) (435,001) 5,533,999 5,533,999 (435,000) (435,000) (870,001) 5,098,999 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 $ $ 5,248,320 Deferred revenue 372,000 372,000 372,000 Income taxes payable 354,188 354,188 #DIV/O! #DIV/0! Venture short term loan - due on demand 3,133,000 3,133,000 3,133,000 Current portion of long term debt 195,000 195,000 #DIV/0! #DIV/0! 9,302,508 9,302,508 #DIV/O! #DIV/O! #DIV/0! Term loan 954,000 954,000 954,000 Less: portion due within one year (100,000) (100,000) (100,000) 854,000 854,000 854,000 Refinance term loan #DIV/0! #DIV/O! Less: portion due within one year #DIV/0! #DIV/O! #DIV/O! #DIV/0! Mortgage 1,150,000 1,150,000 1,150,000 Less: portion due within one year (95,000) (95,000) (95,000) 1,055,000 1,055,000 1,055,000 Total long term debt 2,104,000 2,104,000 #DIV/0! #DIV/0! Less: portion due in one year (195,000) (195,000) #DIV/O! #DIV/O! 1,909,000 1,909,000 #DIV/0! #DIV/0! Deferred income taxes payable 533,063 533,063 118,063 651,126 11,744,571 11,744,571 #DIV/0! #DIV/0! #DIV/0! Shareholders' Equity Share capital 1,673,100 1,673,100 #DIV/0! #DIV/O! Retained earnings 1,495,461 1,495,461 #DIV/0! #DIV/O! 3,168,561 3,168,561 #DIV/0! #DIV/0! #DIV/O! $ 14,913,132 $ $ $ 14,913,132 #DIV/O! #DIV/O! #DIV/O! Out of Balance = must be 0 - adjust cash #DIV/0! #DIV/0! #DIV/O! a 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 GREENGO LTD. Opening Balance Sheet Equipment Project Acquisition Project Combined Results Earnings Impact Refinancing Decision Balance Sheet January 31, 2023 Assets Current assets Cash $ 159,213 Accounts receivable 4,620,000 Inventory Prepaid expenses Property, plant and equipment 4,154,920 115,000 9,049,133 $ 159,213 4,620,000 6,179,470 $ 4,154,920 115,000 9,049,133 6,179,470 Pro-forma Balance Sheet $ 6,338,683 4,620,000 4,154,920 115,000 15,228,603 Land Buildings 2,010,000 2,450,000 2,010,000 2,450,000 Equipment Vehicles 1,129,000 1,129,000 380,000 380,000 2,010,000 2,450,000 1,129,000 380,000 5,969,000 5,969,000 5,969,000 Less: Accumulated amortization (435,001) (435,001) 5,533,999 5,533,999 (435,000) (435,000) (870,001) 5,098,999 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 $ $ 5,248,320 Deferred revenue 372,000 372,000 372,000 Income taxes payable 354,188 354,188 #DIV/O! #DIV/0! Venture short term loan - due on demand 3,133,000 3,133,000 3,133,000 Current portion of long term debt 195,000 195,000 #DIV/0! #DIV/0! 9,302,508 9,302,508 #DIV/O! #DIV/O! #DIV/0! Term loan 954,000 954,000 954,000 Less: portion due within one year (100,000) (100,000) (100,000) 854,000 854,000 854,000 Refinance term loan #DIV/0! #DIV/O! Less: portion due within one year #DIV/0! #DIV/O! #DIV/O! #DIV/0! Mortgage 1,150,000 1,150,000 1,150,000 Less: portion due within one year (95,000) (95,000) (95,000) 1,055,000 1,055,000 1,055,000 Total long term debt 2,104,000 2,104,000 #DIV/0! #DIV/0! Less: portion due in one year (195,000) (195,000) #DIV/O! #DIV/O! 1,909,000 1,909,000 #DIV/0! #DIV/0! Deferred income taxes payable 533,063 533,063 118,063 651,126 11,744,571 11,744,571 #DIV/0! #DIV/0! #DIV/0! Shareholders' Equity Share capital 1,673,100 1,673,100 #DIV/0! #DIV/O! Retained earnings 1,495,461 1,495,461 #DIV/0! #DIV/O! 3,168,561 3,168,561 #DIV/0! #DIV/0! #DIV/O! $ 14,913,132 $ $ $ 14,913,132 #DIV/O! #DIV/O! #DIV/O! Out of Balance = must be 0 - adjust cash #DIV/0! #DIV/0! #DIV/O!
Expert Answer:
Answer rating: 100% (QA)
In order to balance the proforma balance sheet for Greengo Ltd we need to adjust the cash amount to ... View the full answer
Related Book For
Basic Finance An Introduction to Financial Institutions Investments and Management
ISBN: 978-1111820633
10th edition
Authors: Herbert B. Mayo
Posted Date:
Students also viewed these accounting questions
-
Typhoon Sons & Company manufactures various types of golf clubs to third party vendors. On April 1, 2024, Typhoon delivers a large quantity of golf clubs to Resona Country Club. Under the sales...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
A new out-of-state client, Robert Ball, has asked you to prepare a Form 709 for a large gift he made in 2013. When you request copies of any prior gift tax returns he may have filed, he responds,...
-
For the probability distribution shown, find the x Pr(x) 1...........................1/12 2.............................1/6 3.............................1/3 4...........................5/12 (a)...
-
An electromagnetic standing wave in air of frequency 750 MHz is set up between two conducting planes 80.0 cm apart. At which positions between the planes could a point charge be placed at rest so...
-
Consider the National Football League data in Table B.1. Build a linear regression model relating the number of games won to the yards gained rushing by opponents $x_{8}$, the percentage of rushing...
-
In 2013, Lisa Perry opened Lisas Jeans Company, a small store that sold designer jeans in a suburban mall. Perry worked 14 hours a day and controlled all aspects of the operation. The company was...
-
Dana's Ribbon World makes award rosettes. Following is information about the company: Variable cost per rosette Sales price per rosette Total fixed costs per month Required: $ 2.00 5.00 1500.00 1....
-
In this mini-case you will perform some procedures required as a part of audit planning. For ease your audit manager has already organized the workpapers and completed several of the required...
-
Which of the following injury is called "Aviator's fracture' A Pott's fracture Total dislocation of talus Fracture neck of metatarsal D Subtalar dislocation E Fracture of neck of talus.
-
Graph each sequence in Problems 27-34 in one dimension. \(a_{n}=\frac{n+1}{n^{2}}\)
-
Graph the first-degree inequalities in two unknowns in Problems 13-48. \(2 x-3 y+6 \leq 0\)
-
In April 2023, an article in the Economist discussed Apples plans to increase the number of iPhones manufactured in India. According to the article, Apple is scrambling to avoid having all its apples...
-
An article in the Wall Street Journal on the Indian economy noted that an estimated 263 million Indians55 percent of the countrys workforceeke out a living from farms. This makes any attempt at...
-
In early 2021, an economist at a financial firm argued, If we want to recover from the pandemic, its not just a matter of getting to where we were back in February [2020] and declaring victory. Why...
-
Consider the conversion of glyceraldehyde 3-phosphate into 1,3- bisphosphoglycerate during glycolysis. If the P, used inthis reaction was uniformly labeled with 18O (see below), then how many of the...
-
Access the Federation of Tax Administrators Internet site at www. taxadmin.org/state-tax-forms and indicate the titles of the following state tax forms and publications: a. Minnesota Form M-100 b....
-
Ten years ago your grandfather purchased for you a 25-year $1,000 bond with a coupon rate of 10 percent. You now wish to sell the bond and read that yields are 8 percent. What price should you...
-
Big Toy, Inc. annually sells 100,000 units of Big Blobs. Currently, inventory is financed through the use of commercial bank loans. Big Toy pays $12.20 per Big Blob. The cost of carrying this...
-
The futures price of gold is $1,000. Futures contracts are for 100 ounces of gold, and the margin requirement is $5,000 a contract. The maintenance market requirement is $1,500. You expect the price...
-
At what height above the surface of Pluto is the acceleration due to gravity half its surface value?
-
How far above Farth's surface must a \(10,000-\mathrm{kg}\) boulder be moved to increase the mass of the Earthboulder system by \(2.50 \mathrm{mg}\) ? Assume the same ratio of energy change to mass...
-
Show that for small displacements the restoring force exerted on part 2 of the displaced string in Figure 15.14 is linearly proportional to the displacement of that part from its equilibrium...
Study smarter with the SolutionInn App