Use the financial reports below to answer the two questions in the required. CostCutter Inc. Balance...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the financial reports below to answer the two questions in the required. CostCutter Inc. Balance Sheet October 31, 2020 Assets Current Assets Cash Accounts receivable Allowance for doubtful accounts Inventory Prepaid expenses Notes receivable Total current assets Capital assets Property, plant and equipment Accumulated depreciation Total capital assets Total assets Liabilities Current liabilities Accounts payable Unearned revenue Total current liabilities Long term liabilities Notes payable Total liabilities Equity Contributed Capital Preferred shares, $1 non-cumulative, 20,000 shares issued and outstanding Common shares, 50,000 shares issued and outstanding Total contributed capital Retained earnings Total equity Total liabilities and equity 238,000 (2,300) 1,621,100 (325,000) 219,000 3,100 100,000 250,000 2020 136,000 235,700 84,000 50 600 456,350 1,296,100 1,752,450 222,100 114,000 336,100 350,000 1,066,350 1,416,350 1,752,450 219,000 (2,100) 1,234,670 (208,000) 174,000 750 100,000 250,000 2019 98,000 216,900 71,000 30 400 386,330 1,026,670 1,413,000 174,750 116,200 290,950 350,000 772,050 1,122,050 1,413,000 CostCutter Inc. Statement of Changes in Equity October 31, 2020 Balance, November 1, 2019 Net Income Balance, October 31, 2020 100,000 250,000 Sales 943,000 Sales disc (14,000) Net sales Cost of goods sold Gross profit CostCutter Inc. Income Statement for the year ended October 31, 2020 Preferred Common Shares Shares 100,000 250,000 Operating expenses Operating income Investment income 2020 929,000 424,000 505,000 141,000 364,000 9,000 Earnings before inte 373,000 Interest expense 5,700 Earnings before taxe 367,300 Income tax 73,000 Net income 294,300 798,000 (11,000) 2019 787,000 335,000 452,000 103,000 349,000 7,000 356,000 6,500 349,500 69,000 280,500 Retained Earnings Total 772,050 1,122,050 294,300 294,300 1,066,350 1,416,350 Other information 1. No dividends were declared or paid for the years ended October 31, 2020 and 2019. 2. The market value per common share at October 31, 2020 and 2019 were $29 and $25 respectively. 3. Industry averages for 2020 are provided in the chart below. Required 1. Create the chart below in Excel and calculate all of the ratios listed for 2020 and 2019. For ratios expressed as a percentage include the percent sign in your worksheet. Round all ratios to two decimal places. State whether each ratio is favourable or unfavourable (F/U) compared to the previous year and the industry average. Current ratio Quick ratio Accounts receivable turnover (use net A/R and net sales) Average collection period (use net A/R and net sales) Inventory turnover Inventory holding period Total asset turnover (use net sales) Accounts payable turnover Debt to total assets Equity to total assets Times interest earned Profit Margin (use net sales) Gross profit ratio Return on assets Return on equity Book value per common share Book value per preferred share Earnings per share Price earnings ratio Ratio for Ratio for 2020 2019 Is the change between 2020 and 2019 Favorable or Unfavorable Industry Average 1.96 1.42 4.35 95.12 5.2 75.08 1.8 8.45 21.00% 79.00% 50.16 30.14% 52.16% 17.20% 31.00% $14.91 $22.00 $4.32 $6.91 Is the change between 2020 and the industry average Favorable or Unfavorable 2. Choose 5 of your favorite ratios from the list above and explain why the change is favorable or unfavorable. Use the financial reports below to answer the two questions in the required. CostCutter Inc. Balance Sheet October 31, 2020 Assets Current Assets Cash Accounts receivable Allowance for doubtful accounts Inventory Prepaid expenses Notes receivable Total current assets Capital assets Property, plant and equipment Accumulated depreciation Total capital assets Total assets Liabilities Current liabilities Accounts payable Unearned revenue Total current liabilities Long term liabilities Notes payable Total liabilities Equity Contributed Capital Preferred shares, $1 non-cumulative, 20,000 shares issued and outstanding Common shares, 50,000 shares issued and outstanding Total contributed capital Retained earnings Total equity Total liabilities and equity 238,000 (2,300) 1,621,100 (325,000) 219,000 3,100 100,000 250,000 2020 136,000 235,700 84,000 50 600 456,350 1,296,100 1,752,450 222,100 114,000 336,100 350,000 1,066,350 1,416,350 1,752,450 219,000 (2,100) 1,234,670 (208,000) 174,000 750 100,000 250,000 2019 98,000 216,900 71,000 30 400 386,330 1,026,670 1,413,000 174,750 116,200 290,950 350,000 772,050 1,122,050 1,413,000 CostCutter Inc. Statement of Changes in Equity October 31, 2020 Balance, November 1, 2019 Net Income Balance, October 31, 2020 100,000 250,000 Sales 943,000 Sales disc (14,000) Net sales Cost of goods sold Gross profit CostCutter Inc. Income Statement for the year ended October 31, 2020 Preferred Common Shares Shares 100,000 250,000 Operating expenses Operating income Investment income 2020 929,000 424,000 505,000 141,000 364,000 9,000 Earnings before inte 373,000 Interest expense 5,700 Earnings before taxe 367,300 Income tax 73,000 Net income 294,300 798,000 (11,000) 2019 787,000 335,000 452,000 103,000 349,000 7,000 356,000 6,500 349,500 69,000 280,500 Retained Earnings Total 772,050 1,122,050 294,300 294,300 1,066,350 1,416,350 Other information 1. No dividends were declared or paid for the years ended October 31, 2020 and 2019. 2. The market value per common share at October 31, 2020 and 2019 were $29 and $25 respectively. 3. Industry averages for 2020 are provided in the chart below. Required 1. Create the chart below in Excel and calculate all of the ratios listed for 2020 and 2019. For ratios expressed as a percentage include the percent sign in your worksheet. Round all ratios to two decimal places. State whether each ratio is favourable or unfavourable (F/U) compared to the previous year and the industry average. Current ratio Quick ratio Accounts receivable turnover (use net A/R and net sales) Average collection period (use net A/R and net sales) Inventory turnover Inventory holding period Total asset turnover (use net sales) Accounts payable turnover Debt to total assets Equity to total assets Times interest earned Profit Margin (use net sales) Gross profit ratio Return on assets Return on equity Book value per common share Book value per preferred share Earnings per share Price earnings ratio Ratio for Ratio for 2020 2019 Is the change between 2020 and 2019 Favorable or Unfavorable Industry Average 1.96 1.42 4.35 95.12 5.2 75.08 1.8 8.45 21.00% 79.00% 50.16 30.14% 52.16% 17.20% 31.00% $14.91 $22.00 $4.32 $6.91 Is the change between 2020 and the industry average Favorable or Unfavorable 2. Choose 5 of your favorite ratios from the list above and explain why the change is favorable or unfavorable.
Expert Answer:
Answer rating: 100% (QA)
1 Chart of Ratios Ratio 2020 2019 Industry Average Changes from 2019 Change from Industry Average FU Current Ratio 205 222 196 Unfavorable ... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-0176509736
10th Canadian Edition, Volume 1
Authors: Donald Kieso, Jerry Weygandt, Terry Warfield, Nicola Young,
Posted Date:
Students also viewed these finance questions
-
The following accounts were taken from ABC Company's unadjusted trial balance at December 31, 2025: Accounts Payable Accounts Receivable Advertising Expense Cashi Common Stock Cost of Goods Sold...
-
For the truss structure shown: 1) set-up element stiffness matrices for each element, 2) assemble global stiffness matrix equations, 3) apply boundary conditions, 4) solve for unknown displacements,...
-
Which of the following rule applies to the partnership firm in the absence of a partnership deed? Equal profit sharing ratio Profit based salary to the partners No interest shall be charged on...
-
Financial statements for the ACTACTSTAT Company are given below: During 2021 the firm declared and paid cash dividends of P85,000. There were 50,000 shares of common stock outstanding throughout the...
-
A Circuit within a Circuit Fig. 29.47 shows a small circuit within a larger one, both lying on the surface of a table. The switch is closed at t = 0 with the capacitor initially uncharged. Assume...
-
Bailer and Piegorsch [2000] report on an experiment that examines the effect of a herbicide, nitrofen, on the umber of offspring produced by a particular freshwater invertebrate zooplankton. The data...
-
The transactions for Dancing Antz, Inc., for the month of September 2010 have been posted to the accounts as follows: Requirements 1. Prepare the journal entries that served as the sources for the...
-
Shop Rite Services is ready to prepare its financial statements for the year ended December 31, 2012. The following information can be determined by analyzing the accounts: 1. On August 1, 2012, Shop...
-
How does this article highlight the extreme, positive impact media has on environmental reform in China? "Getting their voices heard: Three cases of public participation in environmental protection...
-
A US motivational speaker was brought in by a South African private company as part of its annual general meeting to speak to the sales and marketing staff. Part of the presentation included...
-
Quantitatively analyze fiscal years 2020, 2021, and 2022 of Disney's finances using the provided Excel template; summarize the financial highlights, explaining the significance of the key ratios of...
-
1. Given 2 equations of the IS curve, Y = 2500-800r and Y = 2500 -1500r: a) Calculate the national income equilibrium (Y) for both equations if r = 5% and 10%. b) Based on the IS equations, draw the...
-
A compay reported 31, 2024, balance sheet equipment at cost of $800,000.a disclosure note indicates that the company uses straight line depreciation over five years, and estimates salvage value as...
-
In a portfolio consisting of the risk free asset and/or a risky asset, what is the expected return and standard deviation if you borrow 25% of your net worth by selling short the risk free asset and...
-
A circuit consists of a battery with an EMF of 12 V and three capacitors in series, where C = 15 F, C =30 F, and C3 = 45 F. What energy is stored in the capacitors?
-
Discount Rate Required rate of return = 10% Expected Net Cash Flow Year Franchise L Franchise S 0 -100 -100 1 10 65 2 60 50 3 80 20 a) Calculate NPV = $18.78 IRR= MIRR 18.126% 16.50% Decision if...
-
Reggie contributes 10% of his monthly salary to his 401(k) plan. (His salary is $10,000 per month). How much does he get to deduct from his income as an 'above-the-line' deduction for the year?
-
Write electron configurations for the following ions, and determine which have noble-gas configurations: (a) Cd2+ (b) p3- (c) Zr4+ (d) Ru3+ (e) As3- (f) Ag+
-
The following are transactions recorded by Bounce Corporation during the current year. 1. Ordinary operating maintenance on equipment was recorded as follows: 2. The company received an advance on a...
-
Describe what is meant by information asymmetry.
-
The financial statements for Maple Leaf Foods Inc. may be found on the company's website or at www.sedar.com. Instructions (a) Calculate the liquidity and coverage (solvency) ratios identified in...
-
Applying the criterion for equilibrium, derive the Clausius-Clapeyron equation.
-
A binary liquid mixture consists of \(60 \mathrm{~mol}\) per cent ethylene and \(40 \mathrm{~mol}\) per cent propylene. At \(423 \mathrm{~K}\), the vapour pressure of ethylene and propylene are...
-
The pure component vapour pressure of two organic liquids \(\mathrm{X}\) and \(\mathrm{Y}\) by Antoine equations are given by \[ \ln P_{1}^{\text {Sat }}=14.35-\frac{2942}{T+220} \] and \[...
Study smarter with the SolutionInn App