+ Reply to Thread
Results 1 to 1 of 1

Revenue Forecast formula for Excel

  1. #1
    Registered User
    Join Date
    San Diego
    MS-Off Ver
    Excel 2008

    Red face Revenue Forecast formula for Excel

    Question, I've been asked to project revenue for the upcoming quarter based on the past two years. Orders and revenue are my only metrics to go on. It's been a few years since I had to do my own forecasting. Does anyone have a simple formula for projecting based on this type of data? Ex:

    2011 orders $Per rev '11 % growth
    Jan 100 $50 $5,000
    Feb 50 $52 $2,600 -48%
    Mar 150 $53 $7,950 206%
    Apr 50 $50 $2,500 -69%

    I determined the Cost per unit based on rev/orders. I also determined the growth % and graphed out 2011 and 2012. What I'm having trouble remembering is how to forecast the year ahead with this data. Any help is much appreciated.
    Last edited by gcupcakes; 01-17-2013 at 07:25 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1