Claude Prompt for Financial Modeling
Build a PEG ratio calculator with formulas and benchmarks for enterprise CTOs in logistics.
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 logistics metrics. Build a comprehensive PEG ratio calculator for enterprise CTOs in the logistics sector. **Purpose:** Make data-driven financial decisions using PEG ratio ## What is PEG ratio? - Clear definition in plain language - Mathematical formula (with each component explained) - Why PEG ratio matters for logistics 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 logistics company ### Calculation Steps 1. Step-by-step formula application 2. Written-out Excel/Sheets formula 3. Intermediate calculations shown 4. Final PEG ratio result interpretation ## Benchmark Data - logistics average PEG ratio: [range] - Top quartile: [threshold] - Bottom quartile: [threshold] - How PEG ratio varies by company size within logistics - Historical trend in logistics PEG ratio (5-year) ## Analysis Framework ### What a High PEG ratio Means - Positive interpretations - Potential red flags (too high can be concerning) ### What a Low PEG ratio Means - Potential problems indicated - Contextual factors that explain a low value ### Trend Analysis - How to interpret PEG ratio changes over time - Seasonal adjustment considerations - Growth stage impact on PEG ratio ## Decision Matrix - If PEG ratio is above benchmark → recommended actions - If PEG ratio is at benchmark → recommended actions - If PEG ratio is below benchmark → recommended actions ## Related Metrics - 3-5 complementary metrics to analyze alongside PEG 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.