•Reducing Balance Financial Engine
Loan EMI & Prepayment Amortization Schedule
Generate full month-by-month loan amortization tables with lump-sum & recurring prepayment interest-saving simulations.
Monthly EMI
₹1,03,186
Reducing-balance monthly outflow
Total Interest Payable
₹9,97,265
Base: ₹11,91,172
Interest Saved
₹1,93,907
Via early capital prepayment
Months Saved
7 Months
Payoff: 54 of 60 mos
Loan Parameters
Prepayment Simulator
Tenure Acceleration:-7 Months
Interest Reduction:₹1,93,907
Connected with Turia
Supercharge this with Turia Practice
Turia Practice tracks client loan sanction letters, EMI debit dates, and bank interest certificates (Form 26AS/AIS) automatically.
Auto-file in Client Vault by FY
WhatsApp Client Dispatch
Task Auto-advancement
No credit card required • Instant setup
Statutory & Compliance Disclaimer
This tool is an automated calculation, formatting, and compliance aid provided for informational purposes only. It does not constitute formal legal, taxation, or professional auditing advice. Calculations, citations, and draft documents must be independently verified by a qualified Chartered Accountant (CA) or Company Secretary (CS) against statutory provisions and applicable ICAI/ICSI guidelines before execution or certification.
Chartered Accountant Loan Working Paper54 Instalments
Loan Amortization & Debt Repayment Schedule
Borrower: Modern Buildcon LLP•Principal: ₹50,00,000•ROI: 8.75% p.a.
| # | Date | Opening (₹) | EMI (₹) | Principal | Interest | Prepay | Closing (₹) |
|---|---|---|---|---|---|---|---|
| 1 | Apr 2026 | 50,00,000 | 1,03,186 | 66,728 | 36,458 | -- | 49,33,272 |
| 2 | May 2026 | 49,33,272 | 1,03,186 | 67,214 | 35,972 | -- | 48,66,058 |
| 3 | Jun 2026 | 48,66,058 | 1,03,186 | 67,704 | 35,482 | -- | 47,98,354 |
| 4 | Jul 2026 | 47,98,354 | 1,03,186 | 68,198 | 34,988 | -- | 47,30,156 |
| 5 | Aug 2026 | 47,30,156 | 1,03,186 | 68,695 | 34,491 | -- | 46,61,461 |
| 6 | Sept 2026 | 46,61,461 | 1,03,186 | 69,196 | 33,990 | -- | 45,92,265 |
| 7 | Oct 2026 | 45,92,265 | 1,03,186 | 69,701 | 33,485 | -- | 45,22,564 |
| 8 | Nov 2026 | 45,22,564 | 1,03,186 | 70,209 | 32,977 | -- | 44,52,355 |
| 9 | Dec 2026 | 44,52,355 | 1,03,186 | 70,721 | 32,465 | -- | 43,81,634 |
| 10 | Jan 2027 | 43,81,634 | 1,03,186 | 71,237 | 31,949 | -- | 43,10,397 |
| 11 | Feb 2027 | 43,10,397 | 1,03,186 | 71,756 | 31,430 | -- | 42,38,641 |
| 12 | Mar 2027 | 42,38,641 | 1,03,186 | 72,279 | 30,907 | 5,00,000 | 36,66,362 |
| 13 | Apr 2027 | 36,66,362 | 1,03,186 | 76,452 | 26,734 | -- | 35,89,910 |
| 14 | May 2027 | 35,89,910 | 1,03,186 | 77,010 | 26,176 | -- | 35,12,900 |
| 15 | Jun 2027 | 35,12,900 | 1,03,186 | 77,571 | 25,615 | -- | 34,35,329 |
| 16 | Jul 2027 | 34,35,329 | 1,03,186 | 78,137 | 25,049 | -- | 33,57,192 |
| 17 | Aug 2027 | 33,57,192 | 1,03,186 | 78,706 | 24,480 | -- | 32,78,486 |
| 18 | Sept 2027 | 32,78,486 | 1,03,186 | 79,280 | 23,906 | -- | 31,99,206 |
| 19 | Oct 2027 | 31,99,206 | 1,03,186 | 79,858 | 23,328 | -- | 31,19,348 |
| 20 | Nov 2027 | 31,19,348 | 1,03,186 | 80,441 | 22,745 | -- | 30,38,907 |
| 21 | Dec 2027 | 30,38,907 | 1,03,186 | 81,027 | 22,159 | -- | 29,57,880 |
| 22 | Jan 2028 | 29,57,880 | 1,03,186 | 81,618 | 21,568 | -- | 28,76,262 |
| 23 | Feb 2028 | 28,76,262 | 1,03,186 | 82,213 | 20,973 | -- | 27,94,049 |
| 24 | Mar 2028 | 27,94,049 | 1,03,186 | 82,813 | 20,373 | -- | 27,11,236 |
| 25 | Apr 2028 | 27,11,236 | 1,03,186 | 83,417 | 19,769 | -- | 26,27,819 |
| 26 | May 2028 | 26,27,819 | 1,03,186 | 84,025 | 19,161 | -- | 25,43,794 |
| 27 | Jun 2028 | 25,43,794 | 1,03,186 | 84,638 | 18,548 | -- | 24,59,156 |
| 28 | Jul 2028 | 24,59,156 | 1,03,186 | 85,255 | 17,931 | -- | 23,73,901 |
| 29 | Aug 2028 | 23,73,901 | 1,03,186 | 85,876 | 17,310 | -- | 22,88,025 |
| 30 | Sept 2028 | 22,88,025 | 1,03,186 | 86,502 | 16,684 | -- | 22,01,523 |
| 31 | Oct 2028 | 22,01,523 | 1,03,186 | 87,133 | 16,053 | -- | 21,14,390 |
| 32 | Nov 2028 | 21,14,390 | 1,03,186 | 87,769 | 15,417 | -- | 20,26,621 |
| 33 | Dec 2028 | 20,26,621 | 1,03,186 | 88,409 | 14,777 | -- | 19,38,212 |
| 34 | Jan 2029 | 19,38,212 | 1,03,186 | 89,053 | 14,133 | -- | 18,49,159 |
| 35 | Feb 2029 | 18,49,159 | 1,03,186 | 89,703 | 13,483 | -- | 17,59,456 |
| 36 | Mar 2029 | 17,59,456 | 1,03,186 | 90,357 | 12,829 | -- | 16,69,099 |
| 37 | Apr 2029 | 16,69,099 | 1,03,186 | 91,015 | 12,171 | -- | 15,78,084 |
| 38 | May 2029 | 15,78,084 | 1,03,186 | 91,679 | 11,507 | -- | 14,86,405 |
| 39 | Jun 2029 | 14,86,405 | 1,03,186 | 92,348 | 10,838 | -- | 13,94,057 |
| 40 | Jul 2029 | 13,94,057 | 1,03,186 | 93,021 | 10,165 | -- | 13,01,036 |
| 41 | Aug 2029 | 13,01,036 | 1,03,186 | 93,699 | 9,487 | -- | 12,07,337 |
| 42 | Sept 2029 | 12,07,337 | 1,03,186 | 94,383 | 8,803 | -- | 11,12,954 |
| 43 | Oct 2029 | 11,12,954 | 1,03,186 | 95,071 | 8,115 | -- | 10,17,883 |
| 44 | Nov 2029 | 10,17,883 | 1,03,186 | 95,764 | 7,422 | -- | 9,22,119 |
| 45 | Dec 2029 | 9,22,119 | 1,03,186 | 96,462 | 6,724 | -- | 8,25,657 |
| 46 | Jan 2030 | 8,25,657 | 1,03,186 | 97,166 | 6,020 | -- | 7,28,491 |
| 47 | Feb 2030 | 7,28,491 | 1,03,186 | 97,874 | 5,312 | -- | 6,30,617 |
| 48 | Mar 2030 | 6,30,617 | 1,03,186 | 98,588 | 4,598 | -- | 5,32,029 |
| 49 | Apr 2030 | 5,32,029 | 1,03,186 | 99,307 | 3,879 | -- | 4,32,722 |
| 50 | May 2030 | 4,32,722 | 1,03,186 | 1,00,031 | 3,155 | -- | 3,32,691 |
| 51 | Jun 2030 | 3,32,691 | 1,03,186 | 1,00,760 | 2,426 | -- | 2,31,931 |
| 52 | Jul 2030 | 2,31,931 | 1,03,186 | 1,01,495 | 1,691 | -- | 1,30,436 |
| 53 | Aug 2030 | 1,30,436 | 1,03,186 | 1,02,235 | 951 | -- | 28,201 |
| 54 | Sept 2030 | 28,201 | 28,407 | 28,201 | 206 | -- | 0 |
| Grand Totals | -- | ₹59,97,265 | ₹50,00,000 | ₹9,97,265 | -- | 0 | |