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 | Status |
|---|---|
| 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 diagram | Not 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 escalation | In progress |
| Converting time lines | In progress |
| Loan life coverage ratio | In progress |
| Debt sizing | In progress |
| Blank input cells | In progress |
| Sign convention | In progress |
| How to break circularity | In progress |
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.