Purchase Solution

Valuation of a Stock and Bond

Not what you're looking for?

Ask Custom Question

With that in mind, you decide to put an Excel spreadsheet together that values the firm's stock and bonds. The company's stock trades for US$35 per share, with an annual dividend payment of US$1.50, expected to grow to US$1.58 next year. The required return on stocks is 10%, and the dividend is expected to increase by 6% for the foreseeable future. The bonds you are valuing have 3 years to maturity, a 4% annual coupon, and a face value of US$1,000. The market interest rates are 5%.

Use Microsoft Excel to calculate the value of the stocks and the bonds. In addition, answer these questions:

- At the current trading price of US$35 per share, is the dividend discount model value of the stock equal to the market value? If they are different, explain why.
- At the face value of US$1,000, is the bond trading price greater than, equal to, or less than its face value? Explain your answer.

Your submission should include the Excel spreadsheet.

Purchase this Solution

Solution Summary

This solution provides a step by step response illustrating how to compute the valuation of both a stock and a bond. An Excel spreadsheet is attached which illustrates how to derive the appropriate values.

Solution Preview

Valuation of Stock:
P0= $39.50 (Div1/(ke-g)
Div1= Expected dividend per share next year.
G = Growth 6%
Ke = Cost of equity 10%
Div1= ...

Purchase this Solution


Free BrainMass Quizzes
Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.