MONEY: A USER GUIDE

day5.html
Calculate Current Spending

Calculating spending is a big job. But like any big job, it gets easier if you break it down into bite-size chunks.

There are two types of spending: Monthly Payments and Occasional Expenditures. We'll create a table for each.

Monthly payments are payments due each month, typically on the same day of the month. Examples: rent, utilities, phone, internet, streaming services, car payments, and credit card payments. Monthly payments typically involve a statement and are easy to calculate.

Below is a Monthly Payments table.

MONTHLY PAYMENTS
Expense Due Amt IE 1 IE 2
Rent 01 1,100.00 539.00 561.00
Utils 05 350.00 171.50 178.50
Phone 10 150.00 75.00 75.00
Internet 14 100.00 100.00
Streaming 19 14.99 14.99
Car pmnt 23 280.52 280.52
CC pmnt 28 614.56 301.13 313.43
TOTALS 1,201.62 1,408.45

Step-by-step instructions for building it may be found here (Numbers) or here (Excel).

Restate The Lesson. in a user-friendly way.

Aphorism

Prev    Next


Nashville, IN USA