Calculation of amount of Discount to be written off every year:
Period | Year End | Outstanding Amount (Rs.) | Months Used | Product | Ratio | Discount | Total Discount to be written off |
2013-14 | 31st March, 2014 | 20,00,000 | 9 | 1,80,00,000 | 180 | 30,000 | |
2014-15 | 30th June, 2014 | 20,00,000 | 3 | 60,00,000 | 60 | ||
31st March, 2015 | 16,00,000 | 9 | 1,44,00,000 | 144 | 34,000 | ||
2015-16 | 30th June, 2015 | 16,00,000 | 3 | 48,00,000 | 48 | ||
31st March, 2016 | 12,00,000 | 9 | 1,08,00,000 | 108 | 26,000 | ||
2016-17 | 30th June, 2016 | 12,00,000 | 3 | 36,00,000 | 36 | ||
31st March, 2017 | 8,00,000 | 9 | 72,00,000 | 72 | 18,000 | ||
2017-18 | 30th June, 2017 | 8,00,000 | 3 | 24,00,000 | 24 | ||
31st March, 2018 | 4,00,000 | 9 | 36,00,000 | 36 | 10,000 | ||
2018-19 | 30th June, 2018 | 4,00,000 | 3 | 12,00,000 | 12 | 2,000 | |
Total | 7,20,00,000 | 720 | 1,20,000 | 1,20,000 |