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)
The question seems to be asking for financial ratio analysis based on the provided balance sheets income statement and statement of changes in equity ... 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...
-
On February 2, Phillips induced Miller to purchase from her fifty shares of stock in the XYZ Corporation for $10,000, representing that the actual book value of each share was $200. A certificate for...
-
Find the sum of the convergent series. 18 n=0 3n+2 In
-
The production department of Zunni's Manufacturing is considering two numerically controlled drill presses; one must be selected. Comparison data is shown in the table below. MARR is 10 percent/year....
-
Frevert purchased a new piece of equipment to be used in its new facility. The $370,000 piece of equipment was purchased with a $50,000 down payment and with cash received through the issuance of a...
-
ony purchased an empty office building in London from Margot, an unconnected third party, on 1 September 2024. Tony paid 996,000 for the office building. No VAT was charged on the supply. Margot had...
-
Pasqual Melo is employed by a public corporation. On January 1, 20X0, she was given an option to purchase 1,000 shares of the public corporation for $8 per share (the option extended for two years)....
-
Run the widget below to generate a carbon species plot like the one found on page 431 of your text book to answer the following questions. The temp_C control allows you to change the temperature of...
-
Customers moving up future purchases to the present is market growth. stealing share. forward selling. forward buying.
-
Devise appropriate discounting schemes for a supply chain.
-
Customers substituting the firms product for a competitors product is known as market growth. stealing share. forward selling. forward buying.
-
In most instances of differential pricing, demand from the segment paying the lower price arises earlier in time than demand from the segment paying the higher price. arises later in time than demand...
-
Pricing decisions based only on revenue considerations often result in a decrease in overall profitability. an increase in overall profitability. a decrease in overall revenue. a decrease in supply...
-
For the beam shown below: a) Find reactions at support A and support B b) Draw the shear diagram c) Draw the bending moment diagram d) What is the design shear V and bending moment M for the beam? e)...
-
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...
-
You are the CEO of XO, a bulk chemical producer and processor. XO is generating quite a lot of free cash flow that cannot be profitably invested domestically. You are looking to expand XOs operations...
-
Connect each term to its definition or description. a. Acquisition of assets b. Acquisition of stock c. Acquisition premium d. Consolidation e. Merger f. Method of payment g. Synergy A. Creation of...
-
You are the chairman of Tres Equis, a family-run beverage manufacturer based in Guadalupe, Mexico. For years, you have harbored ambitions of expanding operations into other Latin American countries...
Study smarter with the SolutionInn App