Our goal is to create a dynamic model that allows for easy calculations for various scenarios in the early stages of a project. Therefore, we create a monthly forecast on a separate tab, where we set all the indicators using formulas.
To determine the month from which the traffic and the number of sellers and buyers appears in the model, we use an IF function (in Excel or Google Sheets).
If the date value for the column is greater than or equal to the marketplace launch date or the start date of direct marketing campaigns, we begin calculating the indicator using a formula. Otherwise, the cell value is set to “0”.
In a general sense, this formula in Excel or Google Sheets looks like this:
=IF(E2(
month in forecast) >= Projections!$E$13 (
start date in input data), formula, 0).
Depending on the specific metric this formula can be expanded. We can include growth calculation, set the maximum or minimum value etc.
In our store you can download the ready-to-use
Marketplace Startup Financial Model template with all the formulas.