Financial Data collected 20X1 Cash Common Stock Accounts Receivable Retained earnings Inventories Prepaid Expenses Land Building...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6657fc627c84e_2746657fc626f035.jpg)
Transcribed Image Text:
Financial Data collected 20X1 Cash Common Stock Accounts Receivable Retained earnings Inventories Prepaid Expenses Land Building China, Glass, etc. Accumulated depreciation Deferred income taxes ---Current Accounts payable Long-term debt Current portion of long-term debt Accrued Expense Marketable Securities Required 21,600 306,704 18,000 240,000 18,780 4,200 180,000 1,209,600 360,000 552,316 10,200 16,800 672,000 25,200 2,400 13,440 20X2 Financial Department Note 26,670 Business bank account balance at the end of the year 398,043 Common shares at the end of the year 9,652 Outstanding Accounts Receivable at the end of the year 203,200 Accumulated earning for previous years 40,640 Warehouse inventory balance at the end of the year 4,216 Advance payment for future 190,500 Land property balance at the end of the year 1,280,160 Building property balance at the end of the year 444,500 Other investment assets property 711,200 Total accumulated depreciation 10,668 Current deferred income tax owing 20,320 Owing balance at the end of the year 635,000 Net long-term loan borrowed from the bank 22,860 Current portion of the loan owing 2,667 Owing to utility providers 7,620 Investment in GIC and securities 1) Rearrange the Accounts order following the Balance Sheet Format 2) Calculate the sub-total for each category accounts on the Balance sheet 3) Calculate net working capital for 20x1 and 20x2 4) Calculate the amount change and percentage changes from 20x1 to 20x2. 5) Calculate the following ratio Current Ratio Acid Test Ratio A/R turn-over Ratio and Avg collection period Solvency Ratio Debt to Equity Ratio Other Info 2001 Total Revenue 2,600,000 2,180,000 2002 Total Revenue 2001 Net profit 2002 Net profit 195,000 1,416,000 Asset turn-over Ratio Profit Margin ROA ROE Financial Data collected 20X1 Cash Common Stock Accounts Receivable Retained earnings Inventories Prepaid Expenses Land Building China, Glass, etc. Accumulated depreciation Deferred income taxes ---Current Accounts payable Long-term debt Current portion of long-term debt Accrued Expense Marketable Securities Required 21,600 306,704 18,000 240,000 18,780 4,200 180,000 1,209,600 360,000 552,316 10,200 16,800 672,000 25,200 2,400 13,440 20X2 Financial Department Note 26,670 Business bank account balance at the end of the year 398,043 Common shares at the end of the year 9,652 Outstanding Accounts Receivable at the end of the year 203,200 Accumulated earning for previous years 40,640 Warehouse inventory balance at the end of the year 4,216 Advance payment for future 190,500 Land property balance at the end of the year 1,280,160 Building property balance at the end of the year 444,500 Other investment assets property 711,200 Total accumulated depreciation 10,668 Current deferred income tax owing 20,320 Owing balance at the end of the year 635,000 Net long-term loan borrowed from the bank 22,860 Current portion of the loan owing 2,667 Owing to utility providers 7,620 Investment in GIC and securities 1) Rearrange the Accounts order following the Balance Sheet Format 2) Calculate the sub-total for each category accounts on the Balance sheet 3) Calculate net working capital for 20x1 and 20x2 4) Calculate the amount change and percentage changes from 20x1 to 20x2. 5) Calculate the following ratio Current Ratio Acid Test Ratio A/R turn-over Ratio and Avg collection period Solvency Ratio Debt to Equity Ratio Other Info 2001 Total Revenue 2,600,000 2,180,000 2002 Total Revenue 2001 Net profit 2002 Net profit 195,000 1,416,000 Asset turn-over Ratio Profit Margin ROA ROE
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
A trunk with a weight of 220 N rests on the floor. The coefficient of static friction between the trunk and the floor is 0.41, and the coefficient of kinetic friction is 0.32. (a) What is the...
-
The following information relates to Ozone Ltd at 1 January 20X0: Required: (a) Using Hickss concept of income: (i) calculate the budgeted income for the year; (ii) calculate the actual income for...
-
The City of Paradise Falls plans to develop a golf course during 2013 and account for it as the Golf Enterprise Fund (GEF). The course will be built on a parcel of land to be purchased from a private...
-
The following account balances are for the Agee Company as of January 1, 2020, and December 31, 2020. All amounts are denominated in kroner (Kr). Accounts payable Accounts receivable Accumulated...
-
MKTG 1010En la investigacin del mercado, cules de los siguientes son una fuente externa de datos secundarios? Grupo de opciones de respuesta Libros de texto Bases de datos en lnea, publicaciones...
-
Business and management Question; Competition between developed nations has far-reaching consequences on the financial markets. Name at 4 least consequences and discuss each
-
1) What are the options that Chen/JMF are considering? 2) Why is Chen considering an investment? How does service from the local utility provider affect the potential investment decision? 3) Assess...
-
Which approach to trust repair is an effort to create rules, regulations, and procedures to minimize the likelihood of trust violations in the future
-
a) Organizations are increasingly adopting team approach in management of employees. Outline the benefits of this approach to an organization . b) Explain the factors that influence customer...
-
Write a business simulation game report of 2000 words.
-
2. Use the Gram-Schmidt algorithm to find the orthonormal bases in R. 2 2 3
-
What is the cost per batch of pencils if variable costing is used? a. $45 b. $105 c. $35 d. $109 Ariana Corp. makes pencils. The actual and budgeted overhead for the year was $350,000. The com- pany...
-
Bryon Ltd has held 1,500,000 shares in Carlyle Ltd for many years. At the date of acquisition, the reserves of Carlyle Ltd amounted to 800,000. On 31 March 2006 Carlyle Ltd bought 400,000 shares in...
-
On 1 April 2001, Machinery Limited bought 80% of the ordinary share capital of Components Limited. On 1 April 2003, Machinery Limited was itself taken over by Sales Limited who purchased 75% of the...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App