rate with different pmv

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

Harlan Grove

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.

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;35000;35000;35000;35000;35000;
10000;10000;10000;10000;10000;10000;10000;10000;10000;10000;10000;10000})*12

returns 0.102922349.
 
B

Brad

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

pth

Thanks Harlan Grove and Brad for so speedy reply!!

make me know more about IRR/XIRR function.

I deeply appreciated yours answer!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top