ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
HOME LOAN REPAYMENT STRATEGY — INTERACTIVE CALCULATOR
3
CA Shankar Pawar | Finovaa Solutions | AMFI-Registered Mutual Fund Distributor (ARN: 326614)
4
5
6
What this workbook contains
7
This workbook compares four home loan repayment strategies on a ₹1,00,00,000 illustrative loan: (1) Base Case — standard EMI only, (2) one extra EMI paid every year, (3) EMI stepped up 10% every year, and (4) both combined.
8
9
How to use it
10
Each scenario has its own sheet with an Inputs box (blue text, gold fill) — Loan Amount, Interest Rate, and Tenure can be edited there. All EMI, interest, and balance figures recalculate automatically using formulas.
11
A Year-Wise Summary table sits at the top of each sheet for quick reading. The full Monthly Amortization Schedule (240 rows) below it is the calculation engine — you don't need to read it row by row.
12
The '5. Comparison Dashboard' sheet pulls the key results (tenure, total interest, savings) from all four sheets side by side.
13
14
Colour legend
15
Blue bold text on gold fill = editable input cell.
16
Black text = formula-calculated (do not overtype).
17
Gold-shaded rows/cells in results = headline numbers worth highlighting to a client.
18
19
Assumptions used in the illustrative example
20
Loan Amount: ₹1,00,00,000 | Interest Rate: 8.5% p.a. (floating, illustrative) | Tenure: 20 years (240 months)
21
Extra-EMI scenario: one additional EMI-equivalent payment applied to principal at the end of each policy year (month 12, 24, 36...).
22
Step-up scenario: EMI increases by 10% at the start of each subsequent year, applied to the outstanding reducing balance.
23
RBI regulation note: banks/NBFCs cannot levy foreclosure or prepayment charges on floating-rate home loans taken by individual borrowers for non-business purposes (RBI circulars of 2012/2014, reinforced and widened by the RBI (Pre-payment Charges on Loans) Directions, 2025, effective for loans sanctioned/renewed on or after 1 January 2026).
24
25
Important note
26
This workbook is for educational purposes only and does not constitute investment, loan, or tax advice. CA Shankar Pawar is an AMFI-Registered Mutual Fund Distributor (ARN: 326614) under Finovaa Solutions, distributed via Prudent Corporate Advisory Services Ltd. (ARN-163501) through the ZFunds platform, and is NOT a SEBI-Registered Investment Adviser. Figures are illustrative; please verify against your actual loan statement and consult your bank/financial advisor before making any prepayment decision.
27
28
Internal Use Only — Not for Client Distribution without accompanying compliance disclaimer.
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100