Revenue Projection Formula Excel

About a project or event that is likely to take place in the near future.

Revenue projection formula excel. This function is normally concerned with future events. Forecast function as worksheet function. Doing financial projection about a project business proposal or event. The excel trend function is used to calculate a linear trend line through a given set of dependent y values and optionally a set of independent x values and return values along the trend line.

Arguments of forecast function in excel. Input sales figures and years into the cells. Apart from that it will give you product wise profit in and in terms of revenue. This known y values is a dependent array or range of data.

These financial projection templates in excel is used for making financial projection. Input forecast formula into the blank cell for the year you want to forecast such as 2018. In this forecast example let s consider datasets for known y s values and known x s values and calculate a forecast value for 30 on the basis of known values x s and y s. This known x values is an independent array or range of data.

By simply amending the starting revenue 60 000 or changing the fixed amount 50 000 used in the revenue projection formula the projections for years 1 through 5 can be quickly recalculated. Additionally the trend function can extend the trendline into the future to project dependent y values for a set of new x values. The revenue for each of the five years using the revenue formula should be 60 000 110 000 160 000 210 000 and 260 000 respectively. Open excel select a new spreadsheet.

The formula is shown below as forecast x known y s known x s like this. Use the forecast sheet tool in excel 2016 or later to automatically create a visual forecast worksheet. The sales revenue analysis template is a ready to use template in excel google sheets and openoffice that makes it easy for you to keep track of the fast moving products in your product line. Forecast formula in excel can be used as a worksheet function and as a vba function.

On the data tab in the forecast group click forecast sheet. This is a numeric value where we need to forecast new y value known y. The word projection actually implies making a prediction and therefore the financial forecast will imply that making a prediction about financial aspects.