How to read your result
In Loan Payment mode, the headline number is the periodic payment — what a fixed-rate loan actually costs each period once interest and principal are combined. Total interest and total paid show the full lifetime cost, and the amortization schedule breaks every payment into its interest and principal slice, so you can see the split move from mostly-interest at the start to mostly-principal near the end. Add extra payments to see the new payoff date and how much interest that saves. In Loan Eligibility mode the logic runs in reverse: from your income, existing EMIs, and an FOIR/DTI limit, the tool works out your affordable monthly payment first, then converts that into an estimated loan amount — a planning ceiling, not an approval. Use the scenario comparison to test a different rate, term, or FOIR limit side by side before you download the workbook.
Worked example
A $15,000 personal loan at 6.5% over 60 months (monthly payments, monthly compounding) produces a payment of $293.49 a month. Total interest comes to about $2,609.55 — roughly 17.4% on top of what you borrowed — for a total paid of about $17,609.55. The first payment is $81.25 interest and $212.24 principal; because interest is charged on the outstanding balance, that split shifts steadily toward principal as the balance falls, even though the payment itself never changes.
Limitations
- It does not replace an official lender payoff quote.
- It does not guarantee loan approval, a rate, or any specific terms.
- It does not include all possible fees by default, so it is not a full APR.
- Variable-rate and adjustable-rate loans behave differently once the rate changes.
- Revolving debt (credit cards) and tax or accounting treatment are not modeled.
- Results depend entirely on the values you enter.
What is not included: lender fees, escrow, property taxes, insurance, PMI, late payments, variable or changing interest rates, and lender-specific compounding or rounding rules, unless you build them into the amount, rate, term, or extra payments above.
Read the guides
For the amortization formula worked through step by step, see How to Calculate Monthly Loan Payments Before Borrowing.
For why early payments barely touch the balance, see How Amortization Works: Principal, Interest, and Loan Balance Explained.