EMI calculator including GST

300°
Crowdpuller
roXtar007

I have credit cards. In the past many times my friends and relatives requested me to buy some products on EMI for them and I agreed to some of them to do so. But one problem I faced each time was that the EMI installment which was mentioned during purchase was without GST, but when the bill comes I need to sum the EMI amount and the GST amount each month to them.

I searched and tried many EMI calculators, but none of them includes GST amount. (Tell me if you know any) 

So I made this Excel sheet by which I can calculate the exact Installments for every month and the extra amont which I need to pay including GST.

I also included a interest percentage calculator with it so I can calculate the percentage of any running EMI.

It'll be also useful for me to calculate the exact extra cost if I ever need to buy something on EMI.(Though I never purchased anything on EMI and I also avoid buying)

So, I'm sharing this sheet with you guys. Maybe it can be useful for you too.

https://docs.google.com/spreadsheets/d/1wEQDkDp...

Disclaimer
We are not SEBI/IRDA registered. The information provided herein is for education purposes only. We will not be responsible for any of your profit/loss with this channel's suggestions. Consult your financial advisor before making any decisions.
10 Comments  |  
4 Dimers
  • Sort By
Crowdpuller Crowdpuller
Link Copied

Download the sheet from file option as .xlsx format and use

Critic Critic
Link Copied

vu + kg 

Crowdpuller Crowdpuller
Link Copied

image

Benevolent Benevolent
Link Copied

good post. is it possible to edit the emi amount and thereby the number of transactions increases automatically accordingly?

Crowdpuller Crowdpuller
Link Copied
Please clarify. Do you want to check that by reducing EMI amount to a specific value, how many months will it take to complete the loan?
View 2 more replies
Deal Cadet Deal Cadet
Link Copied

VU .Do include processing fee + GST if possible :) 

Crowdpuller Crowdpuller
Link Copied

Good suggestion,  ok will include that..  Thanks..

View 1 more reply
replyuser
Click here to reply
Reply