Market enterprises would like to issue bonds


Asked by maham237 @ in Business viewed by 340 People


Market Enterprises would like to issue $1,000 bonds and needs to determine the approximate rate it would need to pay investors. A firm with similar risk recently issued bonds with the following current features: a 5% coupon rate, 10 years until maturity, and a current price of $1,170.50. At what rate would Market Enterprises expect to issue bonds, assuming annual interest payments? Please round to the closest answer. (Solve this problem using either Excel's "Goal Seek" function, plug into tvm tables, or a financial calculator.)

Answered by maham237 @



Answer:

It will use a 3% rate

Explanation:

We need to solve for the discount rate which makes the coupon payment and maturity of the similar bond equal their current market value of 1,170.50

This is done using excel goal seek tool:

C \times \frac{1-(1+r)^{-time} }{rate} = PV\\

C 50.00 (1,000 x 5%)

time 10 years

rate 0.030011

50 \times \frac{1-(1+0.030011)^{-10} }{0.030011} = PV\\

PV $426.4860

\frac{Maturity}{(1 + rate)^{time} } = PV

Maturity 1,000.00

time 10.00

rate 0.030011071

\frac{1000}{(1 + 0.030011)^{10} } = PV

PV 744.01

PV c $426.4860

PV m $744.0139

Total $1,170.5000

market rate = 0.030011071 = 3%

The procedure will be to build up the formulas and link the rates to a cell.

and then, click on the total cell and use goal seek changing the rate cell


Similar Questions

What i would like to do for my country

Asked by admin @ in Social Sciences viewed by 401 persons

Essay on what i want to do for my country

Which marketing techniques are most likely to pay you

Asked by admin @ in English viewed by 288 persons

Which marketing techniques are most likely to pay you?

A change you would like to bring to india essay

Asked by admin @ in Social Sciences viewed by 328 persons

Essay on a change that you would like to bring to india

What would you like to be in the future essay

Asked by admin @ in English viewed by 351 persons

What would you like to be in future essay​

Which court would most likely have jurisdiction over this case

Asked by maham237 @ in History viewed by 373 persons

O O A. A state supreme court B. A federal court of Appeals O C. The U.S. Supreme Court O D. A federal district court

Which of the following would most likely employ a forester

Asked by maham237 @ in Business viewed by 356 persons

a. state governments b. lumber businesses c. national governments d. all of the above

Would you like to come to my house for dinner

Asked by maham237 @ in World Languages viewed by 473 persons

Rewrite the sentence, using colloquial speech.

Which investment advice would gale most likely give to alex

Asked by maham237 @ in Mathematics viewed by 422 persons

Avoid investing in stocks because they can be risky. Put most of your money in a savings account instead. Spread your investments in several different areas. Stick with the stocks …

What is a saturated market like for sellers

Asked by maham237 @ in Business viewed by 313 persons

What is a saturated market like for sellers? A. Consumer demand is higher. B. It contains more available consumers. C. It is more competitive. D. It encourages companies to produce …

Which executive agency would most likely investigate cases of espionage

Asked by maham237 @ in History viewed by 337 persons

the Central Intelligence Agency the Department of State the Department of Defense the Securities and Exchange Commission

What would you like to contribute to the yogurtland culture?

Asked by maham237 @ in Social Studies viewed by 370 persons

An entrepreneur would most likely be a

Asked by wiki @ in Business viewed by 348 persons

A) Low risk taker. B) Trained manager. C) Person who works well alone. D) person who has a brief work week.

Which country would most likely be affected by a typhoon

Asked by admin @ in Geography viewed by 347 persons

Because of its geography Canada would be MOST likely to be affected by A) typhoons B) hurricanes C) sand storms D) forest fires

An example of a perfectly competitive market would be the

Asked by admin @ in Business viewed by 299 persons

An example of a perfectly competitive market would be the a. breakfast cereal market. b. soybean market. c. shampoo market. d. cable tv market.

Most viewed questions in Business


Foolproof module 9 test answers

Asked by maham237 @ in Business viewed by 3326 persons


Interest rates are expressed as a percentage of

Asked by maham237 @ in Business viewed by 2115 persons



How to enhance knowledge regarding environmental factors through capsim?

Asked by wiki @ in Business viewed by 1861 persons


Match the job titles with the career clusters.

Asked by maham237 @ in Business viewed by 1486 persons


A company that allows you to license software

Asked by maham237 @ in Business viewed by 1298 persons



Lupe is ready to open a checking account

Asked by maham237 @ in Business viewed by 1292 persons


Mays and mccovey are beer brewing companies

Asked by maham237 @ in Business viewed by 1222 persons


What must be marked on ready to eat bags phfs

Asked by maham237 @ in Business viewed by 1176 persons



Coq six sigma

Asked by maham237 @ in Business viewed by 1145 persons


Henry ford was the first entrepreneur to implement which strategy

Asked by maham237 @ in Business viewed by 1090 persons


Your company was recently served with a lawsuit

Asked by maham237 @ in Business viewed by 1080 persons



Case study starting a business project schedules and curves edgenuity

Asked by maham237 @ in Business viewed by 1074 persons


The total annual expenditures on advertising in the united states

Asked by maham237 @ in Business viewed by 977 persons