>>>>Does anyone know where to find the calculation for the interest rate if you have Present Value, Term, & Payment Amount?
>>>
>>>VFP has PAYMENT(). You can use automation to Excel to get most any financial funciton you need.
>>
>>Hey Craig,
>>Wouldn't automation be a little slow just to figure out one calculation? I have only used Word automation and it's not exactly quick. What do you think?
>
>Yes, it would be slow. You can look at Excel help. Some of the calculations are explained there. At Franklin, I had to figure out the calculation for charging interest, which is based on a 360-day calendar. I found lots of good info in Excel Help.
Thanks Craig but I don't want interest accrued, I want the interest rate if you have number of payments, loan amount and final amount.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement