Question
Suppose we have the following corporate bond: Issue date: 3/15/2015 First coupon date: 9/15/2015 Maturity date: 9/15/2042 Settlement date: 6/1/2019 Last coupon date: 3/15/2019 Next
Suppose we have the following corporate bond:
Issue date: 3/15/2015 First coupon date: 9/15/2015 Maturity date: 9/15/2042 Settlement date: 6/1/2019 Last coupon date: 3/15/2019 Next coupon date: 9/15/2019 Coupon rate: 8.00% Yield to maturity: 7.30% Par value (% of par) 100 Par value ($ value) $ 1,000 Coupons per year: 2
Using the Excel bond price function, we can find the price of the bond as: Bond price: ?
Using the PRICE function in Excel returns the clean price. To find the invoice, or dirty, price, we need to calculate the accrued interest. Excel has a function that calculates the accrued interest. Using ACCRINT, we find the accrued interest is:
Accrued interest (incorrect): $ 336.89
Obviously this number is too high. When you allow computer programmers to program financial functions, you often get errors, which is what we get in this case. First, ACCRINT requires the par value in dollars, not a percent of par, which is different from the price function. Second, the accrued interest in this function is the total accrued interest since the bond was issued, a relatively unimportant number. To get the ACCRINT function to work properly, we will have to adjust the inputs. For the Issue date, we can use the date the last coupon payment was made, and the First_interest date is the date of the next coupon payment. Using these adjustments, we find the accrued interest is: Accrued interest (correct): ?
the dirty price is the clean price, plus accrued interest, or: Dirty price: ?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started