The table below summarizes prices $($per $$100$ face value$)$ of various default$-$free zero$-$coupon bonds $($expressed as a percentage of face value$)$:

Compute the yield to maturity for each bond. $($for each year$)$

Maturity

$($years$)$ Price

$1$ $$95\mathrm{.}51$

$2$ $$91\mathrm{.}05$

$3$ $$86\mathrm{.}38$

$4$ $$81\mathrm{.}65$

$5$ $$76\mathrm{.}51$

USE EXCEL AND CELL REFERENCES, PLEASE SHOW ALL FORMULAS AND WORK. USE RATE FUNCTION IN EXCEL.