revenue-buildlisted

# Revenue Build (Driver-Based Forecast) ## When to use Use when revenue should be built bottom-up from real operating drivers rather than a single growth percentage: customers from marketing spend or a funnel, churn, ARPU, or volume times price by product line. Good for operating plans, ARR forecasts, and fundraising models that need a defensible bridge from drivers to the top line. The skill builds a downloadable .xlsx in the Claude app with openpyxl; it does not use any Excel add-in or Microsoft 365 connection. ## What it builds A workbook with six tabs: - Cover: title, color legend, scenario selector, headline revenue and growth. - Drivers: all blue inputs (starting customers, marketing spend, CAC or funnel rates, ARPU, churn, price, scenario multipliers). - Revenue Build: the period-by-period customer or units schedule and revenue. - Summary: annual revenue, growth, ending customers, and the scenario in force. - Sensitivity: new-adds by churn Data Table driving ending ARR or revenue. - Checks: roll-forward identity and sanity flags. ## Build workflow 1. Create the workbook and the six tabs in the order above. 2. On Drivers, lay out every input in blue with units; add a scenario cell (1=Base, 2=Bull, 3=Bear) named `scn`. 3. Set up the period header row (months or quarters) once and reference it everywhere. 4. Build the customer or units roll-forward on Revenue Build: beginning, adds, churn, ending. 5. Compute revenue each period from the schedule (customers times ARPU,