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
|