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

[Guest]

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

 

[Rusty]

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