Valuation Fundamentals
Valuation Fundamentals
Acquisitions
OVERVIEW of VALUATION
FUNDAMENTALS
- Notes coverage begins with the very basics but
quickly builds to more developed concepts – we will
skim much of these slides in class
1
Valuation and M&A
►Valuation plays a key role in M&A as in all of finance. In valuation, we
wish to determine value (what something is worth today using the most
up-to-date information available) and make decisions based on that
value assessment. While M&A’s specific transaction context, execution
and source of value may differ from firms’ traditional individual capital
budgeting decisions, the objective remains the same => to obtain a +
NPV (Net Present Value) result.
►But first, let’s review valuation, NPV, generating pro formas, etc.
2
Outline of Topics
• The Finance Function within the Firm
• Present Value, Discounted Cash Flows, NPV, WACC
• Review of Financial Statements
• Free Cash Flow – Estimation
• Valuing a Firm – using FCFs and WACC – a DCF method
• Building Pro Formas
• Issues to Keep in Mind with WACC, CAPM/SML
• Un-leveraging / Re-leveraging Betas
• APV Valuation – a DCF method
• FCFE – a DCF method
• Appendix: Financial Ratio Analysis 3
The Firm: Investment Vehicle Model - Flow of Cash
Firm's Operations
(2) Financial Manager (1) Financial
Investors
(4a)
(3) (4b)
• Share Prices reflect the market value of the residual claims – i.e., the
value of the remaining cash flow after all business costs have been
addressed. Thus they ultimately reflect the underlying firm’s ability
to generate cash flows. Accordingly, the goal of financial management
is to maximize share price as it is said to maximize the contributions of
the firm. When might this not be appropriate?
End of End of
Today year 1 year 2
0 1 2 3
• Future Value (FV) – the value of a cash flow sometime into the future. On a
timeline t > 0. Translating a value to the future is referred to as compounding.
9
Present Value
• Assume a stream of cash flows 𝐶𝐶1 , 𝐶𝐶2 , 𝐶𝐶3 , … where the subscripts denote time periods that
the cash flows are received, and r is the constant discount rate per period.
• The Present Value (PV: value at period 0) of the stream of cash flows is
𝐶𝐶1 𝐶𝐶2 𝐶𝐶3
𝑃𝑃𝑃𝑃 = + + +⋯
1+𝑟𝑟 1+𝑟𝑟 2 1+𝑟𝑟 3
• A perpetuity refers to a constant period cash flow C = 𝐶𝐶1 , 𝐶𝐶2 , 𝐶𝐶3 , …, and the first cash
flow occurs at the end of the first period,
𝐶𝐶
𝑃𝑃𝑃𝑃 =
𝑟𝑟
• For a perpetuity whose period cash flow increases at a steady rate g for every period in
perpetuity, and the first cash flow occurs at the end of the first period
𝐶𝐶
𝑃𝑃𝑃𝑃 = 𝑟𝑟−𝑔𝑔
1
• For an annuity where the payments are constant in amount C, made per period for a fixed
number of n periods and r is the constant discount rate per period
𝐶𝐶 1
𝑃𝑃𝑃𝑃 𝑜𝑜𝑜𝑜 𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴 = 1− 10
𝑟𝑟 1+𝑟𝑟 𝑛𝑛
Direct Valuation of Bonds/Stocks
• When valuing a firm’s bonds, we use PV of an annuity and PV of an
individual cash flow, to value the fixed stream of periodic coupon
payments as well as the one-time return of principal payment at par
value. The cash flows are discounted at the firm’s required rate of
return on debt, i.e. its yield to maturity (sometimes referred to as
YTM or rD).
56,357.14 PV12%,1
PV12%,2
56,441.32
PV12%,3
64,828.94
12,627.40
NPV = 63,120/(1.12) + 70,800/(1.12)2 + 91,080/(1.12)3 – 165,000 = +12,627.40
Relating NPV to an Acquirer: NPV + when Target B + ∆V > Target B + ∆P + C
What I’m Receiving > What I’m Paying 13
Estimating the Value of a ‘Stand Alone’ Firm
1) Forecast all relevant after tax expected free cash flows (FCFs) generated by
the project or firm. We estimate a firm or project’s free cash flow based on the
firm’s projected financial statements.
Firm Value =
Year 1 Free Cash Flow Year 2 Free Cash Flow
+ +. . .
1 + 𝑟𝑟 1 + 𝑟𝑟 2
Year n Free Cash Flow + Termnal Value as of Year n
+
1 + 𝑟𝑟 𝑛𝑛
where D E
r = WACC = rD * (1 − TC ) * + rE
V V
►When estimating WACC, use market values for D (debt), E (equity) and V
(V=D+E), and essentially use the firm’s target D/V ratio.
►WACC stands for Weighted Average Cost of Capital. It is the average return that
the firm must generate per year on funds obtained from all investors.
►Free Cash Flow (FCF) is also called Unlevered Cash Flows and Free Cash Flows to the Firm (FCFF)
15
Re WACC Components: rD cost of debt
Lenders to the firm receive an annual return of rD (also
referred to as YTM, yield to maturity). They are
compensated for:
Required
Return on (re )
Equity SML
rM
rf
Y-intercept
𝛽𝛽𝑖𝑖
0 βm= 1 = β of the market portfolio Beta
17
Re WACC Components: re cost of equity
βe, the cost of equity, is derived from a regression of the firm’s stock returns on the market
index’s stock returns:
Cov(ri , rm )
βi =
1. Total risk = Stock i σ 2 (rm )
diversifiable risk + return
market risk
2. Market risk is
measured by beta, the beta
sensitivity to market
+10%
-10%
changes
- 10% +10%
Market
return
-10%
The resulting regression:
α + β r + ε
r =
i i i m i
βi- Sensitivity of a stock i’s return to the return on the market portfolio.
rm refers to the historical market portfolio return, ε refers to the “noise” or unique risk 18
The Financial Statements - Reminder
1. Balance sheet – provides a snapshot of a firm’s financial
position at a point in time.
2. Income statement – summarizes a firm’s revenues and
expenses over a given period of time.
3. Statement of retained earnings – shows how much of the
firm’s earnings were retained, rather than paid out as
dividends.
4. Statement of cash flows – reports the impact of a firm’s
activities on cash flows over a given period of time.
Essentially reconciles the beginning and ending cash
balances. 19
Sample “Balance Sheet” December 31, 20XX
ASSETS = LIABILITIES + EQUITY Numbers in thousands ($000s)
2023 2022 2023 2022
Cash & Equiv. 3,171 6,489 A/P 313,286 340,220
A/R 1,095,118 1,048,991 N/P 227,848 86,631
Net Income
+ Depreciation
- Increase in operating current assets
Change in NOWC
+ Increase in operating current liabilities
- Increase in fixed assets at cost (Increase in NFA + Accum Depreciation)
+ After-tax interest paid on debt
= Free Cash Flow
*Note that if there are Deferred Taxes (we would add those back in)
**If Interest has been received on cash balances, we would subtract After-tax Interest Received.
25
Valuing a Firm Using the FCF Method
• The free cash flow method suggests that the value of the firm’s
operating assets (i.e., enterprise value) is equal to the present value
of the firm’s expected future free cash flows generated from those
assets.
• Free cash flows refer to the firm’s after-tax operating income less the
net capital investment in fixed assets and net increased investment in
operating working capital:
32
Example: Part III
• Cash Flow to Creditors (info from B/S and I/S) =
interest paid – net new borrowing (LT Debt and Notes
Payable) = $70 – [(123+454) – (196+408)] = $70 – -
$27 = $97
• Cash Flow to Stockholders (info from B/S and I/S) =
dividends paid – net new equity raised = $103 – ($640 -
$600) = $63
34
Review: Identifying Relevant Cash Flow Inputs:
1) Depreciation is not a cash flow, but results in a positive tax flow by reducing taxes paid. As
well, increases in deferred taxes arise when a higher tax is computed for reporting purposes
than is actually owed (e.g., a result of using accelerated depreciation for tax purposes but not
for reporting purposes).
4) Estimate cash flows as if entirely equity financed (separate investment and financing
decisions).
Terminal Value – Multiples method: Again assumes going concern. E.g. EBITDA Multiple
– comparing relative values to obtain market value. 36
Valuing the Firm – a note on Terminal Val and growth:
⇒ When a firm’s continuing value expectations after time t are such that it is not
expected to grow but rather maintain market share, then the firm pays out its
entire earnings and does not reinvest in the firm. Thus the firm’s entire earnings
available to stakeholders FCFn+1 are in fact NOPATn+1 (because there is no
further adjustment for additional investment in working capital or capital
expenditure [investment = depreciation], etc., beyond existing operations).
⇒While it is common practice to value these cash flows as:
NOPATn+1
Continuing Value [at time n] (with 𝑔𝑔 = 0) Often Estimated as =
WACC
Note: Depreciation is based on historical costs and therefore does not grow with
inflation.
Common Mistake: Nominal discount rate used to discount real cash flows. Thus,
good projects are rejected.
Review: Identifying Relevant Cash Flow Inputs:
Year 1 Year 2 Year 3 Year 4 Year 5 . . . Terminal
FCF1 FCF2 FCF3 FCF4 FCF5 FCFn+1/(r-g)
FCFs are the cash flows generated by a firm’s operating assets for a given period, after taking into account
investment needed in fixed assets and working capital. Thus it is cash available to the providers of capital
Basic Example: Corporate Valuation
The below timeline indicates the firm’s projected FCFs (in
$Millions): FCF1 = -5, FCF2 = 10, FCF3 = 20. After year three, the firm is
expected to have a long-run constant gFCF = 6%. It has a weighted
average cost of capital (WACC) of 10%. Use the FCF DCF model to
find the firm’s value today.
0 r = 10% 1 2 3 4
g = 6%
...
-5 10 20 21.20
-4.545
8.264
15.026 21.20
398.197 530 = 0.10 - 0.06
416.942 TV3
Basic Example: Corporate Valuation
If the firm has no non-operating assets or liabilities, has $40
million in debt and has 10 million shares of stock, what is
the firm’s value per share?
• MV of equity = MV of firm – MV of debt
D
= $416.94 - $40
= $376.94 million Equity
44
Basic Pro Formas for Company Valuation:
• Some Points
- For the purposes of building pro forma financial statements,
operating “current assets” refers only to those current assets used
in the firm’s operations. This would include: A/R, Inventories,
Pre-paid Expenses. Pro forma “current assets” does not include
Cash and Marketable Securities THAT are NOT required for the
firm’s operations (i.e., it does not include ‘excess cash’).
- Concurrently, when building pro formas, operating “current
liabilities” also refers only to those current liabilities used in the
firm’s operations. Included would be: A/P, Taxes Payable. Short-
term debt and the current portion of long term debt are not
included.
45
Projecting Cash Flows - Overview:
• A Basic Financial Planning Model has 3 Major Components:
i. The Model Parameters/Value Drivers: These reflect the basic
assumptions of the model. More often than not, financial-
statement models are sales-driven – accordingly, once a sales
estimate is made, many of the other financial statement accounts are
expressed as a function (percentage) of the firm’s sales.
ii. Financial Policy Assumptions: How will the firm finance
operating cash shortfalls in the future? If there is instead a cash
surplus generated, will the firm’s excess operating cash generated
go to its cash account or is it used to pay down debt.
iii. Creation of Pro Forma Financial Statements: Once the above
components have been determined, a firm’s pro formas can be
created in line with their business strategy, financial policy and
expected performance. 46
Building Pro Formas – Basic Overview:
Extending the Model to Years 2 and Beyond:
►When valuing firms and creating pro formas, the forecast period is
selected so as to incorporate all non-smooth foreseeable changes in
expected cash flow patterns (lumpy capital expenditures, asset
disposals, reductions in expenses, atypical growth, cyclical effects,
etc.).
48
Sensitivity Analysis:
• By varying the model’s assumptions, we can use the financial planning model
to analyze different scenarios of the firm’s future performance. This allows for
a review of the project’s strengths, weaknesses, and the consequences of mis-
estimating variables. In enterprise valuation, there is no substitute for a
careful analysis of the possible cash flow scenarios.
• While the pro-formas will be produced for the expected operating results (most
likely scenario), it is also important to acknowledge and comment on the effect
of varying financial assumptions on NPV and value.
- Determining the impact of changing certain assumptions on the financial
statements and the free cash flows can easily be done with Excel, by
changing the values of the cells containing the revenue growth
assumptions or the discount rates for valuation
- However to more broadly see the range of impact of changing
assumptions on the financial statements we can use Excel’s Data
Table feature. 49
Sensitivity Analysis:
• Two Dimensional Data Tables (Under Excel ‘What If Analysis’): Below we
vary our example with respect to both the interest rate and the initial deposit.
B C D E F G H
9 $2,334.93 0% 5% 10% 15% 20% 25%
10 50 500.00 660.34 876.56 1,167.46 1,557.52 2,078.31
11 100 1,000.00 1,320.68 1,753.12 2,334.93 3,115.04 4,156.61
12 150 1,500.00 1,981.02 2,629.68 3,502.39 4,672.56 6,234.92
13 200 2,000.00 2,641.36 3,506.23 4,669.86 6,230.08 8,313.23
14 250 2,500.00 3,301.70 4,382.79 5,837.32 7,787.60 10,391.53
15 300 3,000.00 3,962.04 5,259.35 7,004.78 9,345.13 12,469.84
50
More WACC Valuation Issues: Project vs. Firm
We use a firm’s after-tax WACC on a project/transaction when its business risk is the same as
that of the firm’s other assets and it is expected to remain so for the life of the project.
However, when that is not the case, firm WACC should not be used. For example, consider a
conglomerate firm composed of four business divisions, but which uses the firm’s overall
WACC to evaluate projects.
D E P
WACC = rD × (1 − Tc ) × + rE × + rP ×
V V V
Where Value = Debt + Equity + Preferred Equity
► Industry WACCs are sometimes more useful b/c they are less exposed
to random noise and estimation errors. But this assumes company and
industry have same business risk and financing risk (capital structure).
52
More WACC Valuation Issues: Financing
►We use a firm’s after-tax WACC on a project when the project supports the same
fraction of debt to value as the firm’s overall capital structure. However note that the
immediate source of funds has no necessary connection with what the project’s
overall contribution to/ effect on the firm’s borrowing power / debt ratio. We are
concerned with the latter.
• Small or temporary fluctuations in the debt ratios can be ignored because
changes in the tax shield over time tend to offset each other. This does not apply
to large and persistent movement from the target debt ratio.
►Note: Recall that when using the WACC Valuation method, the free cash flows
composing the numerator, have to be projected as if the company were all equity
financed. Again, these cash flows are then discounted at the after-tax cost of capital
thereby incorporating the value of the interest tax shield in the valuation calculation
rendered.
►Note: When using the WACC Valuation method, the value estimate obtained
represents the total value of the firm’s entire operations (excluding non operating
assets which have to be added to this calculation) – this includes all debt and equity.
53
Recall WACC Components
Return on Equity derived from: CAPM => SECURITY MARKET LINE
⇒ The SML describes the risk return relationship between the β of a security and its
expected rate of return. =>The most common method of estimating return on equity 54
Recall Beta and Diversifiable Risk
Cov(ri , rm )
1. Total risk =
βi =
σ 2 (rm )
diversifiable risk Stock i
+ market risk return
2. Market risk is
measured by beta, beta
the sensitivity to +10%
-10%
market changes
-10% +10%
Market
-10% return
The resulting regression:
α + β r + ε
r =
i i i m i
Nasdaq
20%
y = 1.4346x + 0.0025
R2 = 0.6433 15%
10%
5%
0%
-20% -15% -10% -5% 0% 5% 10% 15%
-5% S&P 500
-10%
-15%
-20%
-25%
-30%
57
SML and β Measurement
EXCESS RETURNS, NASDAQ vs S&P 500
December 1999 - August 2003
25%
Nasdaq
20%
15%
y = 1.6865x + 0.0036
R2 = 0.6255 10%
5%
0%
-15% -10% -5% 0% 5% 10% 15%
-5%
S&P 500
-10%
-15%
-20%
-25%
-30%
58
Estimating Betas:
• We can use historical equity return data to estimate a firm’s equity β if
the firm’s past market sensitivity is assumed to be a good indication of
its future.
• Moreover, how far back in the past we look (2 years, 5 years, 30 years,
etc.) depends, on our assumptions about the stationarity of the
distribution of returns and the validity of the pricing model. A firm’s
sensitivity to the market may change. Usually β is estimated based on
more recent data (e.g., 3-5 years).
Recall the formula for a firm’s weighted average cost of capital WACC is given
below (tc represents the firm’s marginal corporate tax rate).
VL − tC DL DL EL
WACCA
WACC = r ( = ) = (1 − t C ) rD + rE
VL VL VL
►When estimating WACC, use projected D/V in market values
►What would WACC be if the firm were unleveraged?
64
Valuation & After-Tax WACC Valuation
VL − tC DL DL EL
WACC= rA (
WACC =V ) = (1 − t C )
VL
rD +
VL
rE
L
As the debt ratio increases, we know that the cost of equity also
increases, due to the increasing financial risk borne by equity holders.
However, the WACC declines. The decline is due to the tax shields on
debt’s interest payments. Were it not for this tax deductibility, the WACC
would be constant and equal to the firm’s cost of capital when it is
unleveraged (denoted rA) at all debt ratios and VL would be equal to VU.
The WACC reflects the after-tax cost of debt. It is via this adjusted
discount rate that the value of interest tax shields are taken into account
under WACC Valuation. The increased firm value gained through interest
tax shields is reflected not through higher after-tax cash flows (we use
unleveraged FCFs in the numerator), but in a lower after-tax discount
rate. 65
Valuation & After-Tax WACC Valuation
rA
rA
WACC
rA (1 − tC ) rA (1 − tC ) WACC
rD rD
D and E are the market values of the firm’s debt and equity and V is
the total market value of the leveraged firm (V = D + E).
67
Un-leveraging & Re-leveraging Issues
• In estimating asset values we don’t always have the required component
estimates of expected return. For example, sometimes we have a firm’s
βE or rE and really want its βA or rA(as in the case of APV Valuation, to be
discussed).
68
Un-leveraging & Re-leveraging Issues
There are a number of ways to approach un-leveraging and re-leveraging.
1st: When working directly with the CAPM framework, then the focus of
un-leveraging and re-leveraging should be β.
2nd: There are slightly different formulas for un-leveraging and re-
leveraging depend on the underlying assumptions about the patterns of firm
cash flows and the discount rate used to discount the tax shields (depending on
debt policy) (all formulas derive from the relationship VL = VU + PV (Tax
Shields)). We will focus on one of these formulas
***Fortunately the results of the different formulas are not too different and
estimates essentially are driven by the measurement error in estimating β s and
risk premiums rather than in the method of un-leveraging and re-leveraging. 69
Un-leveraging and Re-leveraging Betas – when rebalance
debt ratio continuously at a constant level
We can use the structure of the CAPM to un-lever and re-lever equity beta
directly. Once the beta of equity at the new debt ratio is calculated, the new
cost of equity rE is determined by plugging the new βE into the CAPM.
WACC is then recalculated.
βA = βD(D/V) + βE(E/V)
75
APV Valuation: Basic Example
YR1: $10,000 Interest Payment*46% Tax Rate = 4,600
PV of the Annual Tax Shields: YR2: $8,362 Interest Payment*46% Tax Rate = 3,847
APV: Calculates value in parts: (i) the value of a firm as if it was all equity
financed (i.e., the value generated by a firm’s operating assets excluding any
financing effects), plus (ii) incremental value gained from leverage (value
gained from reduced tax outflow via the tax deductibility of interest), plus
(iii) any other value effects (other financing aspects, issuance costs, distress
costs, etc.). APV is ideal to use when the debt/equity ratio is not constant,
but the reduction in debt is systematic and/or predictable.
LBOs – Initially a heavy debt load, but debt/equity ratio falls over
time, as debt is repaid (both the cost of equity and the WACC change as
debts are paid!). The book value of the debt can be easily forecast
given a pre-specified financing payment schedule.
77
A Reminder About WACC DCF Valuation:
D E
WACC = (1 − Tc )rD + ( )rE
VL VL
• Thus the WACC valuation method is ideal to apply when a firm has a
constant target debt/equity ratio (in terms of market values) (and by target
we mean ‘aspirational’ , i.e., a D/E that the firm aims to maintain) and the
firm’s asset risk (i.e., project business risk profile) is also maintained.
78
Free Cash Flows to Equity – FCFE – Valuing
Equity Directly (often used for financing firms)
• Free cash flow available to equity holders (FCFE)
NI
𝐹𝐹𝐹𝐹𝐹𝐹𝐹𝐹
= 𝐸𝐸𝐸𝐸𝐸𝐸𝐸𝐸 − 𝐼𝐼𝐼𝐼𝐼𝐼 1 − 𝑡𝑡 + 𝐷𝐷𝐷𝐷𝐷𝐷 − 𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶 – Δ𝑁𝑁𝑁𝑁𝑁𝑁
+ 𝑁𝑁𝑁𝑁𝑁𝑁 𝐵𝐵𝐵𝐵𝐵𝐵𝐵𝐵𝐵𝐵𝐵𝐵𝐵𝐵𝐵𝐵𝐵𝐵
80
The 5 Major Categories of Ratios
1. Liquidity ratios (Short-Term Solvency) measure the firm’s
ability to pay bills in the short run.
• Can we make required payments as they fall due?
2023 2022
Cash 85,632 7,282
A/R 878,000 632,160
Inventories 1,716,480 1,287,360
Total CA 2,680,112 1,926,802
Gross FA 1,197,160 1,202,950
Less: Dep. 380,120 263,160
Net FA 817,040 939,790
Total Assets 3,497,152 2,866,592
83
Example: D’Leon’s Financial Statements
Balance Sheet: Liabilities and Stockholder’s Equity
2023 2022
Accts payable 436,800 524,160
Notes payable 300,000 636,808
Accruals 408,000 489,600
Total CL 1,144,800 1,650,568
Long-term debt 400,000 723,432
Common stock 1,721,176 460,000
Retained earnings 231,176 32,592
Total Equity 1,952,352 492,592
Total L & E 3,497,152 2,866,592
84
Example: D’Leon’s Financial Statements
Income Statement 2023 2022
Sales 7,035,600 6,034,000
COGS 5,875,992 5,528,000
Other expenses 550,000 519,988
EBITDA 609,608 (13,988)
Depr. & Amort. 116,960 116,960
EBIT 492,648 (130,948)
Interest Exp. 70,008 136,012
EBT 422,640 (266,960)
Taxes 169,056 (106,784)
253,584 (160,176)
Net income 85
Example: D’Leon’s Financial Statements
Additional Data
2023 2022
No. of shares
250,000 100,000
EPS
DPS $1.014 -$1.602
Stock price $0.220 $0.110
$12.17 $2.25
86
1. Liquidity Ratios
• Liquidity is the “ability to convert assets to cash quickly without a
significant loss in value.”
• Liquidity Ratios indicate a firm’s ability to meet its maturing short
term obligations.
• Is high liquidity always good? Kirk Kerkorian’s takeover bid for
Chrysler in April, 1995, is an example of investor dissatisfaction with
excess liquidity. At the time, Chrysler’s management had accumulated
$7.3 billion in cash and marketable securities as a cushion against an
economic downturn. Mr. Kerkorian instigated a takeover bid because
Chrysler’s management refused to pay this cash to stockholders.
87
D’Leon’s Current & Quick Ratios for 2023:
Current ratio = Current assets / Current liabilities
= $2,680 / $1,145 = 2.34x
89
2. Long-term Solvency
• Also known as financial leverage ratios. Financial leverage relates to the
extent that a firm relies on debt financing rather than equity. Generally, the more
debt a firm has, the more likely it is the firm will become unable to fulfill its
contractual obligations.
Total Debt Ratio = Total Debt / Total Assets
VARIATIONS:
Debt/Equity Ratio = (total assets – total equity) / total equity
Equity Multiplier = total assets/total equity
= 1 + debt/equity ratio
Long-Term Debt Ratio = long-term debt / (long-term debt + total equity)
COVERAGE RATIOS:
Times Interest Earned Ratio = EBIT / interest
Cash Coverage Ratio = (EBIT + depreciation) / interest
90
D’Leon’s Long-Term Solvency Ratios
Total Debt Ratio = Total debt / Total assets
= ($1,145 + $400) / $3,497
= 0.442 or 44.2%
Times Interest Earned = EBIT / Interest expense
= $492.6 / $70 = 7.0x
• At this point, D/A and TIE appear to be better than the industry
average.
91
3. Asset Management Ratios
• Also known as activity ratios, they measure how effectively
the firm’s assets are being managed:
• Inventory ratios measure how quickly inventory is
produced and sold
• Receivable ratios provide information on the success of
the firm in managing its collection from credit
customers
• Fixed asset and total asset turnover ratios show how
effective the firm is in using its assets to generate sales
92
D’Leon’s Inventory turnover for 2023:
Inventory Turnover = COGS / Inventory = $5,876/$1,716 = 3.42x
Days’ Sales in
106.7 days 84.9 days 80.9 days 75.7 days
Inventory
93
D’Leon’s Receivables Turnover for 2023:
Rec. turnover = Sales / Receivables = $7,036 / $878 = 8.01x
Receivables
8.01x 9.55x 9.76x 11.4x
Turnover
• Both ratios rebounded from the previous year, but are still below the
industry average. More improvement needed.
• Wide variations in ROE illustrate the effect that leverage can have on
profitability.
*If there is preferred dividend, you should deduct it from net income 98
Effects of Debt on ROA and ROE
• ROA is lowered by debt - interest expense lowers net income, which also
lowers ROA.
• However, the use of debt lowers equity, and if equity is lowered more than net
income, ROE would increase.
• ROE = NI / TE
• Multiply by TA/TA (= 1) and then rearrange
• ROE = (NI / TE) (TA / TA)
• ROE = (NI / TA) (TA / TE) = ROA * EM
• Multiply by (Sales/Sales) and then rearrange
• ROE = (NI / TA) (TA / TE) (Sales / Sales)
• ROE = (NI / Sales) (Sales / TA) (TA / TE)
• ROE = PM * TA TO * EM 101
The Three Ratios of the Dupont Identity
ROE = PM * TA TO * EM
1. Profit margin (PM) is a measure of the firm’s operating
efficiency – how well does it control costs
2. Total asset turnover (TA TO) is a measure of the firm’s
asset use efficiency – how well does it manage its assets
3. Equity multiplier (EM) is a measure of the firm’s
financial leverage
102
D’Leon’s Extended DuPont Equation:
Breaking down Return on Equity
ROE = (Profit margin) x (TA turnover) x (Equity multiplier)
= 3.6% x 2 x 1.8
= 13.0%
PM TA TO EM ROE
2021 2.6% 2.3 2.2 13.3%
2022 -2.7% 2.1 5.8 -32.5%
2023 3.6% 2.0 1.8 13.0%
Ind. 3.5% 2.6 2.0 18.2%
103
Ratio Analysis: Potential Problems/ Limitations
• Comparison with industry averages is difficult if the firm operates
many different divisions (a diversified firm).
• “Average” performance is not necessarily good. Use the leader’s?
• Seasonal factors can distort ratios.
• Window dressing techniques can make statements and ratios look
better.
• Different accounting and operating practices can distort comparisons.
• Sometimes it is difficult to tell if a ratio value is “good” or “bad.”
• Often, different ratios give different signals, so it is difficult to tell, on
balance, whether a company is in a strong or weak financial condition.
104
Some Qualitative Factors
Additional considerations when evaluating a company’s future
financial performance:
105