rate with different pmv

  • Thread starter Thread starter pth
  • Start date Start date
P

pth

If
Pv =500,000
Nper =24
pmt =35000

I can get the rate is 55.75929% with funtion rate:
=RATE(24,-35000,500000)*12


But what if Pmt is 35000 for first 12 Nper,and 10000 for next 12 Nper?

What I know is to use what if analysis find the rate is 10.2923.


Is there another way to solve this question? like ohter functions or macros??
 
pth said:
But what if Pmt is 35000 for first 12 Nper,and 10000 for next 12 Nper?

What I know is to use what if analysis find the rate is 10.2923.
Click to expand...

You're mixing effective and nominal interest rates. 10.2923% is the
nominal annual interest rate.
Is there another way to solve this question? like ohter functions or macros??
Click to expand...

You could try IRR.

=IRR({-500000;35000;35000;35000;35000;35000;35000;35000;35000;35000;35000;35000;35000;
10000;10000;10000;10000;10000;10000;10000;10000;10000;10000;10000;10000})*12

returns 0.102922349.
 
Look at the XIRR function. (You may have to select an add-in to get this
function). The pro feature about this function is that the dates don't have
to be equally spaced. The con feature about this funcation is that you have
to enter the dates - as well as the amounts and the ending balance.....
 
Thanks Harlan Grove and Brad for so speedy reply!!

make me know more about IRR/XIRR function.

I deeply appreciated yours answer!!
 
Back
Top