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 over 10 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 served as a Sr. Analyst 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.

M&A Due Diligence & Transactions

A Seller’s Guide to Maximizing Value with a Carve-Out Transaction

Carve-out transactions (or “carve outs”) have become increasingly popular over the last two decades. Sellers view carve outs as instruments to extract cash from non-core businesses, while investors view them as opportunities for competitive advantages, provided the carve out aligns with their experience and strategy. A carve-out transaction is typically more complex than a complete… View Article

May 6, 2021Aniv Nayar

Careers

Julian de Luna: 6 Questions for 6 Years

Julian de Luna recently celebrated his sixth year with 8020 Consulting! In this post, Julian revisits past projects and experiences, offers advice to professionals considering consulting on their career paths and takes a look forward at the years to come. 1. What do you enjoy most about your work these days? Julian: What I enjoy… View Article

May 4, 2021George Jacob

Financial Systems

Transform Your Budget and Forecast Process: From Excel to Oracle NetSuite PBCS

For small to mid-size companies, relying on Excel can create stress every budget season, including a forecast cycle or two, if time permits! Excel is a great tool for analysis and data representation. However, the pain of consolidating, linking and maintaining version control with multiple spreadsheets and several users to create an annual budget takes… View Article

April 29, 2021Desiree Vaughn

See All