Calculate Interest Rate when payment changes!
 

Hello,

We use the interest fuction to calculate the interest percentage.

we use the following info:

savings time period: 30/12
payments: 150*12
present value: 0
futurevalue: 250.000

this is an example.

now we want to be able to calculate the interest % when not all
payments are made throughout the whole savings time periode.

for instance:

savings time period: 30/12
payments: 150*12 for only (the first 20 years!!)
presentvalue: 0
future value: 250.000

in this example the payments stop after 20 years and after that the
capital grows for another 10 years to reach the future value of
250.000.

we need help in how to calculate then the interest % in wich the
payments/capital need to grow to reach this goadl.

maybe we need a totally different fuction for this ... bu I need
someone to point me in a good direction. wich pro can help us out ??


--
huntermcg
------------------------------------------------------------------------
huntermcg's Profile: http://www.excelforum.com/member.php...o&userid=19391
View this thread: http://www.excelforum.com/showthread...hreadid=478948

Calculate Interest Rate when payment changes!
 

standard homework question:
IRR will give you the answer

put payments in a range
150 then zeros
HELPIRR



"huntermcg" wrote:


Hello,

We use the interest fuction to calculate the interest percentage.

we use the following info:

savings time period: 30/12
payments: 150*12
present value: 0
futurevalue: 250.000

this is an example.

now we want to be able to calculate the interest % when not all
payments are made throughout the whole savings time periode.

for instance:

savings time period: 30/12
payments: 150*12 for only (the first 20 years!!)
presentvalue: 0
future value: 250.000

in this example the payments stop after 20 years and after that the
capital grows for another 10 years to reach the future value of
250.000.

we need help in how to calculate then the interest % in wich the
payments/capital need to grow to reach this goadl.

maybe we need a totally different fuction for this ... bu I need
someone to point me in a good direction. wich pro can help us out ??


--
huntermcg
------------------------------------------------------------------------
huntermcg's Profile: http://www.excelforum.com/member.php...o&userid=19391
View this thread: http://www.excelforum.com/showthread...hreadid=478948

Calculate Interest Rate when payment changes!
 

Thanks that did the trick.


--
huntermcg
------------------------------------------------------------------------
huntermcg's Profile: http://www.excelforum.com/member.php...o&userid=19391
View this thread: http://www.excelforum.com/showthread...hreadid=478948