DA$13\mathrm{.}1$ Data analytics can be used to understand present values. GlobalPie plans to issue $10$ year, semi annual bonds. They want to know what the proceeds will be under various scenarios. Set up a chart that uses a formula to state whether the bond is at par, at a discount, or at a premium. Show the proceeds, the interest rates, and the payments under the three scenarios. Instructions: There are four parts to this problem. Use Excel to perform the following: a$.$ Use a formula to calculate whether the bond is issued at a discount, at par, or at a premium. b$.$ Use formulas to calculate the payment rate, market rate, n$,$ PMT$,$ FV$,$ and PV given the information above for each of the three scenarios. Label with the outcomes in part a$.$ c$.$ Graph the PMT$,$ FV$,$ PV$,$ Bond interest rate, Market Rate for the three scenarios. d$.$ Discuss what you see in the graph in part c $.$ DA$13\mathrm{.}2$ Data analytics can be used to understand how values change over time. 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