Starting with the end in mind is one of the simplest ideas that is frequently ignored. I have seen so many analysts begin designing a financial model without having a clear understanding of the purpose of the model. In this article, you will find three types of models and some tips on how to design a good one.
John Sanchez
John Sanchez is Managing Director of financial planning and training consultancy FPA Group, LLC . He has more than 20 years’ experience including working at a top ten accounting firm, mergers and acquisitions work for Fortune 500 companies, and leadership positions in consolidated business groups such as Royal Caribbean Cruises and AutoNation. John has substantial experience in capital and strategic planning with proven skills in large-scale budgeting, forecasting and financial planning.
Since his move into developing business training courses for financial professionals in the areas of communications, financial planning and analysis, budgeting and forecasting, John has established a clientele including solo start-ups and multi-billion dollar conglomerates in an eclectic array of industries. Among his many projects, he was hired by the Association of Financial Professionals (AFP) as the instructor for the inaugural exam preparation course for the Certified FP&A Professional certification.
John holds a bachelor’s degree in accounting and has served as a member of the board of directors for several organizations.
Author's Articles
When creating a driver-based model, it is important to produce one that is not overly detailed or complex but one that is accurate and actionable. Avoid complexity by adding variables if they do not provide analytical benefit. Starting with the chart of accounts is not a good idea. The model should focus on key performance drivers.
University of Pennsylvania researchers report that the human retina processes data at approximately 10 million bits per second. That’s awfully fast compared to a typical adult reading rate of about 400 to 600 words per minute. There are many advantages to visualising data, aside from speed.
Most business people are familiar with the Pareto Principle, also known as the 80/20 rule. Simply put, it says that 20% of inputs generate 80% of outputs. It's a very simple concept, but many people struggle to use it. When it comes to communication, the practical application of the 80/20 rule is to listen 80% of the time.