Careers

On Supporting a Client with a Dynamic Financial Model

The client was beginning the process of building out a manufacturing facility and wanted to explore partially financing the buildout using venture debt. In order to do so, they needed a more sophisticated and versatile corporate financial model and five-year forecast to determine how much debt the business could support.

However, the existing model was static and incapable of running different scenarios without extensive manual adjustments.

I worked with the COO/Co-Founder to develop various scenarios around key revenue drivers and financing options and to establish base, high and low cases that could be run through the dynamic financial model simply by changing the value of a single cell.

This model allowed the founders to see the company’s “path to profitability” in future years as well as the cash burn required to achieve profitability under multiple operational and financing scenarios. (Learn more about this type of analysis: Scenario Analysis and Sensitivity Analysis in Financial Forecasting.)

The model is also being used as the basis for all financial projections required as part of the due diligence process associated with financing the new manufacturing facility.

mike dynamic forecast model thumbnail

To learn more about forecasting, you can also read our article on dynamic cash-flow forecasting on CFO.com.

Careers at 8020 Consulting

We take pride in nurturing long-term relationships with our team members and our clients. If you’re interested in working on our team of accounting and finance consultants, visit the careers section of our website to learn more about life at 8020. You can also put in an application for consideration by following the instructions at the bottom of the page:

New call-to-action

About Mike

Mike has more than 15 years of experience in roles requiring expertise in strategic planning, forecasting, budgeting, business valuation, financial modeling and both buy-side and sell-side M&A transaction support. He has worked with clients across several industries, including entertainment, e-commerce and subscription, real estate and consumer products. Prior to 8020, he served as Finance Manager at Elements Behavioral Health, where his responsibilities included leading the budgeting and forecasting processes as well as acquisition transaction support. Additionally, he served as a Sr. Associate in the Private Capital group at Union Bank, where he focused on executing middle-market acquisition opportunities across various sectors. Mike holds an MBA from the Graziadio School at Pepperdine University, a B.A. in Economics from Brock University and is a CFA Charter holder.

Categorized in:

similar articles

Learn to think and approach problems like our financial consultants.

Financial Reporting & Accounting

7 Nuances That Make Insurance Agency Accounting Unique

While insurance brokerage accounting isn’t necessarily more complex, it is unique when it comes to integrating operations and financial reporting. Whether your agency is in the early stages of getting off the ground or you are an established one looking to grow, below are several topics that should be taken into consideration when evaluating if… View Article

September 29, 2022Steve Rochen

Financial Reporting & Accounting

Questions Every CPG Accounting and Finance Team Should Be Asking

Best-in-class consumer packaged goods (CPG) accounting and finance departments are particularly adept at understanding their product-driven companies, integrating themselves into their organizations and pushing finance and accounting insight throughout the company. Companies that want to develop best-in-class departments can take strides by asking the right questions and taking care to work their way to the… View Article

September 14, 2022Bob Clark

Financial Reporting & Accounting

5 Signs Your Accounts Payable Department Could Be More Efficient

The Accounts Payable department is often considered something of a forgotten branch of the Accounting department. While it plays a pivotal role in ensuring that the company stays in good graces with its vendors, it is often considered to possess simple processes and not require modernization. In reality, the Accounts Payable (AP) department is often… View Article

August 18, 2022Ellen Vayner

See All

Back to Insights