Diamond Co.
Diamond Co. / Business
Business

Indie Dev’s Monetization Math Spreadsheet

A ready-to-use financial modeling tool for solo game developers who want to estimate revenue, platform fees, and break-even points without building a spreadsheet from scratch.

Who this is for

  • Solo indie developers planning their first release who need quick revenue scenarios
  • Devs who regularly model Steam, itch.io, Apple App Store, and Google Play fee structures
  • Creators exploring pay-what-you-want vs fixed-price pricing strategies and wanting concrete numbers

What’s inside

  • Revenue & platform-fee calculator (Steam 30%, itch.io, Apple, Google Play adjustable percentages)
  • Side-by-side pay-what-you-want and fixed-price projection models
  • Pre-order revenue timeline with adjustable launch windows
  • Tax‑variable adjusters that update with current major store policies
  • Monthly formula updates delivered to your inbox based on store policy changes and community requests

Pricing

$29 fixed price, or pay-what-you-want (minimum $1 suggested). Complete checkout via Gumroad — a simple, direct link is sent after email sign-up. No

Look inside before you buy

Inside the product

  • 1. Spreadsheet Template (Google Sheets)
  • Inputs (Pre-Filled with Examples)
  • Automated Calculations
  • Visualizations
  • 2. Landing Page (Template)
  • What’s Included?
  • Pricing Tiers
  • 3. Monetization Model

Sample from the actual product

*A ready-to-use Google Sheets template and landing page to calculate your game’s profitability with pre-filled formulas, real-world examples, and a structured decision framework.*

---

## **1. Spreadsheet Template (Google Sheets)**
### **Inputs (Pre-Filled with Examples)**
| **Category**          | **Example Values**                                                                 |
|-----------------------|-----------------------------------------------------------------------------------|
| **Game Pricing**      | Base price: $19.99, Discount: 50% off, Bundle: $29.99 (3-game pack)              |
| **Platform Fees**     | Steam: 30%, Apple: 15%, Google: 15%, Itch.io: 10%                                |
| **Tax Rates**         | US: 28%, UK: 20%, Canada: 15% (adjustable by region)                             |
| **Revenue Targets**   | Monthly goal: $5,000, Break-even: 3 months                                       |

A short excerpt from the delivered content. Check the examples and format fit your needs.

Tips & notes

Don't treat gross revenue as net income

Your monetization spreadsheet likely totals gross earnings, but the amount that actually hits your bank account is usually lower — often significantly so.

The practical fix: Add two simple columns to each revenue entry: “Platform Fee %” and “Buyer Region Tax %”. Look up the actual fee structure for each distribution channel you use (it’s rarely a flat rate across all stores), and input the applicable tax percentage based on where the buyer resides. Then calculate your net as: Gross × (1 - Fee%) × (1 - Tax%).

Why it matters: Price adjustments, budget planning, and investor decks all rely on realistic cash flow numbers, not optimistic totals. A $10k gross monthly figure can become $6.5k net once fees and taxes are accounted for — and that gap is what catches indie devs off guard.

No need for complex tax law knowledge — just a quick per-platform check and a consistent row-level habit.

### **The "Hidden Cost" of Free Trials (And How to Account for It)**

Most indie devs track conversions, retention, and revenue—but few account for the **real cost of free trials**: the players who *never* pay, but still consume your time, server resources, and support bandwidth.

#### **The Mistake:**
Treating free trials as "free" when they’re not. A 7-day trial that converts at 1% still costs you **99% of that player’s lifetime value in upkeep**. If you’re running ads or server costs, those trials eat into your margins *before* you even see a sale.

#### **How to Fix It:**
1. **Calculate your "true" CPI (Cost Per Install):**
   - Divide your **total monthly costs** (ads, servers, support) by **total installs** (paid + free).
   - Example: If you spend $1,000/month on ads and get 10,000 installs (1% conversion), your *real* CPI is **$100**—not the $10 you’d calculate if ignoring free trials.

2. **Set a "break-even" conversion rate:**
   - If your CPI is $50 and your average revenue per user (ARPU) is $20, you need **at least a 25% conversion rate** just to break even.
   - If you’re below that, either:
     - Raise your price (if the game justifies it).
     - Shorten the trial (e.g., 3 days instead of 7).
     - Add a **soft paywall** (e.g., "Play 3 levels for free, then unlock more").

3. **Track "Cost per Paying User" (CPPU):**
   - `CPPU = (Total Costs) / (Paying Users)`
   - If CPPU > ARPU, you’re losing money on every paying player *plus* their free-trial friends.

#### **Quick Checklist:**
- [ ] Are you tracking **total installs** (not just paid) in your spreadsheet?
- [ ] Have you calculated your **real CPI** (including server/support costs)?
- [ ] Does your trial length align with your conversion rate?
- [ ] Are you comparing CPPU to ARPU to spot hidden losses?

Free trials aren’t free—they’re a **high-risk, low-reward** funnel. Treat them like paid users in your math, or they’ll silently drain your margins.
# **The Hidden Cost of "Free" Promotions (And How to Track It)**

Most indie devs treat paid ads, influencer collabs, or even organic social shares as *pure* marketing spend—but they forget to account for the **opportunity cost** of the time and resources sunk into them.

### **The Mistake:**
You run a $500 ad campaign, get 1,000 downloads, and call it a win—until you realize:
- The 20 hours you spent tweaking creatives could’ve been used to **build a new feature** (which might’ve earned you $2,000 in lifetime value).
- The influencer’s 500 "free" downloads had a **real cost**: their audience’s retention rate was 10%, vs. your paid users’ 40%.
- You didn’t track **which promotions actually drove *revenue* vs. just downloads**—so you’re repeating what doesn’t work.

### **How to Fix It:**
1. **Add a "Time Cost" column** to your spreadsheet:
   - Log hours spent on *any* promotion (even "free" ones).
   - Convert it to a dollar value (e.g., $25/hour for your dev time).
   - Compare it to the **actual revenue** generated from those users.

2. **Track "Promo-Specific" metrics**:
   - Retention rate by acquisition source.
   - LTV (Lifetime Value) per promotion type.
   - **Break-even point**: How many users does a promo need to pay for itself *and* leave profit?

3. **Kill the "vanity metrics"**:
   - If a promo gives you downloads but **no revenue**, it’s a time sink—stop doing it.
   - Example: A Reddit post might get 1,000 clicks, but if those users churn in 3 days, it’s worse than useless.

### **Quick Checklist for Your Next Campaign:**
✅ **Before launching**: Estimate time cost + ad spend. Will it *double* its cost in revenue?
✅ **After launch**: Compare retention/LTV of new users vs. your baseline.
✅ **Monthly**: Run a "promo audit"—pause the worst performers, double down on the best.

**Pro tip:** If you’re not tracking this, you’re flying blind. Even "free" promotions have a price—make sure you’re paying it *willingly*.

Don’t gross-revenue your income

Many indie devs headline their store earnings as "revenue," then wonder why cash flow falls short. Platform fees, regional tax withholdings, and chargebacks all take a cut that varies by country and payment method.

The fix:

Build a simple "realization rate" column in your spreadsheet. For each entry, multiply gross revenue by the product of your platform’s fee multiplier, the average tax retention for that region, and an estimated chargeback buffer. This gives you a baseline number you can actually spend or reinvest with confidence. Update the regional rates a few times a year as tax rules shift.

A common monetization math mistake

Don’t calculate ARPU by dividing revenue by total installs.

This inflates per-user value if most users never pay or engage. Instead, divide revenue by paying daily active users (or whatever your core metric is). If 1,000 users install but only 40 pay, your real ARPU is 25× lower — and that’s the number that actually informs sustainable pricing and growth decisions.

Don't treat every user as a customer

A common monetization math mistake is assuming your active user count represents potential revenue. Most players never spend, and spending rates vary by genre, platform, and pricing.

Quick fix:

Track your paying user ratio (paying users ÷ active users) separately for each major update or campaign. If the ratio drops significantly below your own historical average, investigate changes to pricing, value communication, or friction in the purchase flow before assuming the market shifted.

Isolating payers from the majority of non-spenders lets your math actually guide decisions.

Don't confuse revenue with cash in hand

Gross revenue on a spreadsheet looks different from what hits your bank account. Every dollar you earn usually loses at least three cuts before you see it:

  • Platform commission (e.g., 30% for standard storefronts)
  • Payment processor fees (percentage + fixed amount per transaction)
  • Chargebacks and dispute fees (if applicable)
  • Local tax remittance obligations

If you’re pricing at $10, assume ~$6.50–$7.00 is your actual take, not $10. Track your "effective price" from the first sale, not the listed price.

Start here: Add one column to your monetization sheet labeled "Net after cuts." Use your actual platform and processor rates. Update it every time you change pricing or enter a new market.

Monetization Math Checklist

  1. Subtract platform fees before calculating tax implications. Applying the cut after tax is a common error that inflates projected take-home revenue.
  2. Keep gross and net revenue on separate rows. This lets you test fee changes or tax scenarios without restructuring the whole sheet.
  3. Include a refund-rate assumption, even if it's just a conservative placeholder. A 5% assumption can shift break-even timelines more than a pricing tweak.
  4. Model revenue per active user, not per download. A high download count with low activation can make a premium price look worse than a low price with strong retention.

Separate gross from net from the start

When building your monetization tracker, never store gross revenue and platform fees in the same cell or row. Indie devs often subtract fees mid-calculation, which breaks LTV and CAC formulas as the spreadsheet scales. Instead, keep gross_revenue, fee_percent, and net_revenue as distinct columns, with net calculated by formula. This prevents rounding errors and makes scenario planning (like discount promos) far less painful.

Break-even users for a SaaS product

Formula: Fixed monthly costs ÷ (Subscription price − Variable cost per user)

  1. List your fixed monthly expenses (hosting, third‑party services, etc.)
  2. Subtract variable costs per user (payment‑processing fees, etc.)

More from Diamond Co.