Estimate a fixed-rate monthly loan instalment, total interest and repayment schedule. Enter the assumptions you want to test, calculate the result, and download the calculation and inputs as CSV.
Enter your assumptions
Fixed rate; monthly reducing balance. Payments occur at month-end. Fees, insurance, taxes, prepayments and floating-rate resets are excluded. The last instalment may differ because of lender rounding.
Your calculated scenario
Fixed rate; monthly reducing balance. Payments occur at month-end. Fees, insurance, taxes, prepayments and floating-rate resets are excluded. The last instalment may differ because of lender rounding.
Calculation method#
EMI = P × r × (1+r)^n ÷ ((1+r)^n − 1); at zero interest, EMI = P ÷ n. Monthly r = annual rate ÷ 12 ÷ 100.
Assumptions and limits#
Fixed rate; monthly reducing balance. Payments occur at month-end. Fees, insurance, taxes, prepayments and floating-rate resets are excluded. The last instalment may differ because of lender rounding.
For independent background, see the official RBI floating-rate loan guidance. The result is a numerical illustration, not a quotation, tax filing or recommendation to buy a product. Check actual lender, product or transaction terms before making a decision.
Using the result#
Change one input at a time to understand its effect. Keep the calculation period and rate basis consistent. The downloadable CSV records your inputs so another person can review the same scenario. Changing an input clears the previous result until you calculate again.
Explore the other free business tools and calculators or contact SigmaTenders for business compliance support.