An Excel Workbook Showing The Details Of Your Calculations Is Required For Submissio 2841503

An excel workbook showing the details of your calculations is required for submission, in addition to your written report.

1)Using the latest Treasury rates from https://www.treasury.gov/resource-center/data-chart- center/interest-rates/Pages/TextView.aspx?data=yield, estimate the forward interest rate for next year.

2)

a) Estimate the modified duration for 2 IBM bonds from http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=IBM&Country=USA (scroll down to see bond details).
b) Considering future movements of interest rates, which of the 2 bonds would you recommend for a buyer who wants to maximize capital gains (or minimize capital losses)?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!