Family Budget in Excel: Household Spending, Bills, Debt & Savings Goals
20 hands-on labs with one family of four: take-home pay, a monthly spending log, the 50/30/20 check, a bills calendar, groceries, subscriptions, debt order, card payoff, emergency fund, holiday and college goals, net worth and a family dashboard, then sinking funds for irregular costs, a day-by-day cash-flow calendar, a mid-month spending check, the value of an extra workday, the true cost of the car, electricity plans, a year-end forecast and next year's family plan. Educational only, not financial advice.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course follows one fictional family of four through 20 hands-on spreadsheet labs. You turn gross salaries into take-home pay, total a spending log by month, run the 50/30/20 check, build a bills calendar with overdue alerts, compare groceries with the weekly budget, audit subscriptions, rank debts for the snowball and avalanche, time a card payoff with NPER, set an emergency fund target, plan holiday and college savings, track net worth and build a dashboard. Part two adds sinking funds for irregular yearly costs, a day-by-day cash-flow calendar with the lowest balance, a mid-month spending pace check, the real value of an extra workday after childcare, the true cost of the family car per mile, a flat versus time-of-use electricity plan, a year-end forecast and next year's family plan. Educational only, not financial advice.
Lessons
- Household Take-Home Pay: From Gross to NetFree
- Spending Log: Category Totals per Month with SUMIFS Locked
- 50/30/20 Check: Needs, Wants and Savings Locked
- Bills Calendar: Due Dates, Paid Flags and Overdue Alerts Locked
- Grocery Budget vs Actual: Weekly Variance and Cost per Person Locked
- Subscriptions Audit: Annual Cost and Cost per Use Locked
- Debt Order: Snowball vs Avalanche with RANK and SORTBY Locked
- Credit Card Payoff: How Many Months with NPER Locked
- Emergency Fund: Target, Gap and Months to Reach It Locked
- Saving Goals: Holiday and College Fund with PMT and FV Locked
- Net Worth Tracker: Assets, Debts and Progress Locked
- Family Dashboard: Savings Rate, Chart and Colour Alerts Locked
- Sinking Funds: Monthly Savings for Irregular Costs and the Catch-Up Problem Locked
- Cash-Flow Calendar: Running Balance, Lowest Day and a Safety Cushion Locked
- Mid-Month Check: Spending Pace, Projected Month-End and Safe-to-Spend per Day Locked
- Work an Extra Day? Net Pay, Childcare, Commuting and the Gain per Hour Locked
- The True Cost of the Family Car: Per Year, per Month and per Mile Locked
- Electricity Plans: Flat Price vs Time-of-Use Over a Year Locked
- Year-End Forecast: Budget vs Actual to Date and the Projected Gap Locked
- Final Project: Next Year's Family Plan – Buckets, Savings Rate, Emergency Cover and a Status Check Locked
Learner reviews
Be the first to review this course.