Interest Rate Givien IRR ((please help me to solve it)
 

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??

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