Calculate Interest Rate when payment changes!

standard homework question:
IRR will give you the answer

put payments in a range
150 then zeros
HELP>IRR



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

Thanks that did the trick.