ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Enter the loan informationUser Guide
3
Sanctioned Loan Amount*₹45,00,000.001. Use Loan Information Table to enter basic loan details, table below will be auto populated.
2. Disbursal Date and Amount you have to update so, further calculation will be updated
3. EMI Type and Date to be updated only when there's specific case , if you EMI is deducted on different day than your scheduled. Just update those cell only.
4. Surplus Date and Amount to be entered whenever you are putting or withdrawing. Withdrawals with (-) sign.
5. Use ROI column when there's change in ROI from specific day. This is again to override from basic information you added earlier.
6. EMI column (S column) will be auto populated based on ROI, you can also override this amount If bank has taken different amount because of any reason.
Please contact if any issue or suggestion at kapasitejas@gmail.com
4
Interest Rate* To obtained EMI9
5
Loan Tenure (months)*360.00
6
Estimated EMI₹36,209.00
7
Actual EMI*₹36,209.00Default value can be override by simply puttng your new interest rate.
8
EMI Start Date* (e)5-Nov-2022
9
Estimated Interest₹75,85,588.00At the End of the Month, Interest will be deducted from Available Balance.Update any EMI Amount directly if Bank has taken different amount other than schedule.
10
* required - do not leave blank
11
Read NoteConsider Closing loan when reaches 0
12
Original ScheduleActual Outstanding
13
Outstanding PrincipalSurplus + InterestM - N
14
MonthSBI MaxGain Home Loan
15
Disbursal DateDisbursal AmountEMI Payment
Type
EMI Payment
Date
Surplus Deposit /
Withdrawal Date
Surplus Deposit /
Withdrawal Amount
Estimated
Principal
Estimated
Interest (Just for Calculation)
Actual
Principal
Actual
Interest (Just For Calculation)
Drawing Power
(End of Day)
Available Balance
(End of Month)
Book Balance
(End of Month)
ROI at DayDaily Accured Interest for EMI (Calculation Only) Monthly Interest For the EMI (Actual)EMI Amount
16
Oct-202231-Oct-2022₹30,00,000.00₹0.00₹740.00₹0.00₹740.00₹45,00,000.00₹14,99,260.00-₹30,00,740.009₹740.00₹740.00₹0.00
17
1-Nov-2022₹0.00₹740.00₹0.00₹740.00₹45,00,000.00₹14,99,260.00-₹30,00,740.009₹740.00₹0.00₹0.00
18
2-Nov-2022₹0.00₹740.00₹0.00₹740.00₹45,00,000.00₹14,99,260.00-₹30,00,740.009₹1,480.00₹0.00₹0.00
19
3-Nov-20223-Nov-2022₹1,000.00₹0.00₹740.00₹0.00₹740.00₹45,00,000.00₹15,00,260.00-₹29,99,740.009₹2,220.00₹0.00₹0.00
20
4-Nov-2022₹0.00₹740.00₹0.00₹740.00₹45,00,000.00₹15,00,260.00-₹29,99,740.009₹2,960.00₹0.00₹0.00
21
5-Nov-2022EMI5-Nov-2022₹2,921.00₹731.00₹2,921.00₹731.00₹44,97,079.00₹15,33,548.00-₹29,63,531.009₹3,691.00₹0.00₹36,209.00
22
6-Nov-2022₹0.00₹731.00₹0.00₹731.00₹44,97,079.00₹15,33,548.00-₹29,63,531.009₹4,422.00₹0.00₹0.00
23
7-Nov-2022₹0.00₹731.00₹0.00₹731.00₹44,97,079.00₹15,33,548.00-₹29,63,531.009₹5,153.00₹0.00₹0.00
24
8-Nov-20228-Nov-2022₹5,00,000.00₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,33,548.00-₹34,63,531.009₹6,007.00₹0.00₹0.00
25
9-Nov-20229-Nov-2022₹1,000.00₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹6,861.00₹0.00₹0.00
26
10-Nov-2022₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹7,715.00₹0.00₹0.00
27
11-Nov-2022₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹8,569.00₹0.00₹0.00
28
12-Nov-2022₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹9,423.00₹0.00₹0.00
29
13-Nov-2022₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹10,277.00₹0.00₹0.00
30
14-Nov-2022₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹11,131.00₹0.00₹0.00
31
15-Nov-2022₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹11,985.00₹0.00₹0.00
32
16-Nov-2022₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹12,839.00₹0.00₹0.00
33
17-Nov-2022₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹13,693.00₹0.00₹0.00
34
18-Nov-2022₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹14,547.00₹0.00₹0.00
35
19-Nov-2022₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹15,401.00₹0.00₹0.00
36
20-Nov-2022₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹16,255.00₹0.00₹0.00
37
21-Nov-2022₹0.00₹854.00₹0.00₹854.00₹44,97,079.00₹10,34,548.00-₹34,62,531.009₹17,109.00₹0.00₹0.00
38
22-Nov-202222-Nov-2022₹10,00,000.00₹0.00₹1,100.00₹0.00₹1,100.00₹44,97,079.00₹34,548.00-₹44,62,531.009₹18,209.00₹0.00₹0.00
39
23-Nov-2022₹0.00₹1,100.00₹0.00₹1,100.00₹44,97,079.00₹34,548.00-₹44,62,531.009₹19,309.00₹0.00₹0.00
40
24-Nov-2022₹0.00₹1,100.00₹0.00₹1,100.00₹44,97,079.00₹34,548.00-₹44,62,531.009₹20,409.00₹0.00₹0.00
41
25-Nov-2022₹0.00₹1,100.00₹0.00₹1,100.00₹44,97,079.00₹34,548.00-₹44,62,531.009₹21,509.00₹0.00₹0.00
42
26-Nov-2022₹0.00₹1,100.00₹0.00₹1,100.00₹44,97,079.00₹34,548.00-₹44,62,531.009₹22,609.00₹0.00₹0.00
43
27-Nov-2022₹0.00₹1,100.00₹0.00₹1,100.00₹44,97,079.00₹34,548.00-₹44,62,531.009₹23,709.00₹0.00₹0.00
44
28-Nov-2022₹0.00₹1,100.00₹0.00₹1,100.00₹44,97,079.00₹34,548.00-₹44,62,531.009₹24,809.00₹0.00₹0.00
45
29-Nov-2022₹0.00₹1,100.00₹0.00₹1,100.00₹44,97,079.00₹34,548.00-₹44,62,531.009₹25,909.00₹0.00₹0.00
46
30-Nov-2022₹0.00₹1,100.00₹0.00₹1,100.00₹44,97,079.00₹7,539.00-₹44,89,540.009₹27,009.00₹27,009.00₹0.00
47
1-Dec-2022₹0.00₹1,107.00₹0.00₹1,107.00₹44,97,079.00₹7,539.00-₹44,89,540.009₹1,107.00₹0.00₹0.00
48
2-Dec-2022₹0.00₹1,107.00₹0.00₹1,107.00₹44,97,079.00₹7,539.00-₹44,89,540.009₹2,214.00₹0.00₹0.00
49
3-Dec-2022₹0.00₹1,107.00₹0.00₹1,107.00₹44,97,079.00₹7,539.00-₹44,89,540.009₹3,321.00₹0.00₹0.00
50
4-Dec-2022₹0.00₹1,107.00₹0.00₹1,107.00₹44,97,079.00₹7,539.00-₹44,89,540.009₹4,428.00₹0.00₹0.00
51
5-Dec-2022EMI5-Dec-2022₹1,834.00₹1,098.00₹1,834.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹5,526.00₹0.00₹36,209.00
52
6-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹6,624.00₹0.00₹0.00
53
7-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹7,722.00₹0.00₹0.00
54
8-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹8,820.00₹0.00₹0.00
55
9-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹9,918.00₹0.00₹0.00
56
10-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹11,016.00₹0.00₹0.00
57
11-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹12,114.00₹0.00₹0.00
58
12-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹13,212.00₹0.00₹0.00
59
13-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹14,310.00₹0.00₹0.00
60
14-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹15,408.00₹0.00₹0.00
61
15-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹16,506.00₹0.00₹0.00
62
16-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹17,604.00₹0.00₹0.00
63
17-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹18,702.00₹0.00₹0.00
64
18-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹19,800.00₹0.00₹0.00
65
19-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹20,898.00₹0.00₹0.00
66
20-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹21,996.00₹0.00₹0.00
67
21-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹23,094.00₹0.00₹0.00
68
22-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹24,192.00₹0.00₹0.00
69
23-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹25,290.00₹0.00₹0.00
70
24-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹26,388.00₹0.00₹0.00
71
25-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹27,486.00₹0.00₹0.00
72
26-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹28,584.00₹0.00₹0.00
73
27-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹29,682.00₹0.00₹0.00
74
28-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹30,780.00₹0.00₹0.00
75
29-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹31,878.00₹0.00₹0.00
76
30-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹41,914.00-₹44,53,331.009₹32,976.00₹0.00₹0.00
77
31-Dec-2022₹0.00₹1,098.00₹0.00₹1,098.00₹44,95,245.00₹7,840.00-₹44,87,405.009₹34,074.00₹34,074.00₹0.00
78
1-Jan-2023₹0.00₹1,106.00₹0.00₹1,106.00₹44,95,245.00₹7,840.00-₹44,87,405.009₹1,106.00₹0.00₹0.00
79
2-Jan-2023₹0.00₹1,106.00₹0.00₹1,106.00₹44,95,245.00₹7,840.00-₹44,87,405.009₹2,212.00₹0.00₹0.00
80
3-Jan-2023₹0.00₹1,106.00₹0.00₹1,106.00₹44,95,245.00₹7,840.00-₹44,87,405.009₹3,318.00₹0.00₹0.00
81
4-Jan-2023₹0.00₹1,106.00₹0.00₹1,106.00₹44,95,245.00₹7,840.00-₹44,87,405.009₹4,424.00₹0.00₹0.00
82
5-Jan-2023EMI5-Jan-2023₹1,848.00₹1,098.00₹1,848.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹5,522.00₹0.00₹36,209.00
83
6-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹6,620.00₹0.00₹0.00
84
7-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹7,718.00₹0.00₹0.00
85
8-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹8,816.00₹0.00₹0.00
86
9-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹9,914.00₹0.00₹0.00
87
10-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹11,012.00₹0.00₹0.00
88
11-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹12,110.00₹0.00₹0.00
89
12-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹13,208.00₹0.00₹0.00
90
13-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹14,306.00₹0.00₹0.00
91
14-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹15,404.00₹0.00₹0.00
92
15-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹16,502.00₹0.00₹0.00
93
16-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹17,600.00₹0.00₹0.00
94
17-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹18,698.00₹0.00₹0.00
95
18-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹19,796.00₹0.00₹0.00
96
19-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹20,894.00₹0.00₹0.00
97
20-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹21,992.00₹0.00₹0.00
98
21-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹23,090.00₹0.00₹0.00
99
22-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹24,188.00₹0.00₹0.00
100
23-Jan-2023₹0.00₹1,098.00₹0.00₹1,098.00₹44,93,397.00₹42,201.00-₹44,51,196.009₹25,286.00₹0.00₹0.00