Price Increase Impact Calculator

Model a price increase per product and see the new revenue, margin and how many customers you could lose before you are worse off. You enter: Product, Current Price, Unit Cost, Monthly Units, Increase %. It calculates: New Price, Current Profit, New Profit (same units), Units Needed to Match, Max Volume Loss %. Summary tab: Current monthly profit; New monthly profit (same units); Profit gain; Products modeled. Includes an Instructions tab, yellow input cells and example rows so you can overwrite them and start. Works in Excel, Google Sheets and LibreOffice.