Calculation - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Calculation

Author

Topic

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-06-16 : 06:42:04

Dear All,

This is the EMI Calculation Sp,

Please Verify my thought
/*
Created By KK
On 2006-06-15
*/
Create procedure sp_emi_calc
(
@loan_amount numeric(10,2) = 10000, -- Default Values
@rate numeric(10,2) = 250,
@year numeric(10,2) = 5
)
AS
BEGIN
DECLARE
@divide1 numeric(10,2) ,
@divide2 numeric(10,2) ,
@divide numeric(10,2) ,
@emi numeric(10,2)

SELECT @rate = (@rate /100.00)
SELECT @divide1 = power ( 1+@rate ,@year)
SELECT @divide2 = power ( 1+@rate ,@year)-1

SELECT @divide = (@divide1/@divide2)
SELECT @divide = @divide/12

SELECT @emi = @divide *@loan_amount *@rate

SELECT
@emi AS EMI ,
@loan_amount AS Loan_Amount,
@emi * 12 *@year AS Total_Amount,
(@emi * 12 *@year) - @loan_amount AS Interest_Amount

SELECT
@loan_amount/ (12.00 *@YEAR) AS Principal_Amount,
((@EMI * 12.00 *@YEAR) - @loan_amount )/(12.00 *@YEAR) AS Interest_Amount

END

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources