FSAV 6e - Errata 041323
FSAV 6e - Errata 041323
FSAV 6e - Errata 041323
Required
a. Prepare the income statement for the year ended April 30, 2018.
b. Prepare the balance sheet as of April 30, 2018.
c. Prepare the statement of cash flows for the year ended April 30, 2018.
d. Compute ROA.
e. Compute profit margin (PM).
f. Compute asset turnover (AT).
g. Compute ROE.
LO6 P1-47. Using Historical Numbers to Forecast Financial Statement Items
ABBOTT Abbott Laboratories reports the following revenue for fiscal years 2006 through 2019.
LABORATORIES
INC (ABT)
Year Revenue in $ millions Year Revenue in $ millions
2006�������� $22,476 2013�������� $21,848
2007�������� 25,914 2014�������� 20,247
2008�������� 29,528 2015�������� 20,405
2009�������� 30,765 2016�������� 20,853
2010�������� 35,167 2017�������� 27,390
2011�������� 38,851 2018�������� 30,578
2012�������� 39,874 2019�������� 31,904
Required
a. Calculate year-over-year change in Revenue for 2005 2007 through 2019.
b. Assume that an analyst uses the most current year’s revenue growth to forecast next year’s revenue.
Use that method to forecast 2012 revenue for Abbott Labs.
c. Assume that an analyst uses the average of the prior five years’ revenue growth to forecast next year’s
revenue. Use that method to forecast 2012 revenue for Abbott Labs.
d. Compare the forecasts from part b and part c, above. Which method provided the better forecast?
e. Consider revenue growth in 2013. Suggest two reasons for what we observe.
f. In 2016, Abbott Labs announced that it would acquire another pharmaceutical company in 2017. How
would this affect an analyst’s forecast of 2017 revenue?
LO3 P1-48. Formulating a Statement of Stockholders’ Equity from Raw Data
WINNEBAGO Winnebago Industries Inc. reports the following selected information for its fiscal year ended August
INDUSTRIES 25, 2018 ($ thousands).
INC. (WGO)
mework
Ho
Contributed capital, August 26, 2017 ��������������������������������������������������������������������� $ 106,289
MBC Treasury stock, August 26, 2017����������������������������������������������������������������������������� (342,730)
Retained earnings, August 26, 2017����������������������������������������������������������������������� 679,138
Accumulated other comprehensive (loss) income, August 26, 2017����������������������� (1,023)
Required
Use this information to prepare the statement of stockholders’ equity for Winnebago’s fiscal year ended
August 25, 2018.
LO5 P1-49. Computing, Analyzing, and Interpreting Return on Equity and Return on Assets
LOGITECH Following are summary financial statement data for Logitech International for 2016 through 2018.
INTER-
NATIONAL
(LOGI) $ thousands 2018 2017 2016
Ho
mework Sales���������������������������� $2,566,863 $2,221,427 $2,018,100
MBC Net income ������������������ 208,542 205,876 119,317
Total assets������������������ 1,743,157 1,498,677 1,324,147
Equity���������������������������� 1,050,557 856,111 759,948
Required
a. Compute the return on assets (ROA) for 2018 and 2017.
b. Compute the profit margin (PM) for 2018 and 2017.
c. Compute the asset turnover (AT) for 2018 and 2017.
Review
Review 1-5---Solution
1-4—Solution
a. $ millions
Review 1-6—Solution
a. Analysts might be concerned by the significant drop in other non-operating income from 3 billion KRW to 1.5
billion KRW. Questions would include: What sort of items are included in other non-operating income? What
happened during the year to cause the drop? Is the item expected to return to 2017 levels?
b. We forecast the financial statements in the following order: income statement, balance sheet, and statement of
cash flow.
c. We forecast revenue first because it affects many other income statement accounts and various balance sheet
accounts as well.
d. Cost of sales is directly related to revenue, the expense is the cost of the revenue earned and the two items gener-
ally move in tandem.
e. Accounts receivable on the balance sheet is directly related to revenue. Inventory is directly related to cost of
sales on the income statement.
Review 1-7—Solution
a. Beyond Meat has potential for tremendous growth and the market values that. More and more people are adopt-
ing a plant-based diet and retailers that have added Beyond Burgers and Impossible Burgers to their menus have
struggled to meet demand. Analysts and investors are counting future revenue, profits, and cash flow and are
willing to pay now for those future rewards.
b. The contract announced in September likely had no effect on current year GAAP revenue or profits. But inves-
tors understand that future revenue and profits will be positively impacted and, thus, increase their valuation of
the company, which increases its stock price.
c. The future cash flow is more certain for Huntington Ingalls because a five-year government contract is legally
enforceable and the future amounts are known, whereas hoped-for future retail burger sales could come in lower
or higher than expected.
Balance Sheet, June 30, 2017 Income Statement, For Year Ended June 30, 2018
Assets Revenues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $110,360
Cash ��������������������������������������� $ 7,663 Expenses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93,789
Noncash assets����������������������� 242,649 Net income . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 16,571
Total assets����������������������������� $250,312
Liabilities and equity Statement of Cash Flows, For Year Ended June 30, 2018
Total liabilities ������������������������� $162,601
Equity Operating cash flows����������������������������������������������� $43,884
Contributed capital������������������� 69,315 Investing cash flows ���������������������������������������������� (6,061)
Retained earnings������������������� 17,769 Financing cash flows���������������������������������������������� (33,540)
Other stockholders’ equity������� 627
Net change in cash������������������������������������������������ 4,283
Liabilities and equity ��������������� $250,312 Cash balance, June 30, 2017�������������������������������� 7,663
Cash balance, June 30, 2018��������������������������������� $11,946
Notes: 1 $1,908.
. Stock issuances for the year are $1,098. 4. Change in other stockholders’ equity for the year is $(2,814).
2. Dividends for the year are $12,917. 5. Total assets at June 30, 2018 are $258,848.
3. Other decreases in retained earnings are $7,741.
Solution on p. 2-55.
Ratio Definition
ROE: Return on equity ������������������������������������� Net income attributable to controlling interest/Average equity
attributable to controlling interest
NOA: Net operating assets������������������������������� Operating assets − Operating liabilities
NOPBT: Net operating profit before tax��������������� Revenue − Operating expenses including COGS
NNE: Net nonoperating expense after tax ����� Pretax net nonoperating expense × (1 − Tax%)
NOPAT: Net operating profit after tax ����������������� NOPBT − Tax on operating profit
Or: Net income + NNE
RNOA: Return on net operating assets������������� NOPAT / Average NOA
Return on equity for Home Depot over the three-year period ended February 3, 2019, follows.
Return on equity (ROE) for 2019: $10,866 / [($1,454 − $1,878)/2]������������������������������� (5,125.5)% 298.3% 149.4%
Return on assets (ROA) for 2019: $10,866 / [($44,003 + $44,529)/2]��������������������������� 24.5% 19.7% 18.7%
Financial leverage (FL) for 2019: [($44,003 + $44,529)/2] / [($1,454 − $1,878)/2]����������� (208.8) 15.1 8.0
Return on equity is a negative 5,125.5%, a ratio that is uninterpretable. It certainly does not imply
that the company is reporting losses of $51.25 for every dollar of equity. The negative ratio is caused
by Home Depot’s negative stockholders’ equity owing to large levels of treasury stock. This also
causes the ROE in prior years to be high, when treasury stock reduced stockholders’ equity to a
small number and inflated the ROE ratio. An outsized treasury stock account is not unique to Home
Depot. In recent years many firms have returned value to shareholders via stock repurchases (buy-
backs). This has created an analysis challenge: interpreting negative and massive ratios.
As discussed in Analyst Adjustments 3.1, one way to handle this analysis challenge is to add
back the treasury stock balance to both equity and total assets. Under this approach the ROE for
Home Depot over the three-year period ended February 3, 2019, follows.
Restated ROE for 2019: $10,866 / [($1,454 − $1,878 + $58,196 + $48,196)/2] ���������������������������������������������������� 20.5% 18.3% 18.9%
Restated ROA for 2019: $10,866 / [($44,003 + $44,529 + $58,196 + $48,196)/2] ������������������������������������������������ 11.1% 9.8% 10.1%
Restated FL for 2019: [($44,003 + $44,529 + $58,196 + $48,196)/2] / [($1,454 − $1,878 + $58,196 + $48,196)/2] ���� 1.84 1.87 1.88
ROE is in the 20% range over all three years, increasing slightly in 2019 as ROA improved from
9.8% to 11.1%. We conclude that the company’s profitability is strong and sustained. The com-
pany’s financial leverage is holding steady and is below 2.0, which is a reasonable level for a
company such as Home Depot. We return to the issue of leverage below.
Expanded ROE Disaggregation A second method of ROE disaggregation distinguishes
between operating and nonoperating returns. (See Module 3 for additional details.) Operating
return, as measured by return on net operating assets (RNOA) is an aggregate measure of the
return from Home Depot’s main operating activities and is a comprehensive profitability measure
that is not affected by the company’s leverage or treasury stock activity. We use the reported bal-
ance sheet numbers and the adjusted 52-week income statement numbers to further disaggregate
RNOA into profitability and productivity components as follows.
For the year ended February 3, 2019, Home Depot’s statement of cash flows (not included here)
reported cash from operations of $13,038 million for the 53-week fiscal year. We compute the
52-week operating cash flow as: $13,038 million × 53/52
52/53 = $12,792 million. Home Depot’s cash
from operations to total debt ratio was 0.44 in 2019, computed as $12,792 million/($1,339 million
+ $1,056 million + $26,807 million). This ratio has held steady in the past several years shown
in the graphic that follows.
Free Operating Cash Flow to Total Debt Companies must replace tangible assets
each year to continue operations. Any excess operating cash flow after cash spent on capital
expenditures (CAPEX) is considered “free” cash flow in that the company is free to use the cash
for other purposes including debt repayments. Some creditors use the following free cash flow
measure as another coverage ratio.
The free operating cash flow to total debt ratio is argued to reflect a company’s ability to repay
debt from the cash flows remaining after CAPEX. For the year ended February 3, 2019, Home
Depot’s statement of cash flows reported cash spent for capital expenditures of $2,442 million,
which is the number reported on the statement of cash flows (we assume CAPEX is determined
annually and not on a weekly basis). Thus, its free operating cash flow to total debt ratio is 0.35
calculated as ($12,792 million − $2,442 million)/($1,339 million + $1,056 million + $26,807
million). This ratio held steady over the past four years, which is a sign that Home Depot is
managing its debt levels while growing and maintaining its historically strong operating cash
flow (see following graphic).
Liquidity Analysis
Liquidity refers to cash availability: how much cash a company has, and how much it can gener-
ate on short notice. In this section, we discuss several of the most common liquidity measures:
the current ratio, working capital, and the quick ratio.
Current Ratio Current assets are assets that a company expects to convert into cash within
the next operating cycle, which is typically a year. Current liabilities are those liabilities that
come due within the next year. An excess of current assets over current liabilities (Current assets
− Current liabilities), is known as net working capital or simply working capital. Positive working
capital implies more expected cash inflows than cash outflows in the short run. The current ratio
expresses working capital as a ratio and is computed as follows:
Current assets
Current ratio =
Current liabilities
Because of control transferring over time, revenue is recognized based on the extent of progress
towards completion of the performance obligation. . . We generally use the cost-to-cost measure of
progress for our contracts because it best depicts the transfer of control to the customer which occurs
as we incur costs on our contracts. Under the cost-to-cost measure of progress, the extent of progress
towards completion is measured based on the ratio of costs incurred to date, to the total estimated
costs at completion of the performance obligation. Revenues, including estimated fees or profits, are
recorded proportionally as costs are incurred.
To illustrate accounting for long-term contracts using the cost-to-cost approach, assume
Raytheon
Raytheon signs a $10 million contract to develop a prototype for a defense system. Bayer esti-esti-
mates construction will take two years and will cost $7,500,000. This means the contract yields
an expected gross profit of $2,500,000 over two years. The following table summarizes costs
incurred each year and the revenue Raytheon recognizes.
Percentage
Costs Incurred Complete Revenue Recognized
$4,500,000
= 60%
Year 1 . . . . . . . . . . . . . . . . . $4,500,000 $7,500,000 $10,000,000 × 60% = $6,000,000
$3,000,000
= 40%
Year 2 . . . . . . . . . . . . . . . . . $3,000,000 $7,500,000 $10,000,000 × 40% = $4,000,000
This table reveals Raytheon would report $6 million in revenue and $1.5 million ($6 million −
$4.5 million) in gross profit on the project in the first year; it would report $4 million in revenue
and $1 million ($4 million − $3 million) in gross profit in the second year.
The following template captures the recognition of revenue and expense over this two-year
period (M indicates millions).
revenue Accounts
Receivable
= Retained
Earnings
Revenue – = +6M 6M
REV
on partly 6M
completed
contract
COGS . . 3M
Cash . . . . . . . 3M
AR . . . . . 4M
Year 2: Rev . . . . . . . . 4M
Recognize AR
$4M rev- +4M +4M +4M
= – =
4M
Accounts Retained Revenue +4M
enue for Receivable Earnings
Rev
4M
completed
contract
Rev
100,000
Establish −2,900
allowance and −2,900 +−2,900 BDE . . . . 2,900
record bad
Allowance for
Uncollectible = Retained
Earnings
– Bad Debts =
Expense
−2,900
AU . . . . . . . 2,900
BDE
Accounts
debts expense 2,900
AU
2,900
The allowance for uncollectible accounts is subtracted from the gross accounts receivable,
and the net amount collectible is reported on the balance sheet.
Companies typically report the allowance for uncollectible accounts along with accounts receiv-
able as follows.
By setting up the allowance, the company has established a reserve, or a cushion, that it can use
to absorb credit losses as they occur. To see how this works, assume a customer who owes $500
files for bankruptcy. If the company determines the receivable is now uncollectible, it must write
off the receivable. This is absorbed by the allowance for uncollectible accounts as follows.
The write-off of the uncollectible account receivable results in the following balances at the end
of the period.
Part II
1 . Revenue = $3,000,000 × ($500,000/$2,500,000) = $600,000.
Gross profit = $600,000 − $500,000 = $100,000.
2. The cost of $500,000 exceeds the billing of $400,000, and the excess of $100,000 is reported as a current asset
(such as construction in progress).
Review 5-2—Solution
1. “Charged to costs and expenses” represents the amount of returns allowances recorded during fiscal 2018 for
sales during that year. This amount is included in Tiffany’s income statement for the fiscal year.
2. “Deductions” is the dollar value of actual returns offset by the value of the merchandise returned (that reduces
COGS by the same amount). The actual returns number is $10.1 million, which is close to the estimated amount
charged to costs and expenses of $12.6 million. This indicates that Tiffany & Co is fairly accurate in its estima-
tion process.
The sales return allowance is small at year end, compared to gross sales, likely because sales returns are made
quickly after the purchase so the balance outstanding at any time is small. In fact, the amount outstanding is
roughly equal to one day’s sales ($4,442.1/365 days = $12.2).The amount has been increasing over time but
is not of concern given its magnitude.
Charged to costs and expenses ��������������������������� $ 12.6 $ 7.5 $ 2.5
Gross sales����������������������������������������������������������� $4,454.7 $4,177.3 $4,004.3
The % of merchandise that Tiffany estimates will be returned has steadily increased over the three years, but
the amount is so low as to be immaterial. There is no cause for concern here.
c. Tiffany’s sales returns allowance seems a bit high considering the following ratio of actual to estimate.
Review 5-3—Solution
The amount of cash received from the customers is the amount added to the liability.
Cash prepayments by customers during the year = $32,720 + $55,078 − $26,656 = $61,142
FIFO equivalents. Once we convert CAT’s inventory and its total assets to FIFO (by adding the
LIFO reserve, as explained above), we find that the company holds 17% of total assets as inventory,
a greater difference than first noted.
Balance Sheet Adjustments for a LIFO Reserve In general, to adjust for LIFO
on the balance sheet, we must make three modifications and then recompute balance sheet totals
and subtotals (current assets, total assets, and total equity).
■ Increase inventories by the LIFO reserve.
■ Increase tax liabilities by the tax rate applied to the LIFO reserve.
■ Increase retained earnings for the difference.
As an example, to adjust CAT’s 2018 balance sheet, we would:
■ Increase inventories by $2,009 million.
■ Increase tax liabilities by $693 million (see our computation above).
on page 6-8).
■ Increase retained earnings by the difference of $1,316 million (computed as $2,009 million
− $693 million).
During 2018, the change in CAT’s LIFO reserve was $75 million ($2,009 million − $1,934
million). Had CAT always used FIFO, its 2018 COGS would have been $75 million lower (mean-
ing gross profit and pretax income would be $75 million higher), and the company would have paid
$16 million ($75 million × 21%) more in taxes. This does not make much difference either in dollar
or percentage terms for CAT in 2018 because the LIFO reserve increased only slightly during the
year. But in other years, and for other companies, the impact can be great.
LIFO Liquidations
When LIFO companies acquire inventory at different costs, they are required to account for
each cost level as a separate inventory pool or layer (for example, there are the $100 and $150
units in our Exhibit 6.3 illustration). When companies reduce inventory levels, older inventory
costs flow to the income statement. These older LIFO costs are often markedly lower than cur-
rent inventory costs, assuming an inflationary environment. The net effect is that the LIFO cost
of sales is lower than the equivalent FIFO cost of sales (the reverse of the typical situation). The
liquidation boosts gross profit as older, lower costs are matched against current selling prices
on the income statement.
The increase in gross profit resulting from a reduction of inventory quantities in the presence
of rising costs is called LIFO liquidation. The effect of LIFO liquidation is evident in the fol-
lowing footnote from Rite Aid’s 10-K for the fiscal year ended March 2, 2019 (which Rite Aid
labels fiscal 2019).
Inventory (in $000s) At March 2, 2019 and March 3, 2018, inventories were $604,444 and
$581,090, respectively, lower than the amounts that would have been reported using the first-in,
first-out (“FIFO”) cost flow assumption. . . During fiscal 2019, 2018 and 2017, a reduction in non-
pharmacy inventories resulted in the liquidation of applicable LIFO inventory quantities carried at
lower costs in prior years. This LIFO liquidation resulted in a $5,884, $2,707 and $2,375 cost of
revenues decrease, with a corresponding reduction to the adjustment to LIFO for fiscal 2019, fiscal
2018 and fiscal 2017, respectively.
Reversal
Employee termination costs (reversal of 2018 costs) . . . . . . . . . . . . . . . . . . . . . . . . . . −$459
Pretax income . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . +459
Tax expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . +101
Allocation
Wages expense (2018 costs allocated: $459/3 years) . . . . . . . . . . . . . . . . . . . . . . . . . +$153 +$153 +153
Pretax income . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . −153 −153 −153
Tax expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . −34 −34 −34
* No adjustment is required at current year-end because the year-end balance sheet reflects all prior and current year cost allocations.
†
The computation assumes that the severance occurs near year-end (assuming a mid-year severance would mean the current year numbers are cut
by one-half, and similarly for other fractions of a year).
The two tables below show our adjustments for the 2018 asset impairment charges. The adjustments increase
net income by $155 million in 2018 but decrease net income by $45 million in the prior four years. The total effect
from both termination and impairment charges for 2018 is to increase net income by $420 million ($239 million +
$181 million), which is about 4% of Pfizer’s 2018 net income.
Reversal
Asset impairment charges (reversal of 2018 costs) . . . . . . . . −$290
Pretax income . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . +290
Tax expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . +64
Allocation
Depreciation expense (2018 charge allocated: $290/5 years) +$58 +$58 +$58 +$58 +58
Pretax income . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . −58 −58 −58 −58 −58
Tax expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . −13 −13 −13 −13 −13
Total net income (reversal + allocation) . . . . . . . . . . . . . . . . . −$45 −$45 −$45 −$45 +$181
Accumulated depreciation (related to 2018 charge) . . . . . . . . +$58 +$116 +$174 +$232 No adjustment*
Deferred tax assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . −13 −25 −38 −51 No adjustment*
* No adjustment is required at current year-end because the year-end balance sheet reflects all prior and current year cost allocations.
†
The computation assumes that the write-down occurs near year-end (assuming a mid-year write-down would mean the current year numbers are
cut by one-half, and similarly for other fractions of a year).
continued
mework
Ho
MINI EXERCISES
M6-13. Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost LO1
Assume that Madden Company reports the following initial balance and subsequent purchase of inventory. Ho
mework
MBC
Inventory balance at beginning of year������������������������������������������� 1,300 units @ $150 each $195,000
Inventory purchased during the year����������������������������������������������� 1,700 units @ $180 each 306,000
Cost of goods available for sale during the year����������������������������� 3,000 units $501,000
Assume that 2,000 units are sold during the year. Compute the cost of goods sold for the year and the
inventory on the year-end balance sheet under the following inventory costing methods.
a. FIFO b. LIFO c. Average Cost
M6-14. Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost LO1
Wong Corporation reports the following beginning inventory and inventory purchases. Ho
mework
MBC
Inventory balance at beginning of year����������������������������������������������� 400 units @ $12 each $ 4,800
Inventory purchased during the year��������������������������������������������������� 700 units @ $14 each 9,800
Cost of goods available for sale during the year��������������������������������� 1,100 units $14,600
Wong sells 600 of its inventory units during the year. Compute the cost of goods sold for the year and the
inventory on the year-end balance sheet under the following inventory costing methods.
a. FIFO b. LIFO c. Average Cost
M6-15. Computing and Evaluating Inventory Turnover for Two Companies LO3
PriceSmart and Nordstrom report the following information in their respective January 2016 10-K PRICESMART
reports relating to their two most recent fiscal years. (PSMT)
JW
NORDSTROM
PriceSmart ($ thousands) Nordstrom ($ millions) (JWN)
mework
Ho
Cost of Cost of MBC
Sales Goods Sold Inventories Sales Goods Sold Inventories
a. Compute the 2018 inventory turnover for each of these two retailers.
b. Discuss any difference we observe in inventory turnover between these two companies. Does the dif-
ference confirm our expectations given their respective business models? Explain. (Hint: Nordstrom
is a higher-end retailer and PriceSmart operates no-frills, warehouse stores.)
c. Describe ways that a retailer can improve its inventory turnover.
M6-16. Adjusting Balance Sheet and Income Statement for LIFO to FIFO ANALYST ADJUSTMENTS 6.1 LO2
In its December 2019 10-K, LyondellBasell Industries reported the following information ($ millions). LYONDELL-
BASELL
INDUSTRIES
Cost of Goods LIFO Decrease in LIFO Total (LYB)
Sold Inventories Reserve Reserve Assets Net Income Ho
mework
Adjust the account balance for the following financial statement items assuming the company used FIFO
instead of LIFO for its inventory costing method. The company has a 22% tax rate.
a. Inventories b. Total assets c. Cost of goods sold d. Net income
M6-17. Computing Depreciation LO4
A delivery van costing $37,000 is expected to have a $2,900 salvage value at the end of its useful life of Ho
mework
five years. Assume that the truck was purchased on January 1. Compute the depreciation expense for the MBC
first two calendar years under the straight-line depreciation method.
c. Compute inventory turnover and days average inventory outstanding for 2018.
d. Based on the metrics in parts a, b, and c, how do we assess the two companies’ inventory management?
LO5, 6 I6-50. Estimating Useful Life, Percent Used Up, and Gain or Loss on Disposal
HUSKY ENERGY Husky Energy is one of Canada’s largest integrated energy companies. Based in Calgary, Alberta, Husky
(HSE) is publicly traded on the Toronto Stock Exchange. The Company operates in Western and Atlantic Can-
mework
Ho ada, the United States and the Asia Pacific Region with upstream and downstream business segments.
MBC The company uses IFRS to prepare its financial statements. During 2018, the company reported deprecia-
tion expense of $2,591 million. The property and equipment footnote follows.
Cost
December 31, 2017���������������������������������������������������������� $ 41,815 $ 86 $ 2,599 $ 9,191 $ 2,930 $ 56,621
Additions �������������������������������������������������������������������������� 2,465 12 62 744 151 3,434
Acquisitions���������������������������������������������������������������������� 64 — — 3 — 67
Transfers from exploration and evaluation ������������������������ 79 — — — — 79
Intersegment transfers������������������������������������������������������ — — — (5) —5 —
Changes in asset retirement obligations�������������������������� 43 2 (2) (5) 7 45
Disposals and derecognition�������������������������������������������� (632) — — (10) (1) (643)
Exchange adjustments������������������������������������������������������ 362 1 — 773 3 1,139
December 31, 2018���������������������������������������������������������� $ 44,196 $101 $ 2,659 $10,691 $ $3,095
3,090 $ 60,742
Required
a. Compute the average useful life of Husky Energy’s depreciable assets in 2018. Assume that land is
10% of “Refining.”
b. Estimate the percent used up of Husky Energy’s depreciable assets in 2018. How do we interpret this
figure?
c. Consider the disposals and derecognition during the year. This refers to assets that were sold and
removed from the balance sheet during 2018. Calculate the net book value of the total PPE disposed
during the year. Assume that Husky Energy received $4 million cash proceeds for the year. Determine
the gain or loss on the disposal.
Review 6-3—Solution
Review 6-4—Solution
1 . Straight-line depreciation expense = ($95,000 − $10,000)/5 years = $17,000 per year
2. The HD subsidiary reports equipment on its balance sheet at its net book value of $44,000.
Review 6-5—Solution
Part 1.
a. The equipment is impaired since the undiscounted expected cash flows of $40,000 are less than the $44,000 net
book value of the equipment. The HD subsidiary must write down the equipment to its fair value of $36,000.
The effect of this write-down is to reduce the net book value of the equipment by $8,000 ($44,000 − $36,000)
and recognize a loss in the income statement.
b. The HD subsidiary must report a gain on this sale of $6,000, computed as proceeds of $50,000 less the net book
value of the equipment of $44,000 (see Review 6-4, part 2).
Part 2.
a. Coca-Cola’s restructuring expense for 2018 is the increase in the restructuring liability of $508 million.
b. Coca-Cola reports a restructuring liability of $90 million on its 2018 balance sheet.
Review 6-6—Solution
$71,309 $68,619
PPE turnover������������������� = 3.7 = 3.5
$18,432 + $19,721 $19,721+ $19,949
a b a b
2 2
($18,052 + $18,052
$10,090 ++$18,521
$10,090+ $10,475) / 2 ($18,521
$18,521++$10,475
$10,475+ $18,147 + $10,978) / 2 = 18.9
Average useful life����������� $1,454 = 19.4 = 18.8
$1,540
$1,454 = 19.6 $1,540
$17,431
$17,431 $17,219 $17,219
Percent used up ������������� = 62% / 2 = 59% = 59%
($18,052 + $10,090 + $18,521 + $10,475)
$18,052 + $10,090 ($18,521
$18,521++$10,475
$10,475+ $18,147 + $10,978) / 2
= 61%
a. Amgen reports unrealized gains and losses on available-for-sale securities as part of AOCI. Which of
the following types of investments could be included in this account? Select all that apply.
i. Bonds issued by US corporations.
ii. Common stock traded on US stock exchange.
iii. Common stock traded on foreign stock exchange.
iv. Debt securities issued by a foreign government.
v. Municipal bonds.
vi. U.S. Treasury bills.
b. Consider the securities held in the available-for-sale portfolio at December 31, 2018. Which of the
following is true?
i. At December 31, 2018, the fair value of the securities was $338 million less than their amortized cost.
ii. At December 31, 2018, the fair value of the securities was $338 million greater than their amortized
cost.
iii. At December 31, 2018, the fair value of the securities was $338 million lower than their value at
December 31, 2017.
iv. At December 31, 2018, the fair value of the securities was $194 million lower than their value at
December 31, 2017
c. Consider the securities held in the available-for-sale portfolio at December 31, 2018. During the year,
by how much did the market value of those securities increase or decrease?
i. Decreased by $338 million.
ii. Decreased by $556 million.
iii. Increased by $556 million.
iv. Decreased by $191 million.
d. Amgen increased AOCI by $365 million for reclassification adjustments to income. Which of the
following best describes what this line item means?
i. During 2018, Amgen sold available-for-sale securities and realized a loss of $365 million.
ii. During 2018, Amgen sold available-for-sale securities and realized a gain of $365 million.
iii. During 2018, Amgen sold available-for-sale securities that had unrealized gains of $365 million at
December 31, 2017.
iv. During 2018, Amgen sold available-for-sale securities that had unrealized losses of $365 million at
December 31, 2017.
LO4 M9-15. Analyzing Derivatives and Hedging
AMGEN INC. Refer to the information for Amgen in M9-14. This information reports activity related to Amgen’s cash
(AMGN) flow hedges.
a. Explain how this type of hedging works. Provide an example of how Amgen might use this type of
hedging strategy.
b. How did the hedges affect net income for 2018?
c. If these same hedges had instead been fair value hedges, what amount would have been added to
AOCI for the year?
$203.9 mil-
$249.0 million. The net $117.5
disclosed includes cash advances to the joint venture partners of $335.4
lion represents the equity method investment.
c. Do you believe the liabilities of these joint venture entities represent actual obligations of General
Mills? Explain.
d . What potential problem(s) does equity method accounting present for analysis purposes?
LO3 P9-49. Financial Analysis for Equity Method Investments ANALYST ADJUSTMENTS 9.1
CUMMINS INC. Refer to the financial information for the equity method investments of Cummins in E9-36. Make the
(CMI) following assumptions about those data.
mework
Ho
• All assets are operating assets.
MBC
• All current liabilities are operating liabilities.
• Non-current liabilities are loans that bear interest at 8%.
• EMI (Equity Method Investments) investees’ tax rate is 22%.
The following information is derived from the 2018 form 10-K for Cummins Inc., the investor company.
$ millions 2018
Required
a. Compute net operating profit after tax (NOPAT) for the EMI investees.
b. Compute net operating assets (NOA) and net nonoperating obligations (NNO) for the EMI investees.
c. Following the process in Analyst Adjustments box 9.1, reformulate the following ratios for Cummins
for 2018. For simplicity only, use year-end balance sheet numbers provided instead of averages.
1. RNOA 3. NOAT 5. Financial leverage (FLEV)
2. NOPM 4. ROE
d. Does the equity method of accounting for these investments obscure the economic picture? Explain.
LO3 P9-50. Analyzing and Interpreting Disclosures on Consolidations
SNAP-ON Snap-on Incorporated consists of two business units: the manufacturing company (parent corporation)
INCORPORATED
(SNA)
and a wholly-owned finance subsidiary. These two units are consolidated in Snap-on’s 10-K report. Fol-
lowing is a supplemental disclosure Snap-on includes in its 10-K report that shows the separate balance
sheets of the parent and the subsidiary. This supplemental disclosure is not mandated under GAAP but is
voluntarily reported by Snap-on as useful information for investors and creditors. Using this disclosure,
answer the following questions.
Required
a. Do the parent and subsidiary companies each maintain their own financial statements? Explain. Why
does GAAP require consolidation instead of separate financial statements of individual companies?
b. What is the balance of Investments in Financial Services as of December 31, 2018, on the parent’s
balance sheet? What is the equity balance of the financial services subsidiary to which this relates as
of December 31, 2018? Do you see a relation? Will this relation always exist?
c. Refer to your answer for part a. How does the equity method of accounting for the investment in the
subsidiary obscure the actual financial condition of the parent company as compared with the con-
solidated financial statements?
d. Recall that the parent company uses the equity method of accounting for its investment in the sub-
sidiary and that this account is eliminated in the consolidation process. What is the relation between
consolidated net income and the net income of the parent company? Explain.
e. What is the implication for the consolidated balance sheet if the fair value of the financial services
subsidiary (subsequent to acquisition) is greater than the book value of its stockholders’ equity?
Total forecasted lease payments for operating leases are $8,664 million in FY2019. However,
Microsoft’s balance sheet includes liabilities of $7,703 million (current liability of $1,515 million
relating to payments to be made in the upcoming year and long-term liability of $6,188 million),
which is the present value of the forecasted lease payments discounted at 3.15%. Exhibit 10.1
illustrates the present value calculation. The Business Insight box below explains the discount
rate. (The 3.15% discount rate used in this example is consistent with the assumed payment
stream, an approach commonly used in practice. Microsoft’s actual discount rate is 3%, as dis-
closed in its 2019 10-K.)
The total operating lease liability of $7,703 million consists of a portion maturing in the next
year, which is reported as a current liability and the remainder, reported as a long-term liability, as
highlighted in Microsoft’s balance sheet above. The table above shows a current portion of $1,627
million, slightly higher than the $1,515 million Microsoft reports in its footnotes. The difference
arises because Microsoft uses a specific discount rate for each lease, whereas we use an average
of 3.15% for all leases.
B3 × ✓ fx =IRR(B2:J2,0.1)
A B C D E F G H I J
1 N 0 1 2 3 4 5 6 7 8
2 Amount (7,703) 1,678 1,438 1,235 1,036 839 839 839 760
3 IRR* 3.15%
4 =2,438
5 *Formula for cell B3 is =IRR(B2:J2,0.1), as shown in the formula bar at the top of the sheet
To adjust the financial statements, we note that cash contributions have no income statement effect (which is dif-
ferent from most other adjustments). Instead, the cash flow statement is impacted via operating cash flows and the
balance sheet is impacted via pension assets. Because cash contributions to pension plans are deductible for tax
purposes (whereas pension expense is recorded in the income statement) there is a deferred tax effect related to
the pension contribution adjustment. We assume a tax rate of 22% and adjust the financial statements as follows.
These other post-employment benefits can produce large liabilities. For example, Deere’s
footnotes report a funded status for the company’s healthcare obligation of $(4,753) million in
2018, consisting of an APBO liability of $5,472 million and OPEB plan assets of $719 million.
Our analysis of cash flows related to pension obligations can be extended to other post-employ-
ment benefit obligations. For example, in addition to its pension payments, Deere discloses that it
is obligated to make healthcare payments to retirees totaling about $320 million to $345 million
Net sales���������������������������������������������������������� $67,684 100.0% $67,684 × 1.035 $70,053 100.0% Use P&G’s guidance that sales will increase
about 3.5%. Sales forecast equals current
sales × (1 + growth rate %).
Cost of products sold���������������������������������������� 34,768 51.4% $70,053 × 51.4% 36,007 51.4% Assume COGS as % of sales will remain
unchanged from FY2019.
Selling, general, and administrative expense ���� 19,084 28.2% $70,053 × 28.2% 19,755 28.2% Assume SG&A as % of sales will remain
unchanged from FY2019.
Goodwill & indefinite lived intangibles The Goodwill impairment charge is a
impairment charges�������������������������������������� 8,345 12.3% none 0 transitory item and we eliminate that expense
in FY2020.
Operating income �������������������������������������������� 5,487 8.1% subtotal 14,291 20.4%
Interest expense ���������������������������������������������� 509 0.8% computed 483 0.7% Interest expense is discussed below.
Interest income ������������������������������������������������ 220 0.3% no change 220 0.3% Assume no change in interest revenue.
Other nonoperating income, net ���������������������� 871 1.3% none 0 0.0% FY2019 nonoperating income relates to
the dissolution of a partnership and early
extinguishment of debt, and we assume
none for FY2020 given no evidence of
planned divestitures or debt retirement.
Earnings from continuing operations before
income taxes������������������������������������������������ 6,069 9.0% subtotal 14,028 20.0%
Income taxes on continuing operations ������������ 2,103 3.1% $14,028
$14,014 × 17.5% 2,455 3.5% Assume effective tax rate of 17.5% per P&G
guidance.
Net earnings ���������������������������������������������������� 3,966 5.9% subtotal 11,573 16.5%
Less: Net earnings attributable to
noncontrolling interests �������������������������������� 69 0.1% $11,573
$11,562 × 1.7% 197 0.3% Assume noncontrolling interests as % of net
earnings (1.7%) continues.
Net earnings attributable to P&G���������������������� $ 3,897 5.8% subtotal $11,376 16.2%
million/$30,689 million). P&G begins the FY2020 year with $30,092 million ($9,697 million +
$20,395 million) of short-term and long-term debt and predicts contractual payments of $3,388
for FY2020, yielding an anticipated debt balance of $28,320
$26,704 for FY2020 ($30,092 − $3,388). For
the initial forecast, we assume no additional borrowing during the year (we relax that assump-
tion in Appendix 11B when we perform a multiyear forecast). Our forecast for FY2020 interest
expense is $483 million calculated as 1.7% × ($30,092 + $26,704)/2.
Income Tax Expense Income tax expense (labeled “Income taxes on continuing opera-
tions” by P&G) is often a large expense item. We estimate tax expense by applying an estimated
tax rate to pretax income. For FY2020, we use an effective tax rate of 17.5% as provided in PG’s
guidance. In the absence of company guidance, we can use disclosures in the income tax footnote
to get a tax rate estimate. Following is the effective tax rate disclosure in P&G’s FY2019 10-K.
The aim of reviewing the tax table in the footnotes is to determine the tax rate to use for our
forecasts. We look for any transitory items that affect the company’s tax rate and we exclude
such items in our forecast. In FY2019, for example, P&G’s effective tax rate increased by 22.8
percentage points due to the Goodwill impairment that reduced pre-tax profit without a conse-
quent reduction of income tax expense (Goodwill write-offs are generally not a tax-deductible
expense). Given that the Goodwill impairment is a one-time occurrence, we would forecast a tax
rate of 11.9% (34.7% effective tax rate less 22.8%). In addition, the line item labeled as “Other”
increased by 2 to 3 percentage points over the previous two years. Adding that amount, then,
results in an estimate of the effective tax rate that is close to the 17.5% rate in P&G’s guidance.
Impact of Acquisitions When one company acquires another, the revenues and expenses of the
acquired company are consolidated, but only from the date of acquisition onward (we discuss the
consolidation process in an earlier module). Acquisitions can greatly impact the acquirer’s income
statement, especially if the acquisition occurs toward the beginning of the acquirer’s fiscal year.
In FY2019 P&G did not have any material acquisitions. Therefore, we use P&G’s acquisition of
Gillette in October 2005 as an example. In its June 30, 2006, fiscal year-end income statement
(ending eight months following the acquisition), P&G reported the following for sales.
These net sales amounts include Gillette product sales from October 2005 onward (for fiscal
2006), and none of Gillette’s sales is reported in fiscal 2005 or fiscal 2004. P&G’s 2006 sales
growth of 20.2% ([$68,222 million/$56,741 million] − 1) was, therefore, not P&G’s organic
growth, and we would have been remiss in forecasting a 20.2% increase for fiscal 2007.
Importantly, until all three annual income statements in the 10-K include the acquired com-
pany, the acquirer is required to disclose what revenue and net income would have been had the
acquired company been consolidated for all three years reported in the current annual report. This
“what if” disclosure is called pro forma disclosure. Procter & Gamble’s pro forma disclosure in
the footnotes to its 2006 10-K includes the following discussion and table.
Current liabilities
Accounts payable . . . . . . . . . . . . . . . . . . . . . $ 11,260 16.6% $70,053 × 16.6% $ 11,629 16.6% Forecast working capital accounts as
Accrued and other liabilities . . . . . . . . . . . . . 9,054 13.4% $70,053 × 13.4% 9,387 13.4% % of sales unless information suggests
otherwise.
Debt due within one year . . . . . . . . . . . . . . . 9,697 14.3% ($3,388) + $2,009 8,318 16.1% Use footnotes to get current maturities
of long-term debt. Assume other debt
remains unchanged.
Total current liabilities . . . . . . . . . . . . . . . . . 30,011 44.3% subtotal 29,334 46.1%
Long-term debt . . . . . . . . . . . . . . . . . . . . . . . . 20,395 30.1% ($2,009) 18,386 24.3% Use footnotes to get current maturities
of long-term debt to be repaid.
Deferred income taxes . . . . . . . . . . . . . . . . . . 6,899 10.2% $70,053 × 10.2% 7,145 10.2% Assume no change as a % of sales.
Other noncurrent liabilities . . . . . . . . . . . . . . . . 10,211 15.1% $70,053 × 15.1% 10,578 15.1% Assume no change as a % of sales.
* $(1,561) = $110,084 − $6,048 − $5,114 − $5,184 − $2,312 − $21,995 − $40,273 − $23,856 − $6,863.
** To simplify, we forecast accounts as a percent of sales, including inventories and accounts payable. Analysts sometimes use a percent of COGS for inventory and for accounts payable
estimates because both are expressed in input (not output) costs. Either approach is reasonable if used consistently. One could also forecast working capital accounts using turnover
rates or days as follows:
Forecasted account balance = Forecasted revenues (or COGS)/Turnover rate, or = Forecasted days outstanding × [Forecasted revenues (or COGS)/365]
P&G’s 2019 statement of cash flows reports CAPEX of $3,347 million, which yields an historical
rate of 4.9% of sales ($3,347 million/$67,684 million). This is consistent with the 4.5% to 5%
range provided in P&G’s guidance.
Depreciation Expense. Depreciation expense is usually reported in the statement of cash flows
(or in the notes). (Note: If depreciation expense is combined with amortization expense, we can
isolate the depreciation component by subtracting amortization expense, which is frequently
reported separately in footnotes—or, if not separately reported, we may use the change in accu-
mulated amortization.) It is common to estimate depreciation as:
P&G’s 2019 statement of cash flows reports depreciation and amortization expense of $2,824
million. Footnotes report amortization expense in 2019 of $349 million. Thus, we calculate 2019
depreciation expense as $2,475 million ($2,824 million − $349 million). The PPE footnote reports
2018 PPE, gross of $41,487 million, and 2019 PPE, gross of $43,393 million. We calculate a
depreciation expense forecast assumption of 6.0% ($2,475 million expense/$41,487 million PPE,
gross) and an estimated 2020 depreciation expense of $2,604 million (6.0% × $43,393 million).
PPE, net. Drawing on the forecasted CAPEX and forecasted depreciation above, the PPE, net is
forecasted as:
ForecastedD =+Current
IV1 $2++ Forecasted
$41 - Forecasted
IVnet
PPE, 0 =
1
PPE, =net = $39.45 depreciation expense
CAPEX
1 + re 1.09
Forecasted 2020 PPE, net is $21,995 million, computed as $21,271 million + $3,328 million − $2,604
million.
Intangible Assets Intangible assets, other than goodwill, are typically forecasted to
decrease during the year by the amount of amortization (it is common to assume no change in
amortization expense). Forecasted = Current year - Forecasted
D1 assetsD 2 intangible
intangible D 3 assets amortization expense
IV0 = + + +…
1 + re (1 + re )2 (1 + re )3
Alternatively, the company might provide guidance. Footnotes to the P&G’s FY2019 Form 10-K
provide the following schedule of expected amortization expense that we use for its FY2020
forecast. We forecast that intangible assets will decrease by $359 million in FY2020.
Long-Term Debt (LTD) Companies report maturities of long-term debt for the next five
years in the long-term debt footnote. We use this disclosure to forecast long-term debt:
Forecasted LTD = Current year LTD − Current maturities of LTD
Footnotes to P&G’s FY2019 Form 10-K provide the following schedule of maturities of LTD that
we use in our forecasts.
P&G’s balance sheet does not separately report current maturities of long-term debt. Instead, the
current maturities amount is aggregated with other short-term debt and reported as “Debt due
within one year.” To forecast current maturities, we subtract $3,388 million from debt due within
one year to reflect the amount that matures and will be paid in FY2020. We then add $2,009 mil-
lion, the amount that comes due in FY2021. We subtract $2,009 million from long-term debt to
reflect the reclassification from long-term to current.
Retained Earnings We forecast retained earnings as follows.
Forecasted Current year Forecasted Forecasted
retained earnings = retained earnings + net income − dividends
any noncash expenses or revenues, and then recognizes the cash flow effect of changes in working capital followed
by changes in the remaining asset, liability, and equity items. A common method is to compute changes in each of
the line items on the forecasted balance sheet and then classify those changes to either the operating, investing, or
financing sections of the forecasted statement of cash flows.
Exhibit 11A.1 shows the forecasted statement of cash flows for Procter & Gamble. It reveals operating cash
flows of $15,427 million, investing cash outflows of $3,328 million, and a large financing cash outflow of $17,888
million.
Dividends�������������������������������������������������������������������� (7,500)
Increase in short-term debt����������������������������������������
Decrease (1,379)
Decrease in long-term debt���������������������������������������� (2,009)
Purchase of treasury shares�������������������������������������� (7,000)
Net cash from financing activities ������������������������������ (17,888)
The forecasted statement of cash flows highlights financing cash outflows as the main cause for the forecasted
decline in cash. While operating cash flows continue to be strong, P&G’s guidance includes plans to continue to
repurchase common stock (approximately $7,000 million), pay dividends (approximately $7,500 million), and
purchase CAPEX (approximately $3,328 million). In this first forecasting iteration, we forecast a decrease in cash
of $(5,789) million, which reduces P&G’s cash balance from $4,239 million to $(1,550) million. The drop in cash
arises due to the planned outflows for CAPEX, the payment of dividends, and the repurchase of stock with no
borrowings forecasted at this point. Such a low cash balance is not plausible. In Appendix 11B, we discuss how to
modify the forecasts to derive an appropriate cash balance.
Required
a. Compute net operating assets (NOA) for 2019.
b. Compute net operating profit after tax (NOPAT) for 2019, assuming a federal and state statutory tax
rate of 22%. Assume that all items on the 2019 income statement will persist.
c. Use the parsimonious forecast method, as shown in Analysis Insight box on page 13-5, to forecast Cisco’s
sales, NOPAT, and NOA for 2020 through 2023 and the terminal period using the following assumptions.
d. Estimate the value of a share of Cisco common stock using the discounted cash flow (DCF) model
as of July 27, 2019; assume a discount rate (WACC) of 7.6%, common shares outstanding of 5,029
million, and net nonoperating obligations (NNO) of $(8,747) million (NNO is negative, which means
that Cisco has net nonoperating investments).
e. Cisco stock closed at $48.42 on September 5, 2019, 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?
P13-15. Estimating Share Value Using the DCF Model LO2
Following are forecasted sales, NOPAT, and NOA for AT&T for 2019 through 2022.
AT&T INC. (T)
mework
Ho
Forecast Horizon Period
Reported MBC
$ millions 2018 2019 2020 2021 2022
The effective tax rate for 2018 was lower than the U.S. federal statutory rate of 21% primarily at-
tributable to internal restructuring initiatives that resulted in a reduction of accrued withholding taxes of
approximately $1.1 billion related to unremitted foreign earnings. In addition, we recorded a tax benefit
of approximately $440 million as a reduction to our 2017 provisional estimate of impacts from what is
commonly referred to as the U.S. Tax Cuts and Jobs Act.
The effective tax rate for 2017 was higher than the U.S. federal statutory rate of 35% primarily from
the estimated impacts of U.S. Tax Reform of approximately $3.8 billion, partially offset by lower tax
rates on non-U.S. earnings.
a. What adjustments, if any, should we consider before forecasting Honeywell’s 2020 income?
b. Adjust Honeywell’s effective tax rate for each of the three years to reflect persistent factors.
QUESTIONS
Q14-1. In general, what role do expectations play in pricing equity securities? What is the relation between
security prices and expected returns (the discount rate, or WACC, in this case)?
Q14-2. Define the weighted average cost of capital (WACC).
Q14-3. Define net operating profit after tax (NOPAT).
Q14-4. Define net operating assets (NOA).
Q14-5. Define the concept of residual operating income (ROPI). How is residual operating income used in
pricing equity securities?
Q14-6. What insight does disaggregation of RNOA into net operating profit margin and net operating asset
turnover provide for managing a company?
Q14-7. Explain what is meant by the phrase “steady state” when applied to equity valuation models.
Q14-8. What is one way to refine equity valuation models for companies that have not achieved steady state?
mework
Ho
MINI EXERCISES
LO1 M14-9. Interpreting Earnings Announcement Effects on Stock Prices
FACEBOOK On November 2, 2016, Facebook Inc. announced its 2016 third quarter results. Revenues were up nearly
INC. (FB) 50% from 2015 and earnings were up a whopping 180% ($5,944 million compared to $2,127 million).
Yet, in the ensuing days, Facebook’s stock value fell 7% according to CNBC. Why do you believe that
the company’s stock price fell despite the good news?
LO2 M14-10. Computing Residual Operating Income (ROPI)
HOME DEPOT Home Depot reports net operating profit after tax (NOPAT) of $12,073 million for the fiscal year ended
INC. (HD) February 3, 2019. Its net operating assets at the beginning of the fiscal year are $24,887 million. Assum-
mework
Ho ing a 7.85% weighted average cost of capital (WACC), what is Home Depot’s residual operating income
MBC for the fiscal year ended February 3, 2019? Show computations.
LO2 M14-11. Computing, Analyzing, and Interpreting Residual Operating Income (ROPI)
CISCO In its annual report for the fiscal year ended July 27, 2019, Cisco Systems reports net operating income
SYSTEMS after tax (NOPAT) of $11,346 million. As of the beginning of the fiscal year it reports net operating as-
(CSCO)
mework
sets of $22,225 million.
Ho
MBC a. Did Cisco earn positive residual operating income (ROPI) if its weighted average cost of capital
(WACC) is 7.6%? Explain.
b. At what level of WACC would Cisco not report positive residual operating income for the year?
Explain.
LO1, 2 M14-12. Estimating Share Value Using the ROPI Model
TARGET Following are forecasts of Target Corporation’s sales, net operating profit after tax (NOPAT), and net
CORPORATION operating assets (NOA) as of February 2, 2019, which we label fiscal year 2018.
(TGT)
mework
Ho
EXERCISES
LO2 E14-18. Estimating Share Value Using the ROPI Model
Following are forecasts of Illinois Tool Works Inc. sales, net operating profit after tax (NOPAT), and
ILLINOIS TOOL
WORKS INC. net operating assets (NOA) as of December 31, 2018.
(ITW)
mework
Ho Forecast Horizon Period
Reported Terminal
MBC
$ millions 2018 2019 2020 2021 2022 Period
Assets
Current assets
Cash and cash equivalents��������������������������������������������������������������� $ 1,778 $ 3,595
Receivables, net ������������������������������������������������������������������������������� 1,936 1,952
Merchandise inventories ������������������������������������������������������������������� 13,925 12,748
Other current assets ������������������������������������������������������������������������� 890 638
Total current assets����������������������������������������������������������������������� 18,529 18,933
Net property and equipment ����������������������������������������������������������������� 22,375 22,075
Goodwill������������������������������������������������������������������������������������������������� 2,252 2,275
Other assets ����������������������������������������������������������������������������������������� 847 1,246
Total assets ����������������������������������������������������������������������������������� $44,003 $44,529
continued
$ millions, except par value July 27, 2019 July 28, 2018
Required
a. Compute net operating assets (NOA) for 2019.
b. Compute net operating profit after tax (NOPAT) for 2019, assuming a federal and state statutory tax
rate of 22%. Assume that all items on the 2019 income statement will persist.
c. Use the parsimonious forecast method, as shown in the Analysis Insight box on page 14-5 and in Exhibit
14.2, to forecast Cisco’s sales, NOPAT, and NOA for 2020 through 2023 and the terminal period using the
following assumptions.
d. Estimate the value of a share of Cisco common stock using the residual operating income (ROPI)
model as of July 27, 2019.; assume a discount rate (WACC) of 7.6%, common shares outstanding of 5,029 million, and net nonoperating
e. Cisco stock closed at $48.42 on September 5, 2019, the date the Form 10-K was filed with the SEC. obligations (NNO) of
How does your valuation estimate compare with this closing price? What do you believe are some $(8,747) million (NNO is
negative, which means that
reasons for the difference? What investment decision is suggested from your results?
Cisco has net nonoperating
P14-27. Estimating Share Value Using the ROPI Model investments).
LO2
Following are forecasted sales, NOPAT, and NOA for AT&T for 2019 through 2022.
AT&T INC. (T)
mework
Ho
Forecast Horizon Period
Reported MBC
$ millions 2018 2019 2020 2021 2022
Required
a. Forecast the terminal period values for Sales, NOPAT, and NOA, assuming a 2% terminal period
growth rate.
Required
a. Compute net operating assets (NOA) and net nonoperating obligations (NNO) for 2019. The com-
pany’s NNO is negative because cash exceeds debt.
b. Compute net operating profit after tax (NOPAT) for 2019 assuming a federal and state statutory tax
rate of 22%.
c. Use the parsimonious forecast method, as shown in the Analysis Insight box on page 14-5 and
in Exhibit 14.2, to forecast sales, NOPAT, and NOA for 2020 through 2023 using the following
assumptions.
Sales growth����������������������������������������������������������� 8%
Net operating profit margin (NOPM)����������������������� 2019 ratios rounded to three decimal places
Net operating asset turnover (NOAT), year-end����� 2019 ratios rounded to three decimal places
Forecast the terminal period value assuming a 2% terminal period growth and using the NOPM and
NOAT assumptions above.
d. Estimate the value of a share of Nike common stock using the residual operating income (ROPI) model
; assume
as of May 31, 2019. For a discount
simplicity, rate (WACC)
prepare of 6.8% and
your forecasts in $common shares outstanding of 1,682 million. For simplicity, prepare your
millions.
e. Nike’s stock closed at $86.70 on July 23, 2019, the date the Form 10-K was filed with the SEC. How forecasts in $ millions.
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?
P14-29. Estimating Share Value Using the ROPI Model LO2, 3
Following are forecasted sales, NOPAT, and NOA for Colgate-Palmolive Company for 2019 through COLGATE-
2022. PALMOLIVE
COMPANY (CL)
mework
Ho
Forecast Horizon Period
Colgate Palmolive (CL) Reported MBC
$ millions 2018 2019 2020 2021 2022
Required
a. Forecast the terminal period values for Sales, NOPAT, and NOA, assuming a 1% terminal period
growth rate.
b. Estimate the value of a share of Colgate-Palmolive common stock using the residual operating income
(ROPI) model. Assume a discount rate (WACC) of 5.7%, common shares outstanding of 862.9 mil-
lion, net nonoperating obligations (NNO) of $5,640 million, and noncontrolling interest (NCI) from
the balance sheet of $299 million.
c. Colgate-Palmolive stock closed at $66.70 on February 21, 2019, the date the Form 10-K was filed
with the SEC. How does your valuation estimate compare with this closing price? What do you be-
lieve are some reasons for the difference? What investment decision is suggested from your results?
d. The forecasts assumed a terminal growth rate of 1%. If the terminal growth rate had been 2%, what
would the estimated stock price have been?
e. What would WACC need to be to warrant the actual stock price on February 21, 2019?
EXHIBIT 15.5 Estimating Intrinsic Value Using a Net Operating Profit after Tax Multiple
In millions, except per share amounts Dollar General Dollar Tree Big Lots
Company intrinsic value = Net operating profit after tax × NOPAT market multiple
$27,188 = $1,668 × 16.3
To obtain Dollar General’s equity intrinsic value we subtract from the company intrinsic value,
the net nonoperating obligations (in Exhibit 15.1) including the fair value of any preferred
stock outstanding ($0 for Dollar General). We then divide the equity intrinsic value by shares
outstanding to get the per share intrinsic value of its common equity.
Then,
Equity intrinsic value
Equity intrinsic value per share =
Common shares outstanding
$24, 559
$91.40 =
268.7 shares
This estimate suggests that Dollar General was overvalued with respect to its $115.04 closing
price at its fiscal year-end (and vis-à-vis its $117.47 price on the filing date).
In millions, except per share amounts Dollar General Dollar Tree Big Lots
We begin by computing the net income market multiple for both Dollar Tree and Big Lots, which
is computed as equity assumed value divided by net income available to common shareholders.
Exhibit 15.6 shows the results of this computation. Big Lots’ net income market multiple is
7.99, computed as $1,254 million/$157 million. Dollar Tree’s NI multiple is 20.26 computed as
$23,020 million/$1,136 million. We use the average of the two multiples, 14.13, as the NI market
multiple to estimate the equity intrinsic value of Dollar General as follows:
Equity intrinsic value = Net income × NI market multiple
$22,453 = $1,589 × 14.1
To obtain Dollar General’s equity intrinsic value per share we divide by shares outstanding as follows:
Equity intrinsic value
Equity intrinsic value per share =
Common shares outstanding
$22, 453
$83.56 =
268.7 shares
The $83.56 stock price estimate suggests that Dollar General stock was markedly overvalued based
on a $115.04 closing price at its fiscal year-end (and vis-à-vis its $117.47 price on the filing date).
It is again useful for us to compare estimates of Dollar General’s intrinsic value of equity using
the NOPAT multiple vis-à-vis the NI multiple. Using the NOPAT multiple, we estimated the intrinsic
value of a share of Dollar General to be $91.40, while the NI market multiple gave an estimate of
$83.56. How do we assess the quality of the different estimates? The estimate using the NOPAT
market multiple is likely better (for the same reasons that the NOA multiple was superior to the
BV multiple for balance sheet methods). That is, we did not select comparables with similar capital
structures. When selecting comparables, we should select firms that are similar on profitability,
growth, and risk. Although the comparables do control for operating risk, by choosing companies
in the same industry, we did not control for financial risk. Consequently, because financial risk
affects the equity value, but not the company value, we prefer the NOPAT multiple because they are
unaffected by a firm’s choice of capital structure. But, when using net income multiples to estimate
intrinsic value, it is important to select comparables with similar capital structures.
The estimates of equity value we have computed for Dollar General thus far using multiples
highlight the first issue we raised about the use of this method. The two methods based on net
operating assets and book value market multiples yielded more similar values of $71.49 and
$70.33 per share respectively. The two methods based on NOPAT and net income market mul-
tiples yielded less similar values of $91.40 and $83.56 per share respectively. Given the wide dis-
parity among the balance sheet and the income statement based estimates, we are faced with the
question: which performance measure is the right one? Again, this question has no answer. Often