Financial Ratios 1-23-2024
docx
keyboard_arrow_up
School
West Virginia University *
*We aren’t endorsed by this school
Course
528
Subject
Finance
Date
Apr 3, 2024
Type
docx
Pages
5
Uploaded by CaptainHedgehog3108
FIN 422 / 528 Financial Analysis
Ratio Basics
Financial ratios are an excellent tool to understand and risk assess the client. There are limitations though, as they depend entirely on the reliability of the data on which they are based, and they are historical in nature in that they rely upon test data. Key limitations to using financial ratios are that there
may be few industry benchmarks for comparison, inflation may make comparability difficult, management may manipulate ratios, and differences in the application of certain accounting principles can make analyses difficult (e.g. FIFO versus LIFO between companies).
Listed below are several of the ratios that I use, along with their formulas. I categorize these in a slightly different manner than others – you, too will personally have different categories, but in the end you will encapsulates the same information. Additionally, I have embedded a slightly altered income statement and balance sheet for Google to illustrate the calculation of these ratios.
Alphabet (Google)
in thousands
Income Statement, for the period ending
12/31/2019
12/31/2018
12/31/2017
Revenue
161,587,000
136,819,000
110,855,000
COGS
71,896,000
59,549,000
45,583,000
Gross Profit
89,691,000
55.5%
77,270,000
56.5%
65,272,000
58.9%
Operating Expenses
Research & Development
26,018,000
21,419,000
16,625,000
Selling, General, & Admin.
28,015,000
24,459,000
19,765,000
Total Operating Expenses
54,033,000
45,878,000
36,390,000
Operating Income
35,658,000
22.1%
31,392,000
22.9%
28,882,000
26.1%
Interest Expense
100,000
114,000
109,000
Other Income/Expense
1,370,000
1,757,000
(2,892,000)
Income before tax
36,928,000
22.9%
33,035,000
24.1%
25,881,000
23.3%
Income Tax expense
5,282,000
4,177,000
14,531,000
Income from Continuing Operations
31,646,000
19.6%
28,858,000
21.1%
11,350,000
10.2%
Net Income
31,646,000
19.6%
28,858,000
21.1%
11,350,000
10.2%
FIN 422 / 528 Financial Analysis
Alphabet (Google)
in thousands
Balance Sheet, as of
12/31/2019
12/31/2018
12/31/2017
Cash & equivalents
18,498,000
16,701,000
10,715,000
Other short-term investments
101,177,000
92,493,000
91,156,000
Total Cash
119,675,000
109,194,000
101,871,000
Net Receivables
25,326,000
20,838,000
18,336,000
Inventory
999,000
1,107,000
749,000
Other Current Assets
4,412,000
4,236,000
2,983,000
Total Current Assets
150,412,000
135,375,000
123,939,000
Plant, Property, & Equipment
115,148,000
82,507,000
59,647,000
Accumulated Depreciation
(30,561,000)
(22,788,000)
(17,264,000)
Net P,P, & E
84,587,000
59,719,000
42,383,000
Equity & other investmetns
13,078,000
13,859,000
7,813,000
Goodwill
20,624,000
17,888,000
16,747,000
Inangible Assets
1,979,000
2,220,000
2,692,000
Other long-term Assets
2,342,000
2,693,000
2,672,000
Total Non-Current Assets
122,610,000
96,379,000
72,307,000
Total Assets
273,022,000
231,754,000
196,246,000
Accounts Payable
5,561,000
4,378,000
3,137,000
Taxes Payable
274,000
69,000
881,000
Accrued Liabilities
18,379,000
13,769,000
11,278,000
Deferred Revenues
1,908,000
1,784,000
1,432,000
Other Current Liabilities
19,099,000
14,620,000
7,455,000
Total Current Liabilities
45,221,000
34,620,000
24,183,000
Long-Term Debt
3,959,000
3,950,000
3,943,000
Deferred Taxes
1,701,000
1,264,000
430,000
Deferred Revenues
358,000
369,000
340,000
Other Long-Term Liabilities
20,341,000
14,961,000
15,897,000
Total Non-current Liabilities
26,359,000
20,544,000
20,610,000
Total Liabilities
71,580,000
55,164,000
44,793,000
Common Stock
50,552,000
45,049,000
40,247,000
Retained Earnings
152,122,000
134,885,000
113,247,000
Accumulated Other Comprehensive Income
(1,232,000)
(2,306,000)
(992,000)
FIN 422 / 528 Financial Analysis
Financial Performance
Gross Profit (Margin) Percentage = Gross Profit / Revenue
For 2019, it is 55.5% in the example
Operating Income (Margin) Percentage = Operating Income / Revenue
For 2019, it is 22.1%
Return on Sales = Net Income / Revenue
For 2019, it is 19.6%
Return on Assets = Net Income / Average Total Assets
For 2019, it is (31,646,000 / (273,022,000 + 231,754,000) / 2) = = 31,646,000 / 252,388,000 = 12.5% Return on Equity = Net Income / Average Total Stockholders’ Equity
For 2019, it is (31,646,000 / (201,442,000 + 177,628,000) / 2) = = 31,646,000 / 189,535,000 = 16.7% Return on capital employed = (Net Income / (total assets – current liabilities), which answers the question “For every dollar invested, what does it return?”
For 2019, it is (31,646,000 / (273,022,000 – 45,221,000) =
= 31,646,000 / 227,801,000 = 13.9%
Price to Earnings ratio (PE ratio) = current stock market price / Net Income per share, OR
Market Capitalization / Net Income
Assume that the current Alphabet Inc. -Google Stock price (GOOG) is $1,500 per share with a total market capitalization of $1,003,000,000,000 (that’s right, that’s more than $1 trillion), and a basic earnings per share (eps) of $49.59 for 2019.
The PE ratio is $1,500 / $49.59 = 30.24, or calculated the other way is
$1,003,000,000 / $31,646,000 = 31.69.
The difference is in the rounding of the reported market capitalization.
Dividend payout ratio (yearly dividend / eps)
Google doesn’t pay out a dividend, which is fairly common for many high-tech stocks. If the company did pay a $4 per share dividend quarterly, though, the payout ratio would be
($4 x 4) / $49.59 = $16 / $49.59 = 32.3%
Dividend yield (dividend per share / market value per share)
Google doesn’t pay out a dividend, which is fairly common for many high-tech stocks. If the company did pay a $4 per share dividend quarterly, though, the payout ratio would be
($4 x 4) / $1,500 = $16 / $1,500 = 0.017%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
FIN 422 / 528 Financial Analysis
Operational Efficiency and Effectiveness
Inventory turnover = COGS / Average Inventory
For 2019, it is (71,896,000 / (999,000 + 1,107,000)/2) = 71,896,000 / 1,053,000 = 68.28 (this is very, very high, which is good!)
Days of inventory = 365 / Inventory Turnover
365 / 68.28 = 5.35
AR turnover = Revenue / Average Accounts Receivable
For 2019, it is (161,587,000 / (25,326,000 + 20,838,000)/2) =
161,587,000 / 23,082,000 = 7.0
Average Collection Period or Days Sales in Accounts Receivable = 365 / AR turnover
365 / 7.0 = 52.1
Asset turnover = (Revenue / Average Total Assets)
For 2019, it is (161,587,000 / (273,022,000 + 231,754,000) / 2) = = 161,587,000 / 252,388,000 = 64.0% CAPEX = Capital spending / Depreciation
This is the rate in which the company reinvests in their Plant, Property, and Equipment. Capital spending and depreciation is taken from their cash flow statement (not provided). For 2019, it is 24,180,000 / 12,827,000 = 1.89
Financing & Solvency
Debt ratio = (total debt / total assets)
For 2019, it is (71,580,000 / 273,022,000) = 26.2%
Debt to Equity ratio = (total debt / total SE)
For 2019, it is (71,580,000 / 201,442,000) = 35.4%
Equity ratio = (total equity / total assets)
For 2019, it is (201,442,000 / 273,022,000) = 73.8%
Liquidity
Working Capital = Current Assets – Current Liabilities
For 2019, it is (150,412,000 – 45,221,000 ) = $105,191,000
FIN 422 / 528 Financial Analysis
Working Capital ratio = Current Assets / Current Liabilities
For 2019, it is (150,412,000 / 45,221,000 ) = 3.33
Acid-test ratio (Quick ratio) = (cash + cash equivalents + AR) / current liabilities
For 2019, it is (18,498,000 +25,326,000) / 45,221,000 = = 43,824,000 / 45,221,000 = 0.97
Interest coverage ratio (Times Interest Earned) = (EBIT / interest expense) In general, 1.5 is the “rule of thumb,” and lower is not good. In this case, Google will have no problem covering their interest payment:
For 2019, it is (36,658,000 / 100,000) = 366.6
On the income statement above, you can see the vertical analyses of the various percentages. When performing a horizontal analysis, you work across the page. For example, the sales growth from 2018 to 2019 is ((161,587,000 – 136,819,000) / 136,819,000) = 18.1%
When you look at multiple periods, you have to do the Compound Annual Growth Rate (CAGR). The growth from 2017 to 2018 is ((136,819,000 – 110,855,000) / 110,855,000 = 23.4%, and the CAGR will be somewhere between 23.4% and 18.1%. The formula to calculate this is:
(ending balance / beginning balance)
(1/n)
– 1
Where n = number of periods
So, from 2017 to 2019, Google had a compound growth rate of
(161,587,000 / 110,855,000)
(1-2)
-1 = (1.4576)
0.5
– 1 = 20.73%
Related Documents
Related Questions
FINANCIAL ACCOUNTING MCQ
arrow_forward
Financial analysts are aware of the many limitations of ratio analysis as a technique of financial statement analysis.
Describe the advantages and disadvantages of ratio analysis.
Explain ways that ratios may be misleading to an analyst. For example, ratios are retrospective and do not directly incorporate forecasts of future performance.
arrow_forward
Which is not a potential problem of utilizing ratio analysis?
A. trends and industry averages are historical in nature.
B. financial data may be distorted due to price-level changes.
C. firms within an industry may not use similar accounting methods.
D. all of the above
E. answer not given
arrow_forward
Economic consequences of accounting standard-setting means:
a. standard-setters must give first priority to ensuring that companies do not suffer any adverse effect as a result of a new standard.
b. standard-setters must ensure that no new costs are incurred when a new standard is issued.
c. the objective of financial reporting should be politically motivated to ensure acceptance by the general public.
d. accounting standards can have detrimental impacts on the wealth levels of the providers of financial information.
arrow_forward
1
arrow_forward
Accounting
What are some common financial statement errors or discrepancies that analysts and auditors should watch out for?
arrow_forward
Can assessment measures be used for predictive purposes?
Accounting practitioners have criticized some proposed accounting standards on the grounds that they are difficult to implement because of measurement problems. They, therefore, conclude that the underlying theory is inappropriate. Assuming that the critics are correct about the implementational difficulties, do you agree with their thinking? Discuss.
What type of measurement scale (nominal, ordinal, interval, or ratio scale) is being used in the following situations?
Musical scales - interval scales
Insurance risk classes for automobile insurance -
Numbering of pages in a book
A grocery scale
A grocery scale deliberately set 10 pounds too high
Assignment of students to advisers, based on major
arrow_forward
Which of the following is not an advantage of accounting standards?
Select one:
a. All of the given answers are correct.
b. It reduces the reliability of financial statements.
c. It helps to attain uniformity in accounting.
d. It provides guidance on the content and presentation of financial statements.
arrow_forward
Explain the role
arrow_forward
A tradeoff between enhancing qualitative characteristics often occurs. For example, when a company records sales revenue, it is required to simultaneously estimate and record an expense for potential bad debts (uncollectible accounts). Including this estimated expense is considered to represent the economic event faithfully and to provide relevant information about the net profi ts for the accounting period. Th e information is timely and understandable; but because bad debts may not be known with certainty until a later period, inclusion of this estimated expense involves a sacrifi ce of verifi ability. Th e bad debt expense is simply an estimate. It is apparent that it is not always possible to simultaneously fulfi ll all qualitative characteristics. Companies are most likely to make tradeoff s between which of the following when preparing fi nancial reports? A . Relevance and materiality. B . Timeliness and verifi ability. C . Relevance and faithful representation.
arrow_forward
If CBA Failed to meet earning expectations because Loan Impairment expense
was Higher than expected, the ERC is likely to be?
A. Small, as imperfections are 'fictitious accounting'
B. Big, as markets dislike impairments more than other forms of expenses
C. Small, because impairment represents once off expense
D. Very large, because loan impressions account for a significant portion of the
revenue
arrow_forward
Much of the current thinking of accounting standard setters about measurement seems to be based on an idealized view of markets as being complete and in perfectly competitive equilibrium. In such conditions, there is a unique market price based on full information for every asset and liability, and there is an obvious attraction in using this price as the measure for accounting. This explains the apparent enthusiasm for single ideal measurement methods for all assets and liabilities.Required:Given that in reality, ideal conditions of markets are unlikely to hold, critically appraise whether a single measurement basis in financial reporting is appropriate.
arrow_forward
Mf1.
arrow_forward
Which of the following statements is true?
Select one:
1.Non-financial measures may reflect drivers of future financial performance.
2.Non-financial measures are not consistent with contemporary management accounting.
3.Non-financial measures are more difficult to action.
4.Non-financial measures are more difficult to understand.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning

Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Related Questions
- FINANCIAL ACCOUNTING MCQarrow_forwardFinancial analysts are aware of the many limitations of ratio analysis as a technique of financial statement analysis. Describe the advantages and disadvantages of ratio analysis. Explain ways that ratios may be misleading to an analyst. For example, ratios are retrospective and do not directly incorporate forecasts of future performance.arrow_forwardWhich is not a potential problem of utilizing ratio analysis? A. trends and industry averages are historical in nature. B. financial data may be distorted due to price-level changes. C. firms within an industry may not use similar accounting methods. D. all of the above E. answer not givenarrow_forward
- Economic consequences of accounting standard-setting means: a. standard-setters must give first priority to ensuring that companies do not suffer any adverse effect as a result of a new standard. b. standard-setters must ensure that no new costs are incurred when a new standard is issued. c. the objective of financial reporting should be politically motivated to ensure acceptance by the general public. d. accounting standards can have detrimental impacts on the wealth levels of the providers of financial information.arrow_forward1arrow_forwardAccounting What are some common financial statement errors or discrepancies that analysts and auditors should watch out for?arrow_forward
- Can assessment measures be used for predictive purposes? Accounting practitioners have criticized some proposed accounting standards on the grounds that they are difficult to implement because of measurement problems. They, therefore, conclude that the underlying theory is inappropriate. Assuming that the critics are correct about the implementational difficulties, do you agree with their thinking? Discuss. What type of measurement scale (nominal, ordinal, interval, or ratio scale) is being used in the following situations? Musical scales - interval scales Insurance risk classes for automobile insurance - Numbering of pages in a book A grocery scale A grocery scale deliberately set 10 pounds too high Assignment of students to advisers, based on majorarrow_forwardWhich of the following is not an advantage of accounting standards? Select one: a. All of the given answers are correct. b. It reduces the reliability of financial statements. c. It helps to attain uniformity in accounting. d. It provides guidance on the content and presentation of financial statements.arrow_forwardExplain the rolearrow_forward
- A tradeoff between enhancing qualitative characteristics often occurs. For example, when a company records sales revenue, it is required to simultaneously estimate and record an expense for potential bad debts (uncollectible accounts). Including this estimated expense is considered to represent the economic event faithfully and to provide relevant information about the net profi ts for the accounting period. Th e information is timely and understandable; but because bad debts may not be known with certainty until a later period, inclusion of this estimated expense involves a sacrifi ce of verifi ability. Th e bad debt expense is simply an estimate. It is apparent that it is not always possible to simultaneously fulfi ll all qualitative characteristics. Companies are most likely to make tradeoff s between which of the following when preparing fi nancial reports? A . Relevance and materiality. B . Timeliness and verifi ability. C . Relevance and faithful representation.arrow_forwardIf CBA Failed to meet earning expectations because Loan Impairment expense was Higher than expected, the ERC is likely to be? A. Small, as imperfections are 'fictitious accounting' B. Big, as markets dislike impairments more than other forms of expenses C. Small, because impairment represents once off expense D. Very large, because loan impressions account for a significant portion of the revenuearrow_forwardMuch of the current thinking of accounting standard setters about measurement seems to be based on an idealized view of markets as being complete and in perfectly competitive equilibrium. In such conditions, there is a unique market price based on full information for every asset and liability, and there is an obvious attraction in using this price as the measure for accounting. This explains the apparent enthusiasm for single ideal measurement methods for all assets and liabilities.Required:Given that in reality, ideal conditions of markets are unlikely to hold, critically appraise whether a single measurement basis in financial reporting is appropriate.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage LearningAuditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College PubFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning

Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning

Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning