$|$ It is $\frac{7}{15}\frac{?}{24},$ and you are considering two corporate bonds. The first bond has a $7\mathrm{.}2\%$ coupon

rate and matures on $\frac{1}{15}\frac{?}{29}.$ The second bond has a $2\mathrm{.}1\%$ coupon rate and matures on

$\frac{1}{15}\frac{?}{27}.$ Both bonds are priced to yield $14\mathrm{.}2\%$ if held to maturity. Use the spreadsheet method

to calculate the Macaulay and Modified Durations for each bond. Assume that each bond has a

$$100$ par value for your calculations. $(25\mathrm{.}5$ points total$)$

You do not know if you will be able to hold the bond you pick until maturity. If you think interest

rates are likely to rise in the future, which bond would be the better choice based on duration to

two decimal places? $(4\mathrm{.}5$ points$)$

Which Bond?

Please include all excel formulas and how you are able to solve everything. Thank you