Calculate Interest Rate when payment changes!

[huntermcg]

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

[Vacation's Over]

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

[huntermcg]

Thanks that did the trick.