# 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!!"

Pages (275 words)
Standard price: \$0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
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