Financial Ratios 1-23-2024

docx

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

Report
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%