formula for 2% annual sales increases
 

need for projected csah flow report.thanks

formula for 2% annual sales increases
 

Not much info to go on, but one way:

B1: = A1 * 1.02

In article ,
shepzuck wrote:

need for projected csah flow report.thanks

formula for 2% annual sales increases
 

Thanks.Can you advise how to apply the 2% increase to each succeeding year as
a formula ?Thanks.

"JE McGimpsey" wrote:

Not much info to go on, but one way:

B1: = A1 * 1.02

In article ,
shepzuck wrote:

need for projected csah flow report.thanks

formula for 2% annual sales increases
 

Yes, just keep mulitplying the previous year by 1.02.

If you want to calculate multiple years in one formula, you want the future
value function.
PV=Starting Cash Flow
IntRate=2%
Nper=Number of years

Regards,
Fred.

"shepzuck" wrote in message
...
Thanks.Can you advise how to apply the 2% increase to each succeeding year
as
a formula ?Thanks.

"JE McGimpsey" wrote:

Not much info to go on, but one way:

B1: = A1 * 1.02

In article ,
shepzuck wrote:

need for projected csah flow report.thanks

formula for 2% annual sales increases
 

Thanks for the assist.

"Fred Smith" wrote:

Yes, just keep mulitplying the previous year by 1.02.

If you want to calculate multiple years in one formula, you want the future
value function.
PV=Starting Cash Flow
IntRate=2%
Nper=Number of years

Regards,
Fred.

"shepzuck" wrote in message
...
Thanks.Can you advise how to apply the 2% increase to each succeeding year
as
a formula ?Thanks.

"JE McGimpsey" wrote:

Not much info to go on, but one way:

B1: = A1 * 1.02

In article ,
shepzuck wrote:

need for projected csah flow report.thanks