How to write a variable timeline including excel formulas for time period.

Bond pricing Inputs \begin{tabular}{|l|r|} \hline Par & 1000 \\ \hline Coupon rate & 0.05 \\ \hline YTM & 0.06 \\ \hline Term (years) & 15 \\ \hline \end{tabular}