A price increase can lower your gross profit if customers buy less. This sheet shows which way it goes, for up to 3 products. Enter each product's name, price, cost and monthly units sold. Then enter the increase (%) and the drop in units sold you expect (%). You get the change in monthly gross profit and a verdict per product: "Increase favorable" or "Increase unfavorable". Gross margin, the price after the increase and gross profit per unit appear next to it. The number to watch is the maximum drop you can absorb: how far units sold can fall before gross profit does. You can apply one rate to all products or set rates per product. A row with a problem input shows the reason in "Status" and is left out of the totals. Rate cells reject numbers outside the range. One limit comes first: the sheet uses gross profit only. Fixed costs, labor, advertising, sales fees, shipping and discounts are not included. If you pay fees that scale with price, the gain from an increase looks larger than it is. This is the English version of a Japanese template. The file is in English, amounts are in yen, and the notes on consumption tax follow Japanese rules. ■ What you download After extracting, you get "PriceIncreaseSimulator_Free_v1.4.xlsx" (Excel, 2 sheets: How to use / By product). ■ Related The paid version (980 yen) handles 20 products and judges by net gross profit after fees, shipping and discounts. It adds a sensitivity table, a one-page decision memo and a reverse calculation. Try this free version first. - Paid version (20 products, sensitivity table, decision memo, reverse calc; 980 yen): https://keiei-template.booth.pm/items/8977690 ■ Please note - The drop in units sold is an assumption. Real reactions vary by product, season and competitors. At 0%, almost every product shows "Increase favorable", so try other rates too. - This file does not guarantee results or profits and is not tax, accounting or legal advice. - Consumption tax: enter amounts excluding tax if you are a taxable business, or including tax as-is if you are a tax-exempt business. If you are registered as a qualified invoice issuer, you are a taxable business. If you are not sure which applies to you, ask your tax office or a licensed tax accountant. In Japan, taxable businesses that show prices to consumers in advance must show tax-inclusive prices (except when selling exclusively to other businesses; tax-exempt businesses are not covered). Source: National Tax Agency No.6902, Consumption Tax Act Article 63(1). Based on laws as of April 1, 2026; checked on October 10, 2026. - Operating environment: an Excel-format (.xlsx) file, delivered as a zip file. Double-click the zip file (or use your computer's extract function) to get the Excel file. No macros are used. You need spreadsheet software that can open and edit .xlsx files. We checked every formula by recalculating the file in LibreOffice and comparing all results, cell by cell, with the Japanese version (including unusual inputs). At this time, operation has not been checked in desktop Excel, Excel for the web, Google Sheets or Numbers, so please check that the file opens in your environment before relying on it. - Downloading from BOOTH requires a pixiv account (free). - Product names and figures in the sample are fictional. - If you find a problem, please contact kojin.keiei.template@gmail.com with the file name and what happened. We will publish a corrected file. ■ Terms of use Anyone may use this file free of charge for their own business. Redistributing or selling the file, or posting it online, is prohibited. If you recommend it, please share the link to this page.