Question $2$

Suppose a hypothetical bond is currently priced at $$992.$ Its Macauley duration is $12\mathrm{.}34$ years. Yield$-$to$-$maturity is $6\mathrm{.}15\%.$ Interest is paid quarterly. If market interest rates increase by $15$ basis points, estimate the new bond price. You may round to the nearest dollar. Show all formulas & calculations. Excel is optional. If you use Excel please include the spreadsheet.