Personal Finance in Excel
Budget, track spending, pay off debt and plan savings, investing and retirement in a live spreadsheet that checks your work.
Every course ends with a final exam and a verifiable certificate. The first lesson is always free.
Personal finance, portfolios, options, bonds and real estate — the maths behind your money decisions.
Budget, track spending, pay off debt and plan savings, investing and retirement in a live spreadsheet that checks your work.
Measure returns, risk, diversification, beta and value, with every formula checked on a live spreadsheet. Educational only, not investment advice.
Analyse a 12-unit apartment building from NOI to IRR, plus rent vs buy, with every formula checked on a live spreadsheet. Educational only, not investment advice.
Price forwards, chart option payoffs and strategies, test put-call parity, build binomial trees, run Black-Scholes, the Greeks and implied volatility in a live spreadsheet, every cell checked. Educational only, not trading advice.
Take a 120-unit apartment project from land bid and budget through construction loan, lease-up and sale to the investor waterfall, every formula checked live. Educational only, not investment advice.
Income need, inflation, years to FI, saving plans, employer match and fees, withdrawals, sequence risk and annuities: 8 labs with one plan. Educational, not financial advice.
Measure yield, payout safety, dividend growth, DRIP compounding, portfolio income and total return, with every formula checked on a live spreadsheet. Educational only, not investment advice.
Understand share prices, P/E, total return, compounding, index funds vs active funds, diversification, dollar-cost averaging, rebalancing and trading costs, with every formula checked on a live spreadsheet. Educational only, not investment advice.
Measure owner earnings and quality, price stocks with P/E, P/B and EV/EBIT, apply Graham's tests, build a DCF and a reverse DCF, set a margin of safety and score a checklist, all on a live spreadsheet. Educational only, not investment advice.
Build candles, moving averages, crossovers, RSI, MACD, Bollinger Bands and breakout levels from raw prices, then backtest a rule against buy-and-hold, every cell checked. Educational only, not trading advice.
Read quotes and spreads, value pips across lot sizes, calculate P&L, margin and margin level, size positions from risk %, and measure R:R, cross rates, swap and expectancy, every cell checked. Educational only, not trading advice.
Analyse one 2-bed apartment as a short-term rental: occupancy, ADR and RevPAR, seasonal forecast, fees, NOI, financing vs a long-term let, arbitrage, dynamic pricing and break-even. Educational only, not investment advice.