BACC 681_Assignment W14 & 15
docx
School
University of the Cumberlands *
*We aren’t endorsed by this school
Course
681
Subject
Finance
Date
Apr 3, 2024
Type
docx
Pages
2
Uploaded by shrey2508
Title: Valuation of Walmart Common Stock using Residual Income Approach
Introduction
This assignment focuses on valuing Walmart's common stock using the Residual Income Valuation approach, incorporating the Free Cash Flow valuations from Integrative Case 12.1.
We will compare the estimated share values obtained from the Residual Income Valuation method with the Dividends Valuation approach.
Residual Income Valuation
Using the Residual Income Valuation approach, the estimated share values for Walmart at the
end of 2015 are as follows:
Year +1: $73.20
Year +2: $73.50
Year +3: $74.90
Year +4: $76.50
Year +5: $78.30
Reasonable Range of Share Values
Based on the Residual Income Valuation approach, a reasonable range of share values for Walmart common stock at the end of 2015 would be approximately $73.20 to $78.30.
Market Price and Investment Recommendation
At the end of 2015, the market price for Walmart shares was $67.50, which was below the estimated range from the Residual Income Valuation approach. This suggests that the stock was potentially undervalued at that time according to this valuation method.
Investment Recommendation:
Considering the Residual Income Valuation approach indicating potential undervaluation, investors may consider purchasing Walmart shares at a discount to their estimated intrinsic value. However, as with any investment decision, further research and analysis should be conducted, considering other factors such as industry trends, competitive landscape, and economic conditions.
Comparison with Dividends Valuation
Comparing the Residual Income Valuation with the Dividends Valuation approach:
The Dividends Valuation approach estimated Walmart's share value at $73.11 for Year +1, while the Residual Income Valuation approach estimated it at $73.20.
Both approaches provide similar estimated share values, indicating consistency in the valuation models used.
Conclusion
The Residual Income Valuation approach provides a reasonable range of share values for Walmart common stock at the end of 2015. The market price was lower than the estimated range, suggesting potential undervaluation. By incorporating different valuation methods, investors can gain a comprehensive understanding of Walmart's intrinsic value and make informed investment decisions.
References
Wahlen, J. M., Baginski, S. P., & Bradshaw, M. T. (2020). Financial Reporting, Financial Statement Analysis, and Valuation (9th ed.). Cengage Learning.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Estimating Share Value Using the ROPI Model
Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana.
Terminal
Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal place
Reported
Horizon period
$ millions 2018
2019 2020 2021
2022 Period
Sales
$56,880 $57,734 $58,600 $59,480 $60,372
2,492 2,542 2,580 2.619 2,658
4,000 4,065 4,126 4,189 4,252
NOPAT
NOA
$60,976
2,684
4,295
Answer the following requirements with the following assumptions:
Assumptions
Terminal period growth rate
Discount rate (WACC)
19
7.8%
Common shares outstanding
135.6 million
Net nonoperating obligations (NNO) S(6,161) million
NNO is negative because Humana's nonoperating assets exceed its nonoperating liabilities.
(a) Estimate the value of a share of common stock using the residual operating income (ROPI) model as of December 31,…
arrow_forward
Need correct answer general accounting question
arrow_forward
Consider the following price and dividend data for GS
Company:
Date
Price ($)Dividend ($)
December 31, 2008 $14.64
January 26, 2009 $13.35
$0.10
April 28, 2009
$9.14
$0.10
July 29, 2009
$10.74
$0.10
October 28, 2009 $8.02 $0.10
December 30, 2009 $7.72
Assume that you purchased GS Company stock at the closing
price on December 31, 2008 and sold it at the closing price on
December 30, 2009. What is your realized annual return for the
year 2009?
arrow_forward
SUBJECT FINANCIAL ACCOUNTING
arrow_forward
Please provide correct answer general accounting question
arrow_forward
Estimating Share Value Using the ROPI Model
The following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29, 2011. Refer to the information in the table to answer the following requirements.
Reported
Horizon Period
(In millions)
2011
2012
2013
2014
2015
Terminal Period
Sales
$ 3,469
$ 3,989
$ 4,587
$ 5,275
$ 6,066
$ 6,187
NOPAT
152
319
367
422
485
495
NOA
1,032
1,173
1,349
1,551
1,784
1,820
Answer the following requirements assuming a discount rate (WACC) of 10%, a terminal period growth rate of 2%, common shares outstanding of 87.2 million, and net nonoperating obligations (NNO) of $(858) million. (Negative NNO reflects net nonoperating assests such as investments rather than net obligations)(a) Estimate the value of a share of Abercrombie & Fitch common stock using the residual operating income (ROPI) model as of January 29, 2011.
Rounding instructions:
Round answers to…
arrow_forward
which of the below ratios can I use the attached file to calculate?
return on total assets
return on common stockholder's equity
dividend payout ratio
price-earnings ratio
arrow_forward
Please help me with all answers thanku
arrow_forward
Using ratios to evaluate a stock investment
Comparative financial statement data of Garfield Inc. follow:
Market price of Garfield’s common stock:$69.36 at December 31 2018 and $38.04 at December 31, 2017.
Common shares outstanding 14, 000 on December 31, 2018 and 12,000 on December 31 2017 and 2016.
All sales are on credit.
Requirements
Compute the following ratios tor 2018 and 2017:
a. current ratio
b. Cash ratio
c. Times-interest-earned ratio
d. Inventory turnover
e. Gross profit percentage
f. Debt to equity ratio
g. Rate of return on common stockholder’s equity
h. Earnings per share of common stock
i. Price/earnings ratio
2. Decide (a) whether Garfield’s ability to pat debts and to sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.
arrow_forward
Residual Income Valuation Method
Suppose that BKE has the following:
Year +1
Year +2
Year +3
Year +4
Year +5
Year +6
Common shareholders' equity at
beginning of year
$
4,223.13 $4,557.87 $ 4,683.21 $ 4,802.33 $
5,001.22 $ 5,503.76
Comprehensive income available
for common shareholders
1,668.76 $1,717.54 $ 1,902.22 $ 1,988.34 $
2,003.45
Their required rate of return is 9.25%
Their long run growth rate is 4.20%
They have 750 M shares of stock.
Market Based Valuation Methods
Suppose that BKE has the following:
BKE
Price
$
87.21
Number of shares (K)
64,575
Book value of equity K$
588,324
EPS
6.75
arrow_forward
You are given the following information:
Stockholder's Equity
Price/Earnings Ratio
Share Outstanding
Market/Book Ratio
$1,250
5
25
1.5
Calculate the market price of a share of the company's stock. Consider the summarized data from the
balance sheets and income statements of Wiper Inc. If Wiper's stock had a price/earnings ratio of 12 at
the end of 2020, what was the market price of the stock? Wiper Inc.
Condensed Balance Sheets
December 31, 2020, 2019, 2018 (in millions)
2020 2019 2018
Current assets $764 $981 $843
Other assets
Total assets
2,424 1,931 1,730
$3,188 $2,912 $2,573
Current liabilities
Long-term liabilities
Stockholders' equity
$588 $841 $734
1,582 1,034 910
1,018 1,037 929
Total liabilities and stockholders' equity $3,188 $2,912 $2,573
Wiper Inc.
Selected Income Statement and Other Data
For the year Ended December 31, 2020 and 2019 (in millions)
2020 2019
Income statement data:
Sales $3,061 $2,924
Operating income
307
321
Interest expense
95
76
Net income
224
219
Other…
arrow_forward
Estimating Share Value Using the DCF ModelAssume following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29, 2011.
Reported
Horizon Period
(In millions)
2011
2012
2013
2014
2015
Terminal Period
Sales
$ 3,750
$ 4,500
$ 5,400
$ 6,480
$ 7,776
$ 7,853
NOPAT
464
539
654
794
982
960
NOA
1,320
1,602
1,933
2,332
2,791
2,802
Answer the following requirements assuming a discount rate (WACC) of 13.3%, a terminal period growth rate of 1%, common shares outstanding of 86.2 million, and net nonoperating obligations (NNO) of $(261) million (negative NNO reflects net nonoperating assets such as investments rather than net obligations).(a) Estimate the value of a share of Abercrombie & Fitch common stock using the discounted cash flow (DCF) model as of January 29, 2011.
Rounding instructions:
Round answers to the nearest whole number unless noted otherwise.
Use your rounded answers for…
arrow_forward
Compute the value of a share of Alto common stock using the residual income method
arrow_forward
Estimating Share Value Using the DCF Model
Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 2, 2019, which we label fiscal year 2018.
Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places.
Reported Forecast Horizon Period
Terminal
$ millions 2018
Sales
$75,956
NOPAT
NOA
3,269
23,620
2019
2020 2021
2022
$79,124 $83,680 $87,234 $92,196
4,002 3,572 4,351 3,939
24,197 26,007 26,677 28,611
Period
$93,428
4,617
28,571
Answer the following requirements with the following assumptions:
Assumptions
Terminal period growth rate
Discount rate (WACC)
Common shares outstanding
2%
7.63%
517.80 million
Net nonoperating obligations (NNO) $12,323 million
Estimate the value of a share of Target common stock using the discounted cash flow (DCF) model as of February 2, 2019.
Increase in NOA
($ millions)…
arrow_forward
Refine Assumptions for Dividend and Retained Earnings Forecast
Provided below is FY2016 information for Medtronic PLC.
Medtronic plc
Consolidated Statement of Income
($ millions) Apr. 29, 2016
Net sales $29,277
Costs and expenses
Cost of products sold 9,142
Research and development expenses 2,224
Selling, general, and administrative expense 9,469
Special charges (gains), net 70
Restructuring charge, net 290
Certain litigation charges, net 26
Acquisition-related items 283
Amortization of intangiable assets 1,931
Other expense, net 107
Operating profit 5,735
Interest expense, net 955
Income from operations before income taxes 4,780
Provision for income taxes 908
Net income $3,872
Medtronic plc
Consolidated Balance Sheet
($ millions) Apr. 29, 2016 Apr. 24, 2015
Current assets
Cash and cash equivalents $2,975 $4,942
Investments 9,758 14,637
Accounts receivable 5,562 5,112
Inventories 3,473 3,463
Tax assets 697 1,335
Prepaid expenses and other current assets…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- Estimating Share Value Using the ROPI Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Terminal Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal place Reported Horizon period $ millions 2018 2019 2020 2021 2022 Period Sales $56,880 $57,734 $58,600 $59,480 $60,372 2,492 2,542 2,580 2.619 2,658 4,000 4,065 4,126 4,189 4,252 NOPAT NOA $60,976 2,684 4,295 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate Discount rate (WACC) 19 7.8% Common shares outstanding 135.6 million Net nonoperating obligations (NNO) S(6,161) million NNO is negative because Humana's nonoperating assets exceed its nonoperating liabilities. (a) Estimate the value of a share of common stock using the residual operating income (ROPI) model as of December 31,…arrow_forwardNeed correct answer general accounting questionarrow_forwardConsider the following price and dividend data for GS Company: Date Price ($)Dividend ($) December 31, 2008 $14.64 January 26, 2009 $13.35 $0.10 April 28, 2009 $9.14 $0.10 July 29, 2009 $10.74 $0.10 October 28, 2009 $8.02 $0.10 December 30, 2009 $7.72 Assume that you purchased GS Company stock at the closing price on December 31, 2008 and sold it at the closing price on December 30, 2009. What is your realized annual return for the year 2009?arrow_forward
- SUBJECT FINANCIAL ACCOUNTINGarrow_forwardPlease provide correct answer general accounting questionarrow_forwardEstimating Share Value Using the ROPI Model The following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29, 2011. Refer to the information in the table to answer the following requirements. Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $ 3,469 $ 3,989 $ 4,587 $ 5,275 $ 6,066 $ 6,187 NOPAT 152 319 367 422 485 495 NOA 1,032 1,173 1,349 1,551 1,784 1,820 Answer the following requirements assuming a discount rate (WACC) of 10%, a terminal period growth rate of 2%, common shares outstanding of 87.2 million, and net nonoperating obligations (NNO) of $(858) million. (Negative NNO reflects net nonoperating assests such as investments rather than net obligations)(a) Estimate the value of a share of Abercrombie & Fitch common stock using the residual operating income (ROPI) model as of January 29, 2011. Rounding instructions: Round answers to…arrow_forward
- which of the below ratios can I use the attached file to calculate? return on total assets return on common stockholder's equity dividend payout ratio price-earnings ratioarrow_forwardPlease help me with all answers thankuarrow_forwardUsing ratios to evaluate a stock investment Comparative financial statement data of Garfield Inc. follow: Market price of Garfield’s common stock:$69.36 at December 31 2018 and $38.04 at December 31, 2017. Common shares outstanding 14, 000 on December 31, 2018 and 12,000 on December 31 2017 and 2016. All sales are on credit. Requirements Compute the following ratios tor 2018 and 2017: a. current ratio b. Cash ratio c. Times-interest-earned ratio d. Inventory turnover e. Gross profit percentage f. Debt to equity ratio g. Rate of return on common stockholder’s equity h. Earnings per share of common stock i. Price/earnings ratio 2. Decide (a) whether Garfield’s ability to pat debts and to sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.arrow_forward
- Residual Income Valuation Method Suppose that BKE has the following: Year +1 Year +2 Year +3 Year +4 Year +5 Year +6 Common shareholders' equity at beginning of year $ 4,223.13 $4,557.87 $ 4,683.21 $ 4,802.33 $ 5,001.22 $ 5,503.76 Comprehensive income available for common shareholders 1,668.76 $1,717.54 $ 1,902.22 $ 1,988.34 $ 2,003.45 Their required rate of return is 9.25% Their long run growth rate is 4.20% They have 750 M shares of stock. Market Based Valuation Methods Suppose that BKE has the following: BKE Price $ 87.21 Number of shares (K) 64,575 Book value of equity K$ 588,324 EPS 6.75arrow_forwardYou are given the following information: Stockholder's Equity Price/Earnings Ratio Share Outstanding Market/Book Ratio $1,250 5 25 1.5 Calculate the market price of a share of the company's stock. Consider the summarized data from the balance sheets and income statements of Wiper Inc. If Wiper's stock had a price/earnings ratio of 12 at the end of 2020, what was the market price of the stock? Wiper Inc. Condensed Balance Sheets December 31, 2020, 2019, 2018 (in millions) 2020 2019 2018 Current assets $764 $981 $843 Other assets Total assets 2,424 1,931 1,730 $3,188 $2,912 $2,573 Current liabilities Long-term liabilities Stockholders' equity $588 $841 $734 1,582 1,034 910 1,018 1,037 929 Total liabilities and stockholders' equity $3,188 $2,912 $2,573 Wiper Inc. Selected Income Statement and Other Data For the year Ended December 31, 2020 and 2019 (in millions) 2020 2019 Income statement data: Sales $3,061 $2,924 Operating income 307 321 Interest expense 95 76 Net income 224 219 Other…arrow_forwardEstimating Share Value Using the DCF ModelAssume following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29, 2011. Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $ 3,750 $ 4,500 $ 5,400 $ 6,480 $ 7,776 $ 7,853 NOPAT 464 539 654 794 982 960 NOA 1,320 1,602 1,933 2,332 2,791 2,802 Answer the following requirements assuming a discount rate (WACC) of 13.3%, a terminal period growth rate of 1%, common shares outstanding of 86.2 million, and net nonoperating obligations (NNO) of $(261) million (negative NNO reflects net nonoperating assets such as investments rather than net obligations).(a) Estimate the value of a share of Abercrombie & Fitch common stock using the discounted cash flow (DCF) model as of January 29, 2011. Rounding instructions: Round answers to the nearest whole number unless noted otherwise. Use your rounded answers for…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning