Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Household Take-Home Pay: From Gross to NetLabFree
  2. Spending Log: Category Totals per Month with SUMIFSLab Locked
  3. 50/30/20 Check: Needs, Wants and SavingsLab Locked
  4. Bills Calendar: Due Dates, Paid Flags and Overdue AlertsLab Locked
  5. Grocery Budget vs Actual: Weekly Variance and Cost per PersonLab Locked
  6. Subscriptions Audit: Annual Cost and Cost per UseLab Locked
  7. Debt Order: Snowball vs Avalanche with RANK and SORTBYLab Locked
  8. Credit Card Payoff: How Many Months with NPERLab Locked
  9. Emergency Fund: Target, Gap and Months to Reach ItLab Locked
  10. Saving Goals: Holiday and College Fund with PMT and FVLab Locked
  11. Net Worth Tracker: Assets, Debts and ProgressLab Locked
  12. Family Dashboard: Savings Rate, Chart and Colour AlertsLab Locked
  13. Sinking Funds: Monthly Savings for Irregular Costs and the Catch-Up ProblemLab Locked
  14. Cash-Flow Calendar: Running Balance, Lowest Day and a Safety CushionLab Locked
  15. Mid-Month Check: Spending Pace, Projected Month-End and Safe-to-Spend per DayLab Locked
  16. Work an Extra Day? Net Pay, Childcare, Commuting and the Gain per HourLab Locked
  17. The True Cost of the Family Car: Per Year, per Month and per MileLab Locked
  18. Electricity Plans: Flat Price vs Time-of-Use Over a YearLab Locked
  19. Year-End Forecast: Budget vs Actual to Date and the Projected GapLab Locked
  20. Final Project: Next Year's Family Plan – Buckets, Savings Rate, Emergency Cover and a Status CheckLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy