On 1/1/A, S issues $30k of 4 year 13% bonds to yield 17% (coupon payments occur every 12/31). P purchases 12 of the bonds on 1/1/B for $12,586.49. (You have to figure out the market rate of interest on the repurchase date for P).

Create an amortization table on Excel for the 12 bonds from the point of views of S and P from 1/1/B onward. You must use interest method of amortization and the table format attached. (For S starting balance, you must to find the present value of 12 13% bonds that yield 17%.

EXAMPLE FORMAT: (Do not use this data)

COMPLETE THIS TABLE:

\begin{tabular}{||l|c|c|c|c|l|c|c|c||} \hline \begin{tabular}{c} Date \\ S books \end{tabular} & \begin{tabular}{c} .12int \\ exp \end{tabular} & pmt & bal & bal diff & \begin{tabular}{c} Date \\ P books \end{tabular} & .09 int rev & pmt & bal \\ \hline 1/1/B & - & - & 7616 & 587 & 1/1/B & - & - & 8203 \\ \hline 12/31/B & 914 & 800 & 7730 & & 12/31/B & 738 & 800 & 8141 \\ \hline 12/31/C & 927 & 800 & 7857 & & 12/31/C & 732 & 800 & 8073 \\ \hline 12/31/D & 943 & 800 & 8k & & 12/31/D & 727 & 800 & 8k \\ \hline & 2784 & & & 587 & & 2197 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline Date S Books & .13lntExp & PMT & BAL & BAL DIFF & Date P Books & .? Int Rev & PMT & BAL \\ \hline 1/1/B & & & & & 1/1/B & & & 12,586 \\ \hline 12/31/B & & & & & 12/31/B & & & \\ \hline 12/31/C & & & & & 12/31/C & & & \\ \hline 12/31/D & & & & & 12/31/D & & & \\ \hline \end{tabular}