Gumroad Excel Tool : Profit Engine

Validated against a real UK giftware retailer dataset, where the tool flagged underpriced products and concentration risk automatically.

1M+
transactions tested
67%
profit from top 3 products
£6,600
monthly upside surfaced

Built & Published | A profitability analysis tool for product-based businesses, sold on Gumroad.

Overview

An Excel-based profitability engine for product businesses, especially those running drops and limited releases. It breaks a product catalogue into three things: profit per product, where that profit concentrates, and where pricing is leaving money on the table. Everything outputs in plain language, no financial background needed.

What It Does

  • Inputs tab — enter products, costs, prices, units
  • Insights tab — auto-generated plain-language analysis
  • Logic tab — underlying calculations and Business Health Score
  • Flags low-margin products, pricing gaps, and concentration risk automatically

Validation

Tested against a real UK giftware retailer dataset (1M+ transactions):

  • Top 3 products drove 67% of total profit
  • Two top-10 revenue products had sub-20% margins
  • A £1 price increase on two underpriced products = ~£6,600/month in added profit with zero cost changes

Tools & Skills

  • Python (openpyxl), advanced Excel formula architecture
  • Business analysis, unit economics, pricing strategy
  • Product design, building tools non-technical users can actually use

What This Demonstrates

  • Ability to turn financial analysis into a usable product
  • End-to-end execution, concept, build, validation, publish
  • Commercial thinking beyond pure analysis
//////

Resources