Compounding

[Mike]

I would like to know how to compound cash flows now.

How do I take a series of cash flows and reinvest them at
a continuous factor. let us say 10%.

If I have A10:E10 that is a series of numbers, how can I
select that series of numbers and then compound them by
the factor placed in A3 (10% in this case!)

Mike

 

[Biff]

Hi Mike,

Enter the value in A3 as 1.10. This equates to 110%. Now
copy cell A3. Select the range A10:E10. Then do a Paste
Special>Multiply. The values in the range will be
increased by 10%.

Biff

 

[Kevin Stecyk]

Hi Mike,

I think you want the Future Value function.

FV(rate,nper,pmt,pv,type)

Please consult XL's help feature.

Also, Mike, there have been a few replies to your previous questions. You
should acknowledge whether the people have correctly answered your questions
(if so, a thank you is appreciated), and if not, please restate your
question.

If you look at XL's help, you will see a lot of the commonly used financial
functions are already provided in Excel.

Regards,
Kevin

 

[Guest]

Kevin,

I did not know what the protocol to this. I do appreciate
your help. Exactly what I needed.

Michael

 

[Kevin Stecyk]

Mike,

Welcome, and glad to help.

Regards,
Kevin