Service 08

Financial planning and management accounting

A project financial model, covenant calculation, cost by site and plan versus actual. We set it up in Tunuk on the real data of the company, and the model and reports update from the system.

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.

  1. We go through the source data. We look at management and statutory reporting, contracts, the cost structure and liabilities.
  2. We build the model. We assemble cash flow, payback indicators and the debt service schedule on the real data of the company.
  3. We test the scenarios. We calculate sensitivity to price, volume, exchange rate and interest rate so that the model holds up to lender questions.
  4. 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.
  5. 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.

All services

Discuss your case

Tell us about the situation at your company and we will propose a scope of work and a way to start.