[go: up one dir, main page]
Scribd
Upload
73 views3 pages

Monthly Amortization Schedule

The document shows a monthly amortization schedule for a loan amount of Rs. 9,75,000 over a period of 36 months. It displays the EMI amount of Rs. 31,050 that is paid each month, divided into principal and interest components. The principal amount increases each month while the interest amount decreases as the loan balance reduces over time, until the full amount is paid off by the 36th month.

Uploaded by

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

Monthly Amortization Schedule

The document shows a monthly amortization schedule for a loan amount of Rs. 9,75,000 over a period of 36 months. It displays the EMI amount of Rs. 31,050 that is paid each month, divided into principal and interest components. The principal amount increases each month while the interest amount decreases as the loan balance reduces over time, until the full amount is paid off by the 36th month.

Uploaded by

glideluxor
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Calculate Amortization

800k

600k
Amount

400k 372,602 372,601

200k

0
2017 2018

Inte re st P rincip le Ba la nce

Monthly Amortization Schedule

MONTH'S COUNT EMI INT PRIN LOAN AMOUNT

Aug-2018 1 31,050 7,394 23,656 9,51,344

Sep-2018 2 31,050 7,214 23,836 9,27,508

Oct-2018 3 31,050 7,034 24,017 9,03,491

Nov-2018 4 31,050 6,851 24,199 8,79,293

Dec-2018 5 31,050 6,668 24,382 8,54,910

Jan-2019 6 31,050 6,483 24,567 8,30,343

Feb-2019 7 31,050 6,297 24,753 8,05,590

Mar-2019 8 31,050 6,109 24,941 7,80,649


Apr-2019 9 31,050 5,920 25,130 7,55,519

May-2019 10 31,050 5,729 25,321 7,30,198

Jun-2019 11 31,050 5,537 25,513 7,04,685

Jul-2019 12 31,050 5,344 25,706 6,78,979

Aug-2019 13 31,050 5,149 25,901 6,53,078

Sep-2019 14 31,050 4,953 26,098 6,26,980

Oct-2019 15 31,050 4,755 26,296 6,00,684

Nov-2019 16 31,050 4,555 26,495 5,74,190

Dec-2019 17 31,050 4,354 26,696 5,47,494

Jan-2020 18 31,050 4,152 26,898 5,20,595

Feb-2020 19 31,050 3,948 27,102 4,93,493

Mar-2020 20 31,050 3,742 27,308 4,66,185

Apr-2020 21 31,050 3,535 27,515 4,38,670

May-2020 22 31,050 3,327 27,724 4,10,947

Jun-2020 23 31,050 3,116 27,934 3,83,013

Jul-2020 24 31,050 2,905 28,146 3,54,867

Aug-2020 25 31,050 2,691 28,359 3,26,508

Sep-2020 26 31,050 2,476 28,574 2,97,934

Oct-2020 27 31,050 2,259 28,791 2,69,143

Nov-2020 28 31,050 2,041 29,009 2,40,134

Dec-2020 29 31,050 1,821 29,229 2,10,905

Jan-2021 30 31,050 1,599 29,451 1,81,454


Feb-2021 31 31,050 1,376 29,674 1,51,780

Mar-2021 32 31,050 1,151 29,899 1,21,881

Apr-2021 33 31,050 924 30,126 91,755

May-2021 34 31,050 696 30,354 61,401

Jun-2021 35 31,050 466 30,585 30,816

Jul-2021 36 31,050 234 30,816 0

11,17,805 1,42,805 9,75,000

Privacy Security Website usage terms Sitemap

You might also like