Investor Connect Podcast

How to Build a Bottoms-up Financial Model

Hello, this is Hall T. Martin with the Startup Funding Espresso -- your daily shot of startup funding and investing.

There are two approaches to building a financial model: top-down and bottoms-up.

The bottoms-up approach uses specific data from your financials, such as historical revenue, specific expenses, working capital, etc.

You apply assumptions to the historical numbers to build out the projections.

To build a bottoms-up financial model, consider the following:

Sales and marketing expenses drive the revenue.

Review the historical relationship between sales and marketing expenses and revenue. 

Project expenses and revenue based on the monetization model you have, such as recurring revenue, transaction fee, contract work, etc.

Calculate your cost of goods sold which is the cost to build and deliver the product.

Project the operating expenses which are those that do not directly drive the revenue, such as office leases and utilities.

Fixed expenses remain the same.

Variable expenses rise and fall with the activity of the business.

Calculate your working capital, also called cash runway.

Add key metrics into the model such as customer acquisition cost, lifetime value of customer, and growth rate.

Adjust the model for any other business conditions or events such as a fundraise.


Thank you for joining us for the Startup Funding Espresso where we help startups and investors connect for funding.

Let’s go startup something today.
___________________________________

For more episodes from Investor Connect, please visit the site at: http://investorconnect.org 

Check out our other podcasts here: https://investorconnect.org/ 
For Investors check out: https://tencapital.group/investor-landing/ 
For Startups check out: https://tencapital.group/company-landing/ 
For eGuides check out: https://tencapital.group/education/ 
For upcoming Events, check out https://tencapital.group/events/ 

For Feedback please contact info@tencapital.group  

Please follow, share, and leave a review.

Music courtesy of Bensound.

Direct download: How_to_build_a_bottoms_up_financial_model.mp3
Category:general -- posted at: 6:00am CDT