| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for 2% annual sales increases
need for projected csah flow report.thanks
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Annual return formula | Excel Worksheet Functions | |||
| Annual Return Formula | Excel Worksheet Functions | |||
| variable annual wage increases based on start date | Excel Worksheet Functions | |||
| annual increases in price lists | Excel Discussion (Misc queries) | |||
| formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
Linear Mode
