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