1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
boyakko [2]
2 years ago
9

Both Bond Bill and Bond Ted have 6.2 percent coupons, make semiannual payments, and are priced at par value. Bond Bill has 5 yea

rs to maturity, whereas Bond Ted has 25 years to maturity. If interest rates suddenly rise by 2 percent, what is the percentage change in the price of Bond Bill? Of Bond Ted? Both bonds have a par value of $1000. If rates were to suddenly fall by 2 percent instead, what would the percentage change in the price of Bond Bill be then? Of Bond Ted? Illustrate your answers by graphing bond prices versus YTM. What does this problem tell you about the interest rate risk of longer-term bonds?
Business
1 answer:
iragen [17]2 years ago
6 0

Answer:

a-1. Percentage change in the price of Bond Bill = -8.07%

a-2. Percentage change in the price of Bond Ted = -21.12%

b-1. Percentage change in the price of Bond Bill = 8.94%

b-1. Percentage change in the price of Bond Ted = 30.77%

c. See the attached excel file for the graph.

d. It tells us that the longer the term of a bond, the greater will be its interest rate risk.

Explanation:

The price of each bond can be calculated using the following excel function:

Bond price = -PV(YTM, NPER, PMT, FV) ........... (1)

Where;

a-1. If interest rates suddenly rise by 2 percent, what is the percentage change in the price of Bond Bill?

YTM = (6.2% + 2%) / Number of semiannuals in a year = 8.2% / 2 = 4.1%

NPER = Number of semiannuals to maturity = 5 * 2 = 10

PMT = Payment = Coupon rate * Face value = (6.2% / Number of semiannuals in a year) * 1000 = (6.2% / 2) * 1000 = $31

FV = Face value = Initial price of Bond Bill = $1,000

Substituting all the values into equation (1), we have:

New price of Bond Bill = -PV(4.1%, 10, 31, 1000)

Inputting =-PV(4.1%, 10, 31, 1000) in a cell in an excel file (Note: As done in the attached excel file), we have:

New price of Bond Bill = $919.29

Percentage change in the price of Bond Bill = ((New price of Bond Bill - Initial price of Bond Bill) / Initial price of Bond Bill) * 100 = (($919.29 - $1,000) / $1,000) * 100 = -8.07%

a-2. If interest rates suddenly rise by 2 percent, what is the percentage change in the price of Bond Ted?

YTM = (6.2% + 2%) / Number of semiannuals in a year = 8.2% / 2 = 4.1%

NPER = Number of semiannuals to maturity = 25 * 2 = 50

PMT = Payment = Coupon rate * Face value = (6.2% / Number of semiannuals in a year) * 1000 = (6.2% / 2) * 1000 = $31

FV = Face value = Initial price of Bond Ted = $1,000

Substituting all the values into equation (1), we have:

New price of Bond Ted = -PV(4.1%, 50, 31, 1000)

Inputting =-PV(4.1%, 50, 31, 1000) in a cell in an excel file (Note: As done in the attached excel file), we have:

New price of Bond Ted = $788.81

Percentage change in the price of Bond Ted = ((New price of Bond Ted - Initial price of Bond Bill Ted) / Initial price of Bond Ted) * 100 = (($788.81 - $1,000) / $1,000) * 100 = -21.12%

b-1. If rates were to suddenly fall by 2 percent instead, what would the percentage change in the price of Bond Bill be then?

YTM = (6.2% - 2%) / Number of semiannuals in a year = 4.2% / 2 = 2.1%

NPER = Number of semiannuals to maturity = 5 * 2 = 10

PMT = Payment = Coupon rate * Face value = (6.2% / Number of semiannuals in a year) * 1000 = (6.2% / 2) * 1000 = $31

FV = Face value = Initial price of Bond Bill = $1,000

Substituting all the values into equation (1), we have:

New price of Bond Bill = -PV(2.1%, 10, 31, 1000)

Inputting =-PV(2.1%, 10, 31, 1000) in a cell in an excel file (Note: As done in the attached excel file), we have:

New price of Bond Bill = $1,089.36

Percentage change in the price of Bond Bill = ((New price of Bond Bill - Initial price of Bond Bill) / Initial price of Bond Bill) * 100 = (($1,089.36 - $1,000) / $1,000) * 100 = 8.94%

b-2. If rates were to suddenly fall by 2 percent instead, what would the percentage change in the price of Bond Ted be then?

rate = new YTM = (6.2% - 2%) / Number of semiannuals in a year = 4.2% / 2 = 2.1%

NPER = Number of semiannuals to maturity = 25 * 2 = 50

PMT = Payment = Coupon rate * Face value = (6.2% / Number of semiannuals in a year) * 1000 = (6.2% / 2) * 1000 = $31

FV = Face value = Initial price of Bond Ted = $1,000

Substituting all the values into equation (1), we have:

New price of Bond Ted = -PV(2.1%, 50, 31, 1000)

Inputting =-PV(2.1%, 50, 31, 1000) in a cell in an excel file (Note: As done in the attached excel file), we have:

New price of Bond Ted = $1,307.73

Percentage change in the price of Bond Ted = ((New price of Bond Ted - Initial price of Bond Bill Ted) / Initial price of Bond Ted) * 100 = (($1,307.73 - $1,000) / $1,000) * 100 = 30.77%

c. Illustrate your answers by graphing bond prices versus YTM.

Note: See the attached excel file for the graph.

d. What does this problem tell you about the interest rate risk of longer-term bonds?

It tells us that the longer the term of a bond, the greater will be its interest rate risk.

Download xlsx
You might be interested in
Last year vaughn corp. had sales of $315,000 and a net income of $17,832, and its year-end assets were $210,000. the firm's tota
KATRIN_1 [288]
I have the same question if anyone can help please let me know
4 0
3 years ago
Slack, a collaboration hub that brings people together within organizations, strives to ensure that its products and people focu
Airida [17]

Answer:

mission statement

Explanation:

A company's mission statement defines the reason why the company exists; what is its business (what product or service they provide), its objectives (or goals) and how they will reach these objectives. It should also include who's needs they are satisfying (target market).

5 0
3 years ago
Padraig receives total employment compensation of $70,000 and had $2,000 in job expenses. Which of the following could be true a
Keith_Richards [23]

The option that's true about Padraig’s gross pay and total employee benefits is "His total employee benefits are 12.5% of his annual gross pay of $64,000"

His annual gross pay is $64,000, his employment benefits will be:

= 12.5% × $64000

= 12.5/100 × $6400

= 0.125 × $64000

= $8000

Therefore, the annual compensation will be:

= $64000 + $8000

= $72000

In conclusion, the correct option is C.

Read related link on:

brainly.com/question/23770424

7 0
2 years ago
What type of interest will earn you the most amount on your money?
kirill [66]
1=A
2=D
3=C
4=A
5=C
6=C
7=D
8=A
9=C
10=D
11=C
12=A
13=C
14=B

8 0
3 years ago
Narrow Falls Lumber has total assets of $913,600, total debt of $424,500, net sales of $848,600, and net income of $94,000. The
Black_prince [1.1K]

Answer:

The firm's sustainable growth rate is 13%.

Explanation:

The firm's sustainable growth rate can be calculated using the following formula:

Sustainable growth rate = Retention Rate * Return on Equity ............. (1)

Where;

Dividend payout ratio = 30%, or 0.30

Retention rate = 1 - dividend payout ratio = 1 - 0.30 = 0.70

Shareholder's equity = Total assets - Total debt = $913,600 - $424,500 = $489,100

Return on equity = Net income / Shareholder's equity = $94,000 / $489,100 = 0.19

Substituting the relevant values into equation (1), we have:

Sustainable growth rate = 0.70 * 0.19 = 0.13, or 13%

Therefore, the firm's sustainable growth rate is 13%.

3 0
3 years ago
Other questions:
  • A useful guideline in designing policies and operating procedures that facilitate good strategy execution is ________.
    13·1 answer
  • Fabriq Inc., a cosmetics company, hired a well-known movie star to appear in its advertisements. The company hoped that using a
    10·1 answer
  • Name a profession which typically includes an apprenticeship as part of its training program
    10·1 answer
  • 1. Congress passed the Sarbanes-Oxley Act to ensure that investors invest only in companies that will be profitable.
    10·1 answer
  • A recession is a period of significant, widespread declines in:
    10·1 answer
  • A family you are working with speaks English, but their native language is Korean and they have stated that it is much easier fo
    9·1 answer
  • List at least three tools or services that are available when you open a savings account.
    5·1 answer
  • Perfect elasticity and zero elasticity refer to the same event, which occurs when quantity demanded or quantity supplied change
    14·1 answer
  • For the underwriting of a municipal bond issue, competitive bids are submitted by underwriters as A) a best efforts underwriting
    11·1 answer
  • Real Wood Structures Company has invested $1,040,000 in a plant to build small tool sheds. The target operating income desired f
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!