Financial Modelling ExampleCashflow Financial Model
Working Capital Cashflow Financial Model
Client:
Healthcare and Education Provider
Project:
Create a detailed 18 month cashflow forecast to use as part of a potential IPO.
Reason for new model:
The current cashflow forecast was too high level.
Inputs:
Revenue templates, with forecast occupancy, charges and billing frequencies. Expense templates with payment profiles.
Structure:
Detailed weekly cashflow for 18 months
Outputs:
Cashflow by site, by week including corporate costs.
Challenges:
Accurately identifying the payment profiles of a diverse range of customers.
With our experience in developing cashflow financial models in Excel within a range of industries, our London financial modelling consultancy can be a responsive and competitive alternative to hiring an interim financial modeller.
