સોમ–શનિ · સવારે 10:30 – સાંજે 07:30 Firm Regn. No. 107147રિંગ રોડ, સુરત+91 98250 56839
CA India Ankit Shah and Co. Chartered Accountants

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.

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.

₹ All amounts in Lakh  —  so the columns stay readable at any scale. For example, ₹1,12,500 is shown as 1.13.

મારી લોન વિશે ચર્ચા કરો →
PROJECT REPORT — loanint.xlsx ₹ IN LAKH · 2 DP
C4 fx = Opening balance × Rate × 3 ÷ 12
A
B
C
D
E
F
G
H
1
Calculation of interest on Bank Loan
2
3
Assumptions
Loan Amount (₹)
Rate %
Tenure (yrs)
Moratorium (q)
4
5
6
Year
Quarter
Loan Amount
Rate
Interest (3 mo)
Principal
Instalment
Balance Due
loanint +

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.

← Project Finance પર પાછા જાઓ