0% found this document useful (0 votes)
65 views2 pages

Loan Amortization Schedule

The document outlines the details of a home loan of 700,000 with an interest rate of 8.25% and a tenure of 84 months. The monthly EMI is 10,998, with a total interest of 223,810 and a total payment of 923,810 over the loan period. An amortization table is provided, detailing monthly principal and interest payments, outstanding balance, and percentage of loan paid to date.

Uploaded by

Ghajendra Singh
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)
65 views2 pages

Loan Amortization Schedule

The document outlines the details of a home loan of 700,000 with an interest rate of 8.25% and a tenure of 84 months. The monthly EMI is 10,998, with a total interest of 223,810 and a total payment of 923,810 over the loan period. An amortization table is provided, detailing monthly principal and interest payments, outstanding balance, and percentage of loan paid to date.

Uploaded by

Ghajendra Singh
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
You are on page 1/ 2

Loan Details

Home Loan 700000


Interest Ra 8.25
Loan Tenur 84

Payment Summary
Loan EMI 10998
Total Inter 223810
Total Payme 923810

Loan Amortization Table


Month # Month & YPrincipal ( Interest (BTotal MontOutstandinLoan Paid To Date (%)
1 Apr-2025 6185 4813 10998 693815 0.88
2 May-2025 6228 4770 10998 687587 1.77
3 Jun-2025 6271 4727 10998 681316 2.67
4 Jul-2025 6314 4684 10998 675003 3.57
5 Aug-2025 6357 4641 10998 668646 4.48
6 Sep-2025 6401 4597 10998 662245 5.39
7 Oct-2025 6445 4553 10998 655800 6.31
8 Nov-2025 6489 4509 10998 649311 7.24
9 Dec-2025 6534 4464 10998 642777 8.17
10 Jan-2026 6579 4419 10998 636199 9.11
11 Feb-2026 6624 4374 10998 629575 10.06
12 Mar-2026 6669 4328 10998 622905 11.01
13 Apr-2026 6715 4282 10998 616190 11.97
14 May-2026 6761 4236 10998 609429 12.94
15 Jun-2026 6808 4190 10998 602621 13.91
16 Jul-2026 6855 4143 10998 595766 14.89
17 Aug-2026 6902 4096 10998 588864 15.88
18 Sep-2026 6949 4048 10998 581915 16.87
19 Oct-2026 6997 4001 10998 574918 17.87
20 Nov-2026 7045 3953 10998 567872 18.88
21 Dec-2026 7094 3904 10998 560779 19.89
22 Jan-2027 7142 3855 10998 553636 20.91
23 Feb-2027 7191 3806 10998 546445 21.94
24 Mar-2027 7241 3757 10998 539204 22.97
25 Apr-2027 7291 3707 10998 531913 24.01
26 May-2027 7341 3657 10998 524572 25.06
27 Jun-2027 7391 3606 10998 517181 26.12
28 Jul-2027 7442 3556 10998 509739 27.18
29 Aug-2027 7493 3504 10998 502246 28.25
30 Sep-2027 7545 3453 10998 494701 29.33
31 Oct-2027 7597 3401 10998 487104 30.41
32 Nov-2027 7649 3349 10998 479455 31.51
33 Dec-2027 7701 3296 10998 471754 32.61
34 Jan-2028 7754 3243 10998 463999 33.71
35 Feb-2028 7808 3190 10998 456192 34.83
36 Mar-2028 7861 3136 10998 448330 35.95
37 Apr-2028 7915 3082 10998 440415 37.08
38 May-2028 7970 3028 10998 432445 38.22
39 Jun-2028 8025 2973 10998 424420 39.37
40 Jul-2028 8080 2918 10998 416340 40.52
41 Aug-2028 8135 2862 10998 408205 41.68
42 Sep-2028 8191 2806 10998 400014 42.86
43 Oct-2028 8248 2750 10998 391766 44.03
44 Nov-2028 8304 2693 10998 383462 45.22
45 Dec-2028 8361 2636 10998 375100 46.41
46 Jan-2029 8419 2579 10998 366681 47.62
47 Feb-2029 8477 2521 10998 358205 48.83
48 Mar-2029 8535 2463 10998 349669 50.05
49 Apr-2029 8594 2404 10998 341076 51.27
50 May-2029 8653 2345 10998 332423 52.51
51 Jun-2029 8712 2285 10998 323710 53.76
52 Jul-2029 8772 2226 10998 314938 55.01
53 Aug-2029 8833 2165 10998 306106 56.27
54 Sep-2029 8893 2104 10998 297212 57.54
55 Oct-2029 8954 2043 10998 288258 58.82
56 Nov-2029 9016 1982 10998 279242 60.11
57 Dec-2029 9078 1920 10998 270164 61.41
58 Jan-2030 9140 1857 10998 261024 62.71
59 Feb-2030 9203 1795 10998 251821 64.03
60 Mar-2030 9266 1731 10998 242554 65.35
61 Apr-2030 9330 1668 10998 233224 66.68
62 May-2030 9394 1603 10998 223830 68.02
63 Jun-2030 9459 1539 10998 214371 69.38
64 Jul-2030 9524 1474 10998 204847 70.74
65 Aug-2030 9589 1408 10998 195257 72.11
66 Sep-2030 9655 1342 10998 185602 73.49
67 Oct-2030 9722 1276 10998 175880 74.87
68 Nov-2030 9789 1209 10998 166092 76.27
69 Dec-2030 9856 1142 10998 156236 77.68
70 Jan-2031 9924 1074 10998 146312 79.1
71 Feb-2031 9992 1006 10998 136320 80.53
72 Mar-2031 10061 937 10998 126260 81.96
73 Apr-2031 10130 868 10998 116130 83.41
74 May-2031 10199 798 10998 105931 84.87
75 Jun-2031 10269 728 10998 95661 86.33
76 Jul-2031 10340 658 10998 85321 87.81
77 Aug-2031 10411 587 10998 74910 89.3
78 Sep-2031 10483 515 10998 64427 90.8
79 Oct-2031 10555 443 10998 53873 92.3
80 Nov-2031 10627 370 10998 43245 93.82
81 Dec-2031 10700 297 10998 32545 95.35
82 Jan-2032 10774 224 10998 21771 96.89
83 Feb-2032 10848 150 10998 10923 98.44
84 Mar-2032 10923 75 10998 0 100

You might also like