Hello Mikael, I'm Stefan.
It will take between 3 to 5 days per model (10-15 work hours), depending on data I have to search, and will build the model in one excel file, with 3 scenarios, so you can compare "What if scenarios" and plan ahead your next moves. You will have for each scenario an assumptions sheet that will control the model;from this tab you can vary the inputs for all your variables, and for each revenue stream: product mix, pricing, payroll costs, variable costs, overheads. You can use the scenarios to show investors you thought in advance to what follows, that you are prepared, you have alternatives.
Following the ratio analysis, I will simulate a Sensitivity Analysis that will tell you what variation in a key ratio each variable produces (for example what impact will have upon profitability decreasing the price and with what percentage ... you can link this with what variation will produce to profitability an increase to the same product quantity). This will give you a huge understanding at how sensitive the business is to each variable change.
Also, after building the Proformas, I will run a Monte Carlo simulation (based on an agreed +&- variation of the variables). This report is made to answer your questions regarding the achievement certainty of a specific ratio, (given all data we have I will show the certainty in reaching the predicted results).
Kind regards, Stefan.