ACC201 SLP3

1. Show the computation of the three ratios.

2. Comment on the purpose and information conveyed by each ratio.

3. What did you learn about xxx Company by reviewing the three ratios?

4. What is your conclusion about the profitability of the company?

5. How successful is xxx Company relative to the industry average and leaders in the small specialty retail store industry?

The purpose of this SLP is to apply ratio analysis to assess the financial health of ABC Company. Use the income statement presented in the case during this module to compute general or overall profitability ratios. Compute three ratios using at least one of the income statement accounts for each ratio. Some profitability ratios include both income and balance sheet accounts. The balance sheet accounts are found in module 2.

Assume that ABC Company is a small specialty retail store. Ratios are relevant when assessed over time or across companies. IBIS is a comprehensive resource containing market research and statistics, which can be used to compare ABC Company to the industry and leaders in the industry.

1. Show the computation of the three ratios.

2. Comment on the purpose and information conveyed by each ratio.

3. What did you learn about ABC Company by reviewing the three ratios?

4. What is your conclusion about the profitability of the company?

5. How successful is ABC Company relative to the industry average and leaders in the small specialty retail store industry? Write two paragraphs or more. Include ratios found in the IBIS database to support your conclusion.

Assignment Expectation

Show the formulas for the computations. Two to three sentences are sufficient to respond to questions 1 through 4.

See above for question 5 instructions. Do not use an essay format.

Show sources when appropriate and APA format is suggested, but not required.

Hello Trident University

PDF PRINT IEXPERT SEARCH TUTORIAL

About this Industry Industryat a Glance
Industry

Performance Industry Outlook
Products &

Markets
Competitive
Landscape Major Companies

Operating
Conditions Key Statistics

Key Statistics
Industry Data

Revenue

($m)

IVA
($m)

Establishments
(Units)

Enterprises
(Units)

Employment
(Units)

Exports
($m)

Imports
($m)

Wages
($m)

Domestic
Demand

($m)

E-commerce
sales

(%)

2008 31,247.1 4,942.5 134,115 130,140 221,320 – – 3,787.8 – 3.6
2009 30,339.4 4,440.0 132,353 127,902 213,307 – – 3,502.9 – 4.0
2010 31,028.0 4,926.9 134,223 129,729 215,522 – – 3,590.1 – 4.5
2011 32,733.7 5,237.0 137,035 132,554 219,680 – – 3,644.3 – 4.9
2012 32,043.2 5,118.1 139,284 134,620 219,085 – – 3,518.2 – 5.3
2013 31,518.8 5,276.3 138,770 134,104 224,021 – – 3,675.4 – 5.8
2014 31,037.6 5,446.0 140,578 135,888 231,795 – – 3,904.8 – 6.4
2015 31,573.6 5,784.3 140,941 136,097 234,035 – – 3,955.2 – 7.3
2016 31,513.2 5,666.9 140,466 135,621 233,415 – – 3,944.6 – 8.2
2017 31,421.6 5,561.1 139,503 134,651 232,382 – – 3,927.1 – 9.2
2018 31,326.3 5,454.5 139,003 134,155 231,462 – – 3,911.1 – 10.3
2019 31,236.4 5,360.2 138,266 133,418 230,572 – – 3,895.7 – 11.4
2020 31,152.9 5,278.5 137,959 133,122 229,796 – – 3,882.1 – 12.5
2021 31,070.9 5,222.1 137,738 132,907 229,413 – – 3,873.9 – 13.6
2022 30,999.0 5,183.0 138,084 133,283 229,458 – – 3,871.8 – 14.5

Back to top

Annual Change

Revenue
(%)

IVA
(%)

Establishments
(%)

Enterprises
(%)

Employment
(%)

Exports
(%)

Imports
(%)

Wages
(%)

Domestic
Demand
(%)
E-commerce
sales

(%)
2008 -1.6 -14.7 -4.8 -4.9 -7.5 N/C N/C -14.9 N/C 5.9
2009 -2.9 -10.2 -1.3 -1.7 -3.6 N/C N/C -7.5 N/C 11.1
2010 2.3 11.0 1.4 1.4 1.0 N/C N/C 2.5 N/C 12.5
2011 5.5 6.3 2.1 2.2 1.9 N/C N/C 1.5 N/C 8.9
2012 -2.1 -2.3 1.6 1.6 -0.3 N/C N/C -3.5 N/C 8.2
2013 -1.6 3.1 -0.4 -0.4 2.3 N/C N/C 4.5 N/C 9.4
2014 -1.5 3.2 1.3 1.3 3.5 N/C N/C 6.2 N/C 10.3
2015 1.7 6.2 0.3 0.2 1.0 N/C N/C 1.3 N/C 14.1
2016 -0.2 -2.0 -0.3 -0.4 -0.3 N/C N/C -0.3 N/C 12.3
2017 -0.3 -1.9 -0.7 -0.7 -0.5 N/C N/C -0.5 N/C 12.2
2018 -0.3 -1.9 -0.4 -0.4 -0.4 N/C N/C -0.4 N/C 12.0
2019 -0.3 -1.7 -0.5 -0.6 -0.4 N/C N/C -0.4 N/C 10.7
2020 -0.3 -1.5 -0.2 -0.2 -0.3 N/C N/C -0.4 N/C 9.6
2021 -0.3 -1.1 -0.2 -0.2 -0.2 N/C N/C -0.2 N/C 8.8
2022 -0.2 -0.8 0.3 0.3 0.0 N/C N/C -0.1 N/C 6.6

Back to top

Key Ratios
IVA/

Revenue
(%)

Imports/
Demand

(%)

Exports/
Revenue

(%)

Revenue/
Employee

(

Wages/
Revenue

(%)
Employees/

Establishment

Wages/
Employee

($)
2008 15.8 0.0 N/C 141.2 12.1 1.7 17,114.6
2009 14.6 0.0 N/C 142.2 11.5 1.6 16,421.9
2010 15.9 0.0 N/C 144.0 11.6 1.6 16,657.7

HOME > INDUSTRY MARKET RESEARCH > US INDUSTRY REPORTS (NAICS) > SMALL SPECIALTY RETAIL STORES

Search

http://clients1.ibisworld.com/user/setupusercontact.aspx?edt=1&return=%2freports%2fus%2findustry%2fkeystatistics.aspx%3fentid%3d1106

http://clients1.ibisworld.com/reports/us/industry/default.aspx?entid=1106

http://clients1.ibisworld.com/reports/us/industry/ataglance.aspx?entid=1106

http://clients1.ibisworld.com/reports/us/industry/currentperformance.aspx?entid=1106

http://clients1.ibisworld.com/reports/us/industry/industryoutlook.aspx?entid=1106

http://clients1.ibisworld.com/reports/us/industry/productsandmarkets.aspx?entid=1106

http://clients1.ibisworld.com/reports/us/industry/competitivelandscape.aspx?entid=1106

http://clients1.ibisworld.com/reports/us/industry/majorcompanies.aspx?entid=1106

http://clients1.ibisworld.com/reports/us/industry/operatingconditions.aspx?entid=1106

http://clients1.ibisworld.com/reports/us/industry/keystatistics.aspx?entid=1106

http://clients1.ibisworld.com/excel/default.aspx?cid=1&view=20&rtid=1&eid=1106&tid=1&grid=0&mpid=0&tt=Key%20Statistics

http://clients1.ibisworld.com/reports/us/industry/keystatistics.aspx?entid=1106#

http://clients1.ibisworld.com/excel/default.aspx?cid=1&view=21&rtid=1&eid=1106&tid=1&grid=0&mpid=0&tt=Key%20Statistics%20Growth

http://clients1.ibisworld.com/reports/us/industry/keystatistics.aspx?entid=1106#

http://clients1.ibisworld.com/

http://clients1.ibisworld.com/reports/us/industry/

http://clients1.ibisworld.com/reports/us/industry/default.aspx?entid=1106

http://clients1.ibisworld.com/

http://clients1.ibisworld.com/about/

http://clients1.ibisworld.com/about/us/products/

http://clients1.ibisworld.com/about/us/careers/

http://clients1.ibisworld.com/media/

http://clients1.ibisworld.com/about/us/inquiry/

2011 16.0 0.0 N/C 149.0 11.1 1.6 16,589.1
2012 16.0 0.0 N/C 146.3 11.0 1.6 16,058.6
2013 16.7 0.0 N/C 140.7 11.7 1.6 16,406.5
2014 17.5 0.0 N/C 133.9 12.6 1.6 16,845.9
2015 18.3 0.0 N/C 134.9 12.5 1.7 16,900.0
2016 18.0 0.0 N/C 135.0 12.5 1.7 16,899.5
2017 17.7 0.0 N/C 135.2 12.5 1.7 16,899.3
2018 17.4 0.0 N/C 135.3 12.5 1.7 16,897.4
2019 17.2 0.0 N/C 135.5 12.5 1.7 16,895.8
2020 16.9 0.0 N/C 135.6 12.5 1.7 16,893.7
2021 16.8 0.0 N/C 135.4 12.5 1.7 16,886.1
2022 16.7 0.0 N/C 135.1 12.5 1.7 16,873.7

Figures are inflation adjusted 2017 Dollars

Back to top

Industry Financial Ratios
Apr 2016 – Mar 2017 by company revenue

Apr 2013 – Apr 2014 – Apr 2015 – Apr 2016 – Small Medium Large

Mar 2014 Mar 2015 Mar 2016 Mar 2017 (<$10m) ($10-50m) (>$50m)

Liquidity Ratios

Current Ratio 1.8 1.8 1.8 1.7 1.9 1.5 1.4

Quick Ratio 0.5 0.6 0.5 0.6 0.6 0.4 0.7

Sales / Receivables (Trade Receivables Turnover) 74.8 68.7 119.9 60.5 108.2 57.9 23.0

Days’ Receivables 4.9 5.3 3.0 6.0 3.4 6.3 15.9

Cost of Sales / Inventory (Inventory Turnover) 4.7 5.2 5.0 4.6 4.3 4.8 7.5

Days’ Inventory 77.7 70.2 73.0 79.3 84.9 76.0 48.7

Cost of Sales / Payables (Payables Turnover) 15.7 16.5 19.3 18.8 22.8 16.9 11.0

Days’ Payables 23.2 22.1 18.9 19.4 16.0 21.6 33.2

Sales / Working Capital 10.9 12.1 11.6 11.6 10.6 12.0 17.7

Coverage Ratios

Earnings Before Interest & Taxes (EBIT) / Interest 5.6 6.9 6.3 6.1 5.9 9.2 5.1

Net Profit + Dep., Depletion, Amort. / Current Maturities LT Debt 4.6 3.6 2.6 3.6 1.6 4.8 n/a

Leverage Ratios

Fixed Assets / Net Worth 0.4 0.4 0.4 0.4 0.3 0.4 0.8

Debt / Net Worth 2.2 1.9 1.6 2.0 2.1 1.8 2.2

Tangible Net Worth 20.2 28.8 28.5 22.8 18.8 34.3 19.3

Operating Ratios

Profit before Taxes / Net Worth, % 29.9 33.0 27.1 31.9 33.2 33.6 17.7

Profit before Taxes / Total Assets, % 8.5 10.2 10.8 9.5 11.1 7.3 4.1

Sales / Net Fixed Assets 35.4 38.8 31.6 33.3 40.5 33.9 16.1

Sales / Total Assets (Asset Turnover) 3.0 3.1 3.1 2.7 2.8 2.9 2.0

Cash Flow & Debt Service Ratios (% of sales)

Cash from Trading 39.2 37.9 37.8 40.5 42.6 29.0 32.6

Cash after Operations 3.7 4.4 3.3 4.1 4.1 3.8 5.1

Net Cash after Operations 3.8 4.5 3.9 4.4 4.5 3.9 5.6

Cash after Debt Amortization 0.7 1.2 0.8 0.6 0.5 1.0 1.0

Debt Service P&I Coverage 2.4 2.8 2.3 2.8 3.0 2.5 2.5

Interest Coverage (Operating Cash) 5.3 5.7 4.9 6.0 5.9 5.3 9.3

Assets, %

Cash & Equivalents 13.0 13.6 12.9 13.2 14.0 12.7 9.3

Trade Receivables (net) 12.2 12.2 10.6 12.1 11.8 11.8 14.7

Inventory 42.0 39.4 42.6 41.2 41.7 43.0 32.9

All Other Current Assets 3.3 4.0 2.0 2.6 2.5 3.0 2.0

Total Current Assets 70.5 69.1 68.1 69.0 70.0 70.5 58.9

Fixed Assets (net) 16.8 17.6 18.2 16.9 16.7 16.3 19.8

Intangibles (net) 6.2 6.4 6.8 7.7 7.0 7.4 12.8

All Other Non-Current Assets 6.4 6.9 6.8 6.4 6.3 5.8 8.5

Total Assets 100.0 100.0 100.0 100.0 100.0 100.0 100.0

http://clients1.ibisworld.com/excel/default.aspx?cid=1&view=22&rtid=1&eid=1106&tid=1&grid=0&mpid=0&tt=Key%20Statistics%20Ratios

http://clients1.ibisworld.com/reports/us/industry/keystatistics.aspx?entid=1106#

Total Assets ($m) 4,188.1 4,549.1 4,388.8 4,677.1 0.0 1,063.9 3,312.7

Liabilities, %

Notes Payable-Short Term 13.6 11.8 11.1 15.4 16.1 13.7 15.1

Current Maturities L/T/D 2.6 2.3 2.4 3.3 3.9 2.0 3.2

Trade Payables 16.9 16.3 16.2 14.6 13.2 17.6 15.9

Income Taxes Payable 0.1 0.1 0.2 0.2 0.2 0.3 0.1

All Other Current Liabilities 12.0 10.7 14.6 13.9 15.2 12.6 8.5

Total Current Liabilities 45.3 41.1 44.4 47.3 48.5 46.2 42.9

Long Term Debt 16.5 15.5 14.1 14.5 17.3 7.8 13.4

Deferred Taxes 0.1 0.2 0.1 0.2 n/a 0.5 0.6

All Other Non-Current Liabilities 11.7 8.0 6.1 7.5 8.4 3.9 11.0

Net Worth 26.4 35.2 35.3 30.5 25.8 41.7 32.1

Total Liabilities & Net Worth ($m) 4,188.1 4,549.1 4,388.8 4,677.1 300.5 1,063.9 3,312.7

Maximum Number of Statements Used 455 453 551 357 228 92 37

Note: For a breakdown of average company profit and costs refer to the Cost Structure chapter
Note: For more years and a breakdown of ratios by quartile please download the Excel version of ratios. For ratio definitions click here.
Source: RMA Annual Statement Studies, rmahq.org. RMA data for all industries is derived directly from more than 260,000 statements
of member financial institutions’ borrowers and prospects.

Back to top

< Operating Conditions

http://clients1.ibisworld.com/reports/us/industry/keystatistics.aspx?entid=1106#

http://clients1.ibisworld.com/reports/us/industry/competitivelandscape.aspx?entid=1106#CSB

http://clients1.ibisworld.com/excel/default.aspx?cid=1&view=31&rtid=1&eid=1106&tid=1&grid=0&mpid=0&tt=Industry%20Financial%20Ratios

http://clients1.ibisworld.com/downloadfile.aspx?ft=pdf&fn=IBISWorld%20Financial%20Ratios%20Definitions &fp=/downloads/faqs/

http://rmahq.org/

http://clients1.ibisworld.com/excel/default.aspx?cid=1&view=31&rtid=1&eid=1106&tid=1&grid=0&mpid=0&tt=Industry%20Financial%20Ratios

http://clients1.ibisworld.com/reports/us/industry/keystatistics.aspx?entid=1106#

http://clients1.ibisworld.com/reports/us/industry/operatingconditions.aspx?indid=1106

http://clients1.ibisworld.com/about/termsofuse/

http://clients1.ibisworld.com/about/us/privacy/

000)

Wages/
Revenue
(%)
Employees/
Establishment
Wages/
Employee
($)
2008 15.8 0.0 N/C 141.2 12.1 1.7 17,114.6
2009 14.6 0.0 N/C 142.2 11.5 1.6 16,421.9
2010 15.9 0.0 N/C 144.0 11.6 1.6 16,657.7