Tokanny Faith Foundation Tokanny Faith Foundation Learning Hub
Unit 6 · Lesson 4

A simple budget in Sheets

Plan your money with income and expenses, use formulas to see what's left, and work out how long it takes to save for a goal.

2:07 videoSave video (2.1 MB) Captions are on

Key points

  • A budget is a plan for your money, showing income (money in) and expenses (money out).
  • In Sheets, add expenses with SUM and take them away from income, for example =B2-SUM(B3:B5).
  • To find how long a goal takes, divide the price by what you save each week, for example =B2/B3.
  • Pay yourself first, track small spending and put needs before wants.

Try it: Plan a week's budget

Type your weekly income and expenses (real or made up). Try to make the left over ₦0 or more.

Check your understanding