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 overtime. your company issued 8% bonds in a market where the interest rate is 10%. the bonds have 5 year term, beginig 1/1/2025. interest is paid quarterly. bond face vale =100,000, market rate = 10%, bond term= 5years, interest paid is 4 times per year. bond interest rate is 8%. 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 rhe chart.