1. Allow the user to input the current price of the bond as a percentage of par with 3 decimal places (usewhole numbers so that 100.000 represents a bond trading at par or face value), the annual coupon rate, the settlement date (day traded), the maturity date, and the percentage increment to use in the table and graph for changes in the discount rate. All calculations in the remaining steps should reference these inputs.
2. Using the inputs, calculate the yield to maturity (YTM), maturity, Macaulay’s duration, modified
duration, and accrued interest (as of the settlement date) of the bond. You will find the yield() function
useful for calculating YTM, the yearfrac() function useful for calculating maturity, the duration()
function useful for calculating Macaulay’s duration, and the couppcd() function useful for calculating
accrued interest. Assume 2 payments per year and a 30/360 basis. Do not use the mduration() function for modified duration, as it is incorrect. Instead, calculate the modified duration as the duration divided by (one plus the YTM that is calculated) or MD = D / (1+ytm).
3. Create a table in which each row contains a change in interest rates, the value of the bond given the
change in interest rates, the actual percentage change in the bond value given the change in interest rates, and the percentage change in the bond price predicted by the duration model for the change in interest rates. You will find the price() function useful for calculating values. The change predicted by the duration model is the negative of the modified duration multiplied by the change in interest rates or
?PV/PV ? -MD × ?i. Your table should include a change of 0% and then +/- 1, 2, 3, and 4 times the
interest rate increment input from step one. For example, if the interest rate increment is 0.50%, the
interest rate changes in the table from top row to bottom row would be -2.00%, -1.50%, -1.00%, -0.50%, 0.00%, +0.50%, +1.00%, +1.50%, and +2.00%.
4. Create a line graph of the actual and predicted percentage changes in value, with appropriate formatting of the axes, labels on the x and y axes, title and legend, etc. In particular, keep the font sizes small, so that most of the graph space is the actual graph, not the labeling.
Check your essay before you submit. See exactly what your professor sees.
See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.
Struggling with paper writing? Look no further, as you have found the ideal paper writing company! We are a reputable essay writing service that offers high-quality papers at affordable prices. On our user-friendly website, you can request a wide range of assignments. Rest assured that our work is entirely original. Each essay is crafted from scratch, tailored to meet the precise requirements of your assignment. We guarantee that it will successfully pass any plagiarism check.
Get Your Assignments Completed by Expert Writers. Hire Essay Helpers for Any Task
Order essays, term papers, research papers, reaction paper, research proposal, capstone project, discussion, projects, case study, speech/presentation, article, article critique, coursework, book report/review, movie review, annotated bibliography, or another assignment without having to worry about its originality – we offer 100% original content written completely from scratch

