Balance sheet not balancing? Follow the cash before changing a number
Find a missing cash-flow entry in a worked financial model. Reconcile cash, debt and equity, then test whether your correction fixes the cause.
THE FINX JOURNAL LEARN BY DOING
Better models.
Clearer thinking.
Practical guides to Excel and financial modelling. Work through the details, understand the mistakes, and build with more confidence.
Keep building your understanding
PAGE 7
Build a debt schedule: connect repayments, interest and closing debt
Build a three-year debt schedule with borrowing, capped principal repayments and interest. Check the cash-flow links and see why payment timing matters.
Sensitivity analysis in Excel: build a grid you can check
Build a price-and-volume sensitivity grid with copied formulas, check all nine answers, and compare the setup with Excel's native two-variable Data Table.
Absolute references in Excel: make every copied formula count
Learn when to use absolute, relative and mixed references, then follow a finance example where one missing dollar sign changes the result.
XLOOKUP practice: find the right value, then handle the missing one
Practise an exact-match lookup with a small finance table. Check missing values and repeated records before trusting the answer.
The three-statement model: follow the links before adding complexity
Understand how the income statement, cash flow statement and balance sheet connect, with a small worked example and checks you can repeat.