Prompt Library for Small Businessby Small Business Control Center · free
Money and pricingWork with your numbers Check the numbersAbout 15 minutes

Recalculate your margins after a cost increase

A table to see which products or services are no longer profitable and what the minimum price is.

Useful for: most businesses (7 of 8 types).

  1. 1Copy the prompt
  2. 2Replace what’s in [brackets] with your details
  3. 3Paste it into ChatGPT, Claude, Gemini or Copilot

The prompt

Act as a practical financial advisor for small businesses. Write in English. My business is in [COUNTRY, e.g. the US, the UK or Australia]: if something depends on the rules there and you’re not sure, tell me. My costs have gone up and I want to see what has happened to my margins. Don’t do the math yourself: design the table and give me the formulas. Details: - Type of business: [TYPE OF BUSINESS] - List of products or services with their current price before tax: [PRODUCTS AND PRICES] - Cost of each before the increase: [PREVIOUS COSTS] - Cost of each now: [CURRENT COSTS] - Minimum margin I need to cover fixed costs: [MINIMUM MARGIN, e.g. 35%] Give me: 1. The sheet’s columns (price, previous cost, current cost, previous margin, current margin, minimum price). 2. The formulas for Excel and Google Sheets. 3. How to highlight in red whatever falls below the minimum margin. 4. A list of the 3 decisions I’d need to make with the results (raise the price, change supplier, drop the product). Always work with prices before tax. If any detail is missing, ask me.
Fill in the gaps on this page
Example of what to write: TYPE OF BUSINESS: coffee shop | PRODUCTS AND PRICES: latte $4.50, toast $3.20 | CURRENT COSTS: latte $0.92, toast $0.95 | MINIMUM MARGIN: 60%.

Did it work for you?

One click is enough. Your answer tells us which prompts need work, and it helps the next person who uses it.

Reviewed with: Claude (Nov 2026). Last updated: 2026-11-15. AI answers can contain mistakes. Check what matters.

More like this

Recommended tools

Tools we recommend for your business

We picked them because they suit small businesses. Some links are affiliate links: if you sign up through them we get a commission, at no extra cost to you. How we choose them and all the tools.

Affiliate linkEmail and teamworkGoogle Workspace

Email on your own domain, shared documents, calendar and video calls.

Works with Small Business Control Center: the workbook runs in Google Sheets, which comes with Google Workspace.

What’s new

New and reviewed prompts every week

See more updates →

Help us improve the library

What would you like AI to take off your plate?

Tell us the task that eats up your week. We read every request and the most repeated ones become new prompts.

We’ll only use them to reply about this request. No newsletter unless you ask for it.

Free newsletter · 1 email a week

Get practical tools to run your business better

A selection of prompts, guides and tips to put AI to work and improve how you run your business. We only ask for your email; unsubscribe whenever you like.