Using Data Analytics to Analyze Data DA$13\mathrm{.}2$ Data analytics can be used to understand how values change over time Problem Your company recently issued bonds at a discount. You have been asked to prepare the amortization schedule and to prepare a visualization that shows the outflows, expenses, and balances over time. Your company issued $\backslash (8\backslash \%\backslash )$ bonds in a market where the interest rate is $\backslash (10\backslash \%\backslash ).$ The bonds have a $5$ year term, beginning $\backslash (1/1/2025\backslash ).$ Interest is paid quarterly. Instructions: There are four parts to this problem. Use Excel to perform the following:

a$.$ Calculate the issue price of the bonds.

b$.$ Create the Schedule of Bond Discount Amortization.

c$.$ Graph the Schedule of Bond Discount Amortization.

d$.$ Discussion of the chart

I need help with issuing the price of the bonds and explanation on how to create and graph a bond discount amortization.