0% found this document useful (0 votes)
129 views6 pages

Monthly Interest Calculation for Loan

The document calculates the monthly interest on a proposed term loan of Rs. 240 lakh at an annual interest rate of 8.85% over 10 years. It shows the opening balance, interest accrued, and installment amount paid on a monthly basis. The total interest accrued over the 10 year term is Rs. 97.94 lakh and the loan is paid off in equal monthly installments.

Uploaded by

Manoj Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
129 views6 pages

Monthly Interest Calculation for Loan

The document calculates the monthly interest on a proposed term loan of Rs. 240 lakh at an annual interest rate of 8.85% over 10 years. It shows the opening balance, interest accrued, and installment amount paid on a monthly basis. The total interest accrued over the 10 year term is Rs. 97.94 lakh and the loan is paid off in equal monthly installments.

Uploaded by

Manoj Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

CALCULATION OF MONTHLY INTEREST ON PROPOSED TERM LOAN

Term Loan (Rs. lakh) 240.00


Rate of Interest 8.85%

Date Opening Balance Repayment Closing Balance


1 1/10/2023 240.00 0.00 240.00
2 2/10/2023 240.00 0.00 240.00
3 3/10/2023 240.00 0.00 240.00
4 4/10/2023 240.00 0.00 240.00
5 5/10/2023 240.00 0.00 240.00
6 6/10/2023 240.00 0.00 240.00
7 7/10/2023 240.00 0.00 240.00
8 8/10/2023 240.00 0.00 240.00
9 9/10/2023 240.00 0.00 240.00
10 10/10/2023 240.00 0.00 240.00
11 11/10/2023 240.00 0.00 240.00
12 12/10/2023 240.00 0.00 240.00
13 1/10/2024 240.00 1.50 238.50
14 2/10/2024 238.50 1.50 237.00
15 3/10/2024 237.00 1.50 235.50
16 4/10/2024 235.50 1.50 234.00
17 5/10/2024 234.00 1.50 232.50
18 6/10/2024 232.50 1.50 231.00
19 7/10/2024 231.00 1.50 229.50
20 8/10/2024 229.50 1.50 228.00
21 9/10/2024 228.00 1.50 226.50
22 10/10/2024 226.50 1.50 225.00
23 11/10/2024 225.00 1.50 223.50
24 12/10/2024 223.50 1.50 222.00
25 1/10/2025 222.00 2.00 220.00
26 2/10/2025 220.00 2.00 218.00
27 3/10/2025 218.00 2.00 216.00
28 4/10/2025 216.00 2.00 214.00
29 5/10/2025 214.00 2.00 212.00
30 6/10/2025 212.00 2.00 210.00
31 7/10/2025 210.00 2.00 208.00
32 8/10/2025 208.00 2.00 206.00
33 9/10/2025 206.00 2.00 204.00
34 10/10/2025 204.00 2.00 202.00
35 11/10/2025 202.00 2.00 200.00
36 12/10/2025 200.00 2.00 198.00
37 1/10/2026 198.00 3.00 195.00
38 2/10/2026 195.00 3.00 192.00
39 3/10/2026 192.00 3.00 189.00
40 4/10/2026 189.00 3.00 186.00
41 5/10/2026 186.00 3.00 183.00
42 6/10/2026 183.00 3.00 180.00
43 7/10/2026 180.00 3.00 177.00
44 8/10/2026 177.00 3.00 174.00
45 9/10/2026 174.00 3.00 171.00
46 10/10/2026 171.00 3.00 168.00
47 11/10/2026 168.00 3.00 165.00
48 12/10/2026 165.00 3.00 162.00
49 1/10/2027 162.00 4.00 158.00
50 2/10/2027 158.00 4.00 154.00
51 3/10/2027 154.00 4.00 150.00
52 4/10/2027 150.00 4.00 146.00
53 5/10/2027 146.00 4.00 142.00
54 6/10/2027 142.00 4.00 138.00
55 7/10/2027 138.00 4.00 134.00
56 8/10/2027 134.00 4.00 130.00
57 9/10/2027 130.00 4.00 126.00
58 10/10/2027 126.00 4.00 122.00
59 11/10/2027 122.00 4.00 118.00
60 12/10/2027 118.00 4.00 114.00
61 1/10/2028 114.00 4.50 109.50
62 2/10/2028 109.50 4.50 105.00
63 3/10/2028 105.00 4.50 100.50
64 4/10/2028 100.50 4.50 96.00
65 5/10/2028 96.00 4.50 91.50
66 6/10/2028 91.50 4.50 87.00
67 7/10/2028 87.00 4.50 82.50
68 8/10/2028 82.50 4.50 78.00
69 9/10/2028 78.00 4.50 73.50
70 10/10/2028 73.50 4.50 69.00
71 11/10/2028 69.00 4.50 64.50
72 12/10/2028 64.50 4.50 60.00
73 1/10/2029 60.00 5.00 55.00
74 2/10/2029 55.00 5.00 50.00
75 3/10/2029 50.00 5.00 45.00
76 4/10/2029 45.00 5.00 40.00
77 5/10/2029 40.00 5.00 35.00
78 6/10/2029 35.00 5.00 30.00
79 7/10/2029 30.00 5.00 25.00
80 8/10/2029 25.00 5.00 20.00
81 9/10/2029 20.00 5.00 15.00
82 10/10/2029 15.00 5.00 10.00
83 11/10/2029 10.00 5.00 5.00
84 12/10/2029 5.00 5.00 0.00
Total 240.00
HLY INTEREST ON PROPOSED TERM LOAN
(Rs. lakh)

Interest on Closing Balance Annual Interest Annual Instalment


1.80
1.63
1.80
1.75
1.80
1.75
1.80
1.80
1.75
1.80
1.75
1.80 21.23 0.00
1.79
1.67
1.77
1.70
1.75
1.68
1.73
1.71
1.65
1.69
1.63
1.67 20.44 18.00
1.65
1.48
1.62
1.56
1.59
1.53
1.56
1.55
1.48
1.52
1.45
1.49 18.48 24.00
1.47
1.30
1.42
1.35
1.38
1.31
1.33
1.31
1.24
1.26
1.20
1.22 15.79 36.00
1.19
1.05
1.13
1.06
1.07
1.00
1.01
0.98
0.92
0.92
0.86
0.86 12.05 48.00
0.82
0.74
0.76
0.70
0.69
0.63
0.62
0.59
0.53
0.52
0.47
0.45 7.52 54.00
0.41
0.34
0.34
0.29
0.26
0.22
0.19
0.15
0.11
0.08
0.04
0.00 2.43 60.00
97.94 97.94 240.00

You might also like