Financial modeller's 10 worst nightmare

A list of the top 10 worst nightmares for a financial modeller, and how to solve them:

• Cleaning up someone else's models.
• Circular references appearing where you did not expect them.
• The financial model crashes, and you don't have a backup.
• Worksheet compatibility issues.
• A balance sheet that does not balance.
• Changes in accounting standards or applicable fiscal regimes which, in turn, make your life miserable.
• The first time you are asked to build a cash-flow waterfall when the only waterfall you knew was Niagara Falls.
• Clients who have Excel phobia.
• 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.
• Being called a data cruncher.