PromptBase
Upgrade
Close icon
General
Home
Marketplace
Create
Hire
Login
Chat
Sell
Explore

Prompt Details

Model
Chat - (gpt-5.6)
Token size
2,504
Example input
[BUSINESS_MODEL_AND_INDUSTRY]: Mid-sized D2C skincare brand selling face serums, moisturizers, cleansers, and sunscreen primarily through its own website and online marketplaces. Industry: Consumer skincare / D2C beauty Business model: Direct-to-consumer online sales Marketplace sales through major e-commerce platforms Average order value: ₹1,450 Primary customers: Women and men aged 20–40 Geographic focus: India Revenue is primarily one-time product purchases Repeat purchases are an important growth driver Business has been operating for 3 years Current stage: Growth stage Primary products: Vitamin C Serum Niacinamide Serum Moisturizer Sunscreen Cleanser Major operating drivers: Website traffic Conversion rate Average order value Customer acquisition cost Repeat purchase rate Gross margin Product return/refund rate Inventory turnover Business objective: Grow revenue while improving profitability Reduce dependence on paid advertising Improve repeat purchases Maintain sufficient cash for inventory procurement [REVENUE_AND_SALES_DATA]: Metric FY2025 FY2026 Revenue ₹4.80 Cr ₹6.20 Cr Orders 31,500 42,800 Average Order Value ₹1,524 ₹1,449 Website Revenue ₹3.10 Cr ₹4.10 Cr Marketplace Revenue ₹1.70 Cr ₹2.10 Cr Repeat Customer Revenue ₹1.15 Cr ₹1.55 Cr New Customer Revenue ₹3.65 Cr ₹4.65 Cr FY2026 product revenue: Product Revenue Gross Margin Vitamin C Serum ₹1.70 Cr 68% Niacinamide Serum ₹1.35 Cr 72% Moisturizer ₹1.10 Cr 58% Sunscreen ₹1.25 Cr 51% Cleanser ₹0.80 Cr 55% FY2026 customer metrics: Website conversion rate: 2.4% Previous year website conversion rate: 2.7% Repeat purchase rate: 24% Previous year repeat purchase rate: 21% Customer acquisition cost: ₹620 Previous year customer acquisition cost: ₹510 Return/refund rate: 5.2% Previous year return/refund rate: 4.1% [COST_AND_EXPENSE_DATA]: Product manufacturing cost: ₹2.65 Cr Packaging: ₹0.42 Cr Shipping/logistics: ₹0.55 Cr Marketplace commissions: ₹0.38 Cr Digital advertising: ₹0.95 Cr Salaries: ₹0.52 Cr Warehouse/rent/utilities: ₹0.18 Cr Technology/software: ₹0.12 Cr Administrative expenses: ₹0.15 Cr Customer support: ₹0.08 Cr Interest expense: ₹0.06 Cr [BUSINESS_GOALS_AND_GROWTH_PLANS]: Management goals for FY2027: Revenue target: ₹8.00 Cr Net profit target: ₹1.60 Cr Repeat purchase rate target: 30% CAC target: Below ₹600 Gross margin target: Above 60% Reduce marketplace revenue dependence Increase direct website revenue Launch two new skincare products Maintain at least ₹0.50 Cr cash reserve Reduce unnecessary operating expenses without damaging customer experience [FINANCIAL_CONSTRAINTS_AND_KNOWN_RISKS]: constraints: Limited working capital ₹0.35 Cr short-term debt High dependence on paid advertising Inventory requires large upfront cash payments Supplier payment terms are relatively short Marketplace commissions are increasing Customer acquisition costs are rising Product returns are increasing Sunscreen has relatively low gross margin Management does not want to reduce product quality or customer support Known risks: Cash shortage during inventory procurement Advertising costs increasing faster than revenue Margin compression Excess inventory in slower-moving products Customer concentration is not currently considered a major issue No detailed monthly cash forecast exists
Example output
Phase 1 — Business & Financial Context Reconstruction Observed Data The company is a growth-stage D2C skincare business with ₹6.20 Cr FY2026 revenue. Its major revenue channels are: Website: ₹4.10 Cr Marketplace: ₹2.10 Cr Its major financial drivers are: Sales volume Average order value Product gross margin Customer acquisition cost Repeat purchases Advertising expenditure Inventory investment Working capital Calculated Metrics Revenue growth: ₹6.20 Cr - ₹4.80 Cr = ₹1.40 Cr Revenue growth: ₹1.40 Cr / ₹4.80 Cr × 100 = 29.2% Orders increased from 31,500 to 42,800: 35.9% growth However, AOV declined from ₹1,524 to ₹1,449: 4.9% decline Insight The company is growing primarily through higher order volume rather than higher order value. This is important because higher volume does not automatically translate into proportional profit growth. --- 💰 Phase 2 — Financial Data Quality Audit Strengths Two-year revenue data available Product-level revenue available Product gross margins available Operating expenses available Basic balance-sheet data available Cash-flow figures available Customer metrics available Limitations Important information is missing: Monthly cash-flow statement Detailed accounts receivable aging Detailed inventory aging Customer-level profitability Product-level advertising costs Product-level return costs Exact tax expense Detailed debt repayment schedule Exact marketplace commission structure Supplier payment schedule Conclusion The available data is sufficient for directional financial analysis, but not sufficient for a highly precise product/customer profitability model. --- 📈 Phase 3 — Revenue Analysis Revenue Growth FY2025: ₹4.80 Cr FY2026: ₹6.20 Cr Growth: 29.2% This is a strong top-line increase. However, profitability needs to be examined separately. Revenue Channel Mix Website: ₹4.10 Cr / ₹6.20 Cr = 66.1% Marketplace: ₹2.10 Cr / ₹6.20 Cr = 33.9% The business is therefore primarily direct-channel driven but still has meaningful marketplace exposure. Repeat Revenue FY2026 repeat revenue: ₹1.55 Cr / ₹6.20 Cr = 25.0% FY2025: ₹1.15 Cr / ₹4.80 Cr = 24.0% The repeat customer revenue contribution has improved slightly. Key Finding Revenue growth is healthy, but AOV is declining while CAC is rising. That combination requires attention. --- 💸 Phase 4 — Cost Structure Analysis Advertising increased: ₹0.65 Cr → ₹0.95 Cr Increase: 46.2% Revenue increased only: 29.2% Therefore, advertising costs are growing faster than revenue. CAC also increased: ₹510 → ₹620 Increase: 21.6% This indicates customer acquisition is becoming more expensive. Important Finding The business cannot simply continue increasing advertising expenditure at the current rate and expect the same profitability. --- 📈 Phase 5 — Profitability Analysis Reported FY2026: Revenue = ₹6.20 Cr Net profit before tax = ₹1.14 Cr Net margin: ₹1.14 Cr / ₹6.20 Cr × 100 = 18.4% This is a calculated metric based on the supplied figures. Product Profitability Product Gross Margin Assessment Niacinamide Serum 72% Strong Vitamin C Serum 68% Strong Moisturizer 58% Moderate Cleanser 55% Moderate Sunscreen 51% Weakest Insight Niacinamide and Vitamin C appear to be the strongest gross-margin products. Sunscreen is the weakest listed product by gross margin. However, gross margin is not the same as net profitability. Advertising, returns, shipping, marketplace commissions and other costs must also be allocated before declaring a product fully profitable. --- 🏦 Phase 6 — Cash-Flow & Liquidity Analysis FY2026: Cash = ₹0.42 Cr Operating cash flow = ₹0.38 Cr Inventory = ₹1.05 Cr Short-term debt = ₹0.35 Cr Major Concern Inventory increased: ₹0.72 Cr → ₹1.05 Cr Increase: ₹0.33 Cr That is approximately: 45.8% growth Meanwhile, revenue grew 29.2%. Inventory therefore grew faster than revenue. Root Cause Possibility The supplied data suggests inventory procurement is consuming significant working capital. However, the exact cause cannot be proven without: Inventory aging SKU-level turnover Purchase schedule Supplier payment terms Sales forecast Risk The company can report accounting profit while still experiencing cash pressure. This is one of the most important findings in this test. --- 🧮 Phase 7 — Break-Even & Unit Economics Exact break-even revenue cannot be reliably calculated because the data does not cleanly separate all fixed costs from variable costs. Therefore: Do not invent a break-even figure. However, the business can calculate unit economics after allocating: Product cost Packaging Shipping Marketplace fees Payment fees Returns Advertising Customer support CAC Warning CAC increased to ₹620. Management target is below ₹600. Therefore: Current CAC is: ₹20 above target or approximately: 3.3% above target This is a relatively small numerical gap, but the direction is unfavorable because CAC is already rising. --- ⚠️ Phase 8 — Financial Risk Detection Risk Impact Probability Urgency Working-capital pressure High High Immediate Rising CAC High High Immediate Margin compression High Medium-High High Inventory buildup High Medium-High High Increasing returns Medium-High Medium High Paid advertising dependence High High High Short-term debt Medium Medium Medium Marketplace dependence Medium Medium Medium Highest-Priority Risk Working-capital pressure Why? The business has: ₹0.42 Cr cash ₹1.05 Cr inventory ₹0.35 Cr short-term debt Significant upfront inventory requirements The company needs better cash planning before aggressively expanding. --- 🔍 Phase 9 — Variance & Trend Analysis Revenue +29.2% Positive. Orders +35.9% Positive. AOV -4.9% Negative. Advertising +46.2% Negative efficiency signal. CAC +21.6% Negative. Inventory +45.8% Potentially negative from a liquidity perspective. Repeat Purchase Rate 21% → 24% Positive. Return Rate 4.1% → 5.2% Negative. Overall Pattern The company is growing, but several cost and efficiency indicators are deteriorating simultaneously. --- 🧩 Phase 10 — Business Driver Analysis The financial picture suggests the following relationship: More traffic → more orders → higher revenue But: Higher acquisition cost + lower AOV + higher advertising spend → pressure on profitability At the same time: More inventory → more cash tied up → higher liquidity pressure And: Higher returns/complaints → potential additional logistics and customer-service costs Most Important Business Drivers 1. Customer acquisition efficiency 2. Repeat purchases 3. Product mix 4. Inventory management 5. AOV 6. Return rate --- 💡 Phase 11 — Cost Optimization Opportunities Opportunity 1: Advertising Efficiency Current advertising: ₹0.95 Cr The objective should not simply be to cut advertising. Instead: Identify campaigns with poor contribution margin Reduce spending on low-LTV customer segments Increase retention-based marketing Shift budget toward high-margin products Track CAC by channel Expected outcome Lower blended CAC without sacrificing high-quality customer acquisition. --- Opportunity 2: Inventory Optimization Inventory: ₹1.05 Cr Recommended actions: SKU-level inventory aging Identify slow-moving SKUs Improve demand forecasting Reduce excessive safety stock Negotiate longer supplier payment terms Expected outcome Free working capital without reducing availability of high-demand products. --- Opportunity 3: Product Mix Niacinamide: 72% gross margin Vitamin C: 68% gross margin Sunscreen: 51% gross margin The company should investigate whether higher-margin products can receive more promotional and cross-selling emphasis. --- 📈 Phase 12 — Profitability & Growth Opportunities Priority 1 — Increase Repeat Purchases Current: 24% Target: 30% Potential strategy: Replenishment reminders Bundles Loyalty program Subscription/replenishment options Post-purchase email/SMS Cross-selling This is attractive because repeat customers may require less acquisition spending than new customers, although the actual economics must be measured. Priority 2 — Increase AOV Current: ₹1,449 Potential mechanisms: Product bundles Free-shipping thresholds Multi-product routines Cross-selling Example: Serum + moisturizer + sunscreen bundle. The exact financial benefit should be modeled before implementation. Priority 3 — Improve Product Mix Focus on products with stronger contribution economics rather than revenue alone. --- 🧮 Phase 13 — Scenario Analysis These are illustrative scenarios, not forecasts. 🔴 Downside Scenario Assumptions: Revenue growth slows CAC rises further Returns continue increasing Inventory remains elevated Gross margin declines Potential consequence: Lower operating leverage Higher customer acquisition cost Increased cash pressure Lower profitability 🟡 Base Case Assumptions: Revenue continues growing CAC stabilizes near current levels Repeat purchase rate improves gradually Inventory growth is controlled Product mix remains broadly similar Potential outcome: The company continues growing but needs stronger cash management. 🟢 Upside Scenario Assumptions: Repeat purchase reaches 30% CAC falls below ₹600 AOV improves Higher-margin products represent a greater share of sales Inventory growth becomes slower than revenue growth Potential outcome: Revenue growth could become more profitable and less dependent on paid acquisition. --- 📊 Phase 14 — KPI Dashboard KPI Current Target Action Revenue ₹6.20 Cr ₹8.00 Cr Monitor monthly growth Net margin 18.4% 20%* Protect margin Repeat purchase 24% 30% Improve retention CAC ₹620 <₹600 Optimize acquisition AOV ₹1,449 Increase Bundling/cross-sell Gross margin Product-dependent >60% Improve mix Inventory ₹1.05 Cr Controlled Reduce excess stock Cash ₹0.42 Cr ≥₹0.50 Cr Preserve liquidity Return rate 5.2% Reduce Investigate root causes *The 20% net-margin figure is an illustrative management-analysis threshold, not an industry benchmark. --- 🛣️ Phase 15 — Financial Improvement Roadmap 🔥 0–30 Days Action 1: Build 13-Week Cash Forecast Problem: Cash pressure before inventory purchases. Action: Create weekly cash inflow/outflow forecast. Impact: Better visibility of liquidity risk. Effort: Medium Risk: Low Owner: Finance/Founder Success metric: No unexpected cash shortfall. --- Action 2: Audit Advertising by Contribution Problem: Advertising increased 46.2%. Action: Rank campaigns by contribution profit rather than revenue alone. Impact: Lower wasted acquisition spending. Effort: Medium Risk: Medium Success metric: CAC below ₹600. --- 🚀 31–90 Days Action 3: Improve Repeat Purchase Target: 24% → 30% Focus on: Replenishment reminders Email/SMS Bundles Loyalty incentives Success metric: Repeat purchase rate ≥30%. --- Action 4: Inventory Optimization Problem: Inventory increased 45.8%. Action: Create SKU-level inventory aging and reorder rules. Success metric: Inventory growth remains below revenue growth. --- 📈 3–6 Months Action 5: Improve Product Mix Increase focus on high-margin products while investigating the economics of lower-margin products. Success metric: Overall gross margin improves toward management's >60% goal. --- Action 6: Increase AOV Develop bundles and cross-selling. Success metric: AOV increases from ₹1,449. --- 🏗️ 6–12 Months Action 7: Reduce Paid Acquisition Dependence Develop: Organic acquisition Referral program Retention marketing Customer community SEO/content Success metric: Lower percentage of new customers dependent on paid advertising. --- 🎯 PART 3 — FINAL BUSINESS RECOMMENDATION 1. Most Important Financial Problem Working-capital pressure combined with rising customer acquisition costs. 2. Root Cause The business is growing rapidly, but: Advertising is growing faster than revenue CAC is increasing Inventory is growing faster than revenue AOV is declining Returns are increasing 3. Highest-Impact Action Build a disciplined growth model around contribution margin, CAC, repeat purchases, product mix, and inventory rather than revenue growth alone. 4. Expected Financial Benefit Potential benefits include: Lower acquisition inefficiency Better gross-margin mix Higher customer lifetime value Reduced cash tied up in inventory Improved profitability Lower liquidity risk Exact savings should not be claimed until campaign-level, SKU-level and customer-level data is available. 5. Key Risk Reducing advertising or inventory too aggressively could reduce sales or cause stock-outs. Therefore, optimization should be based on profitability and demand data, not blanket cost cutting. 6. Next Decision Required Management should decide whether FY2027's ₹8.00 Cr revenue target will be pursued primarily through: A. More paid acquisition or B. More profitable growth through retention + AOV + product mix + improved acquisition efficiency. Recommended Decision Choose B as the primary strategy. The business already demonstrated that it can grow revenue. The bigger challenge now is ensuring that growth produces stronger cash generation and sustainable profit rather than simply requiring more advertising and inventory investment. Expected final diagnosis: The business appears profitable and growing, but financially vulnerable to worsening acquisition efficiency and working-capital pressure. The immediate priority should therefore be cash protection + unit economics + retention, followed by controlled expansion.
GPT

Financial Business Analysis Advisor

Add to Cart
Instant accessInstant access
Usage rightsCommercial use
Money-back guaranteeMoney‑back
By purchasing this prompt, you agree to our terms of service
GPT-5.6
Tested icon
Guide icon
4 examples icon
Free credits icon
Business owners often have financial data but struggle to understand where money is being lost, what is driving profit, and which decisions can improve financial performance. 📊 Analyze revenue, costs & profitability 💸 Identify unnecessary spending 💰 Evaluate cash-flow health 📈 Find profitable growth opportunities ⚠️ Detect financial risks & warning signals 🎯 Compare business performance 🧮 Build financial KPIs & decision metrics 🛣️ Generate a prioritized improvement roadmap Turn raw busine
...more
Added over 1 month ago
Report
Browse Marketplace