Interest Earned?? over time?

[Robert Blass]

Starting with $50.
Contributing exactly $100 per month every month for 10 months

Formula would be?


using excel 97'

 

[FSt1]

hi
based on the "limited" amout of info you have provided, i would suggest that
you look up these formulas in xl help......
=pmt
=PPmt
=cumpmt
=CumPrinc
there are others
surely one of these will get you started

regards
FSt1

regards
FSt2

 

[Bernie Deitrick]

Robert,

With the Annual interest rate in cell A1 (Entered as a percent)

=FV(A1/12,10,-100,-50)

Interest earned would be that - 1050.

HTH,
Bernie
MS Excel MVP

 

[Robert Blass]

hi
based on the "limited" amout of info you have provided, i would suggest that
you look up these formulas in xl help......
=pmt
=PPmt
=cumpmt
=CumPrinc
there are others
surely one of these will get you started

oh of course, surely one will...ok

 

[Robert Blass]

Allow me and permit me to explain more better.


It started @ $44 and is NOW @ $1,600 in just 10 months.

What would it have been IF I had contributed $108 per month for all 10
months so far?


thanks all......

 

[Fred Smith]

What is "it" that you want calculated? The rate of return earned? If so, use
XIRR.

Regards,
Fred.

 

[Fred Smith]

Or, if you have equal periods (like monthly), you can use the rate command,
as in:

=rate(10,-108,-44,1600)

Remember, this answer will be a periodic (ie, monthly) rate of return. Most
people would just multiply by 12 to get an annual rate, but remember it's
compounded monthly.

Regards,
Fred.