Loan tools · live worksheet
Your quarterly repayment schedule, calculated live.
Type into the four green cells at the top of the sheet — loan amount, rate, tenure and any principal moratorium — and the whole working recalculates itself, exactly as it does in the project-report file.
Principal / quarter · ₹ lakh—
Total interest · ₹ lakh—
Total repayment · ₹ lakh—
Instalment by quarter
PrincipalInterest (3 mo)
₹ All amounts in Lakh — so the columns stay readable at any scale. For example, ₹1,12,500 is shown as 1.13.
YearQuarterLoan AmountRateInterest (3 mo)PrincipalInstalmentBalance Due
Equal-principal method · interest = opening balance × rate × 3÷12 each quarter · schedule figures shown in ₹ lakh, rounded to 2 decimals · indicative, not an offer of finance.
Want this schedule inside a bank-ready file?
The same working sits inside every project report we prepare, tied to your projections and covenants.