Financial Modelling for Raising Equity

Challenge

  • Company in urgent need of equity needed a strong financial plan to be presented to investors.
  • Lack of expertise and bandwidth in the finance team to build up a finance model required by the investors.
  • Limited timeframe to convert the business plan in to Financial Statements for next 5 years based on the revenue and cost derived based on the model.

How we helped

  • Our work involved detailed discussions with management and business leads on the business and geographical segments, key drivers, KPIs, key growth metrics, cost structure and marketing plan.
  • We studied research reports of leading analysts of the sector to gain understanding of the growth of the sector in terms of pricing, quality, new market geographies for the near future.
  • Multiple revenue models were built for each business segments covering various assumptions and scenarios with flexibility to play around important metrics and create multiple scenarios.
  • Direct costs were modelled on revenue and headcount and the indirect costs were modelled on major heads with individual drivers and analysis of historical costs.
  • New areas for investment were identified using a BI tool considering the competitor geographies in the same. Investment modelling for assets was based on past experiences and a growth rate of increase over a period was considered in the same.
  • Multiple discussions and potential Q&A analysis were built to ensure loose ends are tied up.

Benefits

  • Financial projections with all assumptions and detailed modelling were delivered to the customer in tight time frame.
  • A flexible template was built to bake in any change that may be needed on various parameters.
  • The financial model doubled up as a budgeting tool for the organisation.