If you are calculating an existing loan, enter the date of your next payment.
Decimals may be used as long as they divide evenly into your payment frequency.įirst Payment Date is the date on which you will make the first payment on the loan. If you are calculating a loan that is already partially paid off, enter the remaining time on the loan. Term is the number of years, starting from today, over which you plan to pay back the loan.
If you're calculating a loan that is already partially paid off, enter the remaining balance of your loan.Īnnual Interest Rate, aka Annual Percentage Rate (APR), is the interest rate designated by the lender. Loan Amount is the entire principal of the loan. Fill in the blue-bordered cells at the top of the spreadsheet with the terms of your loan:
0 kommentar(er)
