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.
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 OptimizerTG |
|
|
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 |
|
|
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. |
|
|
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. |
|
|
|
|
|