Using Excel’s fill down feature (bottom-right corner of a cell), carry down your formulas from Steps 5-8 through all the rows until you reach your last payment. Now you have successfully set up an ...

– The interest rate on the loan – The term of the loan (i.e., length of time until it’s paid off) 2. Use an amortization formula. An amortization formula helps you determine how much of your monthly ...