View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rusty Rusty is offline
external usenet poster
 
Posts: 2
Default 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