Loan repayment schedule for 50 cows dairy farm project
Bank Loan= 3862500 ,grace period = 6 months Interest rate= 12% ,Bank loan at the end of grace period =3862500+231750=4094250
| S.No | Monthly Installment | Interest | Principal | Balance |
| 0 | 4094250 | |||
| 1 | 80043 | 40943 | 39101 | 4055149 |
| 2 | 80043 | 40551 | 39492 | 4015657 |
| 3 | 80043 | 40157 | 39887 | 3975770 |
| 4 | 80043 | 39758 | 40286 | 3935485 |
| 5 | 80043 | 39355 | 40689 | 3894796 |
| 6 | 80043 | 38948 | 41095 | 3853701 |
| 7 | 80043 | 38537 | 41506 | 3812194 |
| 8 | 80043 | 38122 | 41921 | 3770273 |
| 9 | 80043 | 37703 | 42341 | 3727932 |
| 10 | 80043 | 37279 | 42764 | 3685168 |
| 11 | 80043 | 36852 | 43192 | 3641977 |
| 12 | 80043 | 36420 | 43624 | 3598353 |
| 13 | 80043 | 35984 | 44060 | 3554293 |
| 14 | 80043 | 35543 | 44500 | 3509793 |
| 15 | 80043 | 35098 | 44945 | 3464847 |
| 16 | 80043 | 34648 | 45395 | 3419452 |
| 17 | 80043 | 34195 | 45849 | 3373604 |
| 18 | 80043 | 33736 | 46307 | 3327296 |
| 19 | 80043 | 33273 | 46770 | 3280526 |
| 20 | 80043 | 32805 | 47238 | 3233288 |
| 21 | 80043 | 32333 | 47710 | 3185577 |
| 22 | 80043 | 31856 | 48188 | 3137390 |
| 23 | 80043 | 31374 | 48669 | 3088720 |
| 24 | 80043 | 30887 | 49156 | 3039564 |
| 25 | 80043 | 30396 | 49648 | 2989916 |
| 26 | 80043 | 29899 | 50144 | 2939772 |
| 27 | 80043 | 29398 | 50646 | 2889126 |
| 28 | 80043 | 28891 | 51152 | 2837974 |
| 29 | 80043 | 28380 | 51664 | 2786311 |
| 30 | 80043 | 27863 | 52180 | 2734130 |
| 31 | 80043 | 27341 | 52702 | 2681428 |
| 32 | 80043 | 26814 | 53229 | 2628199 |
| 33 | 80043 | 26282 | 53761 | 2574438 |
| 34 | 80043 | 25744 | 54299 | 2520139 |
| 35 | 80043 | 25201 | 54842 | 2465297 |
| 36 | 80043 | 24653 | 55390 | 2409906 |
| 37 | 80043 | 24099 | 55944 | 2353962 |
| 38 | 80043 | 23540 | 56504 | 2297458 |
| 39 | 80043 | 22975 | 57069 | 2240389 |
| 40 | 80043 | 22404 | 57639 | 2182750 |
| 41 | 80043 | 21827 | 58216 | 2124534 |
| 42 | 80043 | 21245 | 58798 | 2065736 |
| 43 | 80043 | 20657 | 59386 | 2006350 |
| 44 | 80043 | 20064 | 59980 | 1946370 |
| 45 | 80043 | 19464 | 60580 | 1885791 |
| 46 | 80043 | 18858 | 61185 | 1824605 |
| 47 | 80043 | 18246 | 61797 | 1762808 |
| 48 | 80043 | 17628 | 62415 | 1700392 |
| 49 | 80043 | 17004 | 63039 | 1637353 |
| 50 | 80043 | 16374 | 63670 | 1573683 |
| 51 | 80043 | 15737 | 64307 | 1509377 |
| 52 | 80043 | 15094 | 64950 | 1444427 |
| 53 | 80043 | 14444 | 65599 | 1378828 |
| 54 | 80043 | 13788 | 66255 | 1312573 |
| 55 | 80043 | 13126 | 66918 | 1245655 |
| 56 | 80043 | 12457 | 67587 | 1178068 |
| 57 | 80043 | 11781 | 68263 | 1109806 |
| 58 | 80043 | 11098 | 68945 | 1040860 |
| 59 | 80043 | 10409 | 69635 | 971226 |
| 60 | 80043 | 9712 | 70331 | 900894 |
| 61 | 80043 | 9009 | 71034 | 829860 |
| 62 | 80043 | 8299 | 71745 | 758115 |
| 63 | 80043 | 7581 | 72462 | 685653 |
| 64 | 80043 | 6857 | 73187 | 612466 |
| 65 | 80043 | 6125 | 73919 | 538547 |
| 66 | 80043 | 5385 | 74658 | 463890 |
| 67 | 80043 | 4639 | 75404 | 388485 |
| 68 | 80043 | 3885 | 76159 | 312326 |
| 69 | 80043 | 3123 | 76920 | 235406 |
| 70 | 80043 | 2354 | 77689 | 157717 |
| 71 | 80043 | 1577 | 78466 | 79251 |
| 72 | 80043 | 793 | 79251 | 0 |