| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Annualize/ Estimate year-to-date from monthly expense
For example I have $500 for June operating expense. How do i annulaize
it? Or how do I estimate year to date expense. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Annualize/ Estimate year-to-date from monthly expense
Any extrapolation from one data value is pretty meaningless: is this all the
info you have? "Positive" wrote: For example I have $500 for June operating expense. How do i annulaize it? Or how do I estimate year to date expense. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Annualize/ Estimate year-to-date from monthly expense
With the information you gave, you would simply multiply by 12.
You wouldn't have to estimate year-to-date expenses, you should have them. You can estimate rest-of-the-year expenses by: TotalToDate / NumberOfMonths * (13 - NumberOfMonths) -- Regards, Fred "Positive" wrote in message ups.com... For example I have $500 for June operating expense. How do i annulaize it? Or how do I estimate year to date expense. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Annualize/ Estimate year-to-date from monthly expense
On Jul 12, 12:13 am, "Fred Smith" wrote:
With the information you gave, you would simply multiply by 12. You wouldn't have to estimate year-to-date expenses, you should have them. You can estimate rest-of-the-year expenses by: TotalToDate / NumberOfMonths * (13 - NumberOfMonths) -- Regards, Fred "Positive" wrote in message ups.com... For example I have $500 for June operating expense. How do i annulaize it? Or how do I estimate year to date expense. Thanks- Hide quoted text - - Show quoted text - Thanks a lot |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Producing expense (monthly) reports in Excel | Excel Discussion (Misc queries) | |||
| linking 12 monthly workbooks to one year to date workbook | Excel Worksheet Functions | |||
| home monthly expense report | Excel Discussion (Misc queries) | |||
| How do I set up a monthly business expense sheet | New Users to Excel | |||
| I need a running total of monthly grocery expense | Excel Discussion (Misc queries) | |||
Linear Mode
