“If you can’t describe what you are doing as a process,
you don’t know what you’re doing”
W. Edwards Deming

The Pipeline

The Financial Modelling Handbook is a collaborative project. There are lots of guides already in production and more being suggested all the time. The list below shows those guides that are being produced, as well as ones that have been suggested but not yet assigned to an author.

If you want to get involved and put a guide together for publishing, please let us know by filling in the form on the right of the page. You can also read more about being a contributor here. You can either contribute one of the ideas from the list that is shown as “Not assigned”, or suggest your own.

We also always interested to hear from people who are interested in translating the guides.

Proposed Title
Overdraft facility Not assigned
Sensitivity analysis Not assigned
Using specific dates to drive revenues
e.g. with a tenancy schedule for real estate assets
Not assigned
Debt sculpting Not assigned
How to create a tornado diagramNot assigned
Name ranges Not assigned
Transferring tables and graphs into Word and Powerpoint Not assigned
Dealing with units Not assigned
Model audit process Not assigned
Payroll modelling Not assigned
Different uses of IRR and XIRR Not assigned
Modelling tariffs (e.g. power projects) Not assigned
Financial asset accounting in IFRIC 12 Not assigned
Cash sweep Not assigned
Dealing with multi-currency models Not assigned
Budgeting and reporting variance Not assigned
Score cards Not assigned
Data checks Not assigned
Accounts payable and receivable In progress
Multi-divisional models Not assigned
Preparing (and formatting) outputs Not assigned
Contract debtor accounting in UK GAAP Not assigned
Scenario analysis In progress
Debt service reserve accounts In progress
Stepped escalationIn progress
Converting time linesIn progress
Loan life coverage ratioIn progress
Debt sizingIn progress
Blank input cellsIn progress
Sign conventionIn progress
How to break circularityIn progress


  1. Andrew says:

    Does anyone have any way to improve the management of accounting data once exported from the GL system of record. I have consistently seen poor organization and management of this information. I would love to have my accounting team adopt F1F9 conventions.

Help make the handbook better