What’s covered:

  • Excel for M&A (formulas, layout and best practice)
  • Date counters
  • Integrity checks
  • Revenue modelling across a variety of business models e.g. product, service, project, etc.
  • Triangulation of forecasting methods to assess reasonableness
  • Cost of sales modelling across a variety of business models
  • Fixed and variable overheads
  • Seasonality and working days for monthly models
  • Working capital projections using working capital days
  • VAT, PAYE and NI modelling
  • Debt schedule
  • Cash plug method V.s. t-account / corkscrew approach to modelling
  • Traditional cash flow and direct receipts and payments for added transparency