EMI calculations

venkatesh duddukuri

10y904SQL

This is the formula to caluculate:

E = P×r×(1 + r)ⁿ/((1 + r)ⁿ - 1)

E is EMI

where P is Priniple Loan Amount

r is rate of interest calualted in monthly basis it should be = Rate of Annual interest/12/100

if its 10% annual ,then its 10/12/100=0.00833

n is tenture in number of months

Eg: For 100000 at 10% annual interest for a period of 12 months

it comes to 100000*0.00833*(1 + 0.00833)¹²/((1 + 0.00833)¹² - 1) = 8792

Please send me stored procedure program in sql

Thanks and regards

Venkatesh D

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhuvanesh Mohankumar10y ago
This may help you,
Suppose I havea string named @vcFormula that contains the following:
"@dVar1 + @dVar2 / @dVar2"

Now supposeI have a variable named@dVar1 thatcontains a value of 1.0, and variable @dVar2 contains a value of 2.5. I can use the REPLACE function to change my original string to look like this:
"1.0 + 2.5 / 2.5"

Now I want to execute this string and find the numeric result, placing it in a variable named @dResult. The following works, but presents a problem:

CREATE TABLE #Result (dResult decimal(20, 10))
INSERT #Result EXEC('SELECT ' + @vcFormula)
SELECT @dResult = dResult FROM #Result
Refrence:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e0b7dfa9-8253-406b-9215-190b64859de0/using-exec-to-execute-a-formula-stored-in-a-string?forum=transactsql
Accept answer, if it was helpful.
0
Shakti Singh Dulawat10y ago
We have one of the post available it will help you http://www.c-sharpcorner.com/UploadFile/a85b23/how-to-make-emi-for-loan-in-sql-server/
0