EMI calculations

Question

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

Bhuvanesh Mohankumar · Answer

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.

Shakti Singh Dulawat · Answer

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/