Question

In: Finance

Question 2: Balance Sheet Build and Analysis (20 Marks) Q.Clean, a student run dry-cleaning service has...

Question 2: Balance Sheet Build and Analysis

Q.Clean, a student run dry-cleaning service has the following financial information as of December 31, 2020:

  • The cash ending balance for the year was $117,820

  • Buildings & Equipment for the year was $91,350

  • Accounts Receivables for the year was $31,510

  • Common Shares for the year was $194,860

  • Inventory for the year was $87,970

  • Land for the year for the year was $281,490

  • Accounts Payable for the year was $74,250

  • Retained earnings for the year was $70,100

  • Buildings & Equipment Accumulated Depreciation for the year was $40,000

  • Wages payable for the year was $46,190

  • Short-term debt for the year was $10,500

  • Taxes payable for the year was $55,750

  • Mortgage for the year was $60,010

  • 10-year bond for the year was $20,500

  • Interest Payable for the year was $37,980

  1. Prepare a 2020 Balance Sheet for the company. Ensure you categorize your accounts into Current and Non-Current Assets/Liabilities, and Shareholders’ Equity.

  2. Calculate the Net Working Capital and Quick Ratio of the company. Explain what these values are and what they are used for. Comment on the company’s financial position, based on the ratios you calculated.

3. In 2021, the company plans to purchase additional retail space in Ray Hall. This space will cost $100,000. Half of the purchase will be made in cash, and the other half will be added to the mortgage. Also, the company takes an additional $35,000 of short-term debt. Please answer the following questions:

  1. Describe the effect that these transactions will have on the 2020 Balance Sheet.

  2. Will this impact the Income Statement in any way? If yes, identify and explain the impact. If no, explain why there is no impact.

Solutions

Expert Solution

Answer:

Q2.

Preparation of Balance Sheet as on 31st December 2020.

Net Working Capital = Current Assets - Current Liabilities

Here Current Assets = $237,300

Current Liabilities = $284,680

Net Working Capital = $237,300 - $284,680 = $-47,380

Quick Ratio = (Current Assets - Inventory) / Current Liabilities

= ($237,300 - $87,970) / $284,680 = $149,330 / $284,680 = 0.52

Net Working Capital - Net working capital is the difference between current assets and current liabilities. This is an indicator of company's liquidity, short term financial health and it's efficiency to mitigate the short term liabilities. A positive working capital that means current assets more than current liabilities then the company has the potential to grow and invest. If the company has negative working capital means current assets less than current liabilities then the company can not mitigate it's short-term liabilities and may have trouble in growing. Also the company can go bankrupt.

In our current scenario, Q.Clean company has the negative working capital that means they can not meet there day to day expenses and the company doesn't have any future growth.

Quick Ratio - This ratio is an indicator of a company’s short-term liquidity position and measures a company’s ability to meet its short-term obligations with its most liquid assets. Liquid assets means those assets that can be quickly converted into cash with minimal impact on the price received in the open market. The quick ratio indicates a company's capacity to pay its current liabilities without needing to sell its inventory or get additional financing.

To measure liquidity, a quick ratio of 1 is considered to be the normal quick ratio. It indicates that the company is fully equipped with exactly enough assets to be instantly liquidated to pay off its current liabilities. A company that has a quick ratio of less than 1 may not be able to fully pay off its current liabilities in the short term, while a company having a quick ratio higher than 1 can instantly get rid of its current liabilities.

In our current scenario, Q.Clean company has the quick ration 0.52 which is less than 1 that means the company can not pay off its current liabilities in the short term.


Related Solutions

I would like to get som survey question for dry cleaning service , I want to...
I would like to get som survey question for dry cleaning service , I want to attract new people who live in the area like new homewoners.
QUESTION 3 (20 MARKS) QUESTION 3 (20 MARKS) An analysis of the Business School graduates found...
QUESTION 3 QUESTION 3 An analysis of the Business School graduates found that 210 out of 318 randomly selected graduates used An analysis of the Business School graduates found that 210 out of 318 randomly selected graduates used  a statistical inference technique during their first year of employment.a statistical inference technique during their first year of employment. (a) Calculate a 90% confidence interval for the proportion of graduates who used a statistical inference (a) Calculate a 90% confidence interval for the...
QUESTION 2   (20 marks) According to Michael Theatre Ltd., the mean cost to run a nightly...
QUESTION 2   According to Michael Theatre Ltd., the mean cost to run a nightly theatre performance is $3,200 with a standard deviation of $460. Performance costs are known to follow a normal probability distribution. Required: What percentage of the performances will cost less than $2,850 to run? Sketch a normal curve and shade the desired area on your diagram. ( 4 marks) What percentage of the performances will cost between $3,250 and $3,520 to run? Sketch a normal curve and...
QUESTION 2   (20 marks) According to Michael Theatre Ltd., the mean cost to run a nightly...
QUESTION 2   According to Michael Theatre Ltd., the mean cost to run a nightly theatre performance is $3,100 with a standard deviation of $440. Performance costs are known to follow a normal probability distribution. Required: What percentage of the performances will cost less than $2,850 to run? Sketch a normal curve and shade the desired area on your diagram. ( 4 marks) What percentage of the performances will cost between $3,150 and $3,520 to run? Sketch a normal curve and...
Question 2 [20 Marks] You are provided with the following information. Conduct an ABC analysis, categorising...
Question 2 [20 Marks] You are provided with the following information. Conduct an ABC analysis, categorising each item of stock appropriately. (80% = A, 15% = B, 5%=C Item no. Unit cost (R) Annual Demand 101 5 48 000 102 11 2000 103 15 300 104 8 800 105 7 4800 106 16 1200 107 70 18000 108 4 300 109 9 5000 110 12 500
QUESTION 4 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b,...
QUESTION 4 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b, 3 for c, 2 for d Belinda, the accountant at Murray Manufacturing Company wants to identify cost drivers for support overhead costs. She has the impression that the staff spend a large part of their time ensuring that the equipment is correctly set up and checking the first units of production in each batch. Deborah has collected the following data for the past 12...
QUESTION 4 CVP Analysis Guide to marks: 20 marks – 4 for a, 4 for b,...
QUESTION 4 CVP Analysis Guide to marks: 20 marks – 4 for a, 4 for b, 4 for c, 8 for d Show all calculations to support your answers. A manufacturer can make two products, A and B. The following data are available:B Product A B Total Sales price per unit $12 $15 Variable cost per unit $8 $10 Total fixed costs/month $5000 (a)Calculate the unit contribution margin for each product. (b)This month the manufacturer will specialise in making only...
QUESTION 3 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b,...
QUESTION 3 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b, 3 for c, 2 for d Belinda, the accountant at Murray Manufacturing Company wants to identify cost drivers for support overhead costs. She has the impression that the staff spend a large part of their time ensuring that the equipment is correctly set up and checking the first units of production in each batch. Deborah has collected the following data for the past 12...
QUESTION 2 (20 Marks) REQUIRED Use the trial balance, adjustments and additional information given below to...
QUESTION 2 REQUIRED Use the trial balance, adjustments and additional information given below to prepare the Statement of Comprehensive Income of Groutville Traders for the year ended 28 February 2019. GROUTVILLE TRADERS PRE-ADJUSTMENT TRIAL BALANCE AS AT 28 FEBRUARY 2019 Debit (R) Credit (R) Balance sheet accounts section Capital 289 000 Drawings 89 000 Vehicles at cost 370 000 Equipment at cost 280 000 Accumulated depreciation on vehicles 160 000 Accumulated depreciation on equipment 100 000 Fixed deposit: Sim Bank...
Question 2 NB it is a 20 marks question There exist a number of strategies that...
Question 2 NB it is a 20 marks question There exist a number of strategies that can be considered for implementation. (a) Identify four (4) issues in strategy implementation. (b) Create four (4) types of strategies using the SWOT Matrix in the matching stage of strategy formulation. (c) Describe any two (2) of the SWOT Matrix strategy types.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT