CapiIvo module 01

Put competing financial choices on the same page

Use structured comparisons to evaluate cost, duration, liquidity, downside, and the assumptions behind each option. This page develops that topic with its own detailed framework and examples.

In-depth guide

Build a decision model that exposes the tradeoffs

A useful model does not predict the future perfectly. It organizes inputs so you can see which assumptions drive the result and where a choice becomes fragile.

Define the output first

Decide what the model is trying to compare: total cost, monthly cash requirement, break-even date, reserve balance, payoff time, or another measurable outcome. Without a defined output, extra inputs only create noise.

Classify inputs by confidence

Label inputs as known, estimated, or uncertain. A contractual payment may be known; future maintenance may be estimated; future income growth may be uncertain. This prevents a spreadsheet from making weak assumptions look equally reliable.

Use consistent units

Convert annual rates, monthly payments, one-time fees, and multi-year costs into compatible units before comparing them. Many bad comparisons come from mixing monthly and annual numbers or ignoring upfront cash.

Calculate a base case

Use the most reasonable current assumptions to create a baseline. The baseline is not a promise; it is a reference point against which alternate scenarios can be measured.

Find the break-even variable

Ask which input would need to change for Option A and Option B to produce the same result. The break-even point often provides more insight than declaring one option the winner under a single set of assumptions.

Document the model date

Rates, prices, fees, and balances change. Date the inputs and keep the source for important numbers. A model should be refreshed before it is reused for a later decision.

Practical reference

Put the idea to work

Define the objective before building the model

A model should answer a specific question: minimize total borrowing cost, preserve monthly liquidity, reach a cash target by a date, or compare two purchase structures. If the objective is vague, the spreadsheet can become detailed without becoming useful.

Separate inputs from assumptions

Inputs are known values such as a quoted price or current balance. Assumptions are estimates such as future income, maintenance, inflation, or resale value. Label them differently. When a result changes dramatically because of an assumption, that assumption deserves more scrutiny than another decimal place in the formula.

Use base, downside, and upside cases

A single forecast can create false confidence. Build at least three cases. The base case uses reasonable expectations; the downside case stresses income or costs; the upside case shows what improves if conditions are favorable. The spread between outcomes communicates uncertainty better than one precise number.

Model opportunity cost explicitly

Money used for one purpose cannot simultaneously fund another. When comparing choices, show what happens to cash reserves, debt payoff, or another priority. Opportunity cost does not require predicting investment returns; it can simply mean recognizing the alternative use of the same dollars.

Know when the model is too complicated

If the answer depends on dozens of speculative inputs, simplify. Identify the three to five variables that drive most of the result and test those. A transparent model that can be explained is generally more useful for household decisions than a sophisticated model nobody can audit.