Why Economies Break Games

A broken game economy ruins everything downstream. If gold accumulates too fast, items become meaningless. If it's too slow, players feel stuck. If crafting materials are abundant, crafted items have no value. If they're scarce, crafting feels like a waste of time.

The fix isn't intuition — it's math. Simple spreadsheet models let you predict how your economy behaves over hours of gameplay, catching problems before players encounter them.

The Faucet and Sink Model

Every game economy is a system of faucets (where currency enters) and sinks (where currency exits).

Faucets (Income Sources)

• Combat rewards (enemy drops, quest completion gold)
• Gathering (selling resources to vendors)
• Trading (player-to-player in multiplayer)
• Passive income (taxes, investments, automated systems)
• Exploration rewards (chests, hidden caches)

Sinks (Expenditures)

• Equipment purchases
• Consumables (potions, ammo, food)
• Crafting costs (materials + fees)
• Repairs and maintenance
• Fast travel fees
• Housing and cosmetics
• Tax or tithe systems (multiplayer)

The Balance Rule

Total faucet rate should slightly exceed total sink rate, creating a feeling of gradual accumulation. If sinks exceed faucets, players feel punished. If faucets far exceed sinks, currency becomes meaningless.

Target ratio: Faucets = 1.1-1.3x Sinks at each progression tier.

Building Your Economy Spreadsheet

Sheet 1: Player Progression Timeline

Map out the player's journey hour by hour:

This becomes your reference for every other calculation.

Sheet 2: Item Pricing Model

Price items relative to the earning rate at the level they become available:

Pricing formula: Item Price = Earnings Per Hour × Hours of Value

"Hours of Value" is how long the item should feel like a meaningful purchase. Weapons: 1-3 hours. Consumables: fraction of an hour. Major purchases: 5-20 hours.

Sheet 3: Loot Tables

Define drop rates and expected value per encounter:

Expected gold per hour = (Enemies killed per hour × Average gold per enemy) + Quest rewards.

Sheet 4: Sink Analysis

Calculate how fast the player should spend money:

Compare to income: If the player earns 250 gold/hr at this level and spends 120, they accumulate 130/hr. That's a reasonable savings rate (~50%).

Progression Curves

Linear vs Exponential

Linear progression: Each level requires the same additional XP (Level 1: 100xp, Level 2: 200xp, Level 3: 300xp). Feels consistent but can feel grindy at high levels.

Exponential progression: Each level requires multiplicatively more XP (Level 1: 100xp, Level 2: 150xp, Level 3: 225xp). Natural feeling of "slowing down" at higher levels, matches increasing content complexity.

Common formula: XP_Required(level) = Base × (level ^ Exponent)

Base = 100, Exponent = 1.5:
Level 1:  100 XP
Level 5:  1,118 XP
Level 10: 3,162 XP
Level 20: 8,944 XP
Level 50: 35,355 XP

Plot this curve in your spreadsheet and ask: "Does the time between levels feel right at every point?"

Power Curves

Player power (damage, health, defense) should also follow a curve:

Flat power curve: Small stat increases per level. Skill matters more than level. Good for competitive/skill-based games.

Steep power curve: Large stat increases per level. Progression feels impactful. Good for RPGs where power fantasy is the goal.

S-curve: Slow start, fast middle, plateau at endgame. Player feels weak initially (motivation to progress), powerful in mid-game (reward), and challenged again at endgame.

Reward Scheduling

Variable Ratio Reinforcement

The most psychologically engaging reward schedule (the one slot machines use):

• Players don't know exactly when the next reward comes
• Average payout is predictable, but individual results vary
• Creates "one more try" motivation

In practice: Loot tables with rare drops. The player might get nothing for 10 kills, then a rare item. On average, they get one rare per 15 kills. The variance keeps it exciting.

Fixed Interval Rewards

Predictable rewards at known intervals:

• Daily login bonuses
• Weekly challenges
• Milestone rewards (every 10 levels)
• Quest completion rewards

These provide reliable progression and prevent the frustration of long dry spells.

Combining Both

Best games use both:

• Variable rewards for moment-to-moment gameplay (combat drops, exploration finds)
• Fixed rewards for progression milestones (level ups, quest completion, achievements)

The fixed rewards prevent frustration when variable rewards have a bad streak.

Common Balancing Mistakes

The Vendor Trash Problem

If most loot is sold to vendors, your loot system is boring. Fix by:

• Making common drops useful in crafting
• Adding salvage systems that extract useful materials from unwanted gear
• Reducing drop quantity but increasing quality
• Adding collection/set bonuses for keeping items

The Exponential Gold Problem

If income grows exponentially but shop prices are static, mid-game players trivialize purchases. Fix by:

• Scaling shop prices by zone or level
• Introducing higher-tier currencies (gold → platinum → mythril)
• Adding gold sinks that scale with wealth (housing taxes, guild upgrades)

The Hoarding Problem

Players who never spend gold miss your carefully designed economy. Encourage spending by:

• Limited-time purchases (rotating shop inventory)
• Degradation and repair costs
• Upgrade systems that consume resources
• Storage limits that make hoarding impractical

The New Player Cliff

If your economy is balanced for 20+ hours of play, new players in the first hour might feel broke or overwhelmed. Fix by:

• Generous early rewards (positive first impression)
• Simplified early economy (fewer currencies, obvious purchases)
• Tutorial that teaches economic systems gradually
• Safety nets (can't sell essential items, minimum income from basic activities)

Testing Your Economy

The Spreadsheet Simulation

Model 100 hours of gameplay in your spreadsheet:

• Accumulate gold at the expected hourly rate per level
• Subtract expected expenditures
• Track total gold over time
• Flag anomalies: negative gold (too expensive), uncapped growth (not enough sinks)

In-Game Analytics

When playtesting, track:

• Gold earned per hour per player
• Gold spent per hour per player
• Most/least purchased items
• Player gold at each level bracket
• Time between major purchases

Playtester Feedback

Ask playtesters specific economy questions:

• "Did you ever feel like you couldn't afford something you needed?"
• "Did you ever feel like gold was pointless?"
• "What was the most satisfying purchase?"
• "What felt overpriced? Underpriced?"

Combine spreadsheet math with real player experience. The math prevents structural problems; playtesting catches feeling problems.

Tools

Spreadsheet Software

Google Sheets or Excel. Create templates you can reuse across projects. Share with your team for collaborative balancing.

UE5 Data Tables

Export your spreadsheet balance values directly to UE5 Data Tables:

1. Export spreadsheet as CSV
2. Import into UE5 Data Table
3. Reference in gameplay code
4. When balance changes, re-export CSV and reimport

This workflow keeps your "source of truth" in the spreadsheet while the game reads from Data Tables.

Game economy design is a skill that improves with practice. Start with simple models, test early, iterate often, and let the spreadsheet catch problems before your players do.