Convert bond quotations from the tick format to the decimal format. See details in LN$04-$ppt#$11.$ I also posted an old video on moodle to illustrate how the tick convention works. I also show an example below.

Based on given information $($maturity date, coupon, asked price, etc.$),$ calculate the term to maturity in years and the associated discount factors for terms from $0\mathrm{.}5$ year to $5$ years. Use the "scatter plot" $()$ to plot the term structure of discount factor.

Calculate the spot rate and six$-$month forward rate for terms from $0\mathrm{.}5$ year to $5$ years. Plot the term structure of spot and forward rates.

Example of bond quotation in ticks: $99\mathrm{.}2920$

$99$ is in decimal.

the two digits $(29)$ after the dot is the number of ticks, and each tick is $\frac{1}{32}$;

the third digit $(2)$ is the number of finer ticks, and each finer tick is $\frac{1}{8}$ of a tick.

The fourth digit is not used at this moment.

In decimal, it is $99+\frac{29+\frac{2}{8}}{32}=99\mathrm{.}9141.$

$\backslash$table$[[$Treasury note and bond data,,,Tuesday, January $16,2024],[$MATURITY$,$COUPON,BID,ASKED,CHG SKED YIELD,,$],[\frac{7}{15}\frac{?}{2024},0\mathrm{.}375,97\mathrm{.}224,97\mathrm{.}23,-0\mathrm{.}006,5\mathrm{.}105,],[\frac{1}{15}\frac{?}{2025},1\mathrm{.}125,96\mathrm{.}184,96\mathrm{.}19,-0\mathrm{.}01,4\mathrm{.}644,],[\frac{7}{15}\frac{?}{2025},3,98\mathrm{.}006,98\mathrm{.}012,-0\mathrm{.}03,4\mathrm{.}37,],[\frac{1}{15}\frac{?}{2026},3\mathrm{.}875,99\mathrm{.}122,99\mathrm{.}126,-0\mathrm{.}042,4\mathrm{.}192,],[\frac{7}{15}\frac{?}{2026},4\mathrm{.}5,100\mathrm{.}302,100\mathrm{.}306,-0\mathrm{.}76,4\mathrm{.}091,],[\frac{1}{15}\frac{?}{2027},4,99\mathrm{.}304,99\mathrm{.}31,-0\mathrm{.}788,4\mathrm{.}011,]]$