TERM STRUCTURE OF INTEREST RATES

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

QUESTION
 
1. Attached is a “Bootstrapping example Excel doc.” Please replicate this “Bootstrapping
example Excel doc” using the following data on these 6 treasury bonds:
PLEASE OBTAIN THIS INFORMATION FROM A BLOOMBERG TERMINAL
Maturity Coupon Bid Ask Change Ask Yield
7/31/22
1/31/23
7/31/23
1/31/24
7/31/24
1/31/25
These 6 treasury bonds are from Bloomberg and pay semi-annual coupons. Annualize the rates
(this is shown in the last line in the attached “Bootstrapping example Excel file attached”.
2. Need a Word Doc Report organized with sections. Number the tables and figures in the Word
Doc. Discuss the data: a) Present a table in the main body of the Word Doc Report on the 6
treasury bonds above showing: maturity, coupon, bid, ask, change and asked yield.
3. In the Word doc Report, construct a timeline. It will be a table, where each row contains cash
flows of one of the six treasury bonds and each column represents a time-period (the cash flow
calculations are shown in the “Bootstrapping example Excel doc” that you will replicate using the
data on the above 6 treasury bonds.
4. Show details of all your calculations in the main body of the Word Doc Report. The data on
the 6 bonds is from Bloomberg and are in ticks: a) Show how you converted prices from
ticks into dollars and cents (the attached 3-page file shows how to convert ticks to
dollars and cents). Show how you calculated semi-annual coupon payments.
5. Show how you calculated each of the six rates of the term structure: a) Show actual formulas,
not Excel formulas. b) Show equations, which you used to find each of the six semi-annual rates
first as formulas with symbols and then with the data plugged into them (use Insert – Equation
in Word to type your equations like in the “Bootstrapping example Excel file attached) c)
Second, show how you plugged in your data into these formulas.
6. Using the Excel Chart menu, “draw” the graph of the term structure: time on the horizontal
axis, corresponding annualized term structure rates on the vertical axis. Paste and copy this
graph into the Word Doc Report. Comment on the graph of the term structure, the implications
observed (is it increasing or decreasing) and comment on the economic conditions as perceived
by market participants.
7. Calculate yields to maturity (YTM) on each bond (you can use the IRR function in Excel).
Compare YTMs to the term structure rates: a) use the graph: time periods on the horizontal axis
a

Sample Solutions
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Phasellus hendrerit. Pellentesque aliquet nibh nec urna. In nisi neque, aliquet vel, dapibus id, mattis vel, nisi. Sed pretium, ligula sollicitudin laoreet viverra, tortor libero sodales leo, eget blandit nunc tortor eu nibh. Nullam mollis. Ut justo. Suspendisse potenti.

Get sample solution
Order Now

Sed egestas, ante et vulputate volutpat, eros pede semper est, vitae luctus metus libero eu augue. Morbi purus libero, faucibus adipiscing, commodo quis, gravida id, est. Sed lectus. Praesent elementum hendrerit tortor. Sed semper lorem at felis. Vestibulum volutpat, lacus a ultrices sagittis, mi neque euismod dui, eu pulvinar nunc sapien ornare nisl. Phasellus pede arcu, dapibus eu, fermentum et, dapibus sed, urna.

Morbi interdum mollis sapien. Sed ac risus. Phasellus lacinia, magna a ullamcorper laoreet, lectus arcu pulvinar risus, vitae facilisis libero dolor a purus. Sed vel lacus. Mauris nibh felis, adipiscing varius, adipiscing in, lacinia vel, tellus. Suspendisse ac urna. Etiam pellentesque mauris ut lectus. Nunc tellus ante, mattis eget, gravida vitae, ultricies ac, leo. Integer leo pede, ornare a, lacinia eu, vulputate vel, nisl.
Suspendisse mauris. Fusce accumsan mollis eros. Pellentesque a diam sit amet mi ullamcorper vehicula. Integer adipiscing risus a sem. Nullam quis massa sit amet nibh viverra malesuada. Nunc sem lacus, accumsan quis, faucibus non, congue vel, arcu. Ut scelerisque hendrerit tellus. Integer sagittis. Vivamus a mauris eget arcu gravida tristique. Nunc iaculis mi in ante. Vivamus imperdiet nibh feugiat est.
Ut convallis, sem sit amet interdum consectetuer, odio augue aliquam leo, nec dapibus tortor nibh sed augue. Integer eu magna sit amet metus fermentum posuere. Morbi sit amet nulla sed dolor elementum imperdiet. Quisque fermentum. Cum sociis natoque penatibus et magnis xdis parturient montes, nascetur ridiculus mus. Pellentesque adipiscing eros ut libero. Ut condimentum mi vel tellus. Suspendisse laoreet. Fusce ut est sed dolor gravida convallis. Morbi vitae ante. Vivamus ultrices luctus nunc. Suspendisse et dolor. Etiam dignissim. Proin malesuada adipiscing lacus. Donec metus. Curabitur gravida

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services