Please answer in excel and use formulas not just raw numbers

Create an amortization schedule in Excel for a typical installment loan ($500K principal, 8%, 60 months). Include the parameters of the installment loan, a column (and calculation) for prepayments, totals for principal, interest, and overall payments. You will be utilizing your creation for our chapter on leasing so make it user friendly! Due Date: Wednesday, 8/29/18, by 11:59 PM in Moodle