Battery As A Service (BaaS) Financial Model Template

Unlike a simple one-page calculator, this battery swapping station financial forecast template is a complete monthly-to-yearly financial model with the following sheets:

• ⚙️ Driver's Assumptions – the only tab you need to fill in (all input cells are color-coded)
• 📈 Executive Summary, Metrics & Dashboard – lifetime revenue, EBITDA, NPV, IRR, ROIC, key ratio charts
• 📈 Valuation – DCF valuation, EV/EBITDA and EV/Revenue multiples, pre-money & post-money valuation
• 📊 Financial Statements (Monthly & Yearly) – full Income Statement, Balance Sheet and Cash Flow Statement
• 👥 Customers – monthly new customers, churn, and net active subscribers by segment
• 💰 Revenue – Subscriptions + Swap Forecast and 💰 Revenue – Walk-In Charging – two distinct revenue engines
• 💸 COGS & OPEX – per-battery, per-swap, per-user, and revenue-based cost drivers
• ☀️ Solar Demand Forecast and 🔋 BESS Demand Forecast – daylight vs. night energy demand splits
• Energy Dispatch Flow & Solar + BESS Production – models how solar generation and battery discharge meet demand
• 🏗️ BAAS, Solar, and BESS CAPEX & Depreciation (3 separate tabs) – asset-class-level CAPEX and depreciation schedules
• 👥 Headcount & Salaries and Loan Amortization – payroll planning and debt schedule

Every tab is interlinked, so a single change in your assumptions flows automatically through revenue, costs, financial statements, and valuation.

This isn't a single-revenue-line spreadsheet. It models the layered revenue reality of a real BaaS operation:

• Subscription revenue by customer segment (individual riders, car owners, logistics companies, industrial clients, telecom towers)
• Battery swap fees and overage swap charges for usage beyond plan limits
• Walk-in / non-subscriber charging revenue, with its own growth rate, pricing, and daily capacity cap
• Second-life battery revenue and cost savings, once EV batteries are retired and repurposed into stationary BESS storage
• Ancillary energy revenue, including reserved capacity payments and grid-charging cost offsets from your solar + BESS setup

Each revenue stream carries its own COGS structure — per battery, per swap, per user, and as a percentage of revenue — so your gross margin by segment is always visible, not buried in a single blended number.

Everything is driven from the Driver's Assumptions tab using simple, color-coded input cells:

• Customer segmentation: starting month, first-month users, monthly growth rate, and churn rate — per segment
• Pricing: monthly subscription fee, swap fee, and overage fee — per segment
• Battery allocation & lifecycle: batteries per subscriber, swaps/day, usage life (months), charging efficiency, total life cycles
• CAPEX planning: dynamic (auto-calculated) EV battery CAPEX plus static CAPEX for interconnection, land, contingency, and website costs
• Solar & BESS toggle: switch solar and/or BESS installation on or off, with capacity, performance ratio, daylight hours, irradiance, and degradation rate inputs
• Working capital: accounts receivable timing and collection percentages
• Headcount & payroll: designation-wise hiring month and salary
• Financing: equity vs. loan-based investment, WACC/CAPM inputs, dividend policy

Because every input is a variable, you can stress-test different growth rates, pricing tiers, or solar/BESS scenarios in seconds and instantly see the impact on your 10-year outlook.

• Full 3-statement projections (Income Statement, Balance Sheet, Cash Flow) on a monthly and yearly basis
• Executive Summary dashboard with lifetime Revenue, EBITDA, Net Income, and Free Cash Flow
• Valuation outputs — DCF-based Enterprise & Equity Value, EV/EBITDA and EV/Revenue multiples, pre-money and post-money valuation for fundraising
• Key ratios — EBITDA margin, ROIC, ROE, DSCR, Debt/EBITDA, Cumulative ROA
• Customer and battery-fleet metrics — active subscribers, batteries in field, swaps/day, batteries retired from service
• Energy metrics — solar generation vs. BESS discharge vs. grid demand, battery storage capacity buildup
• CAPEX & depreciation schedules by asset class, plus a full loan amortization schedule

This makes it just as useful for internal planning as it is for a bank, investor, or grant application.

• Ready-to-use — download and start entering your own numbers immediately; no formula-building required
• Simple, color-coded inputs — yellow cells are the only cells you touch
• Built specifically for BaaS economics — subscription + swap + charging + solar/BESS revenue in one linked model, not a generic template forced to fit
• Investor-grade valuation built in — DCF, comparable multiples, and pre/post-money calculations are already set up
• Not password protected — fully editable so you can expand line items as your business evolves
• Free support and error correction included after download

• Founders launching an electric vehicle battery swapping or battery-subscription startup
• Consultants preparing a battery swapping station financial model for a client pitch or feasibility study
• Renewable energy and infrastructure teams evaluating a combined BaaS + solar + BESS rollout
• Analysts who need an EV battery swapping cost & revenue calculator Excel for quick scenario comparisons
• Anyone applying for funding who needs a defensible battery as a service business model Excel template with a working valuation section

• Download the Excel file after purchase — works in Excel (desktop or Microsoft 365).
• Open the Driver's Assumptions tab and fill in the yellow input cells with your company's numbers.
• Toggle Solar/BESS on or off depending on whether your business includes on-site energy infrastructure.
• Review the Dashboard, Financial Statements, and Valuation tabs — they update automatically.
• Customize line items (segments, cost categories, CAPEX items) as needed — the model isn't locked.

Both. You can toggle solar and BESS on or off independently, so the model works whether you're running a pure battery-swapping operation or pairing it with on-site renewable energy infrastructure.