
Every financial model starts with a question. Is this project feasible? How much capital do we need? What will investors ask? Our case studies show how financial models answered those questions for real businesses, from a gin distillery and a battery recycler to a solar park, a private debt fund, and mobile apps.
Each case study walks through the situation, the questions the model had to answer, the key drivers and scenarios, and what the results meant for the decision. Use them to see what a good model looks like in your industry before you build or buy one.
Why Financial Model Case Studies Are Worth Your Time
A template shows you the structure of a model. A case study shows you the model at work. Here is what you gain from reading one:
- Learn from real decisions, not theory. Each case follows a business through an actual planning, fundraising, or valuation question, so you see how the numbers shaped the outcome.
- Find the drivers that matter in your industry. Case studies point out which few assumptions move the result, such as gas price and certification for biogas, payable rates for battery recycling, or chance of success for biotech.
- Anticipate investor and lender questions. Many cases list the questions investors asked and how the model answered them, so you can prepare before your own pitch.
- See scenario and risk analysis in practice. Worst, base, and best cases show how to present downside honestly and still make the case for the upside.
- Choose the right template with confidence. Seeing a model solve a problem like yours makes it easier to pick the template, or the custom build, that fits.
- Save time and avoid common mistakes. Learn which methods hold up (for example, a DCF over EBITDA multiples for a solar park valuation) before you commit time to building.
Browse Case Studies by Industry and Use Case
We have published several case studies across many industries. Pick your sector below.
Renewable Energy
- Biogas Financial Model Case Study: Shows a biogas developer that gas price and certification decide whether the project is feasible, with the key drivers, scenarios, and questions to ask.
- Green Hydrogen Financial Model Case Study: One model compares every wind-to-hydrogen project on the same basis, covering wind and hydrogen returns, tax credits, offtake (HPA) length, and electrolyzer sizing.
- Solar Park Valuation Case Study: A fair market value DCF prepared for a tax authority, separating PPA and post-PPA years, and explaining why EBITDA multiples fall short.
Oil & Gas
- Gas Well Project Financial Model Case Study: Tests a new drilling program for investors and compares four uses of the gas (direct sale, power, processing, and Bitcoin mining) in worst, base, and best cases.
Real Estate
- Airbnb Building Acquisition Financial Model Case Study: A monthly model shows a developer what a short-term rental building earns on all-in cost, including seasonality and a downside case.
- Fund Buying Distressed Real Estate: Financial Model Case Study: A per-property model helps a distressed real estate fund judge each deal, show investors the range of returns, and set out the profit split.
Manufacturing
- Battery Recycling Financial Model Case Study: Prepares a recycler for investor talks with supply contracts, payable rates, cost scenarios, and the questions investors will raise.
- Beverage Manufacturing Financial Model Case Study: Shows a beverage start-up where its margin is really made, why its own brand deserves more focus, and what investors ask.
Food & Beverage: Distillery
- Gin Distillery Financial Model Case Study: Breaks down what each bottle earns by sales channel and what three funding rounds cost in capital and founder equity.
Private Debt & Financial Services
- Private Debt Fund Financial Model Case Study: Explains loan yields, defaults, fees, and investor payouts, with fund returns in worst, base, and best cases.
Life Sciences
- Biotech Financial Model Case Study: A model built on realistic probabilities of success helps a biotech founder plan the next funding round, with upside and downside views.
Online & Information Technology
- Community App Financial Model Case Study: A subscription app model shows founders whether paid growth pays off, how many subscribers it takes to break even, and whether to bootstrap.
- Nightlife Events App Financial Model Case Study: Gives pre-pilot founders a realistic view of how much cash they need, the risks, and the potential return.
Growth Strategy: Product Rollout
- Product Rollout Financial Model Case Study: Calculates the payback period per location and shows how reinvested profits can fund a fast multi-site rollout.
How to Use These Case Studies
- Start with your industry and read the closest case study to see which drivers and scenarios matter most.
- Note the investor questions each case raises and check that your own plan answers them.
- Pick a template built for your sector (see below) and plug in your own assumptions.
- Need something bespoke? Our experts can build a custom model around your business.
Conclusion: Turn These Insights Into Your Own Financial Model
The businesses in these case studies did not start from a blank spreadsheet. They started from a clear structure, focused on the few drivers that matter, and tested their plans against realistic scenarios before talking to investors. You can do the same. Browse expert-built financial model templates for the industries covered above:
- Renewable Energy: All Renewable Energy Templates · Solar · Biogas · Hydrogen · Wind
- Oil & Gas: Oil & Gas Financial Model Templates
- Real Estate: All Real Estate Templates · Airbnb
- Manufacturing & Product Rollout: Manufacturing Financial Model Templates
- Distillery: Distillery Financial Model Templates
- Private Debt & Financial Services: Financial Services Templates · Debt Fund
- Life Sciences: Life Science Financial Model Templates
- Online & IT: Information Technology Templates · Mobile App · SaaS
Ready to model your own business? Find a template for your industry above, or contact our team for a custom financial model built around your plan.