BUY WITH CONFIDENCE
BENEFITS OF DOCUMENT
DESCRIPTION
Our checklist is intended for all kinds of financial models: M&A models, valuation tools, liquidity forecasts. You name it. It covers standard checks, which are applicable for all financial models like the following:
• Which financial modelling standard was applied?
• Is the model's structure fit for its purpose?
• Is there a clear distinction between ‘Input', ‘Calculations' and ‘Output' sections?
• Was a consistent color coding applied throughout the model?
And of course there is plenty of space to document any other model-specific findings.
The checklist is intended for all finance professionals, who act as a reviewer of a financial model prepared by a colleague or a professional advisor. Regardless if it is a high-level review or an in-depth model audit.
Use of the template
You may download the Excel template and take the following five steps:
1. Copy the checklist to the financial model under review
2. Carry out topics listed in section ‘I. Standard checks for all Financial Models'
3. Add more line items for all worksheets under review and your comments in section ‘II. Specific comments on worksheets'
4. Document your findings and the replies of the model owner
5. Track the process of the review until 100% of the issues are closed
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Financial Modeling Excel: Model Review Checklist Template Excel (XLSX) Spreadsheet, Olaf Kiel, CFA, AFM
OVERVIEW
ABOUT THE AUTHOR
I am a seasoned consultant with 20+ years of professional experience. After working as a senior manager with top tier accounting firms in both Switzerland and Germany, I founded my own business in 2014. Olaf is a trusted partner in all financial modelling and valuation related matters.
He is a CFA charterholder since 2004 and an Advanced Financial Modeller (AFM) since 2023.
Ask the Author a Question
Financial Modeling Strategic Planning Project Management Lean Management/Enterprise Lean Daily Management System Go-to-Market Strategic Sourcing Business Case Development Consulting Frameworks Strategy Frameworks Strategic Analysis Strategic Thinking
![]() |
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. |