Read a sample: 1. A Spreadsheet for a Decision
A household decision often begins with two numbers that seem easy to compare: one monthly payment against another, or the price of a new item against the cost of keeping an old one. The difficulty is that the visible numbers may not cover the same things. One choice may require money upfront. Another may cost less each month but create a larger expense later.
A spreadsheet gives you a place to put those pieces side by side. It does not tell you what will happen, and it cannot decide what matters most to your household. Its job is more modest and more useful: to show what follows from the assumptions you enter, make the arithmetic repeatable, and help you notice questions before you commit.
You do not need to be a spreadsheet expert to begin. In this book, a spreadsheet is simply a table in which you can enter labels, numbers, and instructions for calculating with those numbers. You will build small comparisons that can be recreated in common spreadsheet programs. No spreadsheet file is included; the examples show the information and formulas in the text so you can build and check your own worksheet.
The first skill is not typing a formula. It is defining a question that a formula can help answer.
Suppose you are considering moving to a different rental home. The proposed rent is lower, which makes the move appealing. But the new home may have different utility costs, and moving itself will cost money. Comparing rent alone would answer a narrow question: “Which rent is lower?” It would not answer the household question: “How do the estimated costs of staying and moving compare over a period that matters to us?”
A useful decision statement names the alternatives and the period being compared. For example:
Compare the estimated household costs of staying in the current rental and moving to the proposed rental over the first 12 months.
That statement is not yet a complete worksheet, but it gives the work a boundary. You know there are two alternatives, and you know the comparison covers 12 months. You can now ask which costs differ between the choices during that period.
The statement also reveals what the worksheet will not automatically answer. It will not tell you whether the new neighborhood suits your family, whether the landlord will accept your application, or what your rent will be after the comparison period. Those questions may affect the decision as much as the calculated total.
Other choices can be framed in the same way:
- Compare paying cash for a particular car with financing that same car over a stated ownership period.
- Compare repairing an appliance with replacing it, using the same period of household use.
- Compare two service plans based on the amount of service the household expects to use.
The alternatives should meet reasonably comparable needs. A cheaper plan that does not provide enough data, for example, may not be a practical substitute for the more expensive plan. A spreadsheet can show a price difference, but you still need to determine whether the choices are genuinely comparable.
The time horizon is the span covered by your comparison. It might be 12 months, three years, or the period you expect to own a car. There is no single horizon that fits every decision.
A short horizon can help answer an immediate cash question. A longer horizon can reveal whether higher upfront spending is offset by lower recurring costs. The appropriate period depends on the decision and on what you reasonably want to examine—not on which period makes a preferred option look better.
Consider a hypothetical choice between two appliances. One costs more to buy but is estimated to cost less to operate each year. A one-year comparison may favor the lower purchase price, while a longer comparison may narrow or reverse the difference. Neither result predicts exactly how long either appliance will last. Each answers a question under a stated set of assumptions.
Whatever horizon you choose, apply it consistently. If you compare 12 months of rent for one home with 18 months of rent for another, the totals are not answering the same question. Likewise, a one-time moving expense belongs in a 12-month total if it occurs during those 12 months, but it should not be multiplied by 12 as though it were a monthly bill.
You may eventually want to look at more than one period. For now, pick one, label it clearly, and make sure both alternatives cover it. Later chapters will show how timing, partial periods, and changes over time can be included more carefully.
A useful worksheet includes costs that can affect the comparison without pretending that every future expense is knowable.
Start by asking what changes between the alternatives. For a move, possible differences include rent, utilities, commuting, parking, moving services, and payments required at the start of a lease. For a car purchase, they may include the purchase price, financing charges, insurance, fuel, maintenance, and fees.
Then ask when each amount occurs. A cost may be:
- Upfront or one-time: paid once during the comparison period.
- Recurring: paid monthly, annually, or on another schedule.
- Occasional or uncertain: expected to arise, but not on a dependable schedule or for a known amount.
The distinction matters because the calculation depends on it. A hypothetical moving expense of $900 is not…