The company has now been in business 3 years. Nick has been working on growing within...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The company has now been in business 3 years. Nick has been working on growing within the industry and paying down debt. Nick is hoping that some additional analysis can be completed on his business to assess its success and is open to any kind of suggestions you may provide him with. Perfect Smile's financial statements are shown below. Analyze the statements, completing the requirements to the right. Your answers should be in the cells noted in blue. Do not make any changes to the financial statements. Sales Revenue (Note 1) Cost of Goods Sold: Gross Margin Operating expenses Perfect Smile Company Statement of Income For the year ended December 31 Sales and marketing expenses Occupancy expenses Administration expenses Total operating expenses Operating income Non-operating or other Gain (loss) on sale of land and building Interest (expense) income Total non-operating Income before tax 2020 2019 $3,998,314 $3,127,434 1,672,667 1,216,572 2,325,647 1,910,862 981,784 196,357 274,900 1,453,040 1,447,967 940,238 188,048 319,681 130,427 12,712 23,256 19,109 153,683 31,821 718,924 431,075 Income tax expense 161,758 101,303 Net Income (Loss): 557,166 329,772 Note 1: Management has determined that 80% of its sales were on credit in 2020, and 90% in 2019. Perfect Smile Company Statement of Changes in equity For the year ended December 31 Retained earnings, January 1, 2019 Add: Net income Less: Dividends declared Retained earnings, December 31, 2020 2020 657,256 557,166 (178,300) 1,036,122 2019 423,113 329,772 (95,630) 657,256 Assets Current assets: Cash Accounts receivable, net (Note 2) Prepaid expenses Inventory Total current assets Non-Current Assets Marketable securities Property plant & equipment, net Total assets Perfect Smile Company Statement of Financial Position As at December 31 Liabilities and shareholders' equity Current liabilities: Accounts payable Unearned revenue Bank loan, current portion Total current liabilities Non-Current liabilities: Bank loan payable Total liabilities Shareholders' equity Common shares Retained earnings Total liabilities and shareholders' equity 2020 2019 100,834 624,869 15,327 890,607 542,310 68,119 75,000 685,429 75,449 771,443 18,369 19,632 978,689 801,546 1,843,950 1,631,637 1,309,909 500,000 400,000 561,501 533,382 2,905,451 2,565,019 617,828 31,035 75,000 723,863 475,000 1,036,122 2,905,451 2,565,019 400,000 657,256 2018 158,731 330,000 Note 2: Accounts receivable is net of allowance for doubtful accounts (AFDA). 708,900 783,900 858,900 1,394,329 1,507,763 1,302,496 50,000 565,700 1,925,609 314,443 54,153 75,000 443,596 200,000 423,113 1,925,609 Perfect Smile Company Statement of Cash Flows For the Year Ended December 31 Cash Flows from Operating Activities Net Income Depreciation Expense Gain on sale of Equipment Changes in working capital items: Accounts Receivable Inventories Prepaid expenses Accounts Payable Unearned revenue Net cash used for operating activities Cash Flows from Investing Activities Add: Purchase of marketable securities Add: Proceeds from Sale of Equipment Deduct: Acquisition of equipment Net cash provided by investing activities Cash Flows from Financing Activities Issurance (repurchase) of common shares Less: Dividends Paid Less: Repayment of Bank Loan Net cash used for financing activities Overall increase (decrease) in cash Cash position at beginning of year Cash position at end of year 2020 557,166 66,418 (130,427) (100,000) 205,000 (169,110) (64,110) (146,574) (294,869) (88,082) (89,061) (3,042) 4,305 (75,517) 303,385 37,084 (23,118) 217,025 308,873 75,000 (178,300) (75,000) (178,300) 2019 (25,385) 100,834 75,449 329,772 91,170 (12,712) (350,000) 55,000 (101,140) (396,140) 200,000 (95,630) (75,000) 29,370 (57,897) 158,731 100,834 Requirement a - Ratio Analysis Please ensure you read the notes under the financial statements. Please calculate each of the following ratios for 2019 and 2020. Answers must be in the blue cells provided using formulas in Excel (do not use your calculator and input your final answer into Excel). Liquidity Ratio Current Ratio Quick Ratio Activity Ratio Accounts Receivable Tumover Average Collection Period Inventory Turnover Days to Sell Inventory Accounts Payable Turnover Average Payment Period Solvency Ratios Debt to Equity Cash Flows to Total Liabilities Profitability Ratios Gross Margin Profit Margin Return on Equity Return on Assets Current Assets/Current Liabilities (Current Assets- Inventory- Prepaid Expenses) Current Liabilities Credit Sales/Average Accounts Receivable (net) 365/Accounts Receivable Tumover - Cost of Goods Sold / Average Inventory 365 days/Inventory Turnover Credit Purchases/ Average Accounts Payable 365/Accounts Payable Turnover Net debt / Shareholders Equity Cashflows from Operating Activities/Total Liabilities Gross Margin / Sales enue Net Income / Sales Revenue Net Income/Average Total Shareholders Equity Net Income / Average Total Assets 2020 2019 Requirement b- Financial Statement Analysis i) Nick has a policy of collecting accounts receivable within 45 days. How does the average collection period compare to these terms? H) Has the accounts receivable turnover ratio improved or worsened from 2019 to 2020? iii) What has happened to the average collection period from 2019 to 2020? iv) Has the company shown an improvement in their liquidity ratios from 2019 to 2020? If the bank loan requires that the company has a minimum quick ratio of 1:5 to 1, is the company meeting this obligation? v) What do the solvency ratios tell you? vi) Examine the company's cash flow statement. What is the cash flow pattern for 2020? 2019? 2020 2019 Operating Activities Investing Activities Financing Activities What does the cash flow pattern tell you about Perfect Smile Company? vii) Has the company's gross margin improved from 2019 to 2020? vili) How does gross margin differ from profit margin? The company has now been in business 3 years. Nick has been working on growing within the industry and paying down debt. Nick is hoping that some additional analysis can be completed on his business to assess its success and is open to any kind of suggestions you may provide him with. Perfect Smile's financial statements are shown below. Analyze the statements, completing the requirements to the right. Your answers should be in the cells noted in blue. Do not make any changes to the financial statements. Sales Revenue (Note 1) Cost of Goods Sold: Gross Margin Operating expenses Perfect Smile Company Statement of Income For the year ended December 31 Sales and marketing expenses Occupancy expenses Administration expenses Total operating expenses Operating income Non-operating or other Gain (loss) on sale of land and building Interest (expense) income Total non-operating Income before tax 2020 2019 $3,998,314 $3,127,434 1,672,667 1,216,572 2,325,647 1,910,862 981,784 196,357 274,900 1,453,040 1,447,967 940,238 188,048 319,681 130,427 12,712 23,256 19,109 153,683 31,821 718,924 431,075 Income tax expense 161,758 101,303 Net Income (Loss): 557,166 329,772 Note 1: Management has determined that 80% of its sales were on credit in 2020, and 90% in 2019. Perfect Smile Company Statement of Changes in equity For the year ended December 31 Retained earnings, January 1, 2019 Add: Net income Less: Dividends declared Retained earnings, December 31, 2020 2020 657,256 557,166 (178,300) 1,036,122 2019 423,113 329,772 (95,630) 657,256 Assets Current assets: Cash Accounts receivable, net (Note 2) Prepaid expenses Inventory Total current assets Non-Current Assets Marketable securities Property plant & equipment, net Total assets Perfect Smile Company Statement of Financial Position As at December 31 Liabilities and shareholders' equity Current liabilities: Accounts payable Unearned revenue Bank loan, current portion Total current liabilities Non-Current liabilities: Bank loan payable Total liabilities Shareholders' equity Common shares Retained earnings Total liabilities and shareholders' equity 2020 2019 100,834 624,869 15,327 890,607 542,310 68,119 75,000 685,429 75,449 771,443 18,369 19,632 978,689 801,546 1,843,950 1,631,637 1,309,909 500,000 400,000 561,501 533,382 2,905,451 2,565,019 617,828 31,035 75,000 723,863 475,000 1,036,122 2,905,451 2,565,019 400,000 657,256 2018 158,731 330,000 Note 2: Accounts receivable is net of allowance for doubtful accounts (AFDA). 708,900 783,900 858,900 1,394,329 1,507,763 1,302,496 50,000 565,700 1,925,609 314,443 54,153 75,000 443,596 200,000 423,113 1,925,609 Perfect Smile Company Statement of Cash Flows For the Year Ended December 31 Cash Flows from Operating Activities Net Income Depreciation Expense Gain on sale of Equipment Changes in working capital items: Accounts Receivable Inventories Prepaid expenses Accounts Payable Unearned revenue Net cash used for operating activities Cash Flows from Investing Activities Add: Purchase of marketable securities Add: Proceeds from Sale of Equipment Deduct: Acquisition of equipment Net cash provided by investing activities Cash Flows from Financing Activities Issurance (repurchase) of common shares Less: Dividends Paid Less: Repayment of Bank Loan Net cash used for financing activities Overall increase (decrease) in cash Cash position at beginning of year Cash position at end of year 2020 557,166 66,418 (130,427) (100,000) 205,000 (169,110) (64,110) (146,574) (294,869) (88,082) (89,061) (3,042) 4,305 (75,517) 303,385 37,084 (23,118) 217,025 308,873 75,000 (178,300) (75,000) (178,300) 2019 (25,385) 100,834 75,449 329,772 91,170 (12,712) (350,000) 55,000 (101,140) (396,140) 200,000 (95,630) (75,000) 29,370 (57,897) 158,731 100,834 Requirement a - Ratio Analysis Please ensure you read the notes under the financial statements. Please calculate each of the following ratios for 2019 and 2020. Answers must be in the blue cells provided using formulas in Excel (do not use your calculator and input your final answer into Excel). Liquidity Ratio Current Ratio Quick Ratio Activity Ratio Accounts Receivable Tumover Average Collection Period Inventory Turnover Days to Sell Inventory Accounts Payable Turnover Average Payment Period Solvency Ratios Debt to Equity Cash Flows to Total Liabilities Profitability Ratios Gross Margin Profit Margin Return on Equity Return on Assets Current Assets/Current Liabilities (Current Assets- Inventory- Prepaid Expenses) Current Liabilities Credit Sales/Average Accounts Receivable (net) 365/Accounts Receivable Tumover - Cost of Goods Sold / Average Inventory 365 days/Inventory Turnover Credit Purchases/ Average Accounts Payable 365/Accounts Payable Turnover Net debt / Shareholders Equity Cashflows from Operating Activities/Total Liabilities Gross Margin / Sales enue Net Income / Sales Revenue Net Income/Average Total Shareholders Equity Net Income / Average Total Assets 2020 2019 Requirement b- Financial Statement Analysis i) Nick has a policy of collecting accounts receivable within 45 days. How does the average collection period compare to these terms? H) Has the accounts receivable turnover ratio improved or worsened from 2019 to 2020? iii) What has happened to the average collection period from 2019 to 2020? iv) Has the company shown an improvement in their liquidity ratios from 2019 to 2020? If the bank loan requires that the company has a minimum quick ratio of 1:5 to 1, is the company meeting this obligation? v) What do the solvency ratios tell you? vi) Examine the company's cash flow statement. What is the cash flow pattern for 2020? 2019? 2020 2019 Operating Activities Investing Activities Financing Activities What does the cash flow pattern tell you about Perfect Smile Company? vii) Has the company's gross margin improved from 2019 to 2020? vili) How does gross margin differ from profit margin?
Expert Answer:
Related Book For
Business Law Text and Cases
ISBN: 978-1285185248
13th edition
Authors: Kenneth Clarkson, Roger LeRoy Miller, Frank Cross
Posted Date:
Students also viewed these accounting questions
-
How energy is store in magnetic field? Briefly explain.
-
Exhibits 1 and 4 present DHBs original 20032004 balance sheets and income statements and the restated balance sheets and income statements for those two years, respectively. Review the original and...
-
On June 1, Helen Martin started Ivanhoe Designs Co., a company that provides craft opportunities, by investing $12,810 cash in the business. Following are the assets and liabilities of the company at...
-
20 -101 10 in- laminate substrate Fig.2 Q2: The tool shown in Fig.2 is used in a gluing operation to press a thin laminate to a thicker substrate. If the wheels at points A and B both have 2 in...
-
Refer to the data in Exercise 10.60. Suppose you wish to establish that the mean response of 35-44 year olds is larger than that of 19-24 year olds by more than 150 dollars. (a) Formulate the null...
-
Recent studies indicate that the typical 50-year-old woman spends $350 per year for personal- care products. The distribution of the amounts spent follows a normal distribution with a standard...
-
An investor purchased $\$ 20,000$ of U.S. Treasury bonds at face value. These bonds have a 25 -year maturity period, and they pay $1.25 \%$ interest every three months. Unfortunately, interest rates...
-
Nathan Industries had a remaining debit balance of $20,000 in its under-and overapplied factory overhead account at year-end. It also had year-end balances in the following accounts: Work in...
-
A Corporation wants to raise $1,210,000 via a rights offering. The company currently has 220,000 shares of common stock outstanding that sells for $32 per share. The issue will allow current...
-
Suppose availability and purchase costs for V8 short blocks at Juarez and New Orleans are the same as in problem #2 (without tariffs). However, suppose that HP does not pay shipping from Juarez or...
-
FIREHOUSE SUBS Firehouse Subs is a 16-year-old restaurant chainbased in Jacksonville, Fla. It emphasizes a firefighter theme and has more than 390 restaurants that serve specialty submarine...
-
Solve. (im X 9 3 x - 3
-
Show that lim |x| = 0. x10
-
1. The figure below shows two pendulums suspended from pivots with viscous friction, b, and connected at their midpoints by a linear spring, k; the angles (radians) are relatively small so that sin 0...
-
Solve Tim (00-3) 13 2 + x5 4-20 - 3
-
Fill in the Blank Question insurance provides regular cash income lost by employees as a result of an accident or illness.
-
Vehicle operating costs incurred for the month totaled $7,840. Total miles drive were 22,400, distributed as follows: Construction by Work Orders $11,200 Retirement by Work Orders $1,120 Operation of...
-
Suppose you need to answer any four of seven essay questions on a history test and you can answer them in any order. a. How many different question combinations are possible? b. What is the...
-
Brendan Coleman created and marketed Clinex, a software billing program. Later, Retina Consultants, P. C., a medical practice, hired Coleman as a software engineer. Together, they modified the Clinex...
-
At an annual retreat for Major League Baseball umpires, a Wilson [Sporting Goods Company] representative gave [Edwin] Hickox an umpires mask with what the representative claimed was a new, safer...
-
Before buying a house, Dean and Donna Testa hired Ground Systems, Inc. (GSI), to inspect the sewage and water disposal system. GSI reported a split system with a watertight septic tank, a wastewater...
-
The following are summaries of the cash book and bank accounts of P. Maclaran who does not keep her books using the double entry system. You are required to: (a) Calculate the value of P. Maclaran's...
-
Jean Smith, who retails wooden ornaments, has been so busy since she commenced business on 1 April 2015 that she has neglected to keep adequate accounting records. Jean's opening capital consisted of...
-
The following trial balance of the Grampian Golf Club was extracted from the books as on 31 December 2016: (1) Bar purchases and sales were on a cash basis. Bar inventory at 31 December 2016 was...
Study smarter with the SolutionInn App