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 Planning & Analysis

The Art of Storytelling in Finance: Challenges and Benefits

As with any industry, the entertainment business has grown and changed drastically over the last decade. Streaming content, which was once considered a niche part of the entertainment industry, has now become an integral part of how we consume television and film. This change has posed a significant challenge as executives and C-level leaders want… View Article

January 25, 2023Joe Favre

Financial Planning & Analysis

The Importance of Trade Spend Tracking

In the last few years, I worked at two different consumer goods companies – one for natural skincare, another for CBD. Their trade spend percentages had skyrocketed over the last couple of years, and their owners wanted that percentage reduced! At both of those companies, I became known as the “spend police.” My main responsibility… View Article

January 11, 2023Lizzette Acuña

Careers

Vikram Mehta: 9 Questions for 9 Years

We’re celebrating Vikram Mehta’s recent nine-year anniversary with 8020 Consulting! In this interview, Vikram reflects on what he likes most about his work, looks back on past projects, explores how he’s grown as a Consultant and revisits memorable experiences with Clients. 1. What do you enjoy most about your work these days? I enjoy the… View Article

December 9, 2022George Jacob

See All

Back to Insights