On 15 September 2020 you plan to buy a 6% p.a. Treasury bond maturing on 15 September 2026.

a. How much would you pay to earn 7% p.a. on your transaction? Ignore taxation considerations.

b. How much would you pay to earn a net return of 7% p.a. on your transaction, allowing for tax on interest only of 30%? In this instance, assume tax on interest is paid immediately.

c. How much would you pay to earn a net return of 7% p.a. on your transaction, allowing for tax on interest and capital gains of 30%? In answering this question, you should assume that the tax on interest and capital gains is deferred by twelve months.

d. Allowing for tax on interest and capital gains of 30%, what would your net annual yield be if you paid $97.447 for the bond? Again, assume that the tax on interest and capital gains is deferred by twelve months.

Note: that all the interest rates given in all question are j2 rates. Pls answer it on excel or spreadsheet with separate part for each questions