Projecting Revenues
How can I project total revenue for a month, based on daily revenues so far
for the month. I want to recalculate each day and keep a running monthly projection based on the revenues so far, but, I also want to keep my actual total revenues. |
Projecting Revenues
Assume that you input daily revenue into the cells B2 through B32 (one cell
for each day). Enter the formula =sum(B2:B32) in cell B33. That gives you month-to-date revenue. Enter the formula =countif(B2:B32,"<0") in cell B34. That gives you the number of days for which you have recorded revenue. Enter the formula =B33/B34*31 (number of revenue days in the month). That gives you projected revenue for the month based on the average daily revenue month-to-date. From there, the complexity of you calculations is based on your appetite for detail. Tom |
All times are GMT +1. The time now is 09:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com