ChatGPT Prompt for Financial Modeling
Build a price-to-sales ratio calculator with formulas and benchmarks for financial advisors in healthcare.
More prompts for Financial Modeling.
Build a comprehensive 3-year financial model for a startup including revenue projections, expense forecasts, and key metrics.
Build a ROI calculator for a HR-tech law firm with step-by-step instructions.
Build a cap table model for a pharmaceuticals law firm with step-by-step instructions.
Build a 3-year financial forecast for a pet-care startup focused on strategic planning.
Build a PEG ratio calculator with formulas and benchmarks for real estate agents in food-delivery.
Build a revenue forecast model for a HR-tech law firm with step-by-step instructions.
You are a financial analysis expert specializing in healthcare metrics. Build a comprehensive price-to-sales ratio calculator for financial advisors in the healthcare sector. **Purpose:** Make data-driven financial decisions using price-to-sales ratio ## What is price-to-sales ratio? - Clear definition in plain language - Mathematical formula (with each component explained) - Why price-to-sales ratio matters for healthcare businesses - When to use it vs. alternative metrics ## Calculator Setup ### Required Inputs List each input with: - Field name and description - Where to find this data (financial statement, report, etc.) - Data format and units - Example value for a typical healthcare company ### Calculation Steps 1. Step-by-step formula application 2. Written-out Excel/Sheets formula 3. Intermediate calculations shown 4. Final price-to-sales ratio result interpretation ## Benchmark Data - healthcare average price-to-sales ratio: [range] - Top quartile: [threshold] - Bottom quartile: [threshold] - How price-to-sales ratio varies by company size within healthcare - Historical trend in healthcare price-to-sales ratio (5-year) ## Analysis Framework ### What a High price-to-sales ratio Means - Positive interpretations - Potential red flags (too high can be concerning) ### What a Low price-to-sales ratio Means - Potential problems indicated - Contextual factors that explain a low value ### Trend Analysis - How to interpret price-to-sales ratio changes over time - Seasonal adjustment considerations - Growth stage impact on price-to-sales ratio ## Decision Matrix - If price-to-sales ratio is above benchmark → recommended actions - If price-to-sales ratio is at benchmark → recommended actions - If price-to-sales ratio is below benchmark → recommended actions ## Related Metrics - 3-5 complementary metrics to analyze alongside price-to-sales ratio - How to create a composite score - Dashboard layout recommendation Present as numbered steps. Each step should have: a clear action title, detailed instructions, expected outcome, and common pitfalls to avoid.
Replace the bracketed placeholders with your own context before running the prompt:
[range]— fill in your specific range.[threshold]— fill in your specific threshold.