EMI
₹40,280.00per month
Monthly installment that you will have to pay for 240 Months
₹40,280.00per month
Monthly installment that you will have to pay for 240 Months
₹4,667,118.00
This is the total amount of interest you will be paying during the loan tenure
₹1,107,969.00
The amount you will save from not paying income tax if you are in 30% income tax bracket
₹9,667,118.00
This is the total amount of interest you will be paying during the loan tenure
| Year | Opening Balance | EMI * 12 | Interest paid yearly | Principal paid yearly | Tax Saved yearly | Carry forward Loss | Closing balance |
|---|---|---|---|---|---|---|---|
| 1 | ₹5,000,000.00 | ₹483,356.00 | ₹371,197.00 | ₹112,159.00 | ₹60,000.00 | -₹171,197.00 | ₹4,887,841.00 |
| 2 | ₹4,887,841.00 | ₹483,356.00 | ₹362,489.00 | ₹120,867.00 | ₹60,000.00 | -₹333,686.00 | ₹4,766,974.00 |
| 3 | ₹4,766,974.00 | ₹483,356.00 | ₹353,106.00 | ₹130,250.00 | ₹60,000.00 | -₹486,792.00 | ₹4,636,724.00 |
| 4 | ₹4,636,724.00 | ₹483,356.00 | ₹342,995.00 | ₹140,361.00 | ₹60,000.00 | -₹629,787.00 | ₹4,496,363.00 |
| 5 | ₹4,496,363.00 | ₹483,356.00 | ₹332,098.00 | ₹151,258.00 | ₹60,000.00 | -₹761,885.00 | ₹4,345,105.00 |
| 6 | ₹4,345,105.00 | ₹483,356.00 | ₹320,355.00 | ₹163,001.00 | ₹60,000.00 | -₹882,240.00 | ₹4,182,104.00 |
| 7 | ₹4,182,104.00 | ₹483,356.00 | ₹307,701.00 | ₹175,655.00 | ₹60,000.00 | -₹989,941.00 | ₹4,006,450.00 |
| 8 | ₹4,006,450.00 | ₹483,356.00 | ₹294,065.00 | ₹189,291.00 | ₹60,000.00 | -₹1,084,006.00 | ₹3,817,158.00 |
| 9 | ₹3,817,158.00 | ₹483,356.00 | ₹279,369.00 | ₹203,986.00 | ₹60,000.00 | -₹992,179.00 | ₹3,613,172.00 |
| 10 | ₹3,613,172.00 | ₹483,356.00 | ₹263,534.00 | ₹219,822.00 | ₹60,000.00 | -₹893,223.00 | ₹3,393,350.00 |
| 11 | ₹3,393,350.00 | ₹483,356.00 | ₹246,468.00 | ₹236,888.00 | ₹60,000.00 | -₹786,585.00 | ₹3,156,462.00 |
| 12 | ₹3,156,462.00 | ₹483,356.00 | ₹228,078.00 | ₹255,278.00 | ₹60,000.00 | -₹671,668.00 | ₹2,901,184.00 |
| 13 | ₹2,901,184.00 | ₹483,356.00 | ₹208,260.00 | ₹275,096.00 | ₹60,000.00 | -₹547,830.00 | ₹2,626,088.00 |
| 14 | ₹2,626,088.00 | ₹483,356.00 | ₹186,904.00 | ₹296,452.00 | ₹60,000.00 | -₹427,475.00 | ₹2,329,636.00 |
| 15 | ₹2,329,636.00 | ₹483,356.00 | ₹163,889.00 | ₹319,467.00 | ₹60,000.00 | -₹319,774.00 | ₹2,010,169.00 |
| 16 | ₹2,010,169.00 | ₹483,356.00 | ₹139,088.00 | ₹344,268.00 | ₹60,000.00 | -₹225,709.00 | ₹1,665,901.00 |
| 17 | ₹1,665,901.00 | ₹483,356.00 | ₹112,362.00 | ₹370,994.00 | ₹60,000.00 | -₹138,071.00 | ₹1,294,907.00 |
| 18 | ₹1,294,907.00 | ₹483,356.00 | ₹83,561.00 | ₹399,795.00 | ₹60,000.00 | -₹21,631.00 | ₹895,112.00 |
| 19 | ₹895,112.00 | ₹483,356.00 | ₹52,523.00 | ₹430,833.00 | ₹22,246.00 | -₹0.00 | ₹464,279.00 |
| 20 | ₹464,279.00 | ₹483,356.00 | ₹19,077.00 | ₹464,279.00 | ₹5,723.00 | -₹0.00 | ₹0.00 |