• 

Send to a friend

• linkedin
• twitter
• facebook
• code

Originally published: 30/05/2018 16:44
Last version published: 08/08/2019 08:34
Publication number: ELQ-23725-5
View all versions & Certificate

Financial Model audit check list - spreadsheet

This is an audit or productivity tool that you can use while reviewing someone else’s models.

by FinExMod
Financial modelsFollow 104

61 reviews3,415 views|6 comments|Bookmark download for free

financial modelingtoolsproductivityfinancial modelersfinancial model auditfinancial model reviewfinancial model review checklist

Description
All projects are different and have their own specific issues so it’s not possible to generalize all issues related to projects of different natures.

Throughout the years reviewing financial model, I realized that there some issues that comes up in almost all projects. So I made a checklist and when I do the first round of check, I open this spreadsheet and go over this list one by one.

It is certainly not an exhaustive list and it should be the start of a conversation about what you should be looking for when reviewing a financial model and will help you to be faster in preparing you preliminary report on the financial model.

The first set of issues in the checklist are the “Mechanical checks” meaning things like color coding, format, integrity and basically an overall check on compatibility of the financial model with the best practice financial modelling standards. Then it dives into typical financial model assumptions like "Key timing", "Capex", "Opex", Technical", "Financing" and etc.
The last section deals with the financial statements, and main metrics and model results.

For a more detailed look at each of these topics and more, check my book available on Eloquens:
https://www.eloquens.com/tool/nJVLtz7k/finance/financial-modeling-courses-tutorials/financial-model-detective-book-hints-and-tricks-on-how-to-review-project-finance-models

This Best Practice includes
Excel file

FinExMod offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Reviews

• • 
    4.7 / 5 (61 votes)

    • 75%
    • 20%
    • 5%
    • -
    • -
  • Rate this Downloadable Best Practice
    

    Write a review

• Ahsan Zia(last updated: 10/01/2021 16:36)
  
• andreas shiakas(last updated: 27/12/2020 17:39)
  
• Ogundele victor ojo(last updated: 15/12/2020 10:12)
  
• Nadezhda Borodachyova(last updated: 10/12/2020 06:49)
  
• Jos Bollen(last updated: 24/11/2020 07:03)
  
• Helimah Kemboi(last updated: 29/10/2020 09:00)
  
• Financial Modeler(last updated: 29/10/2020 07:52)
  
• Bacary GBANE(last updated: 12/10/2020 13:43)
  
• Patricia Gooden, MSF, MBA, PMP(last updated: 09/10/2020 23:17)
  
• Adewusi Adeseye, ACA(last updated: 29/09/2020 03:37)
  
• Rubén Ojeda Hernández(last updated: 25/09/2020 05:28)
  
• Hossam M.sedik(last updated: 23/09/2020 17:53)
  
• Ilgar Zarbaliyev260(last updated: 22/09/2020 17:29)
  
• Ken Hallinen(last updated: 22/09/2020 14:15)
  
• Maysam(last updated: 22/09/2020 14:13)
  
• Qasim Amin(last updated: 22/09/2020 13:48)
  
• Meena Jafferali(last updated: 22/09/2020 10:32)
  
• Ravi Kumar Karri(last updated: 22/09/2020 09:16)
  
• David Mark(last updated: 22/09/2020 07:32)
  
• Sivarajah Panjalingam(last updated: 22/09/2020 06:52)
  
• Vu Pham(last updated: 21/09/2020 09:22)
  
• Folorunso Lala(last updated: 20/09/2020 22:26)
  
• Ossama Tanveer Cheema(last updated: 19/09/2020 06:23)
  
• Andreas Gottschalk(last updated: 24/08/2020 07:09)
  
• Hélène Messier(last updated: 17/08/2020 11:41)
  
• Ade Babayemi(last updated: 29/07/2020 15:46)
  
• Jean Stephane Koffi(last updated: 08/07/2020 10:08)
  
• Arif Arafat Zahari(last updated: 20/04/2020 18:10)
  
• Dunga(last updated: 18/02/2020 14:23)
  
• Luay Albraim, CMA(last updated: 21/01/2020 11:20)
  

keyboard_arrow_downShow all

People using this Best Practice also downloaded

Post Comment

• 

  FinExMod 1 year ago
  Authorstar

  I want to thank you for your interest and support in my work throughout the year 2019 in our great Eloquens community.
  
  To thank you, I want to share with you a spreadsheet that I use to look ahead and focus on what I want for the next year and plan for it.
  
  https://www.eloquens.com/tool/5MB7fQXB/leadership-hr-human-resources-tips-and-methods/productivity/smart-to-do-list
  
  I wish you happiness and success for this Christmas and the year to come.
  
  And I’ll be in $touch$ with you with you next year.

  arrow_drop_uparrow_drop_downReply reply
• 

  Hedieh Kianyfard 1 year ago
  Eloquens Member

  Hope you are doing great!
  Just want to let you know that I just published a new tool on one of the most critical components of any financial model and that is:
  Building integrity checks
  
  Download the excel template and manual here on Elequens:
  https://www.eloquens.com/tool/wmjEi0N4/finance/project-finance-models/building-integrity-checks-in-project-finance-models-manual-template
  
  Wishing you a safe, joyful, and blessed holiday season.
  
  Stay $locked$ and happy modelling.
  
  Hedieh

  arrow_drop_uparrow_drop_downReply reply
• 

  Hedieh Kianyfard 1 year ago
  Eloquens Member

  Thank you SO very much for downloading the Project Finance financial model checklist.
  
  I have also published a book around the same topic and I explain in an easy and step-by-step approach how you can review a typical project finance model. I talk about mechanical checks, things you need to watch out for in the assumptions and the metrics and results that you want to see in a standard financial model.
  
  You can get my book either from Amazon or here at Eloquens.
  
  https://www.amazon.com/Financial-Model-Detective-tricks-financial/dp/1074174607/ref=sr_1_1?crid=3F64EUH1L3HXI&keywords=financial+model+detective&qid=1571657299&sprefix=financial+model+de%2Caps%2C217&sr=8-1
  
  If you have already bought the book please leave an honest review. It'll help me a lot.
  
  Finally,
  
  I’m so honored to have you as a user of this tool.
  
  Please let’s stay in $touch$! And in the meantime happy modelling!

  arrow_drop_uparrow_drop_downReply reply

  • 

    Jagan Ganti 1 year ago
    User

    Hi, I purchased the ebook on Kindle, unfortunately the paragraphs are all jumbled up - its not making sense. I was quite eager to study your book but its seems Amazon has not done a good job. Is there any way you could help me?

    arrow_drop_uparrow_drop_downReply reply

    • 

      Hedieh Kianyfard 1 year ago
      Eloquens Member

      Hi Jagan,
      
      Thanks for letting me know about the issues you are having with the Kindle version of the Financial Model Detective Book. I'll look into it.
      
      I'll send you a coupon to download the PDF version here on Eloquens.
      
      Thanks,
      
      Hedieh

      arrow_drop_uparrow_drop_downReply reply
• 

  Hedieh Kianyfard 1 year ago
  Eloquens Member

  Hi there,
  
  Just to let you know that I recently released two tools that will help you build sensitivity and scenario analysis into your financial models.
  You can find the version using DataTable from the below link:
  
  https://www.eloquens.com/tool/QkrkFG2G/finance/sensitivity-analysis-excel-templates-and-methods/sensitivity-analysis-template-using-data-table
  
  And I uploaded a revised version of the same template but this time using VBA . Here’s where you can get the tool:
  
  https://www.eloquens.com/tool/aAJEF2nD/finance/sensitivity-analysis-excel-templates-and-methods/sensitivity-and-scenario-analysis-excel-template-with-vba
  
  Of course, if you have questions or comments — just hit reply and I’ll be happy to hear from you.
  
  Thank you so much for downloading, commenting and sharing.
  
  Best regards,
  
  Hedieh

  arrow_drop_uparrow_drop_downReply reply