Interest Rate Givien IRR ((please help me to solve it)
"humod.aman" wrote in message
...
hi
can i know how much is the installment givien Only IRR
let say
1- i will Finance 10,000 USD
2- for 5 years
3- my IRR must be 15%
how can i solve it??
Use the PMT function.
It returns $2983.16 for annual payments or $237.90 for monthly payments.
Cheers,
Ken Russell
|