Question: a Develop Combined Results - Pro from a Balance Sheet Using the appropriate column on Financing Balance Sheet spreadsheet add relevant accounting figures from

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.

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!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

In order to balance the proforma balance sheet for Greengo Ltd we need to adjust the cash amount to ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related 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...

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...

In a simple linear regression model, the __________ is a function of only one independent variable. ANSWER Unselected second dependent variable Unselected independent variable Unselected standard...

Consider the following. Test Ho: 02 n=24, x 126.8, s = 21.3, H: 02 >15, a = 0.05 2 00 versus the given alternate hypothesis. State the test statistic. (Round your answer to two decimal places.) State...

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...

I need help with a last minute Accounting 1 assignment. My regular tutor is off the grid so I am looking for a replacement. I have created the outline for you and enclosed the rubric, plus all f the...

I really need help with making the balance sheet and income statement and post closing trial balance. Graded Project Ice Cream Systems 1 PROJECT INFORMATION 1 PROJECT INSTRUCTIONS 14 SUBMITTING YOUR...

Hello Guys, I need your help on that new two modules. I attached them file with this email. The module # 3 is related to the module two, which I submitted in my first questions. So I attached the...

The Tozer corporation is financed with 50% common stock which has a 20% expected return and 50% risk free debt which has a 5% expected return. What would the expected return on the company's stock be...

You are standing at a distance D from an isotropic point source of sound. You walk 50.0 m toward the source and observe that the intensity of the sound has doubled. Calculate the distance D.

9. (LO1, 2) In the context of the extended pie model, what is the basic goal of financial management with regard to capital structure?

12. In which of the following methods, we approximate the curve of solution by the tangent in each interval: secant method Bisection method Newton's method Fixed point method

Put the events of thyroid hormone synthesis into the correct order from first (1) to last (4). [ Select ] [" 4 ", " 1 ", " 2 ", " 3 "] Iodide ions move to follicular cells and undergo oxidation to...

RY OF UNITS Mid-Module Assessment Task 4 1 3. The football stadium at Louisiana State University (LSU) has a seating capacity of 92,542. a. According to the 2010 census, the population of San Jose,...

2. Write the matrix representation of the operation S4 on an arbitrary point (x,y,z) in space.

What happens if convertible debt is antidilutive? A. It's included in DEPS B. It's excluded C. It increases share count D. It increases net income

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...

Repeat Exercise 22.16, using the data on LDIVIDENDS and LCP. In exercise 22.16 Using the data on LPCE and LDPI introduced in Section 21.1 (see the books website for the actual data), develop a...

1. Create process maps for the before and after order management processes. Use Figure 8.15 as a guide. Start from when the consumer places the order and end when the shipment is made. 2. From these...

Class Exercise: Collect data on inflation and unemployment rates in the U.S. for the quarterly periods in 19802007 and develop and estimate a VAR model for the two variables. To compute the inflation...