Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
Beam Inc
Beam Inc. bands are trading today for a price of S1,019.47. The bond pays annual coupons with a coupon rate of 6.5% and the next coupon is due in one year. The bond has a yield to maturity of 6.31%. How many years are there until the band matures?
The number of years until the bond matures is ?years. (Round to the nearest whole number.)
Expert Solution
Computation of Number of Years until the bond matures using NPER Function in Excel:
=nper(rate,pmt,-pv,fv)
Here,
NPER = Number of Years to Maturity = ?
Rate = Yield to Maturity = 6.31%
PMT = Periodic Coupon Payment = $1,000*6.5% = $65
PV = Current Price of Bond = $1,019.47
FV = Face Value = $1,000
Substituting the values in formula:
=nper(6.31%,65,-1019.47,1000)
NPER or Number of Years to Maturity = 17 Years
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.
