How Can I Do Every Month Installment Calculations In Grid Or Using Other Controls

See more:

C#

ASP.NET

SQL-Server-2008R2

I have a registration form in that ,it contains

Name
Type(chit,EMI,...)
Amount(1Lac,2Lac...)
NoOfMonths(12,24,...)
MonthlyPay(automatically comes based on selection of above type,amount,no of months)
Start date
EndDate(calculated automatically based no of months)

i have saved these details in database and binded to grid view

Now i want payment form for this details
That is like if user pay installment show due amount zero,
if he not paid show due amount, if member not paid installment for 2 months show 2 months due
(for Ex.if monthly pay is 3000 for 2 months due is 6000 it should increment based on number of months and start,end date)

can you please give me any sample emi calculation links or suggest me how to do this

if you want i will attach code



Thanks in Advance

Regards
Naresh B