Fsav 5e - Errata 082718 PDF
Fsav 5e - Errata 082718 PDF
Fsav 5e - Errata 082718 PDF
13 13-1
Cash-Flow-Based Valuation 13-2
Glossary G-1
Index I-1
xiii
1st printing
Module 1 | Framework for Analysis and Valuation 1-30
mention that comparison to seasonally lagged earnings numbers provides a measure of earnings
momentum and growth, and therefore is a useful gauge of corporate performance.”
Thus, are earnings important? To the majority of finance chiefs surveyed, the answer is a resounding
yes. (Source: Graham, et al., Journal of Accounting and Economics, 2005)
As noted in the module, all publicly traded companies are required to file various reports with the SEC, two MBC
There is not an
Access
eLecture for this
of which are the 10-Q (quarterly financial statements) and the 10-K (annual financial statements). Following is a reports
Appendix.filed
brief tutorial to access these electronic filings. The SEC’s website is https://www.sec.gov/edgar/searchedgar/
with the SEC.
companysearch.html.
1st printing
2-55 Module 2 | Review of Business Activities and Financial Statements
Review 2-6—Solution
Balance Sheet Income Statement
Cash 1 Noncash 5 Liabil- 1 Contrib. 1 Earned Rev- 2 Expen- 5 Net
Assets Assets ities Capital Capital enues ses Income
3. Sell inventory costing $8,000 for $15,000 on credit. . . . . . . . . . . (8,000) 7,000 15,000 8,000 7,000
Inventory Revenue Cost of
15,000 goods sold
Accounts
receivable
7. Receive $300 cash in advance for future consulting services . . . 300 300
Unearned
revenue
8. Pay $50 cash for interest on long-term debt . . . . . . . . . . . . . . . . (50) (50) 50 (50)
Interest
expense
11. Perform consulting services for client who previously paid in 7 . . (300) 300 300
Unearned Revenue 300
revenue
Review 2-7—Solution
Balance Sheet Income Statement
Cash Noncash 5 Liabil- 1 Contrib. 1 Earned Rev- 2 Expen- 5 Net
Assets 1 Assets ities Capital Capital enues ses Income
Accounting Adjustments
13. Record depreciation of $600 . . . . . . . . . . . . . . . . . . . . . . . . . . . . (600) (600) 600 (600)
PPE Depreciation
expense
02_fsa5e_mod02.indd 55
1st printing
4/13/17 4:03 PM
3
M O D U L E
Profitability Analysis
and Interpretation
Analyst Playbook
Guided
LO Learning Objective | Topics Page eLecture Example Assignments
3–1 Compute and interpret return on equity (ROE). 3-3 e3–1 Review 3-1 1, 6, 18, 22, 26,
ROE Definition :: ROE Computation :: ROE Interpretation 30, 39, 40, 41,
47, 53, 54, 59,
60, 62
3–2 Apply DuPont disaggregation of ROE into return on assets 3-4 e3–2 Review 3-2 2, 5, 19, 26, 30,
(ROA) and financial leverage. (FL). 39, 41, 47, 59, 60
ROE Disaggregation :: Return on Assets :: Financial Leverage
3–3 Disaggregate ROA into profitability and productivity and 3-6 e3–3 Review 3-3 16, 19, 26, 30,
analyze both. 31, 32, 39, 47,
ROA Disaggregation :: Profitability :: Productivity :: Financial 59, 60, 66, 67, 68
Leverage (FL)
3–4 Identify balance sheet operating items and compute net 3-14 e3–4 Review 3-4 9, 20, 24, 46, 50,
operating assets. 53, 55, 56, 64
Operating Focus on Balance Sheet :: RNOA Motivation :: NOA
Computation
3–5 Identify income statement operating items and compute net 3-20 e3–5 Review 3-5 7, 8, 21, 25, 29,
operating profit after tax. 33, 45, 46, 50,
Operating Focus on Income Statement :: Operating vs 53, 55, 56, 64
Nonoperating :: NOPAT Computation :: Income Tax Expense
3–6 Compute and interpret return on net operating assets (RNOA). 3-24 e3–6 Review 3-6 6, 22, 23, 27, 34,
RNOA Computation :: ROA vs. RNOA :: ROA components :: Key 35, 36, 37, 38,
Definitions 40, 41, 46, 50,
53, 55, 56, 61,
62, 64
3–7 Disaggregate RNOA into net operating profitability and net 3-26 e3–7 Review 3-7 3, 4, 10, 11, 15,
operating asset turnover. 22, 23, 27, 29,
RNOA Disaggregation :: Net Operating Profit Margin :: Net 36, 37, 38, 40,
Operating Asset Turnover :: Trade-Off of Margin and Turnover 46, 50, 53, 55,
56, 58, 61, 62, 64
3–8 Compute and interpret nonoperating return (Appendix 3A). 3-31 e3–8 Review 3-8 1, 46, 49, 52, 54,
Nonoperating Return Components :: Under Various Conditions 55, 56, 57, 64
3–9 Compute and interpret measures of liquidity and solvency 3-36 e3–9 Review 3-9 28, 42, 43, 44,
(Appendix 3B). 48, 51, 63, 65
Liquidity :: Solvency :: Vertical & Horizontal Analysis
1st printing
03_fsa5e_mod03.indd 1 4/13/17 6:05 PM
3-3 Module 3 | Profitability Analysis and Interpretation
O R G A N I Z AT I O N
MODULE
ROE relates net income to the average total stockholders’ equity from the balance sheet. ROE
measures return from the perspective of the company’s stockholders. ROE is an important metric
and, in the five years from 2011–2015, return on equity of the S&P 500 firms has ranged from
14% to 15%. Exhibit 3.1 includes Intel’s income statement and balance sheet data used to com-
pute its ROE for 2015 of 19.53%.
ROE is a summary return metric that measures the return the company has earned on the book
(reported) value of the shareholders’ investment. It is one measure of how effective management
has been in its role as stewards of the capital invested by shareholders. In our analysis of company
performance, we seek to uncover the drivers of ROE and how those drivers have trended over
time so that we are better able to predict future performance.
1
ROE uses net income, in the numerator, that represents profit earned during the year. Therefore, the denominator would
ideally reflect equity that the company had throughout the year. As an approximation, we use a simple average of the
balance sheet values for equity at the start and end of the year to reflect equity during the year.
1st printing
03_fsa5e_mod03.indd 3 4/13/17 6:05 PM
Module 3 | Profitability Analysis and Interpretation 3-4
R EVIEW 3- 1 L O 1 ide
dEx amp
l
Gu
MBC
es
Following are selected income statement and balance sheet data for Cisco Systems Inc.
Required
Compute return on equity (ROE) for Cisco Systems for fiscal 2015.
Solution on p. 3-66.
1st printing
03_fsa5e_mod03.indd 4 4/13/17 6:05 PM
3-5 Module 3 | Profitability Analysis and Interpretation
Most operating managers understand the income statement and the focus on profit. However,
many of the same managers fail to manage the balance sheet (the denominator in ROA). ROA
analysis encourages managers to focus on the profit achieved from the invested capital under
their control. This means that managers seek to increase profits with the same level of assets and
to decrease assets without decreasing the level of profit. It is this dual focus that makes return
on assets a powerful performance measure—focusing managers’ attention on both the income
statement and balance sheet.
Intel’s net income is $11,420 million and its total assets are $103,065 million and $91,900
million at fiscal-year-end for 2015 and 2014, respectively (data from Exhibit 3.1). Intel’s 11.71%
return on assets is computed as follows.
$11, 420 million
ROA 5 5 11.71%
($103, 065 million + $91, 900 million) / 2
By comparison, the median return on assets of the S&P 500 companies for the same period was
5.2% and ranged from 5.2% to 6.2% for the 2011–2015 period.
• Preferred Stock. The ROE formula takes the perspective of the common stockholder in that it
relates the income available to pay common dividends to the average common stockholder. The
presence of preferred stock on the balance sheet requires two adjustments to ROE.
• Noncontrolling interests. Many companies have two sets of stockholders: those that own the
common stock of the parent company whose financial statements are under analysis (called
controlling interest) and those that own shares in one or more of the parent company’s subsid-
iaries (called noncontrolling interest). Companies separately identify the stockholders’ equity
relating to each group and, likewise, net income attributable to each. ROE is computed from
the perspective of the controlling (parent company) stockholders and, thus, the numerator is net
income attributable to parent company’s stockholders and the denominator is equity attribut-
able to parent company’s stockholders. We explain controlling and noncontrolling interest in a
later module and ROE computations with noncontrolling interests in Appendix 3A.
Measuring financial leverage is important because debt is a contractual obligation and a com-
pany’s failure to repay principal or interest can result in legal repercussions or even bankruptcy.
03_fsa5e_mod03.indd 5
1st printing
4/13/17 6:05 PM
Module 3 | Profitability Analysis and Interpretation 3-6
As
Asfinancial leverage
financial (FL) increases so does the level of debt payments, which all else equal, increases
leverage
the probability of default and possible bankruptcy. For fiscal 2015, Intel’s financial leverage is
1.67, computed as:
Financial leverage (FL) 5
($103, 065 million 1 $91, 900 million) / 2
Financial leverage 5 1.67
($61, 085 million 1 $55, 865 million) / 2
financial leverage
By comparison, the median financial (FL) of the S&P 500 companies for the same period was
leverage
2.74 and ranged from 2.4 to 2.7 for the 2011–2015 period.
R EVIEW 3- 2 L O 2 ide
dEx amp
l
Gu
MBC
es
Refer to the financial information for Cisco Systems reported in Review 3-1.
Required
Compute return on assets (ROA) and financial leverage following DuPont disaggregation of ROE for fiscal
FL = ROE.
2015. Confirm that ROA 3 Financial leverage 5 ROE.
Solution on p. 3-66.
Profit 3 Asset
Margin Turnover
(PM) (AT)
Return on
assets (ROA)
Return on assets is the product of profit margin and utilization of assets in generating sales (asset
turnover). This is the insight that DuPont analysis offers as it focuses managers’ attention on both
profitability and management of the balance sheet. The two drivers of return on assets are:
■■ Profit margin (PM). PM is what the company earns on each sales dollar; a company
increases profit margin by increasing its gross profit margin (Gross profit/Sales) and/or
reducing its operating expenses as a percent of sales.
■■ Asset turnover (AT). AT is the sales level generated from each dollar invested in assets; a
company increases asset turnover (productivity) by increasing sales volume with no increase
in assets and/or by reducing assets invested without reducing sales.
The goal is to increase the productivity of the company’s assets in generating sales and then to
bring as much of each sales dollar to the bottom line (net income). Managers usually understand
product pricing, management of production costs, and control of overhead costs. Fewer manag-
ers understand the role of the balance sheet. The ROA approach to performance measurement
encourages managers to focus on returns achieved from assets under their control, and ROA is
maximized with a joint focus on both profitability and productivity.
“Statutory tax rate” in the adjusted ROA formula is the federal statutory tax rate plus the state tax rate net of any
federal tax benefits; we use the assumed 37% federal and state tax rates as explained in the NOPAT computa-
tion later in this module. This adjusted numerator better reflects the company’s operating profit as it measures
return on assets exclusive of financing costs (independent of the capital structure decision).
5 5
Net income $11,420
Return on assets (ROA) Average total assets ($103,065 + $91,900)/ 2 11.71%
3 3
Average total assets ($103,065 + $91,900) / 2
Financial leverage (FL) Average stockholders’ equity ($61,085 + $55,865) / 2 1.67
5 5
Net income $11,420
Return on equity (ROE) Average stockholders’ equity 19.53%
($61,085 + $55,865)/ 2
1st printing
03_fsa5e_mod03.indd 7 4/13/17 6:05 PM
Module 3 | Profitability Analysis and Interpretation 3-12
■■ Divestiture of production facilities with agreements to purchase finished goods from the
facilities’ new owners.
■■ Sale and leaseback of administrative buildings.
Each of these activities is a strategic and financial event, often requiring integration within the
supply chain, new financing, and relationship building. As such, improvements in PPE turnover
can be difficult to achieve. If properly structured, however, they can markedly increase asset
returns and cash flow.
10%
8%
6%
4%
2%
0%
y
ry
gy
re
ls
ls
es
es
og
le
ria
ia
na
ca
ic
iti
er
ap
ol
er
rv
til
st
En
io
lth
hn
at
St
U
du
Se
t
ea
re
M
c
er
In
Te
sc
n
H
m
io
Di
n
su
at
io
er
ic
on
at
m
un
rm
C
su
m
fo
on
om
In
C
ecl
Te
1st printing
03_fsa5e_mod03.indd 12 4/13/17 6:05 PM
3-13 Module 3 | Profitability Analysis and Interpretation
As for all ratios, analysis of financial leverage ratios must consider ratios over time and
comparisons with peers. Appropriate financial leverage varies across industries because differ-
ent business models generate cash flow streams that differ in amount and variability over time.
Generally, business models that generate high and stable levels of cash flow can support a higher
level of debt.
The median total liabilities-to-equity ratio for all publicly traded companies in 2015 was 0.71,
indicating that companies typically borrow money, but have more equity than borrowed money in
their capital structures. Financial leverage ratios differ by industry and company size. The median
financial leverage ratio for the S&P 500 companies, for example, was 2.74 in 2015 and ranged
from 2.4 to 2.7 over the 2011–2015 period.
Exhibit 3.4 shows a summary of ratios used in the DuPont disaggregation of return on equity.
continued
1st printing
3-31 Module 3 | Profitability Analysis and Interpretation
where Spread is the difference between return on net operating assets and the after-tax cost of debt, net of any
after-tax returns on nonoperating assets such as investments in marketable securities.
This means return on equity can be disaggregated as:
Exhibit 3A.1 provides definitions for each of the terms required in this computation.
In most cases, nonoperating return is positive and it increases ROE. However, there are a number of other situations
where the company’s nonoperating activities are more complex. And in some situations, the nonoperating return is
negative (as for Intel). In this section, we illustrate four specific situations and demonstrate how to directly compute
nonoperating return in each case.
*Financial leverage (FLEV) is defined here differently than the financial leverage (FL) used in the DuPont
analysis, despite the same name.
1st printing
03_fsa5e_mod03.indd 31 4/13/17 6:05 PM
Module 3 | Profitability Analysis and Interpretation 3-42
the financials apart into their component businesses and separately analyze each component. Fortunately, companies
must report financial information (albeit limited) for major business segments in their 10-Ks.
Fuzzy View Ratios reduce, to a single number, the myriad complexities of a company’s operations. No scalar
can accurately capture all qualitative aspects of a company. Ratios cannot meaningfully convey a company’s
marketing and management philosophies, its human resource activities, its financing activities, its strategic initia-
tives, and its product management. In our analysis we must learn to look through the numbers and ratios to better
understand the operational factors that drive financial results. Successful analysis seeks to gain insight into what a
company is really about and what the future portends. Our overriding purpose in analysis is to understand the past
and present to better predict the future. Computing and examining ratios is one step in that process.
dEx amp
ide l
R EVIEW 3- 9 L O 9
Gu
MBC
es
Use the income statement and balance sheet for Cisco Systems Inc. from Reviews 3-4 and 3-5.
Required
a. Compute and interpret measures of liquidity for fiscal 2015 and 2014.
b. Compute and interpret liabilities-to-equity ratio for fiscal 2015 and 2014. Compute times interest earned
for 2015. (Note: The times interest earned ratio uses interest expense, gross, which is what Cisco Systems
reports separately on its income statement.)
Solution on p. 3-68.
GUIDANCE ANSWERS
You Are the CEO Pg. 3-27 Your company is performing substantially better than its competitors. Namely, your
RNOA of 16% is markedly superior to competitors’ RNOA of 10%. However, RNOA disaggregation shows that
this is mainly attributed to your NOAT of 0.89 versus competitors’ NOAT of 0.59. Your NOPM of 18% is essentially
identical to competitors’ NOPM of 17%. Accordingly, you will want to maintain your NOAT as further improvements
are probably difficult to achieve. Importantly, you are likely to achieve the greatest benefit with efforts at improving
your NOPM of 18%, which is only marginally better than the industry norm of 17%.
QUESTIONS
Q3-1. Explain in general terms the concept of return on investment. Why is this concept important in the
analysis of financial performance?
Q3-2. (a) Explain how an increase in financial
A
leverage
financial leverage (FL)can
can increase a company’s ROE. (b) Given the poten-
tially positive relation between financial
financialleverage
leverage
(FL) and
and ROE, why don’t we see companies with 100%
financial leverage (entirely nonowner financed)?
Q3-3. Gross profit margin (Gross profit/Sales) is an important determinant of NOPAT. Identify two factors
that can cause gross profit margin to decline. Is a reduction in the gross profit margin always bad news?
Explain.
Q3-4. When might a reduction in operating expenses as a percentage of sales denote a short-term gain at the
cost of long-term performance?
Q3-5. Describe the concept of asset turnover. What does the concept mean and why is it so important to
understanding and interpreting financial performance?
Q3-6. Explain what it means when a company’s ROE exceeds its RNOA. What about when the reverse occurs?
Q3-7. Discontinued operations are typically viewed as a nonoperating activity in the analysis of the balance
sheet and the income statement. What is the rationale for this treatment?
Q3-8. Describe what is meant by the “tax shield.”
Q3-9. What is meant by the term “net” in net operating assets (NOA)?
Q3-10. Why is it important to disaggregate RNOA into net operating profit margin (NOPM) and net operating
assets turnover (NOAT)?
1st printing
03_fsa5e_mod03.indd 42 4/13/17 6:05 PM
3-43 Module 3 | Profitability Analysis and Interpretation
Q3-11. What insights do we gain from the graphical relation between profit margin and asset turnover?
Q3-12. Explain the concept of liquidity and why it is crucial to company survival.
Q3-13. Identify at least two factors that limit the usefulness of ratio analysis.
Q3-14. Define (1) net nonoperating obligations and (2) net nonoperating expense.
Q3-15. What is the chief difference between the traditional DuPont disaggregation of ROE and the disaggre-
gation based on RNOA?
Q3-16. What is meant by the term cash conversion cycle?
Q3-17. What insights can be gained from a common-sized income statement or balance sheet?
mework
Ho
MINI EXERCISES
Sales������������������������������������������������������������������������������������������������������ 88,519
Net operating profit before tax (NOPBT)������������������������������������������������ 11,774
Nonoperating expense before tax���������������������������������������������������������� 753
Tax expense ������������������������������������������������������������������������������������������ 4,012
Net income �������������������������������������������������������������������������������������������� 7,009
MBC
LO5 M3-21. Compute Net Operating Profit after Tax
HOME DEPOT Refer to the income statement information for Home Depot, from M3-18.
(HD)
mework Compute net operating profit after tax for the year ended January 31, 2016. Assume a statutory tax rate
Ho
of 37%.
MBC
1st printing
03_fsa5e_mod03.indd 43 4/13/17 6:06 PM
Module 3 | Profitability Analysis and Interpretation 3-54
Assets
Cash and cash equivalents�������������������������������������������������� $ 129,852 $ 593,175
Accounts receivable, net������������������������������������������������������ 433,638 279,835
Inventories���������������������������������������������������������������������������� 783,031 536,714
Prepaid expenses and other current assets������������������������ 152,242 87,177
Deferred income taxes �������������������������������������������������������� — 52,498
Total current assets�������������������������������������������������������������� 1,498,763 1,549,399
Property and equipment, net������������������������������������������������ 538,531 305,564
Goodwill ������������������������������������������������������������������������������ 585,181 123,256
Intangible assets, net ���������������������������������������������������������� 75,686 26,230
Deferred income taxes �������������������������������������������������������� 92,157 33,570
Other long-term assets�������������������������������������������������������� 78,582 57,064
Total assets�������������������������������������������������������������������������� $2,868,900 $2,095,083
Stockholders’ equity
Additional paid-in capital������������������������������������������������������ 636,630 508,350
Retained earnings���������������������������������������������������������������� 1,076,533 856,687
Accumulated other comprehensive loss������������������������������ (45,013) (14,808)
Total stockholders’ equity���������������������������������������������������� 1,668,222 1,350,300
Total liabilities and stockholders’ equity������������������������������ $2,868,900 $2,095,083
Required
a. Compute return on equity (ROE).
b. Apply the DuPont disaggregation into return on assets (ROA) and financial leverage.(FL).
c. Calculate the profitability and productivity components of ROA.
d. Confirm the ROA from part a. above with the full DuPont disaggregation: ROE = PM 3 AT 3 FL.
P3-48. Analysis and Interpretation of Liquidity and Solvency LO9
Refer to the financial information of 3M Company in P3-46 to answer the following requirements. 3M COMPANY
(MMM)
Required
a. Compute the current ratio and quick ratio for 2015 and 2014. Comment on any observed trends.
b. Compute times interest earned and liabilities-to-equity ratios for 2015 and 2014. Comment on any
noticeable changes.
c. Summarize your findings about the company’s liquidity and solvency. Do you have any concerns
about its ability to meet its debt obligations?
P3-49. Direct Computation of Nonoperating Return LO8
Refer to the financial information of 3M Company in P3-46 to answer the following requirements. 3M COMPANY
(MMM)
Required
a. Compute its financial leverage (FLEV), Spread, and noncontrolling interest (NCI) ratio for 2015.
Recall that NNE 5 NOPAT 2 Net income.
b. Assume that its return on equity (ROE) for 2015 is 38.95% and its return on net operating assets
(RNOA) is 26.58%. Confirm computations to yield the relation: ROE 5 [RNOA 1 (FLEV 3 Spread)]
3 NCI ratio.
c. What do your computations of the nonoperating return imply about the company’s use of borrowed funds?
1st printing
03_fsa5e_mod03.indd 54 4/13/17 6:06 PM
Module 3 | Profitability Analysis and Interpretation 3-66
$8,981
ROE
ROA=5 5 15.44%
($59,698 1 $56,654) / 2
ROA 5
$8,981
5 8.22% Financial leverage
Financial (FL) 5 ($113, 481 1 $105, 070) / 2 5 1.878
leverage
($113,4811 $105,070) / 2 ($59,698 + $56,654) / 2
8.22% 3 1.878 5 15.44% 5 ROE
Review 3-4—Solution
a.
$ millions July 25, 2015 July 26, 2014
1st printing
Reformulations for the 2013 through 2015 income statements follow (assume a 30% tax rate):
We could have computed our balance sheet average using any number of possible years. The key is that we assess the cred-
ibility of the valuation allowance and adjust it if necessary. We could also use the income statement method to determine the
average percent for 2013 through 2015 as follows.
We would then use this percent and employ similar adjustments as applied above. The key here is deciding which ratio, balance
sheet or the income statement, better reflects actual economic conditions.
dEx amp
ide l
REVIEW 5- 5 L O 5
Gu
MBC
es
AT&T Corporation reported the following information on its December 31, 2015, balance sheet.
Footnotes to the financial statements reported, “Credit risks are assessed based on historical write-offs, net
of recoveries, as well as an analysis of the aged accounts receivable balances with allowances generally
increasing as the receivable ages.”
Assume the company analyzed and aged its accounts receivable at December 31, 2015, and developed
the following table.
AT&T’s allowance for doubtful accounts had a balance of $454 million at January 1, 2015. Assume that dur-
ing the year, the company wrote off accounts receivable totaling $1,166 million. This exceeded the balance
in the account at the start of the year. In its 2015 Form 10-K filing, the company explained that the write-
offs were higher than expected due to acquisitions of DIRECTV and wireless properties in Mexico in 2015.
continued
1st printing
Footnotes to the company’s 10-K provide the following additional information relating to its allowance
for doubtful accounts.
For the Fiscal Years Ended October 31 ($ millions) 2015 2014 2013
a. What is the gross amount of accounts receivables for Hewlett-Packard in fiscal 2015 and 2014?
b. What is the percentage of the allowance for doubtful accounts to gross accounts receivable for 2015
and 2014?
c. What amount of bad debts expense did Hewlett-Packard report each year 2013 through 2015 (ignore
increase in allowance from acquisitions)? How does bad debts expense compare with the amounts of
its accounts receivable actually written off? (Identify the amounts, and explain.)
d. Explain the changes in the allowance for doubtful accounts from 2013 through 2015. Does it appear
that Hewlett-Packard increased or decreased its allowance for doubtful accounts in any particular year
beyond what seems reasonable?
LO5 E5-44. Estimating Bad Debts Expense and Reporting Receivables
At December 31, Barber Company had a balance of $420,000 in its accounts receivable and an unused bal-
ance of $2,600 in its allowance for uncollectible accounts. The company then aged its accounts as follows.
Current . . . . . . . . . . . . . . . . . . . . . . . . . $346,000
1–60 days past due . . . . . . . . . . . . . . . 48,000
61–180 days past due . . . . . . . . . . . . . 17,000
Over 180 days past due . . . . . . . . . . . 9,000
Total accounts receivable . . . . . . . . . . $420,000
The company has experienced losses as follows: 1% of current balances, 5% of balances 1–60 days past
due, 15% of balances 61–180 days past due, and 40% of balances over 180 days past due. The company
continues to base its allowance for uncollectible accounts on this aging analysis and percentages.
a. What amount of bad debts expense does Barber report on its income statement for the year?
b. Show how Barber’s December 31 balance sheet will report the accounts receivable and the allowance
for uncollectible accounts.
LO5 E5-45. Estimating Uncollectible Accounts and Reporting Receivables over Multiple Periods
Weiss Company, which has been in business for three years, makes all of its sales on credit and does not
offer cash discounts. Its credit sales, customer collections, and write-offs of uncollectible accounts for its
first three years follow.
a. Weiss recognizes bad debts expense as 1% of sales. (Hint: This means the allowance account is in-
creased by 1% of credit sales regardless of any write-offs and unused balances.) What does Weiss’
2013 balance sheet report for accounts receivable and the allowance for uncollectible accounts? What
2016
total amount of bad debts expense appears on Weiss’ income statement for each of the three years?
1st printing
Review 5-2—Solution
1. “Additions” represents the amount of returns allowances recorded during fiscal 2015 for sales during that year.
2. “Returns, net” is the dollar value of actual returns offset by the value of the merchandise returned. The actual returns
number is very close to the amount estimated. This indicates that Nordstrom is fairly accurate in its estimation process.
3. a. Sales returns/gross sales shows an increasing pattern. The ratio is up from 13.3%
13.4% two years ago to 16.1%
16.2% in
the most current year. This could indicate that customer satisfaction with products is decreasing. However,
Nordstrom’s business model focuses on customer satisfaction, and the fact that its margin is very high (35% in
2015) puts the increase in perspective—it is not alarming, but should be monitored.
Review 5-3—Solution
1. Some customers have very low credit scores and by allowing them to prepay for their wireless services, AT&T in-
creases revenue without the risk of increasing the bad debt expense. Other customers may want a temporary phone
while visiting the United States. Still other customers may not want a long-term contract because of uncertainty in
their usage. For a variety of reasons, a prepaid wireless service makes economic sense for AT&T. Indeed, the com-
pany collected nearly $5 billion in revenue from this product line in 2015.
2. The amount of cash received from the customers is the amount added to the liability.
Cash prepayments by customers during the year 5 $4,682 1 $4,662 2 $4,105 5 $5,239
3. The gift card is booked as a liability when sold, then AT&T would use historical analysis to age the gift cards. For
example, the analysis might reveal that by the time a gift card is one year old, there is a 75% chance it will be re-
deemed, so AT&T would recognize 25% of the value of these cards as revenue (100% 2 75%) leaving 75% of the
value of the gift card in the liability account. When a gift card is two years old, analysis reveals there is only a 5%
chance it will be redeemed, and AT&T would recognize another 70% of the revenue, leaving 5% of the value of the
gift card still in the liability account.
1st printing
Inventory (in $000s) . . . During fiscal 2016, 2015 and 2014, a reduction in inventories related to
working capital initiatives resulted in the liquidation of applicable LIFO inventory quantities carried
at lower costs in prior years. This LIFO liquidation resulted in a $60,653, $38,867 and $13,894 cost
of revenues decrease, with a corresponding reduction to the adjustment to LIFO for fiscal 2016,
fiscal 2015 and fiscal 2014, respectively.
Rite Aid reports that reductions in inventory quantities in 2016 led to the sale (at current selling
prices) of inventory that had a low balance sheet value—the inventory was valued using costs
from prior years when those costs were much lower. As a result of these inventory reductions,
COGS was lower, which increased income by $60,653 thousand in 2016. Fiscal years 2015 and
2014 were similarly affected.
The Company’s Retail Pharmacy USA segment inventory is accounted for using the last-in-first-out (“LIFO”)
method. At August 31, 2016 and 2015, Retail Pharmacy USA segment inventories would have been greater by
$2.8 billion and $2.5 billion, respectively, if they had been valued on a lower of first-in-first-out (“FIFO”) cost or
market basis.
Walgreens Boots only uses LIFO for its US inventory because IFRS (the accounting rules used in all of the
other countries where Walgreens Boots operates) prohibits use of LIFO.1 To perform a financial analysis of
the company, we must first reformulate certain balance sheet and income statement items using the LIFO
reserve. By accessing each prior years’ 10-K, we can obtain the LIFO reserve for as many additional years
as we believe are useful for our analysis. For our example here, we analyze Walgreens Boots for two years,
which requires we obtain the LIFO reserve for three years as follows.
To convert LIFO numbers to FIFO on the balance sheet and income statement, recall two equations:
FIFO Inventory 5 LIFO Inventory 1 LIFO Reserve
FIFO COGS 5= LIFO
LIFO COGS
COGS 2 Increase in LIFO Reserve (or 1 Decrease)
Using these two equations we reformulate the following key numbers.
1
urther neither IRS nor GAAP requires use of a single inventory costing method. Companies are allowed to, and frequently do, use different
F
inventory methods for different types of inventory (such as spare parts versus finished goods) or inventory in different geographical locations.
2
Recall: Cost of Goods Sold 5 Beginning Inventories 1 Purchases 2 Ending Inventories. Thus, as ending inventories decrease, cost of goods
sold increases.
continued
1st printing
06_fsa5e_mod06.indd 11 4/13/17 4:19 PM
Module 10 | Analyzing Leases, Pensions, and Taxes 10-48
1st printing
A B C D
EXERCISES
Answer the following requirements assuming a discount rate (WACC) of 6%, a terminal period growth rate of 1%,
acommon
. Estimate theoutstanding
shares value of a of
share of million,
318.3 Whole Foods’
and net common stock
nonoperating using the(NNO)
obligations residual operating
of $242 income
million.
(ROPI) model
a. Estimate as of
the value of September 25, 2016.
a share of Whole Foods’ common stock using the residual operating income (ROPI) model as
b. of
Whole Foods25,
September stock closed at $30.96 on November 18, 2016, the date the 10-K was filed with the SEC.
2016.
How does
b. Whole Foodsyour valuation
stock closed atestimate compare
$30.96 on Novemberwith18,this closing
2016, price?
the date Whatwas
the 10-K do you
filedbelieve
with theare some
SEC. How does
reasons for theestimate
your valuation difference?
compare with this closing price? What do you believe are some reasons for the difference?
LO2 E14-19. Estimating Share Value Using the ROPI Model
WALMART Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA)
STORES INC.
(WMT)
as of January 31, 2016, for Walmart Stores Inc.
mework
Ho
MBC Reported
Horizon Period
Terminal
$ millions 2016 2017 2018 2019 2020 Period
a Answer the following requirements assuming a discount rate (WACC) of 7%, a terminal period growth rate of 1%,
. Estimate the value of a share of Walmart common stock using the residual operating income (ROPI)
common shares outstanding of 3,144 million, net nonoperating obligations (NNO) of $41,329 million, and
model as of January 31, 2016.
noncontrolling interest (NCI) on the balance sheet of $3,065 million.
b. Walmart (WMT) stock closed at $68.80 on March 30, 2016, the date the 10-K was filed with the SEC.
a. Estimate the value of a share of Walmart common stock using the residual operating income (ROPI)
How does your valuation estimate compare with this closing price? What do you believe are some
model as of January 31, 2016.
reasons for the difference?
b. Walmart (WMT) stock closed at $68.80 on March 30, 2016, the date the 10-K was filed with the SEC.
How does your valuation estimate compare with this closing price? What do you believe are some
reasons for the difference?
1st printing
Assets
Current assets
Cash and cash equivalents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 7,631 $ 6,877
Investments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58,125 53,539
Accounts receivable, net of allowance for doubtful accounts of
$249 at July 30, 2016 and $302 at July 25, 2015 . . . . . . . . . . . . . . . . . 5,847 5,344
Inventories . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,217 1,627
Financing receivables, net . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4,272 4,491
Other current assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,627 1,490
Total current assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78,719 73,368
Property and equipment, net . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3,506 3,332
Financing receivables, net . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4,158 3,858
Goodwill . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26,625 24,469
Purchased intangible assets, net . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2,501 2,376
Deferred tax assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4,299 4,454
Other assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,844 1,516
Total assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $121,652 $113,373
Required
a. Compute net operating assets (NOA) for 2016.
b. Compute net operating profit after tax (NOPAT) for 2016, assuming a federal and state statutory tax rate of 37%.
c. Use the parsimonious forecast method, as shown in the Analysis Insight box and illustrated in Exhibit 14.2,
to forecast Cisco’s sales, NOPAT, and NOA for 2017 through 2020 and the terminal period using the above
assumptions. continued
1st printing
NIKE INC.
Consolidated Income Statement
May 31, May 31,
For Year Ended ($ millions) 2016 2015
1st printing
NIKE INC.
Consolidated Balance Sheets
May 31, May 31,
$ millions 2016 2015
Current assets
Cash and equivalents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 3,138 $ 3,852
Short-term investments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2,319 2,072
Accounts receivable, net . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3,241 3,358
Inventories . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4,838 4,337
Prepaid expenses and other current assets . . . . . . . . . . . . . . . . . . . . . . . . . 1,489 1,968
Total current assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15,025 15,587
Property, plant and equipment, net . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3,520 3,011
Identifiable intangible assets, net . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 281 281
Goodwill . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131 131
Deferred income taxes and other assets . . . . . . . . . . . . . . . . . . . . . . . . . . . 2,439 2,587
Total assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $21,396 $21,597
Current liabilities
Current portion of long-term debt . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 44 $ 107
Notes payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 74
Accounts payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2,191 2,131
Accrued liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3,037 3,949
Income taxes payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 71
Total current liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5,358 6,332
Long-term debt . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2,010 1,079
Deferred income taxes and other liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . 1,770 1,479
Total liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9,138 8,890
Shareholders’ equity
Class A convertible common stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 0 0
Class B common stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 3
Capital in excess of stated value . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7,786 6,773
Accumulated other comprehensive income . . . . . . . . . . . . . . . . . . . . . . . . . 318 1,246
Retained earnings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4,151 4,685
Total shareholders’ equity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12,258 12,707
Total liabilities and shareholders’ equity . . . . . . . . . . . . . . . . . . . . . . . . . . . . $21,396 $21,597
Required
Required
a. Compute
a. Estimatenet
theoperating
value of aassetsshare(NOA)of Nikeand common stock usingobligations
net nonoperating the residual operating
(NNO) income
for 2016. Note(ROPI)
that themodel
company’s NNO is
as of May
negative 31, 2016.
because cashFor simplicity,
exceeds debt. prepare your forecasts in $ millions. Use the following assumptions:
b. Compute net operating profit after tax (NOPAT) for 2016 assuming a federal and state statutory tax rate of 37%.
c. Use the parsimonious
Sales forecast method, as shown in the Analysis
growth . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6% Insight box and illustrated in Exhibit 14.2, to forecast sales,
Net operating
NOPAT, and NOA profit
formargin (NOPM) . . . . . . . . . . . . .
2017 through 2020 using the following 2016 ratios rounded to three decimal places
assumptions.
Sales
Net operating growth
asset . . . . .(NOAT),
turnover . . . . . . . . year-end . . . . .
. . . . . . . . . . . . . . . . . . 2016 ratios
6% rounded to three decimal places
Net operating profit margin (NOPM) . . . . . . . . . . . . . 2016 ratios rounded to three decimal places
Net operating asset turnover (NOAT), year-end . . . . . 2016 ratios rounded to three decimal places
b. Forecast
Nike’s stock closed at
the terminal $56.99
period on assuming
value July 21, 2016, the date the
a 1% terminal Form
period 10-Kand
growth was filedthe
using with the SEC.
NOPM How assumptions
and NOAT
does your valuation estimate compare with this closing price? What do you believe are some reasons
above.
for the difference?
d. Estimate the value ofWhat investment
a share decision stock
of Nike’s common is suggested
using thefrom youroperating
residual results? income (ROPI) model as of May 31, 2016;
assume a discount rate (WACC) of 6.3% and common shares outstanding of 1,682 million.
e. Nike’s stock closed at $56.99 on July 21, 2016, the date the Form 10-K was filed with the SEC. How does your valuation
estimate compare with this closing price? What do you believe are some reasons for the difference? What investment decision
is suggested from your results?
1st printing
a. Forecast the terminal period values assuming a 1% terminal period growth for all three model inputs, that is Sales,
Required
NOPAT, and NOA.
a. Estimate
b. Estimatethe
thevalue
valueofofa ashare
shareofofColgate-Palmolive
Colgate-Palmolive common
common stock
stock using
using the the residual
residual operating
operating income
income (ROPI model);
(ROPI)a model.
assume discount rate (WACC) of 7.5%, common shares outstanding of 893 million, net nonoperating obligations
b. (NNO)
Colgate-Palmolive stockand
of $5,601 million, closed at $67.22 interest
noncontrolling on February
(NCI) 18,
from2016, the date
the balance the of
sheet Form
$25510-K was filed
million.
with the SEC. Howstock
c. Colgate-Palmolive’s doesclosed
your valuation estimate
at $67.22 on compare
February with
18, 2016, thethis
dateclosing
the Form price?
10-KWhat do you
was filed be-
with the SEC. How
lieveyour
does are valuation
some reasons
estimatefor the difference?
compare What
with this investment
closing decision
price? What do you is believe
suggested are from
some your results?
reasons for the difference?
What investment decision is suggested from your results?
1st printing