SaaS Expansion Strategy: 3-Statement Financial Model & Scenario-Based Valuation

📌 Business Problem

CloudNova Analytics, a mid-size B2B SaaS company, is evaluating a major expansion into the European market. The objective was to build a dynamic financial model to assess whether projected unit economics justify the expansion risk and capital investment.

🧠 Solution Overview

I developed an integrated 3-statement financial model in Microsoft Excel to evaluate the long-term financial impact of the expansion under multiple operating scenarios.

⚙️ Model Architecture

• Bottom-Up Revenue Modeling: Built revenue projections using core SaaS drivers (starting customers, new acquisitions, annual churn rate, and CAC) instead of flat growth assumptions.
• Fully Linked 3-Statement Model: The Income Statement, Balance Sheet, and Cash Flow Statement are dynamically integrated, ensuring automatic balance sheet reconciliation ($0.00 check) without manual plug adjustments.
• DCF Valuation Layer: Estimated implied enterprise value using a WACC-based discounting approach (assumed 12% based on software market benchmarks) and a 3% terminal growth assumption.
• Scenario Engine: Implemented Base, Bull, and Bear cases using Excel's CHOOSE function linked to Data Validation dropdowns to simulate different market conditions in real-time.

📊 Key Insights & Final Recommendation: GO

Based on the scenario-weighted outcomes, the expansion demonstrates acceptable downside risk and strong upside potential, supporting a GO decision.

• Base Case: The company reaches an Implied Enterprise Value of $53.7M by 2030, indicating sustainable profitability.
• Bear Case Resilience: Even under severely stressed assumptions (a churn spike to 15% and CAC increasing to $4,500), the business remains operationally resilient and converges toward positive cash flow by 2028.
• Key Risk: The valuation is highly sensitive to customer retention. Management must prioritize onboarding and customer success in the European market to ensure churn remains at or below the 8% Base threshold.

🔍 If I Had More Data

To improve model accuracy and depth, I would incorporate:

1. Cohort-Based Revenue Modeling: Replacing blended churn assumptions with retention curves by customer vintage.
2. Pricing Segmentation Analysis: Evaluating the revenue impact across different SaaS tiers (Basic, Pro, Enterprise) and European regional pricing elasticity.

💡 What I Learned

This project strengthened my ability to translate financial accounting theory into an integrated, decision-driven tool using Excel. It also deepened my practical understanding of SaaS unit economics, working capital dynamics, and DCF valuation logic.