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...
-
Subject : Taxation III The Venture Group of companies (Venture) has been established by a group of several entrepreneurs to undertake investments in Malaysia. Venture has not been granted any tax...
-
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,...
-
1. Suppose a pair of dice is thrown 18 times. How many times would we expect a sum of 7 to occur? 2. Expand (x + y)5. 3. What is the area under the standard normal curve between z = - 1.6 and z = 1.9?
-
1. What is the present value today of $30,000 due on after 4 years and discounted at 10% compounded annually? 2. What is the present value today of $40,000 due on after 4 years and discounted at 11%...
-
International and domestic transfer prices should always be calculated in the same way in order to avoid governmental and fiscal interference. Do you agree?
-
Industrial Technologies, Inc. (ITI), produces two compression machines that are popular with manufacturers of plastics: no. 165 and no. 172. Machine no. 165 has an average selling price of $30,000,...
-
Show that f(n) = 13 + 23 + ... + n is O(n4) For the t
-
For this assignment, we are going to change our point of view. You are now working for Woolly, and you are preparing Woolly's response to Mammoth's RFP to support the transition of the 12 staff from...
-
In class, we discussed how human behavior is influenced by groups. In this conversation we asked how "good" people can be influenced to do "bad" things via social factors. First, describe at least 1...
-
Congratulations! You have been chosen to participate in the future crime scene investigator program. You participated in a ride-along with a team of crime scene investigators and want to share what...
-
*26 of grigor Jam erf nietsub Assignment 501 vimanist 19 your At belas snow verbs at Unit 3, through Example.p14 14:05 noit (1) Collaborate as needed. Submit your own copy of your own work. Show your...
-
|6 14. Find the exact value of the expression: 4sin cos 15. Find the exact value of the expression: cos 16. Find the exact value of the expression: cos 17. Find the exact value of the expression: sin...
-
Dylan van Rooyen is the managing director of Fordsburg Car Centre (FCC), an automobile repair shop with 22 branches nationally. FCC is a family business that opened its doors in the suburb of...
-
Write a C++ function that takes two parameters hours and rates then calculate and return the employee pay. The function should consider the overtime pay for overtime hours over 40 which should be...
-
Discuss the hormones oxytocin and cortisol and the roles they play in any of the following: labor, delivery, bonding, and development. Here, you may use the Netflix series Babies (Season 1, Episode...
-
In the current year, the City of Omaha donates land worth $500,000 to Ace Corporation to induce it to locate in Omaha and create an estimated 2,000 jobs for its citizens. a. How much income, if any,...
-
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...
-
As MADD executive director Chuck Hurley describes it, Before the 1980s, drunk driving was how people got home. It was normal behavior. In May of that year, Candy Lightner's 13-year-old daughter was...
-
In the early 1990s, most programs that were working to alleviate homelessness in American cities followed a similar model. Homeless men and women could visit shelters, but could not obtain permanent...
-
In the late 19th century, more than half of all Americans lived on farms. New farming techniques, based on science, were being developed through university research, but older generations of farmers...
Study smarter with the SolutionInn App