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 2005 Forums  Transact-SQL (2005)  Future Value of a Loan

Author  Topic  Les.61 Starting Member 49 Posts Posted - 2009-11-25 : 17:51:54 I was wondering if anyone has been able to write a script that will show a future value of a loan based on the following: PV = Present Value I = Interest Rate REPAY = Monthly Repayment Interest is charged monthly I need to be able to show what the balance will be each month from 1 to 24 months. I also have to build in the fact that some loans are interest only and have a term of less then 24 months which is based on a field with remaining term in month.