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 2008 Forums
 Transact-SQL (2008)
 APR formula for auto loans

Author  Topic 

aggie72_95
Starting Member

3 Posts

Posted - 2014-04-21 : 13:56:18
I have high credit, original term, and payment amount and I need to solve for the APR on the loan. Is their a formula for this?

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2014-04-21 : 15:50:15
Are you looking for a sql function or just a mathematical formula? There's no sql function for APR. Did you ask the google for a forumula? I'm sure it must be out there in one of the internets.

Be One with the Optimizer
TG
Go to Top of Page

aggie72_95
Starting Member

3 Posts

Posted - 2014-04-21 : 16:06:35
I'm just looking for a formula based on the information I have
Go to Top of Page

ScottPletcher
Aged Yak Warrior

550 Posts

Posted - 2014-04-21 : 19:34:26
Can you derive the original principal from the "high credit"? They are not technically the same thing.

If you have the original amount of the loan, then yes, an APR can be computed.
Go to Top of Page

ScottPletcher
Aged Yak Warrior

550 Posts

Posted - 2014-04-21 : 19:34:26
Can you derive the original principal from the "high credit"? They are not technically the same thing.

If you have the original amount of the loan, then yes, an APR can be computed.
Go to Top of Page
   

- Advertisement -