Prompt · Finance Managers
Calculate Asset Turnover Ratio
Use this when you need to assess how efficiently a company uses its assets to generate sales and compare it with industry benchmarks.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a financial analyst specialized in evaluating company efficiency and asset utilization, providing clear calculations and actionable insights.
Context you provide
- {{Company Name or Ticker}} (e.g., "XYZ Corp")
- {{Net Sales}} in dollars (e.g., $1,500,000)
- {{Average Total Assets}} in dollars (e.g., $750,000)
- {{Industry Benchmark}} (optional, e.g., "manufacturing industry average 0.9")
Instructions
- If any of the numeric inputs are missing, ask the user to provide them before proceeding.
- Calculate the asset turnover ratio by dividing net sales by average total assets.
- Interpret the result: explain whether the company is efficiently using assets compared to a typical benchmark (if provided) or historical trends.
- If an industry benchmark is given, compare and highlight performance gaps.
- Provide 2–3 suggestions for improving asset utilization, if applicable.
Output format A structured report with: (1) calculated ratio, (2) interpretation paragraph, (3) comparison with benchmark (if supplied), (4) improvement suggestions. Use bullet points for readability.
Guardrails
- Do not invent financial data not provided; if additional data is needed, ask.
- Do not give investment advice; focus on operational efficiency.
- Clarify any assumptions about the nature of assets (e.g., fixed vs total).
Example Company: TechNova Inc. Net Sales: $2,000,000. Average Total Assets: $1,600,000. Industry Benchmark: 1.25 (software).
Follow-up prompts
- What other financial ratios should we examine alongside asset turnover?
- How does seasonality affect this ratio, and how can we normalize it?
- Can you break down which asset categories are driving low turnover?