Suppose you are considering bu

Suppose you are considering buying a $2,000,000 face value ofbond in the secondary market. The bond was issued in 2016 and isdue in 2036. It is now 2020. In 2016, the appropriate marketinterest rate to price the bond was 8%. This bond pays quarterlyinterest payments. Currently, other bonds with similar riskcharateristics are being issued into the market with 12% coupons.How much would you be willing to pay for this bond? Please tell methe price per $2,000,000 face value and the % of par. What is thename type of bond given its current price relative to its facevalue? on excel if you can please


Bond Price:It refers to the sum of the present values of all likely couponpayments plus the present value of the par value at maturity. Thereis inverse relation between Bond price and YTM ( Discount rate )and Direct relation between Cash flow ( Coupon/ maturity Value )and bond Price.

Price of Bond = PV of CFs from it.

Bond price at the end of 2020:

Period Cash Flow PVF/ PVAF @2% Disc CF
1 – 64 $          60,000.00                        35.9214 $     2,155,284.89
64 $    2,000,000.00                          0.2816 $        563,143.41
BondPrice $    2,718,428.30

As Coupon Payments are paid periodically with regular intervals,PVAF is used.Maturity Value is single payment. Hence PVF is used.

Periodic Cash Flow = Annual Coupon Amount / No. times couponpaid in a yearDisc Rate Used = Disc rate per anum / No. of times coupon paid in aYear

What is PVAF & PVF ???PVAF = Sum [ PVF(r%, n) ]PVF = 1 / ( 1 + r)^nWhere r is int rate per AnumWhere n is No. of Years

How to Calculate PVAF using Excel ???+PV(Rate,NPER,-1)Rate = Disc rateNper = No. of Periods

"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.