Complete AI Training

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.

All 27 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. 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

  1. If any required context is missing, ask for it before proceeding.
  2. Extract or request the necessary financial data for {{company}} for {{period}}, including net income and net sales (or revenue).
  3. Calculate the net profit margin using the formula: (Net Income / Net Sales) × 100.
  4. Provide a breakdown of the figures used, showing the calculation steps.
  5. If {{comparison_period}} is provided, calculate the margin for both periods and analyze the change, noting any trends or significant shifts.
  6. 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?