amortization ficial site this loan calculator also known as an amortization schedule calculator lets you estimate your monthly loan repayments it also determines out how much of your repayments will go towards the principal and how much will go towards interest how to prepare amortization schedule in excel 10 steps how to prepare amortization schedule in excel an amortization schedule shows the interest applied to a fixed interest loan and how the principal is reduced by payments it also shows the detailed schedule of all payments so you can see an amortization schedule shows the interest applied to a fixed interest loan and how the principal is reduced by payments it also shows the detailed amortization schedules for 15 year loans what is an amortization schedule an amortization schedule displays the payments required for paying off a loan or mortgage each payment is separated into the amount that goes towards interest with the rest being used to pay down the remaining balance loan amortization with microsoft excel this is the first of a two part tutorial on amortization schedules in this tutorial we will see how to create an amortization schedule for a fixed rate loan using microsoft excel and other spreadsheets the next part shows how to handle extra principal payments and also includes a sample spreadsheet using this same example data amortization schedule calculator an amortization schedule is a table that lists each regular payment on a mortgage over time a portion of each payment is applied toward the principal balance and interest and the amortization
Excel ch04 from 15 year amortization schedule excel , image source: www.slideshare.net