Completing a comprehensive financial statement analysis

In its annual report, XYZ Athletic Supply, Inc. includes the following five-year financial summary:

XYZ ATHLETIC SUPPLY, INC.
Five-Year Financial Summary (Partial; adapted)
(Dollar amounts in thousands except per share data)	2018	2017	2016	2015	2014	2016
Net sales revenue	\(275,000	\)222,000	\(199,000	\)171,000	131,000
Net Sales Revenue Increase	24%	12%	16%	31%	17%
Domestic Comparative Store Sales Increase	6%	6%	5%	8%	10%
Other Income—Net	2,090	1,780	1,770	1,700	1,310
Cost of Goods Sold	208,725	169,386	154,822	134,235	103,883
Selling and Administrative Expenses	41,280	36,340	31,670	27,450	22,540
Interest:
Interest Expense	(1,070)	(1,370)	(1,330)	(1,100)	(800)
Interest Income	140	155	150	230	140
Income Tax Expense	4,420	3,900	3,610	3,390	2,730
Net Income	21,735	12,939	9,488	6,755	2,497
Per Share of Common Stock:
Net Income	1.10	0.80	0.70	0.50	0.28
Dividends	0.45	0.43	0.39	0.35	0.31
Financial Position
Current Assets, Excluding Merchandise Inventory	\(30,900	\)27,200	\(26,800	\)24,400	$21,800
Merchandise Inventory	24,700	22,400	21,600	19,300	17,000	16,800
Property, Plant, and Equipment, Net	51,600	46,200	40,500	35,000	25,200
Total Assets	107,200	95,800	88,900	78,700	64,000
Current Liabilities	32,600	27,800	28,800	25,600	17,000
Long-term Debt	23,000	21,200	16,800	18,600	12,900
Stockholders’ Equity	51,600	46,800	43,300	35,500	34,100
Financial Ratios
Acid-Test Ratio	0.9	1.0	0.9	1.0	1.3
Rate of Return on Total Assets	22.5%	15.5%	12.8%	10.9%	9.9%
Rate of Return on Common Stockholders’ Equity	44.2%	28.7%	24.1%	19.4%	18.9%

Requirements

Analyze the company’s financial summary for the fiscal years 2014–2018 to decide whether to invest in the common stock of XYZ. Include the following sections in your analysis.

1. Trend analysis for net sales revenue and net income (use 2014 as the base year).

2. Profitability analysis.

3. Evaluation of the ability to sell merchandise inventory.

4. Evaluation of the ability to pay debts.

5. Evaluation of dividends.

6. Should you invest in the common stock of XYZ Athletic Supply, Inc.? Fully explain your final decision

The figures that are calculated bycomparing various line items of the financial statementto arrive at aconclusive decision regarding liquidity, solvency, and profitabilityare known as financial ratios.

Analysis: According to the above analysis, it can be said the business entity is improving its profitability because the percentage change reflects that the net income and the net sales revenue of the business entity are increasing each year.

Analysis: All the ratios of profitability analysis reflect that the profitability of the business entity is increasing in each succeeding year. Therefore, the business entity can invest in the stock of the company.

Working note:

Formulas to be used:

$\mathbf{Profit}\mathbf{}\mathbf{margin}\mathbf{}\mathbf{ratio}\mathbf{=}\frac{\mathbf{Net}\mathbf{}\mathbf{income}}{\mathbf{Net}\mathbf{}\mathbf{sales}\mathbf{}\mathbf{revenue}}$

$\mathbf{Rate}\mathbf{}\mathbf{of}\mathbf{}\mathbf{return}\mathbf{}\mathbf{on}\mathbf{}\mathbf{total}\mathbf{}\mathbf{assets}\mathbf{=}\frac{\mathbf{Net}\mathbf{}\mathbf{income}\mathbf{+}\mathbf{Interest}\mathbf{}\mathbf{expenses}}{\mathbf{Average}\mathbf{}\mathbf{total}\mathbf{}\mathbf{assets}}$

$$\begin{gathered} \mathbf{Asset}\mathbf{}\mathbf{turnover}\mathbf{}\mathbf{ratio}\mathbf{=}\frac{\mathbf{Net}\mathbf{}\mathbf{sales}\mathbf{}\mathbf{revenue}}{\mathbf{Average}\mathbf{}\mathbf{total}\mathbf{}\mathbf{assets}} \\ \mathbf{Average}\mathbf{}\mathbf{total}\mathbf{}\mathbf{assets}\mathbf{=}\frac{\mathbf{Net}\mathbf{}\mathbf{income}\mathbf{+}\mathbf{Interest}\mathbf{}\mathbf{expenses}}{\mathbf{Rate}\mathbf{}\mathbf{of}\mathbf{}\mathbf{return}\mathbf{}\mathbf{on}\mathbf{}\mathbf{total}\mathbf{}\mathbf{assests}} \end{gathered}$$

$\mathbf{Rate}\mathbf{}\mathbf{of}\mathbf{}\mathbf{return}\mathbf{}\mathbf{on}\mathbf{}\mathbf{common}\mathbf{}\mathbf{stockholder}\mathbf{\text{'}}\mathbf{s}\mathbf{}\mathbf{equity}\mathbf{=}\frac{\mathbf{Net}\mathbf{}\mathbf{income}\mathbf{-}\mathbf{Preferred}\mathbf{}\mathbf{dividend}}{\mathbf{Average}\mathbf{}\mathbf{common}\mathbf{}\mathbf{stockholder}\mathbf{\text{'}}\mathbf{s}\mathbf{}\mathbf{equity}}$

$\mathbf{Rate}\mathbf{}\mathbf{of}\mathbf{}\mathbf{return}\mathbf{}\mathbf{on}\mathbf{}\mathbf{common}\mathbf{}\mathbf{stockholder}\mathbf{\text{'}}\mathbf{s}\mathbf{}\mathbf{equity}\mathbf{=}\frac{\mathbf{Net}\mathbf{}\mathbf{income}\mathbf{-}\mathbf{Preferred}\mathbf{}\mathbf{dividend}}{\mathbf{Weighted}\mathbf{}\mathbf{average}\mathbf{}\mathbf{number}\mathbf{}\mathbf{of}\mathbf{}\mathbf{common}\mathbf{}\mathbf{shares}\mathbf{}\mathbf{outstanding}\mathbf{}}$

Analysis: In each succeeding year, the company can sell its inventory more efficiently, which is reflected by the number of days calculated in the day’s sales in inventory and the inventory turnover ratio. Therefore, the business entity can invest in the company.

Working note:

$$\begin{gathered} \mathbf{Inventoy}\mathbf{}\mathbf{turnover}\mathbf{}\mathbf{ratio}\mathbf{=}\frac{\mathbf{Cost}\mathbf{}\mathbf{of}\mathbf{}\mathbf{goods}\mathbf{}\mathbf{sold}}{\mathbf{Average}\mathbf{}\mathbf{merchandise}\mathbf{}\mathbf{inventory}} \\ \mathbf{Day}\mathbf{\text{'}}\mathbf{s}\mathbf{}\mathbf{sales}\mathbf{}\mathbf{in}\mathbf{}\mathbf{inventory}\mathbf{=}\frac{\mathbf{365}}{\mathbf{Inventoy}\mathbf{}\mathbf{turnover}\mathbf{}\mathbf{ratio}} \end{gathered}$$

Analysis: The times interest earned ratio increases each year, reflecting that the business entity is efficient in covering its interest expenses. A debt ratio and debt-equity reflect that the debts of the business entity are increasing and decreasing. It states that the business entity is paying off its debt.

Working note:

$\mathbf{Debt}\mathbf{}\mathbf{ratio}\mathbf{=}\frac{\mathbf{Total}\mathbf{}\mathbf{liabilities}}{\mathbf{Total}\mathbf{}\mathbf{assets}}$

$\mathbf{Debt}\mathbf{-}\mathbf{to}\mathbf{-}\mathbf{equity}\mathbf{}\mathbf{ratio}\mathbf{=}\frac{\mathbf{Total}\mathbf{}\mathbf{liabilities}}{\mathbf{Total}\mathbf{}\mathbf{equity}}$

$\mathbf{Time}\mathbf{}\mathbf{interest}\mathbf{}\mathbf{earned}\mathbf{}\mathbf{ratio}\mathbf{=}\frac{\mathbf{Net}\mathbf{}\mathbf{income}\mathbf{+}\mathbf{Income}\mathbf{}\mathbf{tax}\mathbf{}\mathbf{expenses}\mathbf{+}\mathbf{Interest}\mathbf{}\mathbf{expenses}}{\mathbf{Interest}\mathbf{}\mathbf{expenses}}$

Analysis: Earnings per share of the company reflect an increase which means that the business entity can generate higher income for each of its shares. Still, the dividend payout ratio is declining, which means that the business entity is paying fewer dividends.

Working note:

$\mathbf{Earnings}\mathbf{}\mathbf{per}\mathbf{}\mathbf{share}\mathbf{=}\frac{\mathbf{Net}\mathbf{}\mathbf{income}\mathbf{-}\mathbf{Preferred}\mathbf{}\mathbf{dividend}}{\mathbf{Weighted}\mathbf{}\mathbf{average}\mathbf{}\mathbf{common}\mathbf{}\mathbf{shares}\mathbf{}\mathbf{outstanding}}$

$\mathbf{Dividend}\mathbf{}\mathbf{payout}\mathbf{}\mathbf{=}\frac{\mathbf{Annual}\mathbf{}\mathbf{dividend}\mathbf{}\mathbf{per}\mathbf{}\mathbf{share}}{\mathbf{Earnings}\mathbf{}\mathbf{per}\mathbf{}\mathbf{share}}$

The business entity can be considered for investment because it shows constant performance growth. Earnings per share reflect growth from $0.28 per share in 2014 to $1.10 per share in 2018.