"From messy CSV to decision-grade model in minutes, not days. Model the “so what,” not just the cells—ship answers fast. Numbers with a point—build sheets that drive action.”
All
Modifiable
LLM-Conversation
All
Senior business analyst prompt for creating Excel spreadsheets with structured requirements, working formulas, proper formatting, automation, documentation, and constraints. Guides intermediate-level Excel users through data requirements, calculation logic, automation setup, and documentation needs.
Model accounts receivable collection patterns by aging bucket with realistic collection rate assumptions. Track major customer payments separately. Link to main 13-week model with scenario toggles.
Consolidate all financial sheets into professional board summary package. Include executive summary financial performance cash/runway department efficiency and export instructions. Format for print and PDF.
Build scenario modeling system with Base Case Upside and Downside scenarios. All assumptions and outputs update automatically when scenario is changed. Includes sensitivity analysis and probability-weighted forecasting.
Create a master assumptions sheet with all revenue cost headcount and working capital assumptions organized by section. Includes revenue drivers COGS breakdown headcount plan by department operating expenses capital expenditures and funding assumptions with scenario toggles.
Consolidate departmental financial exports and operational data into comprehensive board presentation package. Includes financial analysis departmental review forward-looking projections and executive summary.
Create weekly executive dashboard showing starting/ending cash cash flow components runway critical payment dates and automated alerts for cash concerns. Include scenarios and decision triggers.
Build cohort table tracking customer acquisition month months since acquisition and revenue/customer count retained. Create retention % view normalized to Month 0. Apply conditional formatting for visual pattern identification.
Transform rough dashboards into executive-level presentations with professional formatting key metric creation visualization optimization and business insight generation. Suitable for board presentations.
Deep dive into what drove revenue changes by analyzing new customer sources expansion types contraction reasons and churn analysis. Create risk dashboard showing customers at churn risk and expansion opportunities.
Calculate comprehensive win rate metrics including overall company win rate win rate by sales rep and win rate by deal size bucket. Analyzes average deal size differences between won and lost deals to identify patterns.
Build monthly cash flow statement showing operating cash flow investing activities and financing activities. Model working capital changes funding rounds and debt payments to project ending cash balance and runway.
Build complete revenue bridge analysis from customer transaction data showing drivers of quarter-over-quarter revenue change. Includes cohort analysis NRR/GRR calculations and scenario modeling.
Build one-page executive dashboard with large-format key metrics including total pipeline value weighted pipeline average deal size and win rates. Displays quarterly forecasts top performers and risk indicators in clean scannable layout.
Create detailed hiring plan with monthly headcount tracking by role and department. Calculate fully-loaded employee costs including salary benefits payroll taxes and equipment. Track ramp time for new hires and sales commission structures.
Analyze unit economics by customer segment (Enterprise/Mid-Market/SMB) and product line. Calculate tier performance upgrade paths and bundle economics. Recommend resource allocation by profitability.
Transform messy data exports into clean analysis-ready datasets through standardization categorization and quality validation. Includes duplicate removal format standardization and flagging of data requiring manual review.
Format revenue bridge analysis into professional presentation with waterfall chart key metrics scorecard insights summary and forward outlook. Create forward-looking revenue bridge with projections.
Track revenue bridge components over 6-12 quarters/months to identify trends. Create cohort retention heatmap showing revenue retention over time. Identify seasonal patterns and cohort performance variance.
Build monthly expense projections organized by department (Engineering Sales Marketing CS G&A). Model headcount costs contractors software and departmental overhead with scaling assumptions.
Build professional income statement with rolling 12-month view using SUMIFS formulas to pull categorized data. Includes revenue sections gross profit calculations operating expenses and proper formatting with subtotals and borders.
Create comprehensive expense calendar showing all recurring payments payroll dates one-time expenses and their timing within the 13-week window. Auto-populate main model and flag payment optimization opportunities.
Build cap table tracking founder investor and employee ownership across funding rounds. Model dilution from equity grants and future fundraising. Calculate exit scenarios and liquidation preference impacts.
Create automated actuals import system with paste zone data validation and category mapping from accounting systems. Uses SUMIFS formulas to automatically populate budget tracker with validation checks and last-updated tracking.
Build annual budget input interface with data validation dropdowns and automatic monthly distribution from annual totals. Links to main budget tracker and includes validation checks ensuring monthly budgets sum to annual amounts.
Add budget comparison columns with dollar and percentage variance calculations including intelligent conditional formatting. Colors favorable variances green and unfavorable red correctly accounting for revenue vs expense logic.
Create executive-ready unit economics summary with current state metrics key insights benchmarking strategic priorities quarterly targets monitoring cadence and red flag alerts.
Automatically categorize transactions into standard P&L categories using vendor and description field intelligence. Flags ambiguous transactions for manual review while organizing revenue COGS and operating expenses systematically.
Create revenue analysis sheet with 13-month history showing MoM and YoY growth rates. Calculate TTM revenue run rate 3-month average and CAGR. Include trend visualization and growth acceleration/deceleration analysis.
Summarize CRM pipeline data showing deal counts total value average deal size and weighted pipeline by sales stage. Calculates key totals for open pipeline closed won and closed lost with proper formatting.
Build investor-grade SaaS metrics dashboard including ARR growth NRR LTV:CAC magic number Rule of 40 and benchmarking. Create monthly scorecard suitable for board/investor presentations.
Create executive dashboard with key budget numbers department scorecard with status indicators and monthly trend charts. Includes auto-generated alerts for budget concerns and formatting optimized for printing and presentations.
Create visual funnel with data bars showing deal volume by stage and conversion rates between stages. Includes leakage analysis with color-coded health indicators for conversion rates to identify bottlenecks.
Transform bank or credit card exports into categorized expense reports with automatic vendor standardization and smart categorization. Flags high amounts duplicates unusual merchants and potential personal expenses while creating summary tables by category and vendor.
Create comprehensive validation section checking revenue COGS and expense totals against source data. Displays checklist with indicators for data reconciliation missing months and items requiring review.
Systematically repair Excel formula errors including #REF! #DIV/0! #VALUE! and circular references. Create error log fix all errors optimize formulas and add validation framework.
Build scenarios for efficiency improvements growth investments market pressure expansion focus and product-led growth. Create sensitivity tables and break-even analysis. Build decision tree for strategic planning.
Consolidate revenue and expense projections into standard income statement format. Include gross profit operating expenses by category operating income and net income with margin calculations and Rule of 40 tracking.
Create comprehensive metrics sheet with SaaS/business KPIs including growth retention unit economics profitability operations and benchmarking. Include trend tables and metric definitions.
Project future revenue from existing cohorts using retention curves. Model new cohort revenue contributions. Create revenue forecast with base/growth/conservative scenarios. Show revenue dependency on cohort age.
Create comprehensive dashboard tracking growth metrics unit economics profitability operational metrics cash health and benchmarking comparisons. Include monthly scorecard with traffic light status indicators.
Add conditional formatting for budget variances with red for over-budget and green for under-budget based on customizable thresholds. Generates automated insights identifying departments most over or under budget and calculates company burn rate vs budget.
Calculate customer and revenue retention rates by cohort. Compute GRR NRR and expand LTV. Identify best/worst performing cohorts and seasonal patterns. Compare to industry benchmarks.
Analyze spending by department showing headcount payroll contractors software travel and other costs. Calculate spend as % of revenue and productivity metrics. Compare month-to-month and YTD.
Build monthly MRR waterfall showing new MRR expansion contraction and churn. Model bookings vs revenue recognition with deferred revenue tracking. Include Quick Ratio and NRR calculations by cohort.
Build monthly/quarterly revenue projections using cohort-based customer buildout. Model new customer MRR expansion revenue contraction and churn with detailed tracking by customer segment and revenue stream.
Create cohort retention tables tracking revenue and customer retention over time. Calculate GRR NRR logo retention and expansion rates. Identify best/worst performing cohorts and seasonal patterns.
Build revenue bridge showing starting revenue plus new/expansion minus contraction/churn to ending revenue. Calculate GRR and NRR. Break down by customer segment. Create visual waterfall chart.
Calculate CAC ARPC gross margin and LTV for the overall business and by customer segment. Compute payback period and LTV:CAC ratio with benchmarking. Create unit economics summary dashboard.
Create cohort heatmap retention curves by cohort revenue vs customer retention comparison and cohort size value analysis. Auto-generate key insights about retention trends and expansion timing.
Calculate unit economics for each acquisition channel (Direct Sales Inside Sales Paid Ads Content Partner). Build channel comparison matrix and channel attractiveness framework. Model optimal spend allocation.
Track period-over-period customer revenue changes to identify New Retained Expanded Contracted and Churned customers. Create summary table showing count and revenue by status.
Build scenario modeling (best/base/worst case) for 13-week cash flow. Create sensitivity tables showing impact of collection delays expense timing changes and funding timing. Include break-even analysis.
Create department budget tracker with monthly budget and actual columns YTD calculations and full-year projections. Includes variance columns with formulas and collapsible department groupings for easy navigation.
Build complete headcount tracking system with fully-loaded cost calculations FTE tracking and monthly burn projections. Includes hiring plan integration compensation analysis tenure tracking and scenario modeling for workforce planning decisions.
Add comprehensive scenario planning capabilities to financial models with Base Case Upside and Downside scenarios. Includes assumption management system comparison analytics and decision support.
Calculate historical LTV for mature cohorts and predictive LTV for newer cohorts. Compute CAC payback period. Analyze LTV by customer segment and acquisition channel. Model LTV sensitivity to key variables.
Consolidate all financial models into comprehensive board package with executive summary key metrics forward outlook and decision items. Format professionally for board meeting presentation.
Track days in current stage for all pipeline deals and flag stale deals over 30 days or at-risk deals with past-due close dates. Calculates average pipeline age and provides sorting by longest-sitting deals for prioritization.
Clean raw transaction data from accounting exports by formatting dates and amounts properly removing duplicates and adding month extraction columns. Creates structured foundation for P&L statement generation with data quality flags for missing information.
Build 13-week cash flow model framework with proper structure for inflows outflows and balance tracking. Include operating S&M and other expense categories with week-by-week detail.
Model 24-month cash position with monthly burn rate tracking. Include revenue collection assumptions planned funding rounds and scenario toggles. Display current runway cash out date and funding recommendations.