Planning & Solutions GroupWhen 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
- a document package for a bank or a development institution
- covenant calculation and lender reporting on time
- 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 prepare the bank package. We put the documents and explanations into the form a bank or a development institution expects.
- We run lender reporting. We calculate covenants, prepare periodic reporting and warn about breach risks in advance.
- We link it to the accounts. With Tunuk in place, the model and plan versus actual take data straight from the system.
The outcome
The company comes to the bank with a model that explains every figure, and then services the debt without emergencies: covenants are calculated on time, reporting follows the schedule and profit is visible by site and contract.