N
Need formula help, Excel 2007, Thanks
Hello, is there a formula I can use that will project revenue in real time
based on total sales at any given time. Basically, take my sales to date,
consider how many days into a calendar year we are at presently and make a
prediction to where the sales will be at the end of the calendar year based
on sales to date. So, say I am 50 days into the calendar year and my sales
are 500,000. Presently, I am averaging 10,000 per day and at this rate my
sales for the year will be 3,650,000. Is there a formula that will take the
revenue from cell1 and provide the annual projected revenue in cell2? I hope
I am making sense. Thanks in advance to anyone that can assist.
based on total sales at any given time. Basically, take my sales to date,
consider how many days into a calendar year we are at presently and make a
prediction to where the sales will be at the end of the calendar year based
on sales to date. So, say I am 50 days into the calendar year and my sales
are 500,000. Presently, I am averaging 10,000 per day and at this rate my
sales for the year will be 3,650,000. Is there a formula that will take the
revenue from cell1 and provide the annual projected revenue in cell2? I hope
I am making sense. Thanks in advance to anyone that can assist.