Compounding

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

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
SpecialMultiply. The values in the range will be
increased by 10%.

Biff

-----Original Message-----
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
.

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


"Mike" wrote in message
...
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

Kevin,

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

Michael


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


"Mike" wrote in
message
...
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


.

Mike,

Welcome, and glad to help.

Regards,
Kevin

wrote in message
...
Kevin,

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

Michael


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


"Mike" wrote in
message
...
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


.