--- title: "Financial Modeling Best Practices: 5 Steps to Improve It" description: Financial modeling is the foundation of proper business planning. Here's the best practices to get the most out of your driver based forecasting model. image: https://www.jirav.com/hubfs/model-rocket-engineer-1200x628.jpg --- ![](https://www.jirav.com/hs-fs/hubfs/Imported%20sitepage%20images/header-logo.png?width=98&name=header-logo.png) - [ Resources ](https://www.jirav.com/resources) - Menu / Resources - [Resource Center ](https://www.jirav.com/resources) Blogs and resources on all things finance, FP&A, and Jirav [Webinars ](https://www.jirav.com/webinars) Learn more about Jirav and FP&A from industry experts [Events ](https://www.jirav.com/events) See our upcoming calendar of events [Help Center ](https://help.jirav.com/) Guide on how to use Jirav - [ Company ](https://www.jirav.com/company) - Menu / Company - [About ](https://www.jirav.com/company) Learn about Jirav’s story and meet our leadership team [News Coverage ](https://www.jirav.com/news) See the latest news and highlights [Press ](https://www.jirav.com/press-releases) Recent company announcements and updates [Careers ](https://www.jirav.com/careers) View current job openings and learn how to join the Jirav Tower ![business_env](https://www.jirav.com/hubfs/business_env.svg) [ For Businesses ](https://www.jirav.com/reporting-planning-purpose-built-for-businesses) ![accounting_calc](https://www.jirav.com/hubfs/accounting_calc.svg) [ For Accounting & CFO Firms ](https://www.jirav.com/reporting-planning-purpose-built-for-accounting-cfo-advisory-firms) [ Get a Demo ](https://www.jirav.com/request-demo) [ Sign in ](https://app.jirav.com/) ![](https://www.jirav.com/hubfs/April2021/images/banner-shap.png) BLOG # 5 Steps to Better Financial Modeling [![](https://www.jirav.com/hubfs/April2021/images/fb-icon.png) ](http://www.facebook.com/share.php?u=https://www.jirav.com/blog/5-steps-better-financial-modeling/) [![](https://www.jirav.com/hubfs/April2021/images/tw-icon.png) ](https://twitter.com/share?url=https://www.jirav.com/blog/5-steps-better-financial-modeling/) [![](https://www.jirav.com/hubfs/April2021/images/in-icon.png) ](http://www.linkedin.com/shareArticle?mini=true&url=https://www.jirav.com/blog/5-steps-better-financial-modeling/&summary=&source=CeBIT) 4 minute read ![Pensive engineer looking at window, rocket model on tabletop at home](https://www.jirav.com/hubfs/model-rocket-engineer-1200x628.jpg) Entrepreneurs start businesses for lots of different reasons. However, there’s one thing they all have in common — none of them starts their business expecting it to fail. And yet about [50% of businesses fail in the first five years and only 30% make it 10 years or more](https://www.entrepreneur.com/article/299522). There are many reasons why businesses don’t make it. [Investopedia](https://www.investopedia.com/financial-edge/1010/top-6-reasons-new-businesses-fail.aspx) highlights the following: - failure to investigate the market, - poor business plan, - too little financing, - bad marketing, - being too rigid, and - expanding too fast. While there’s no substitute to doing proper up-front research, the other problems listed—bad marketing, poor business plan, rigidity, expanding too quickly, and not having a revenue model—are solvable when you take the time to create a driver-based financial model. ## Why do you need a financial model? Financial modeling is the foundation of proper business planning. It’s the basis for accurate budgets and forecasts that allow you to see how your business is doing month-to-month compared to what you’d planned for. A financial model ties together all the important numbers in your business. Without a model, you might miss important relationships between those numbers. For example, you might pour hundreds of thousands of dollars every month into marketing and watch excitedly as revenue skyrockets, but perhaps you’re not acquiring customers at a price that makes sense for the business in the long-term. Take a look at a handful of food delivery startups that have gone belly-up in the last few years: [Munchery, Sprig, Maple, and Josephine](https://techcrunch.com/2019/01/21/munchery-shuts-down/), They acquired tons of customers but weren’t able to make a profit in the long-term. Perhaps they weren’t paying attention to the right numbers. Without a financial model, you might make gut-level decisions to expand to new markets without actually understanding how much cash you might burn doing so. Consider [Crumbs Bake Shop](https://www.entrepreneur.com/article/310166). They opened up in dozens of markets with a huge retail footprint. But they failed to grasp that cupcakes are an occasional treat, not something people buy every day, and soon thereafter shut down completely. It could be that a financial model would have exposed the flaw in the business plan before investing all that capital. You get the picture. Now, what are the steps you need to take to actually build that model? ## 5 key steps to building your financial model ### 1. Define SMART business goals “Growth” is not a smart goal. “Increase revenue” is not a smart goal. To be a [SMART goal](https://corporatefinanceinstitute.com/resources/knowledge/other/smart-goal/) a goal has to be Specific, Measurable, Achievable, Realistic, and Timely. To define SMART goals for a business, ask the following questions: - In what clearly defined way will we grow the business? - How will we measure that growth? - Is it achievable and realistic with the resources available? - What is our time frame for achieving it? Here’s an example of a SMART goal: **Grow revenue by 20% by the end of 2020.** This goal is the foundation for building your financial model. ### 2. Define key business drivers: What will get you to that goal? What needs to happen to achieve your goal? If you’re an e-commerce company, you make money when you ship orders to customers who have purchased goods on your website. So, to increase revenue, you need more customers, more orders, or you need to charge more per order. By building a [driver-based forecasting model](https://www.jirav.com/blog/what-is-driver-based-planning), you can see all the levers at work—spending more on marketing to get new customers vs. getting existing customers to purchase more products vs. increasing prices—and test what combination of them will get you to your goal. ### 3. Question your assumptions Just because something happened one way in the past, there’s no guarantee that it will continue to work the same way as your business grows. This is why it’s critical to understand—and have the ability to adjust—your assumptions based on what you’re actually seeing play out in the market. From the example above, you decide to test the impact of bringing more customers to your website to purchase a product, so you make the following assumption: **As my ad spend increases 2X, my cost per lead will stay the same.** This might have been true when you increased ad spend from $1,000/month to $2,000 a month, but will it hold true when you increase to $20,000 a month? What if instead, your cost per lead increases 1.5X? Suddenly your profits take a nosedive because your acquisition costs have increased. To reduce risk of an inaccurate forecast, question your assumptions and test multiple scenarios for the most critical ones. ### 4. Goal + drivers + assumptions = financial model [Driver-based modeling](https://www.jirav.com/product/financial-planning-modeling) pulls your goals, drivers, and assumptions into one place so you can see what impacts what and most importantly, start making changes and seeing the impact in real-time on your financial forecast. When you see that your initial assumptions aren’t playing out, you can adjust the model to see whether the reforecasted financials will affect your year-end goal. And… oh no! It looks like you won’t achieve the goal because your cost per lead increased as you ramped up advertising. So, now you need to try another strategy. Maybe this time you’ll focus on getting existing customers to buy more frequently. ### 5. Update the model and reforecast at regular intervals If you never checked in on your financial model to see how you were actually performing against your goals, as in the example above, then you would never know you needed to switch gears. Creating a financial model is a waste of time if you don’t update it regularly. There’s no way you’ll get everything right on the first try, so it’s essential to compare your initial forecast against your actuals. Then, since the numbers almost certainly won’t line up, modify your assumptions and drivers to match what happened. Then reforecast your financial performance through the rest of the year. The companies doing this kind of regular evaluation on a quarterly basis—or even better, monthly—are ahead of the pack. Don’t be the business that gets too busy for regular check-ins! A financial model allows you to monitor if your assumptions are holding true, if your business is actually growing as expected, or if other factors you may not have even considered are impacting growth. A common reason why business owners fail to develop a realistic financial model is the complexity of doing this in Excel, especially when it comes to comparing your forecast to actuals. It’s difficult and time consuming with spreadsheets, and errors inevitably creep into models, resulting in inaccurate projections. Fortunately, we’ve built powerful yet affordable financial modeling software that can do the heavy lifting for you. Get started today building an easy, fast financial model for your business with Jirav. [![Start Free Trial](https://no-cache.hubspot.com/cta/default/2567042/99f213c6-43d5-462a-a74f-14592a4713a8.png)](https://cta-redirect.hubspot.com/cta/redirect/2567042/99f213c6-43d5-462a-a74f-14592a4713a8) ![Blake Oliver, CPA](https://app.hubspot.com/settings/avatar/61911ff6e9873ee6bb72cdcabb8bc2d2) ##### Blake Oliver, CPA Blake is a CPA, former Jirav marketer, founder and CEO of Earmark, and co-host of the Cloud Accounting Podcast. Published July 30, 2020 ###### Related topics - [Finance and fp&a](https://www.jirav.com/blog/topic/finance-and-fpa) ## Related blog posts ![](https://www.jirav.com/hubfs/Jirav_SitePageAssets_Feb2018/blog-banner@2x-231539-edited.png) Finance and fp&a #### Crunch Numbers in No Time: How Jirav Helps Scale & Attract Investors [ Read more ](https://www.jirav.com/blog/str-helper) ![](https://www.jirav.com/hubfs/cdc-w9KEokhajKw-unsplash-2400px.jpg) Finance and fp&a #### A simple model for forecasting the impact of coronavirus and controls [ Read more ](https://www.jirav.com/blog/coronavirus-covid-19-model) ![](https://www.jirav.com/hubfs/A_heavy_load_(14026394702).jpg) Finance and fp&a #### Tips & Tricks for Forecasting Fully Burdened Labor Costs in Jirav [ Read more ](https://www.jirav.com/blog/forecasting-fully-burdened-labor-costs) ![](https://www.jirav.com/hubfs/Jirav%20Team%20Award.png) Finance and fp&a #### On-Demand Webinar: How to Build a Financial Model for an Accounting Firm [ Read more ](https://www.jirav.com/blog/webinar-financial-model-accounting-firm) ![](https://www.jirav.com/hubfs/Screen%20Shot%202020-04-29%20at%2012.28.40%20PM%20cropped.png) Finance and fp&a #### Forecasting the End of COVID-19: Herd Immunity [ Read more ](https://www.jirav.com/blog/forecasting-the-end-of-covid-19-herd-immunity) ![](https://www.jirav.com/hubfs/Screen%20Shot%202020-03-30%20at%2011.08.41%20AM%20copy.png) Finance and fp&a #### Reforecasting the U.S. COVID-19 Impact [ Read more ](https://www.jirav.com/blog/reforecasting-the-us-covid-19-impact) ![](https://www.jirav.com/hubfs/Webinar_%20How%20to%20Build%20a%20Financial%20Model%20for%20a%20Subscription%20Business.png) Finance and fp&a #### On-Demand Webinar: How to Build a Financial Model for a Subscription-Based Business [ Read more ](https://www.jirav.com/blog/webinar/how-to/build-a-financial-model/subscription-business) ![](https://www.jirav.com/hubfs/ameer-basheer-nVrqbvzOh08-unsplash-cropped.jpg) Finance and fp&a #### Precision vs. Accuracy: Financial Modeling Best Practices [ Read more ](https://www.jirav.com/blog/precision-vs-accuracy-financial-modeling) ![](https://www.jirav.com/hubfs/Jirav_SitePageAssets_Feb2018/blog-banner@2x-231539-edited.png) Finance and fp&a #### How to provide meaningful advisory services with a financial forecast [ Read more ](https://www.jirav.com/blog/advisory-services-financial-forecast) [Load more](##) ## Let’s get started! [ Request a demo ](https://www.jirav.com/request-demo) ![](https://ws.zoominfo.com/pixel/GayWM7nWYSEC9X3nq2tn) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Blake Oliver, CPA", "url" : "https://www.jirav.com/blog/author/blake-oliver-cpa" }, "dateModified" : "2023-10-05T10:07:59.503Z", "datePublished" : "2020-07-30T15:41:01.000Z", "headline" : "Financial Modeling Best Practices: 5 Steps to Improve It", "image" : [ "https://www.jirav.com/hubfs/model-rocket-engineer-1200x628.jpg" ], "mainEntityOfPage" : { "@id" : "https://www.jirav.com/blog/5-steps-better-financial-modeling", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.jirav.com/hubfs/Jirav%20Logo%20-%20176x75%20(small%20logo).png" }, "name" : "Jirav" } } ``` ```json { "@context" : "http://www.schema.org", "@type" : "AccountingService", "address" : { "@type" : "PostalAddress", "addressCountry" : "United States", "addressLocality" : "San Francisco", "addressRegion" : "CA", "postalCode" : "94102", "streetAddress" : "25 Taylor Street" }, "description" : "Jirav is a business planning software powering financial planning and analysis in the cloud with all-in-one forecasts, budgets, reports, and dashboards", "geo" : { "@type" : "GeoCoordinates", "latitude" : "37.782585", "longitude" : "-122.411255" }, "image" : "https://www.jirav.com/hs-fs/hubfs/Jirav_SitePageAssets_Feb2018/Jirav%20Logo%20for%20top%20nav.png?width=1200&height=510&name=Jirav%20Logo%20for%20top%20nav.png", "logo" : "https://www.jirav.com/hs-fs/hubfs/Jirav_SitePageAssets_Feb2018/Jirav%20Logo%20for%20top%20nav.png?width=1200&height=510&name=Jirav%20Logo%20for%20top%20nav.png", "name" : "Jirav", "openingHours" : "Mo, Tu, We, Th, Fr 09:00-17:00", "priceRange" : "$100/month-$750/month", "sameAs" : [ "https://www.instagram.com/gojirav/", "https://www.linkedin.com/company/jirav/", "https://twitter.com/GoJirav", "https://www.facebook.com/GoJirav/" ], "url" : "https://www.jirav.com/" } ```