| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
annualize sales for remainder of year
I have a figure for YTD Sales and am trying to calculate estimated annualized
sales off of this. And, this will change monthly as sales managers update their YTD sales to actual for the prior month end. Mathematically, the formula would be: YTD Sales + ((YTD Sales/# whole months passed) (# whole months remaining in year)). Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Year to date sales | Excel Worksheet Functions | |||
| Annualize/ Estimate year-to-date from monthly expense | Excel Worksheet Functions | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| How do I calculate year vs. year sales in a percentage? | Excel Discussion (Misc queries) | |||
| Sales per year | Excel Worksheet Functions | |||
Threaded Mode
