Financial Modeller's 10 Worst Nightmares

Updated on December 6, 2018

What are your financial modeling nightmares?

1. Cleaning up someone else’s models.

I used to love Kinder Surprise as a kid, and now opening up someone else’s financial model gives me the same sensation. Unnecessarily complex models are like those gifts that require an engineering background to assemble; the overly simplified models are like the readily assembled figurine of dinosaurs that ends up in the trash right away, and good financial models are like those gifts that you still keep in your secret shoe box.

Solution: Do a preliminary review and decide as early as possible whether you want to work with the inherited model or build your own model instead.

2. Circular references appearing where you did not expect them.

I do not understand people who have no problem with having circular references flowing freely in their models! I have no patience to wait for the recalculation of all worksheets every time I change something in the model. Plus, you cannot use many of Excel's functionalities like data tables and Goal Seek.

Solution: The most inefficient way to solve for circularity is to use a copy and paste macro. In many instances, circularity can be resolved with algebra or by using a user-defined function. For more on that, check edbodmer.com.

3. The financial model crashes, and you don’t have a backup.

Hours of work were lost. Yes, it has happened to everyone, but it doesn’t make it less painful.

Solution: Hit your head against the wall and learn to press Ctrl + S frequently.

4. Worksheet compatibility issues.

After finally and proudly sending the model to your clients, you get a comment that some of your functions are not compatible with their version of Excel. This happened to me recently with MINIF, MAXIF, and AVERAGEIF functions. Later, I realized that these are only available to subscribers of Office 365 with the current version of Excel 2016. The standalone version of Excel 2016 does not have these new formulas.

Solution: There are so many alternative ways of doing the same thing in Excel. Use simple functions and do your calculations in blocks to avoid long formulas. Test your models on different versions of Excel.

5. A balance sheet that does not balance.

The other side of the story is the fantastic feeling you get when you get to balance your balance sheet.

Solution: The first trick I do is to check for the difference and see if I can catch the difference in the P&L and cash flow statement. I also do sensitivity. For example, I change different elements to 0, like debt, working capital, and shareholder loan, and I see if the balance sheet balances without any of these elements in action and then try to figure out where the problem is coming from.

6. Changes in accounting standards or applicable fiscal regimes which, in turn, make your life miserable.

Project development is like a roller coaster ride, and a financial model is a tool that should accompany the project throughout the journey. So, you should be prepared for the unexpected. However, there is a trade-off between flexibility and simplicity.

Solution: Try to build enough flexibility into the model to accommodate expected future changes.

7. The first time you are asked to build a cash-flow waterfall when the only waterfall you knew was Niagara Falls.

There are plenty of acronyms and weird expressions in finance. I read somewhere that Elon Musk has said that he doesn’t want people to have to memorize a glossary to function at Tesla Motors.

Solution: Always have your end user in mind and consider that not everyone knows what CFADS or LLCR are. Always add a list of abbreviations and definitions on the cover page or guide page of your model.

8. Clients who have Excel phobia.

Yes, there are people out there who are afraid of Excel. I had some colleagues and clients who were calling me back for every small change that they wanted to apply to the model! I didn’t know why they wouldn’t just use the beautiful switches that I had included in the dashboard to see different scenarios. Later, I realized that they were afraid to mess things up if they did it on their own. In one of the cases, the person with the Excel phobia told me that once upon a time, he had to work on a very complicated financial model and he had to call upon the modeler every time he wanted to make any changes. This might be a smart way of financial modeling, if the financial modeler is getting paid on an hourly basis and is selfish.

Solution: When building your models, have the final user in mind. The same standard applies when you are writing a report: Your financial model should be readable and follow specific standards.

9. When you are given a financial model in Portuguese and your level of Portuguese is limited to the lyrics of Amar Pelos Dois from Salvador Sobral.

I love that song, and when it won the Eurovision Song Contest, it was proof to me that quality is still more powerful than marketing. If the model is in a language that you don’t know, it's still okay. The problem is when the main documents and agreements are in a foreign language and image file format.

Solution: To translate my models, I do the following:

1. I insert a column next to the label column in the financial model.

2. I copy all the labels from the original financial model to Google Translate.

3. I paste the translation into the added column in the model.

4. I go over all the translated labels and edit where necessary.

In my model, I also link labels. For example, at the early stage, I use a placeholder for “Senior tranche 1” in my Inputs sheet and link to wherever I am doing the debt calculations (“Debt” sheet, “Financing” sheet, etc.). Later, when I have a term sheet with a specific bank, I replace “Senior tranche 1” in the Inputs sheet with, as an example, “African Development Bank,” and this will change the label throughout the model. So if you do that, you can easily translate the whole model from one language to another.

10. Being called a data cruncher.

It might be a compliment for some people to be called a data cruncher, but to me, a financial modeler deals with more than just data. In my experience, if you want to make a good deal, send your financial modeler for negotiating contracts. An excellent financial modeler should know all aspects of the projects, from the technical, the legal, the financial, the tax, etc., and should understand the consequences of changing different aspects of the current case of the project’s economics. So invest in financial modelers on your team, make them involved in all aspects of the projects, and treat them as your colleagues and not as machines.

Conclusion:

Some of the nightmares fade away as you get more experienced, but they are soon replaced with new challenges. That’s part of the journey and a constant learning process.

What are your financial modeling nightmares?

This article is accurate and true to the best of the author’s knowledge. Content is for informational or entertainment purposes only and does not substitute for personal counsel or professional advice in business, financial, legal, or technical matters.

Questions & Answers

    © 2018 Hedieh Kianyfard

    Comments

      0 of 8192 characters used
      Post Comment

      No comments yet.

      working

      This website uses cookies

      As a user in the EEA, your approval is needed on a few things. To provide a better website experience, toughnickel.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

      For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://toughnickel.com/privacy-policy#gdpr

      Show Details
      Necessary
      HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
      LoginThis is necessary to sign in to the HubPages Service.
      Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
      AkismetThis is used to detect comment spam. (Privacy Policy)
      HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
      HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
      Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
      CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
      Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
      Features
      Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
      Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
      Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
      Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
      Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
      VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
      PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
      Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
      MavenThis supports the Maven widget and search functionality. (Privacy Policy)
      Marketing
      Google AdSenseThis is an ad network. (Privacy Policy)
      Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
      Index ExchangeThis is an ad network. (Privacy Policy)
      SovrnThis is an ad network. (Privacy Policy)
      Facebook AdsThis is an ad network. (Privacy Policy)
      Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
      AppNexusThis is an ad network. (Privacy Policy)
      OpenxThis is an ad network. (Privacy Policy)
      Rubicon ProjectThis is an ad network. (Privacy Policy)
      TripleLiftThis is an ad network. (Privacy Policy)
      Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
      Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
      Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
      Statistics
      Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
      ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
      Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)