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.
આ schedule bank-ready ફાઇલમાં જોઈએ છે?
અમે તૈયાર કરીએ તે દરેક project report માં આ જ working હોય છે, તમારા projections અને covenants સાથે જોડાયેલ.