help in homework

New User?

Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Your company needs to raise $2 million by selling some coupon bonds at par value

Your company needs to raise $2 million by selling some coupon bonds at par value

Finance

Your company needs to raise $2 million by selling some coupon bonds at par value. Comparable bonds in the market have a 7.5 percent annual coupon, 15 years to maturity, and are selling at $976.87. What coupon rate should you set on your company bonds? 

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Computation of Coupon Payment using PMT Function in Excel:

=pmt(rate,nper,-pv,fv)

Here,

PMT = Coupon Payment = ?

Rate = 7.5%

Nper = 15 years

PV = $976.87

FV = $1,000

Substituting the values in formula:

=pmt(7.5%,15,-976.87,1000)

PMT or Coupon Payment = $72.38

 

Coupon Rate = Coupon Payment/Face Value = $72.38/$1,000 = 7.238% or 7.24%

Sitejabber (5.0)

BBC (5.0)

Trustpilot (4.9)

Google (5.0)