your company recently issued bonds at a discount. you have been asked to prepare the amortization schedule and to prepare visualization that shiws the outflows, expenses, and balance over time. your company issued 8% bonds in a market where the interest rate is 10%. the bonds have 5 year term, begining 1/1/2025. interest is paid quartely. bond face value is $100,000, market rate is 10%. bond term is 5 years, 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 of the bonds, b) create the schedule of the bond amortization c) graph the schedule of bond discount amortization d) discuss the chart.