Calculating Compounded Value

				
--**************************************
-- Name: Calculating Compounded Value
-- Description:Code to calculate the compounded Value
===================================
Often we are faced with situations wherein we want to calculate the compounded value of an invested amount at some specific rate of interest per year for some specific number of years. I was faced with such situation hence developed this code for this purpose.
Example say Rs 10,000.00 is invested for 3 years @ 8% per annum interest given by goverment bank. What will be the value of invested amount after 3 years. Below the code for the same. Please vote my code.
-- By: Dinesh Mishra
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=1383&lngWId=5--for details.--**************************************

Declare @PresentVal Money
Declare @InterestRate float
Declare @Years Tinyint
Set @PresentVal =10000
Set @InterestRate=(8.00/100)
Set @Years=3
select @PresentVal*power((1+(@InterestRate)),@Years)