Question - Price a $10,000,000, 6%, 10 year bond which pays interest semi-annually when the market rate is 5%. Create the Amortization table through the life of the bond in the excel. Please also indicate all the necessary data, such as rate, #of periods, Payment, Type. Use formulas.