Personal Finance in Excel
Budget, track spending, pay off debt and plan savings, investing and retirement in a live spreadsheet that checks your work.
Investing & Personal Finance · 12 courses
Investing and personal finance courses
Most investing advice skips the arithmetic. These investing and personal finance courses do the opposite: you calculate returns, costs, risk and value yourself in a spreadsheet that checks every step, so you can judge a product, a property or a plan on its numbers. Everything is educational, not investment advice.
Personal Finance in Excel and Retirement & Financial Independence Planning cover budgets, debt payoff, saving plans, withdrawals and annuities. Stock Market, ETF & Index Fund Investing is the beginner course on P/E, total return, fees and rebalancing, followed by Investing & Portfolio Analysis, Dividend & Income Investing and Value Investing & Intrinsic Value. Technical Analysis, Forex Trading Math and Options & Derivatives explain indicators, pip values, position sizing, Black-Scholes and the Greeks. Three real estate courses analyse a rental building, a short-term rental and a development project with an equity waterfall. The courses suit beginners managing their own money as well as finance students who want the formulas behind the jargon.
Courses in Investing & Personal Finance
Investing & Portfolio Analysis in Excel
Measure returns, risk, diversification, beta and value, with every formula checked on a live spreadsheet. Educational only, not investment advice.
Real Estate Investment Analysis
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.
Options & Derivatives Basics in Excel
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.
Real Estate Development & Equity Waterfalls
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.
Retirement & Financial Independence Planning
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.
Dividend & Income Investing in Excel
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.
Stock Market, ETF & Index Fund Investing
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.
Value Investing & Intrinsic Value
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.
Technical Analysis Indicators in Excel
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.
Forex Trading Math & Risk Management
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.
Short-Term Rental Investment Analysis
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.
Guides with worked examples
How to Calculate the Sharpe Ratio in Excel (Example)
Calculate the Sharpe ratio in Excel from monthly returns: AVERAGE, STDEV.S and SQRT(12) to annualise, a two-fund example and the common mistakes.
RevPAR Calculation: Formula, ADR, Occupancy and Example
RevPAR calculation step by step: occupancy, ADR, RevPAR = ADR × occupancy, plus TRevPAR, GOPPAR and the RevPAR index, in a worked Excel example.
Cap Rate Calculation: Formula, NOI and Worked Example
How to calculate the cap rate: build NOI from rent, vacancy and expenses, divide by price, and turn a market cap rate into a value. Excel example.
How to Calculate Pip Value: Formula, Lots and Examples
How to calculate pip value for any forex pair: units × pip size, then convert to USD. Yen pairs, USD/CHF, crosses and lot sizes in an Excel example.
RSI Formula in Excel: Wilder's RSI(14) Step by Step
The RSI formula in Excel: gains and losses, a simple first average, then Wilder's smoothing and RSI = 100 − 100/(1+RS). Worked example with 22 prices.
Graham Number Formula: Calculation, Example and Limits
The Graham number formula √(22.5 × EPS × BVPS) in Excel: where 22.5 comes from, three worked stock examples, the net-net (NCAV) test and margin of safety.
Frequently asked questions
Is this investment advice?
No. The courses teach how returns, risks, costs and valuations are calculated. They do not recommend any security, fund or strategy, and the examples are fictional.
Which investing course is best for beginners?
Start with Stock Market, ETF & Index Fund Investing or Personal Finance in Excel. Both have two free lessons and assume no prior knowledge beyond basic percentages.
Do I need to know Excel?
Basic formulas help but are not required. The labs explain each function as it is needed, and the free Excel for Finance course covers the formulas used most often.
More categories
Open your first lab in under a minute
Free lessons work without an account. Sign up to save your progress.