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 wrote...
....
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.

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

You could try IRR.

=IRR({-500000;35000;35000;35000;35000;35000;35000;35000;3 5000;35000;35000;35000;35000;
10000;10000;10000;10000;10000;10000;10000;10000;10 000;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.....
--
Wag more, bark less


"pth" wrote:

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

Thanks Harlan Grove and Brad for so speedy reply!!

make me know more about IRR/XIRR function.

I deeply appreciated yours answer!!

"Harlan Grove" wrote:

pth wrote...
....
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.

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

You could try IRR.

=IRR({-500000;35000;35000;35000;35000;35000;35000;35000;3 5000;35000;35000;35000;35000;
10000;10000;10000;10000;10000;10000;10000;10000;10 000;10000;10000;10000})*12

returns 0.102922349.