CODEWITHSUNDEEP
sql-server-2012
NonProgrammer
NonProgrammer

Reputation: 1387

Calculate amount after interest over time SQL Server 2012

Initial Amount = $100
Interest Rate = 5%
Number of years = 3

Total Amount = $115.76

How would I calculate this in Sql Server?

Upvotes: 1

Views: 30

Answers (1)

NonProgrammer
NonProgrammer

Reputation: 1387

Here's how I calculated total amount:

DECLARE @Current_LeaseEndDate DATE = '01/31/2021'  --3 Years
DECLARE @PercentIncrease  FLOAT = .05
DECLARE @Principal FLOAT = 100

SELECT 
YEAR(DATEADD(day, 1, CAST(@Current_LeaseEndDate AS VARCHAR(10))) + 1),
CASE WHEN YEAR(DATEADD(day, 1, CAST(@Current_LeaseEndDate AS VARCHAR(10))) + 1) >= YEAR(GETDATE())
        THEN @Principal * POWER((1 + @PercentIncrease), YEAR(DATEADD(day, 1, CAST(@Current_LeaseEndDate AS VARCHAR(10))) + 1) - YEAR(GETDATE()))
        END AS MEH

Upvotes: 1

Related Questions