FD Solutions - an experienced team of part-time finance directors
Homeour servicesabout uscase studiesexamplesin the newswhere we arecontact us8 Pepper St, London, E14 9RP
Case Studies
 
Examples
IFRS Examples
Forecast
Management Accounts
Printer Friendly Version
 
Examples Who we are
     

IFRS

Example documents (PDF)
    

 

Management Accounts

Profit & Loss Account (PDF)
   Balance Sheet (PDF)

 

Forecast

Summary (Excel Worksheet)
   Diagram & Contents (Excel Worksheet)


All our forecast models follow these rules:


Be commercial

1. Ensure that the assumptions used are in line with the existing drivers underlying the business or that changes are justified.


Make it user friendly

2. Aim for one assumptions sheet. Clients should be able to change assumptions easily.
   
3. The first sheet should be either a sheet index or a diagram or a text guide explaining how the model works.
   
4. Write up the assumptions. They may be part of a business plan but there should always be some words to explain what the model says.
   
5. Input cells should be coloured, eg blue for input, black for fixed. There should be a key to explain this.
   
6. There should be monthly and separate summary sheets.
   
7. Show file and path name.

Reflect what the client is used to (Intuitive)

8. Wherever possible, use client nominal codes.
   
9. Be rigorous in setting up formats so that they are exactly the same as actuals, eg can we paste actual P&L information and derive actual balance sheet by flexing assumptions?


Add value

10. Consider re-organising clients nominal ledger or re-organising the report so that costs are grouped logically eg marketing, premises, admin, finance.
   
11. Make sure workbook can be printed on A4 and easily read.
   
12. Make sure it looks good. Make sure the summary page gives an immediate, clear understanding of volumes, prices and financial results.

Ensure that it can be checked and validated

13. Include a sheet for version control. Models should be numbered sequentially NOT dated. Version control should indicate if the version is completed and what the main changes were.
   
14. Avoid hiding rows, columns or sheets (we all sometimes hide a payroll sheet).
   
15. Avoid external links.
   
16. Avoid long or similar sheet names.
   
17. Never mix formulae and values in same cell.
 
Malcolm Durham LLB, FCA, Chairman
Malcolm Durham:
Chairman
Malcolm established FD Solutions in 1991 and has particular expertise in the corporate finance aspects of an FD’s role. His experience is mainly in construction, software and all human capital businesses, from consultancy to coaching and mentoring.
Full profile