When you need it
The service is relevant if the company faces:
- the company is preparing for a loan or investment and there is no financial model
- a model exists but does not hold up to questions from a bank or a development institution
- the loan is in place and covenants have to be calculated and reported
- profit is visible for the company as a whole, but it is unclear which site or contract brings it
- a budget is prepared, but plan versus actual is never analysed
- cost is needed by site and contract, not as one total figure
What you get
On completion the client receives:
- a financial model of the project: cash flow, NPV, IRR, payback period, debt service schedule
- covenant calculation
- cost by site and by contract
- a budget and plan versus actual with variance analysis
- handover of the model to your team, with training
How it works
The work is carried out in stages.
- We go through the source data. We look at management and statutory reporting, contracts, the cost structure and liabilities.
- We build the model. We assemble cash flow, payback indicators and the debt service schedule on the real data of the company.
- We test the scenarios. We calculate sensitivity to price, volume, exchange rate and interest rate so that the model holds up to lender questions.
- We set it up in Tunuk. We move the model, the budget and the list of sites into the system so that calculations run on the real data of the company.
- We calculate covenants and plan versus actual. Indicators, cost by site and variances update from the system, with no manual transfer.
The outcome
The model, covenants, cost by site and plan versus actual live in one system and update from it. Decisions on the loan and on each site are made on current figures rather than on week-old spreadsheets.