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

Questions to Drive Budgeting, Reporting and Accounting Process Improvements

As a business reaches a certain point in its growth, whether that growth is organic or through acquisitions, it becomes necessary to explore budgeting, reporting and accounting process improvements.

May 11, 2022Julie Porter

Project Management

Understanding PMP Concepts: a PMP Revisits Past Projects

In the interest of post-mortems and informed hindsight, I thought it would be insightful to revisit some previous projects to explore PMP concepts in action. In other words, let’s revisit some of my long-gone experiences as a less-seasoned consultant to see how experience and a PMP credential informs a Consultant’s approach.

April 27, 2022Seena Mostafavipour, MBA, PMP, CVA

Financial Systems

Enhancing Reporting, Budgeting & Forecasting After Your QuickBooks to NetSuite Migration

In part one, we explored best practices for empowering cost-center transparency in your QuickBooks to NetSuite migration. Those recommendations and the exploration below come from my experience in supporting a company through that process. As an FP&A professional, I found the migration exciting due to the advanced reporting and analysis that was available in the… View Article

April 20, 2022Isaac Alvarez

See All

Back to Insights