Search 75,901 tutors
FIND TUTORS
Ask a question
0 0

bonds/purchase price

Tutors, please sign in to answer this question.

1 Answer

This is how you would enter this into Excel
=PRICE(DATE(2013,7,15),DATE(2015,1,1),8.5%,7.5%,100,2)
 
The inputs of the price function are (settlement, maturity, rate, yld, redemption, frequency)
 
The settlement is the date of purchase, maturity is the redemption date, rate is the coupon rate, yld is the yield, the redemption is the redemption value per 100 of par value, frequency is the number of coupon payments per year. The settlement and maturity must be entered using the DATE function (DATE(year, month, day)).
 
The function returns the price per 100 of par value. Since it is a 5000 bond, multiply the price by 50.
 
The price per 100 is $101.3543
The price of the $5000 bond is $5067.72
 
Financial calculators often have bond functions with similar inputs, check your manual to see how to enter.