>>>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only