After Engaging In A Dialogue With Your Colleagues On Valuati

After engaging in a dialogue with your colleagues on valuation, you will now be given an opportunity to apply principles that were presented in this phase

Using a Web site that provides current stock and bond pricing and yield information, complete and analyze the tables illustrated below. Your mentor suggests using a Web site similar to this one. To fill out the first table, you will need to select 3 bonds with maturities between 10 and 20 years with bond ratings of "A to AAA," "B to BBB," and "C to CC" (you may want to use a bond screener at the Web site linked above). All of these bonds will have a future value of $1,000. You will need to use the bond's coupon rate times the face value to calculate the annual coupon payment.

You should subtract the maturity date from the current year to determine the time to maturity. The Web site should provide you with the yield to maturity and the current quote for the bond. (Be sure to multiply the bond quote by 10 to get the current market value.) You will then need to indicate whether the bond is trading at a discount, premium, or par. The table should include columns for Bond Company, Rating, Face Value (FV), Coupon Rate, Annual Payment (PMT), Time to Maturity (NPER), Yield-to-Maturity (RATE), Market Value (Quote), and whether it is at Discount, Premium, or Par.

Explain the relationship observed between ratings and yield to maturity, and why the coupon rate and yield to maturity determine whether bonds trade at a discount, premium, or par.

Based on the material in this phase, discuss how increasing or decreasing the time to maturity by 5 years would affect the yield to maturity and market value of the bonds.

Next, visit a credible Web site providing detailed information on publicly traded stocks. Select 1 stock with at least a 5-year dividend payment history and 2 of its closest competitors. Gather information to calculate the required rate of return for each stock, including the 5-year risk-free rate of return, the beta (β) of each company, and the market return from Phase 2.

Calculate the required rate of return for each stock using the Capital Asset Pricing Model (CAPM): Required Rate = Risk-Free Rate + β*(Market Return - Risk-Free Rate).

Gather the most recent dividends paid, the projected growth rate for dividends, and the current stock prices to analyze whether stocks are over- or underpriced using the Gordon Growth Model and the P/E ratio model. Fill out the relevant tables accordingly, noting the estimated stock prices and comparisons with current prices.

Finally, synthesize the findings from all three tables, explaining how the relationships observed reflect the principles of valuation discussed earlier. Address the relationship between the required rate of return, growth rate, dividend payments, and stock valuation within the Gordon model. Discuss the strengths and weaknesses of the Gordon model, and how the P/E ratio is used to estimate stock value.

Compare which model—Gordon or P/E—appeared more accurate in estimating stock value. Based on what you learned, explain how changes in growth rate, dividends, required rate of return, or estimated earnings per share would affect stock valuation in each case.

Paper For Above instruction

The principles of valuation are foundational to understanding financial markets, particularly in assessing the fair value of bonds and stocks. This paper explores the practical application of valuation techniques by analyzing actual bonds and stocks using current market data. The discussion emphasizes the relationships between bond ratings, yields, and prices, as well as stock valuation models like the Gordon Growth Model and the Price-to-Earnings (P/E) ratio.

To illustrate bond valuation, three bonds were selected with maturities between 10 and 20 years, each with distinct credit ratings: A to AAA, B to BBB, and C to CC. The bond ratings reflect the creditworthiness of the issuers, impacting their yields to maturity (YTM) and market prices. Using a credible financial website, yield data and quotes were obtained. The face value for all bonds was set at $1,000, with coupon payments calculated by multiplying the face value by the coupon rate. The Web site provided the current quote, which was multiplied by 10 to determine the market value.

The analysis revealed that higher-rated bonds (e.g., AAA) had lower yields and traded closer to par, illustrating low-risk, low-return characteristics. Conversely, bonds with lower ratings (e.g., CC) displayed higher yields and traded at discounts, reflecting higher risk premiums. This inverse relationship between bond ratings and yields aligns with the fundamental principle that investors require higher returns for riskier investments. The coupon rate, in conjunction with yield to maturity, determines whether a bond trades at a discount, premium, or par. For instance, if the coupon rate exceeds the YTM, the bond trades at a premium; if equal, at par; and if lower, at a discount.

The analysis further indicated that increasing the time to maturity generally leads to higher interest rate risk, which can increase the bond's yield and decrease its market value due to the present value effect. Conversely, decreasing maturity reduces interest rate risk, bringing bond prices closer to their face value.

Turning to stocks, one company with a 5-year dividend payment history and two competitors were selected. Using data from the Web, the risk-free rate (derived from government securities), beta values, and market returns were computed to determine the required rate of return using CAPM. The CAPM formula incorporates risk premiums associated with market volatility (beta), illustrating the relationship between risk and expected return.

Stock valuation using the Gordon Growth Model considers the most recent dividend, the expected growth rate, and the required return. The model estimates stock prices based on the assumption of dividends growing at a constant rate indefinitely. The analysis showed that if dividends or growth rates increase, the estimated stock price rises; conversely, if the required rate of return increases, the estimated stock price decreases. Similarly, the P/E ratio method, relying on expected earnings and an industry average P/E multiple, provides an alternative valuation approach.

Comparing the two models, the Gordon model often offers a straightforward, dividend-based perspective, suitable for mature companies with stable dividend growth. The P/E ratio provides a relative valuation based on earnings, which can be more volatile but useful for assessing over- or undervaluation.

In conclusion, valuation models are essential tools in financial decision-making. The observed relationships confirm that higher risk (lower-rated bonds, higher beta stocks) correlates with higher yields, whereas higher growth prospects and dividends increase stock valuations. The strengths of the Gordon Model include simplicity and focus on dividends, while its weaknesses arise from assumptions of stable growth. The P/E ratio offers quick relative valuation but can be distorted by market sentiment or earnings volatility.

Accurately estimating stock values requires understanding the interplay of growth rates, risk, dividends, and earnings. Variations in these factors significantly impact valuations: an increase in dividends or growth rates typically elevates stock prices, whereas increases in the required rate of return or decreases in earnings expectations tend to reduce valuation estimates. These insights underscore the importance of comprehensive analysis when making investment decisions.

References

• Damodaran, A. (2012). Investment Valuation: Tools and Techniques for Determining the Value of Any Asset. Wiley Finance.
• Koller, T., Goedhart, M., & Wessels, D. (2020). Valuation: Measuring and Managing the Value of Companies (7th ed.). Wiley.
• Ross, S. A., Westerfield, R., & Jaffe, J. (2019). Corporate Finance (12th ed.). McGraw-Hill Education.
• Gordon, M. J. (1959). "Dividends, Earnings, and Stock Prices," The Review of Economics and Statistics, 41(2), 99–105.
• Fama, E. F., & French, K. R. (1992). "The Cross-Section of Expected Stock Returns," The Journal of Finance, 47(2), 427–465.
• Investor.gov. (n.d.). What is the CAPM? U.S. Securities and Exchange Commission.
• Yahoo! Finance. (n.d.). Stock Market Data & Financial News.
• Morningstar. (2023). Stock & Fund Research.
• Bloomberg. (2023). Financial Data and Analytics.