SHOW EXCEL FORMULA PLEASE

eBook Crab State Bank has offered you a $1,250,000 5-year loan at an interest rate of 11.5 percent, requiring equal annual end-of-year payments that include both principal and interest on the unpaid balance. Develop an amortization schedule for this loan. Round your answers to the nearest dollar. Do not round intermediate calculations. End of Year Payment Interest (11.5%). Principal Reduction Balance Remaining $1,250,000 0 1 $ 2 3 4 5