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
 
 
Examples: Forecast Who We Are
     

Forecast

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


All our 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, e.g 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 e.g. 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 e.g. 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 (I know 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.


 
Richard Brooks BCom, CA, Chief Executive
Richard Brooks:
Chief Executive
Richard qualified at Ernst & Whinney and became Financial Controller of Samuelson Group plc and Finance Director of Samuelson Communications Ltd at the age of 28.
Full profile