Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solve for interest rate of a security when pv, fv, nper are know? | Excel Discussion (Misc queries) | |||
financial function ..please | Excel Worksheet Functions | |||
FVSCHEDULE should allow cell reference for interest rate schedule | Excel Worksheet Functions | |||
Fv & Emi! | Excel Worksheet Functions | |||
to compute interest rate from principal and interest amount | Excel Discussion (Misc queries) |