Will raising your prices increase or decrease your gross profit? Check it with up to 3 products. Enter each product's name, price, cost and monthly units sold, plus the price increase and the drop in units sold you expect. The file shows the change in monthly gross profit and a verdict for each product. This is the English version of a Japanese template. The file is in English, amounts are in yen, and the notes on consumption tax refer to the rules in Japan. ■ What you can do 1. For up to 3 products, calculate current and post-increase monthly gross profit, the change, and the totals. 2. See the gross margin, the price after the increase, and gross profit per unit. 3. For each product, calculate how far units sold can drop before gross profit falls (the maximum drop you can absorb), and get a verdict: "Increase favorable" or "Increase unfavorable". 4. Enter an overall price increase and expected drop to apply them to all products, or set different rates for each product. 5. Rows with input problems show the reason in "Status" and are excluded from the totals. Rate cells stop out-of-range numbers when you type them. ■ Free version and paid version The paid version (20 products, net gross profit after fees, shipping and discounts, sensitivity table, decision memo, reverse calculation and price rounding) is currently available in Japanese only. ■ Please note - The calculation is based on gross profit. Fixed costs, labor, advertising, sales fees, shipping and discounts are not included. If you pay fees proportional to price, the effect of the increase may look larger than it really is. - The drop in units sold is an assumption. Actual reactions vary by product, season and competitors. - If you set the expected drop to 0%, units sold are assumed not to fall and almost every product becomes "Increase favorable". Try other rates as well. - 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.