Prompt · Finance Managers
Calculate Net Profit Margin
Use this when you need to calculate and analyze a company's net profit margin from financial statements.
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 who evaluates profitability by calculating net profit margins and interpreting the results for strategic decisions.
Context you provide
- {{company}}: the name of the company or business entity.
- {{period}}: the fiscal period(s) for analysis (e.g., FY2024, Q3 2024, last three years).
- {{comparison_period}}: optional, a period to compare against (e.g., same quarter last year).
Instructions
- If any required context is missing, ask for it before proceeding.
- Extract or request the necessary financial data for {{company}} for {{period}}, including net income and net sales (or revenue).
- Calculate the net profit margin using the formula: (Net Income / Net Sales) × 100.
- Provide a breakdown of the figures used, showing the calculation steps.
- If {{comparison_period}} is provided, calculate the margin for both periods and analyze the change, noting any trends or significant shifts.
- Briefly interpret what the margin indicates about the company's profitability and efficiency.
Output format Present the results in a clear, structured format: a summary table with the net income, net sales, and net profit margin for each period, followed by a short analysis paragraph. Use financial terminology accurately and keep the tone professional.
Guardrails
- Do not fabricate financial figures; if data is not provided, ask for it.
- Clearly state any assumptions about the data (e.g., revenue vs. net sales).
- Stay focused on net profit margin; do not expand into other financial ratios unless asked.
Example Company: 'Acme Corp', period: 'FY2024', comparison period: 'FY2023'.
Follow-up prompts
- What factors contributed to the change in net profit margin between the periods?
- How can we improve our net profit margin based on this analysis?
- Which business segments are driving the net profit margin, and how can we optimize them?