Startup Funding Espresso -- How to Build a Bottoms-up Financial Model

Published: Feb. 8, 2022, noon

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.\xa0 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\u2019s go startup something today. ___________________________________ For more episodes from Investor Connect, please visit the site at: \xa0 Check out our other podcasts here: \xa0 For Investors check out: \xa0 For Startups check out: \xa0 For eGuides check out: \xa0 For upcoming Events, check out \xa0 For Feedback please contact info@tencapital.group\xa0\xa0 Please , share, and leave a review. Music courtesy of .