Southwestern College has online access to The Value Line. Or you can take a trip to a local library that has The Value Line. If all else fails, The Value Line gives free access to the data for the thirty stocks in the Dow Jones Industrial Average. For two companies, perform the following valuation model calculations: Using previous 5 years of dividend growth, use Gordon Growth Discount Model to predict the present values at: 1. a. 12% required rate of return b. 10% required rate of return C. 8% required rate of return 2. a. 10% required rate of return b. 8% required rate of return (Reminder: This model will not work if the dividend growth rate is greater than the required rate of return. You may need to try higher required rates of return. Or you may just report "N/A" as the model's result.) Using 3 to 5 years of expected results, use the Discounted Cash Flow Model to predict the present values at: (Don't forget the spreadsheets. They make the calculations much easier.) Notes: Use the current and prior years' dividends per share to calculate the dividend growth rate for the Gordon Growth Dividend Discount Model. The dividend growth rate for each year is computed by the following formula: (Next Year's Dividends - Last Year's Dividends) / (Last Year's Dividends) You then compute the average of the growth rates that you calculated by summing all the growth rates together and dividing by the number of years. Go back at least five years. (Of course, you could simply use The Value Line's projected annual dividend growth rate, but that is not as much fun, is it?) Remember that sometimes this model will produce aberrant results (such as division by zero or negative values) depending upon the required rate of return. If this happens, you can adjust the required rate of return up or down until you get reasonable values. Or you could simply display "N/A" as the result. For the Discounted Cash Flow Model, use The Value Line estimated or actual dividends and extrapolate the estimated dividends from 2024 to 2026, 2027, or 2028. Or use the dividend growth rate you calculated for the Gordon Growth Dividend Discount Model to calculate estimates of the 2025 through 2028 dividends. Use an appropriate value for the target price of early 2026, or anytime in 2026, 2027, or 2028. (You can use your own prediction or look at The Value Line target price range or choose a price somewhere in the middle. How is that for accuracy? Remember that we want to eliminate any pretense of absolute precision. We are predicting the weather! Do not put any credence in your results. We are simply tilting the odds in our favor, in my humble opinion.) Dow Jones Stocks: The models work best with large-cap stocks with long histories of paying dividends. (aka blue-chip stocks) American Express, Amgen, Apple, Boeing, Caterpillar, Chevron, Cisco Systems, Coca Cola, Disney, Dow Chemical, Goldman Sachs, Home Depot, Honeywell, IBM, Intel, Johnson & Johnson, J. P. Morgan, McDonald's, Merck, Microsoft, Nike, Procter & Gamble, salesforce, 3M, Travelers, United Healthcare, Verizon, Visa, Walgreens Boots, Walmart Other stocks to study: Abbott Laboratories, Abbvie, Aetna, AFLAC, Air Products and Chemicals, Anheuser-Busch InBev, Aon, AT&T, Automatic Data Processing, Baker Hughes, Ball Corporation, Bank of America, Bank of New York, Best Buy, BlackRock, The Blackstone Group, Bristol-Myers Squibb, Cardinal Health, Citigroup, CSX, CVS/Caremark, Corning, Deere, Dominion Energy, Dr. Pepper, Dupont, Emerson Electric, ExxonMobil, FedEx, Fifth Third Bancorp, Ford, Gannett, General Dynamics, General Electric, General Mills, General Motors, Halliburton, Harley-Davidson, Hershey's, Illinois Tool Works, Ingersoll-Rand, International Flavors and Fragrances, J. M. Smucker, Johnson and Johnson, Johnson Controls, Kellogg's, Kimberly-Clark, Kraft-Heinz, Eli Lilly, Lockheed-Martin, Lowe's, Marathon Oil, Marsh & McLennan, Mastercard, Medtronic, Mondelez, Newmont Mining, Norfolk Southern, Northrop Grumman, Oracle, PepsiCo, Pfizer, Pitney-Bowes, PPG Industries, Public Storage, Raytheon, Schlumberger, Sherwin-Williams, Snap-on, Southern Co, State Street Corp, Sysco, Target, Texas Instruments, TJX (TJ Maxx), Tyson, Union Pacific, United Technologies, UPS, USB, Wells Fargo, Xcel Energy, Yum Brands Here's an idea: Choose two competitors such as Visa/Mastercard, FedEx/UPS, or Home Depot/Lowe's. Have fun! P.S. If you go to a library to work on The Value Line, flip through The Value Line index and gawk at the sheer number of publicly traded companies. There are thousands! Could any one person ever become qualified to give advice on more than a small percentage of the companies available? We humbly hope that you become addicted to researching companies using these and other techniques you learn along the way. The chapter 4 spreadsheets can help you. Be Awesome!

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%

Business 123 Introduction to Investments

May I please have an expert's solution for the following exercise?

Thank you so much

Southwestern College has online access to The Value Line. Or you can take a trip to a local library that has The Value Line.
If all else fails, The Value Line gives free access to the data for the thirty stocks in the Dow Jones Industrial Average. For
two companies, perform the following valuation model calculations:
Using previous 5 years of dividend growth, use Gordon Growth Discount Model to predict the present values at:
1.
a.
12% required rate of return
b.
10% required rate of return
C.
8% required rate of return
2.
a.
10% required rate of return
b.
8% required rate of return
(Reminder: This model will not work if the dividend growth rate is greater
than the required rate of return. You may need to try higher required rates of
return. Or you may just report "N/A" as the model's result.)
Using 3 to 5 years of expected results, use the Discounted Cash Flow Model to predict the present values at:
(Don't forget the spreadsheets. They make the calculations much easier.)
Notes: Use the current and prior years' dividends per share to calculate the dividend growth rate for the Gordon Growth
Dividend Discount Model. The dividend growth rate for each year is computed by the following formula:
(Next Year's Dividends - Last Year's Dividends) / (Last Year's Dividends)
You then compute the average of the growth rates that you calculated by summing all the growth rates together
and dividing by the number of years. Go back at least five years. (Of course, you could simply use The Value Line's
projected annual dividend growth rate, but that is not as much fun, is it?)
Remember that sometimes this model will produce aberrant results (such as division by zero or negative values)
depending upon the required rate of return. If this happens, you can adjust the required rate of return up or down
until you get reasonable values. Or you could simply display "N/A" as the result.
For the Discounted Cash Flow Model, use The Value Line estimated or actual dividends and extrapolate the
estimated dividends from 2024 to 2026, 2027, or 2028. Or use the dividend growth rate you calculated for the
Gordon Growth Dividend Discount Model to calculate estimates of the 2025 through 2028 dividends. Use an
appropriate value for the target price of early 2026, or anytime in 2026, 2027, or 2028. (You can use your own
prediction or look at The Value Line target price range or choose a price somewhere in the middle. How is that for accuracy?
Remember that we want to eliminate any pretense of absolute precision. We are predicting the weather! Do not put any
credence in your results. We are simply tilting the odds in our favor, in my humble opinion.)
Dow Jones Stocks: The models work best with large-cap stocks with long histories of paying dividends. (aka blue-chip stocks)
American Express, Amgen, Apple, Boeing, Caterpillar, Chevron, Cisco Systems, Coca Cola, Disney, Dow Chemical,
Goldman Sachs, Home Depot, Honeywell, IBM, Intel, Johnson & Johnson, J. P. Morgan, McDonald's, Merck, Microsoft,
Nike, Procter & Gamble, salesforce, 3M, Travelers, United Healthcare, Verizon, Visa, Walgreens Boots, Walmart
Other stocks to study:
Abbott Laboratories, Abbvie, Aetna, AFLAC, Air Products and Chemicals, Anheuser-Busch InBev, Aon, AT&T,
Automatic Data Processing, Baker Hughes, Ball Corporation, Bank of America, Bank of New York, Best Buy,
BlackRock, The Blackstone Group, Bristol-Myers Squibb, Cardinal Health, Citigroup, CSX, CVS/Caremark, Corning,
Deere, Dominion Energy, Dr. Pepper, Dupont, Emerson Electric, ExxonMobil, FedEx, Fifth Third Bancorp, Ford,
Gannett, General Dynamics, General Electric, General Mills, General Motors, Halliburton, Harley-Davidson, Hershey's,
Illinois Tool Works, Ingersoll-Rand, International Flavors and Fragrances, J. M. Smucker, Johnson and Johnson, Johnson
Controls, Kellogg's, Kimberly-Clark, Kraft-Heinz, Eli Lilly, Lockheed-Martin, Lowe's, Marathon Oil, Marsh &
McLennan, Mastercard, Medtronic, Mondelez, Newmont Mining, Norfolk Southern, Northrop Grumman, Oracle,
PepsiCo, Pfizer, Pitney-Bowes, PPG Industries, Public Storage, Raytheon, Schlumberger, Sherwin-Williams, Snap-on,
Southern Co, State Street Corp, Sysco, Target, Texas Instruments, TJX (TJ Maxx), Tyson, Union Pacific, United
Technologies, UPS, USB, Wells Fargo, Xcel Energy, Yum Brands
Here's an idea: Choose two competitors such as Visa/Mastercard, FedEx/UPS, or Home Depot/Lowe's. Have fun!
P.S. If you go to a library to work on The Value Line, flip through The Value Line index and gawk at the sheer number of
publicly traded companies. There are thousands! Could any one person ever become qualified to give advice on more than
a small percentage of the companies available? We humbly hope that you become addicted to researching companies
using these and other techniques you learn along the way. The chapter 4 spreadsheets can help you. Be Awesome!
Transcribed Image Text:Southwestern College has online access to The Value Line. Or you can take a trip to a local library that has The Value Line. If all else fails, The Value Line gives free access to the data for the thirty stocks in the Dow Jones Industrial Average. For two companies, perform the following valuation model calculations: Using previous 5 years of dividend growth, use Gordon Growth Discount Model to predict the present values at: 1. a. 12% required rate of return b. 10% required rate of return C. 8% required rate of return 2. a. 10% required rate of return b. 8% required rate of return (Reminder: This model will not work if the dividend growth rate is greater than the required rate of return. You may need to try higher required rates of return. Or you may just report "N/A" as the model's result.) Using 3 to 5 years of expected results, use the Discounted Cash Flow Model to predict the present values at: (Don't forget the spreadsheets. They make the calculations much easier.) Notes: Use the current and prior years' dividends per share to calculate the dividend growth rate for the Gordon Growth Dividend Discount Model. The dividend growth rate for each year is computed by the following formula: (Next Year's Dividends - Last Year's Dividends) / (Last Year's Dividends) You then compute the average of the growth rates that you calculated by summing all the growth rates together and dividing by the number of years. Go back at least five years. (Of course, you could simply use The Value Line's projected annual dividend growth rate, but that is not as much fun, is it?) Remember that sometimes this model will produce aberrant results (such as division by zero or negative values) depending upon the required rate of return. If this happens, you can adjust the required rate of return up or down until you get reasonable values. Or you could simply display "N/A" as the result. For the Discounted Cash Flow Model, use The Value Line estimated or actual dividends and extrapolate the estimated dividends from 2024 to 2026, 2027, or 2028. Or use the dividend growth rate you calculated for the Gordon Growth Dividend Discount Model to calculate estimates of the 2025 through 2028 dividends. Use an appropriate value for the target price of early 2026, or anytime in 2026, 2027, or 2028. (You can use your own prediction or look at The Value Line target price range or choose a price somewhere in the middle. How is that for accuracy? Remember that we want to eliminate any pretense of absolute precision. We are predicting the weather! Do not put any credence in your results. We are simply tilting the odds in our favor, in my humble opinion.) Dow Jones Stocks: The models work best with large-cap stocks with long histories of paying dividends. (aka blue-chip stocks) American Express, Amgen, Apple, Boeing, Caterpillar, Chevron, Cisco Systems, Coca Cola, Disney, Dow Chemical, Goldman Sachs, Home Depot, Honeywell, IBM, Intel, Johnson & Johnson, J. P. Morgan, McDonald's, Merck, Microsoft, Nike, Procter & Gamble, salesforce, 3M, Travelers, United Healthcare, Verizon, Visa, Walgreens Boots, Walmart Other stocks to study: Abbott Laboratories, Abbvie, Aetna, AFLAC, Air Products and Chemicals, Anheuser-Busch InBev, Aon, AT&T, Automatic Data Processing, Baker Hughes, Ball Corporation, Bank of America, Bank of New York, Best Buy, BlackRock, The Blackstone Group, Bristol-Myers Squibb, Cardinal Health, Citigroup, CSX, CVS/Caremark, Corning, Deere, Dominion Energy, Dr. Pepper, Dupont, Emerson Electric, ExxonMobil, FedEx, Fifth Third Bancorp, Ford, Gannett, General Dynamics, General Electric, General Mills, General Motors, Halliburton, Harley-Davidson, Hershey's, Illinois Tool Works, Ingersoll-Rand, International Flavors and Fragrances, J. M. Smucker, Johnson and Johnson, Johnson Controls, Kellogg's, Kimberly-Clark, Kraft-Heinz, Eli Lilly, Lockheed-Martin, Lowe's, Marathon Oil, Marsh & McLennan, Mastercard, Medtronic, Mondelez, Newmont Mining, Norfolk Southern, Northrop Grumman, Oracle, PepsiCo, Pfizer, Pitney-Bowes, PPG Industries, Public Storage, Raytheon, Schlumberger, Sherwin-Williams, Snap-on, Southern Co, State Street Corp, Sysco, Target, Texas Instruments, TJX (TJ Maxx), Tyson, Union Pacific, United Technologies, UPS, USB, Wells Fargo, Xcel Energy, Yum Brands Here's an idea: Choose two competitors such as Visa/Mastercard, FedEx/UPS, or Home Depot/Lowe's. Have fun! P.S. If you go to a library to work on The Value Line, flip through The Value Line index and gawk at the sheer number of publicly traded companies. There are thousands! Could any one person ever become qualified to give advice on more than a small percentage of the companies available? We humbly hope that you become addicted to researching companies using these and other techniques you learn along the way. The chapter 4 spreadsheets can help you. Be Awesome!
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education