This form is a sample letter in Word format covering the subject matter of the title of the form.
Excel Loan Amortization Schedule With Fixed Principal Payments In Mecklenburg
State:
Multi-State
County:
Mecklenburg
Control #:
US-0019LTR
Format:
Word;
Rich Text
Instant download
Description
Form popularity
FAQ
=PMT(1.5%/12,312,0,8500) The rate argument is 1.5% divided by 12, the number of months in a year. The NPER argument is 312 for twelve monthly payments over three years. The PV (present value) is 0 because the account is starting from zero.
Fortunately, Excel can be used to create an amortization schedule. The amortization schedule template below can be used for a variable number of periods, as well as extra payments and variable interest rates.
While this can be done by hand in a ledger, if that's your style, there are several amortization calculators online as well as amortization schedule chart templates for popular spreadsheet programs, like Microsoft Excel.
