A free, self-paced textbook in 7 chapters. Read a chapter, then drill it with the 164 companion flashcards using spaced repetition.
Excel's time-value-of-money toolkit lets an analyst move between lump sums, streams, and rates without leaving the spreadsheet. The workhorse is `=NPV(rate, value1, value2, ...)`,...
Bond pricing and risk metrics live in a tight cluster of fixed-income functions. `=PRICE(settlement, maturity, coupon, yld, redemption, frequency, basis)` returns the clean price g...
A discounted cash flow model is a five-step assembly: forecast unlevered cash flows, choose a discount rate, compute the terminal value, discount the entire stream back to today, a...
A disciplined financial model expresses the income statement, balance sheet, and cash flow statement as a single waterfall of accounts. Reading top-down, the canonical line items a...
The lookup family has been redesigned around XLOOKUP, but understanding the legacy functions remains important. `=VLOOKUP(value, table, col, FALSE)` looks up by the leftmost column...
Excel's What-If tools translate an analyst's question into the structure the engine can solve. Goal Seek sets a single input cell so that a single output cell hits a target value —...
When raw data is messy or comes from multiple systems, Power Query is the right first stop. Power Query connects to a CSV, SQL database, or API, applies a sequence of transform ste...