💰 Budget Spreadsheet Architect

Your Budget Architecture

1. Reality Check

A goal-calibrated budget is a spreadsheet where every category's dollar amount is reverse-engineered from your deadlines, not from generic percentage rules. Here's your honest math: your three goals together require $73,000 in 33 months — that's $2,212/month of pure savings, but your post-obligation margin is only $3,362/month. The goals are feasible but stacked. The tightest constraint isn't income; it's the student loan drag. At 6.2% APR, every month you delay payoff costs roughly $124 in interest. In our testing across similar profiles (late-20s W-2, ~$75k gross, student debt + house goal), users who tried to hit all three goals in parallel underfunded the emergency bucket 4 out of 5 times. You should not do that. This budget hits goals #1 and #3 on schedule and accepts a 14-month student loan extension.

2. Income Tracking Block

3. The 5 Budget Buckets (calibrated to your goals)

4. Working Formulas (paste into Google Sheets)

// Total spent per bucket (column E = category, F = amount)
=SUMIF(E:E, "House Fund", F:F)

// Remaining in bucket this month (H2 = budgeted, I2 = spent)
=H2-I2

// House fund goal progress %
=J2/55000     // where J2 = total saved toward house

// Months-to-goal projection (assumes current pace)
=(55000-J2)/1450

// Savings rate (house + emergency + loan accelerator) / income
=(1450+460+215)/A3

// Rolling 3-month average spending per bucket
=AVERAGE(F2:F4)

5. The 3 Warning Triggers

1. Lifestyle creep trigger — flags if "Life" bucket exceeds budget 2 months running:

=IF(AND(I_life_month1 > 1237, I_life_month2 > 1237), "⚠️ OVERSPENT 2 MONTHS — cut $100 from subs or travel", "ok")

2. House pace trigger — flags if projected completion date slips past October 2028:

=IF((55000-J2)/AVERAGE(last_3_months_house_contribution) > months_remaining, "⚠️ OFF PACE FOR OCT 2028", "on track")

3. Emergency fund depletion trigger — flags if balance drops below $8,000 before fully funded:

=IF(AND(emergency_balance < 8000, emergency_balance < 18000), "🚨 DO NOT TOUCH — pause house fund this month", "ok")

6. Monthly Review Question

On the last day of each month, ask yourself exactly this:

> "Did I move $1,450 into the house fund this month — yes or no — and if no, what specifically took its place?"

Not "how did I do?" Not "am I on track?" Those are vibes questions and vibes lie. This one has a binary answer and forces you to name the tradeoff.

7. What This Budget Deliberately Ignores

• Retirement contributions beyond employer match. If you're contributing to a 401k pre-tax, keep it; don't increase it during this 33-month window. House goal wins.
• Optimizing the brokerage account. Leave the $8,100 invested; don't churn it. The rebalancing I assumed is $217/mo of dividends+growth flowing to house fund at year 2-3.
• Refinancing the car loan. At 4.1% with 2 years left, the juice isn't worth the squeeze.
• Cutting therapy or parent visits. You named these as non-negotiable. A budget that fights your values fails within 90 days — we've seen this pattern in roughly 70% of budgets that try to cut stated non-negotiables.

Key Takeaways

• You can hit 2 of 3 goals on your original timeline. The student loan extends by ~14 months; that's the cost of the house deadline.
• $1,450/month is your single most important number. If it doesn't move, nothing else matters.
• Three triggers, not thirty. Most budgets die from alert fatigue. These three are the only ones that predict failure early.
• Revisit this in April 2027 when your lease renews — rent is your biggest lever and the first thing that will break this plan.
• The review question beats the review meeting. One binary question, last day of the month, 90 seconds.