formula for 2% annual sales increases

S

shepzuck

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

Fred Smith

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.
 
S

shepzuck

Thanks for the assist.

Fred Smith said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

annualize sales for remainder of year 3
What regular savings, increasing every year to reach goal 11
Help with long if then statement 1
MS Project. Real progress of the project, % complete 1
Style Heading 2 5
XIRR Giving Negative Number on Positive Cash Flow Stream 11
Cash Flows Inflation Adjusted 2
Help with Nested IF Then statement? 3

Top