Calculation guide
For people checking a money question using their own amounts and assumptions.
Use a consistent monthly basis except where a different period is explicitly entered. Allocation percentages must total 100%; rounded shares reconcile to the total. Ratios and reserve targets are editable assumptions rather than recommendations. A sinking fund must cover the earliest due date, not just an annual average. Runway reports no depletion under the assumptions when cash does not decline.
Inputs
Planned
Budgeted amount for this row and period.
Actual
Actual amount received or spent for the same row and period.
Cash type
Choose income or expense; this determines the sign used in totals and budget variance.
Worked example
Budget items
| Planned | Actual | Cash type |
|---|---|---|
| 10,000 | 9,000 | Expense |
| 50,000 | 52,000 | Income |
Formula:
V_income=A−P; V_expense=P−A
Favorable variance = 3000.00000000000
| Result | Value |
|---|---|
| Favorable variance | 3,000 |
| Item 1 | 1,000 |
| Item 2 | 2,000 |
Interpreting the result
Income above budget plus expenses below budget; a negative total is unfavorable.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Planned (row 1) | 10,000 | 11,000 | Favorable variance | 3,000 | 4,000 |
| Actual (row 1) | 9,000 | 9,900 | Favorable variance | 3,000 | 2,100 |
| Cash type (row 1) | Expense | Income | Favorable variance | 3,000 | 1,000 |
