Intro to Linear Regression

  • Length: 5:14
  • Rating Average: 4.8171744 from 361 people
  • View Count: 161076
  • Author: bionicturtledotcom

Tags: Finance  Quant 

A really brief introduction to the "best fit" line through X:Y data.

Correlation & Covariance

  • Length: 9:53
  • Rating Average: 4.879365 from 315 people
  • View Count: 92764
  • Author: bionicturtledotcom

Tags: Quant  Finance 

Covariance is a measure of relationship (or co-movement) between two variables. Correlation is just the translation of covariance into a UNITLESS measure that we can understand (-1.0 to 1.0)

Z-spread (versus bond's nominal credit spread)

  • Length: 8:19
  • Rating Average: 5.0 from 16 people
  • View Count: 4287
  • Author: bionicturtledotcom

Tags: bond  yield  yield to maturity  YTM  spread  z spread  z-spread  Treasury  curve 

(Please note: spreadsheet is available on the website). A nominal credit spread is the difference in yields (YTM), which are single factors; therefore, implicitly, the nominal spread compares flat curves. The Z-spread improves by giving the spread that adds across the entire spot (zero) rate...

Working capital (HPQ example)

  • Length: 8:31
  • Rating Average: 5.0 from 8 people
  • View Count: 3917
  • Author: bionicturtledotcom

Tags: working  capital  current  assets  liabilities 

This is a brief illustration of the calculation of working capital (WC) using Hewlett Packard (ticker: HPQ) data from their latest quarterly filing (10Q): WC = current assets -- current liabilities. The solvency perspective. WC = (current assets excluding cash) -- current liabilities. The...

Repo (repurchase agreement)

  • Length: 4:38
  • Rating Average: 5.0 from 20 people
  • View Count: 5487
  • Author: bionicturtledotcom

Tags: repo  repurchase  agreement  haircut  margin  financial  crisis 

A repo is a secured loan. In August of 2007, repo lenders increased haircuts (initial margin) on repo transactions. The led to a run on the shadow banking system.

Counterparty credit exposure

  • Length: 7:41
  • Rating Average: 5.0 from 6 people
  • View Count: 3261
  • Author: bionicturtledotcom

Tags: counterparty  credit  risk  exposure  expected exposure  EE  potential future  PFE  value  at  var 

Study note: Counterparty credit risk is harder because (i) the initial value is 0 and the future value is highly uncertain and (ii) the contract can gain or lose. Two key metrics are Expected Exposure and Potential Future Exposure (PFE, which is essentially a VaR)

Logistic distribution maps credit score to probability of default (PD)

  • Length: 8:57
  • Rating Average: 4.5 from 8 people
  • View Count: 2821
  • Author: bionicturtledotcom

Tags: logistic  cumulative  distribution  function  CDF  credit  score  probability  of  default 

The logistic function can be used to transform a credit score into a probability of default (PD). The advantages of the logistic are (i) it easy to calculate and (ii) as a cumulative distribution function (CDF) the output is, appropriately, a probability between 0 and 1.0. In this video, I show...

Spearman's rank correlation

  • Length: 6:58
  • Rating Average: 4.6363635 from 11 people
  • View Count: 8647
  • Author: bionicturtledotcom

Tags: spearman's  pearson's  correlation  rank  dependence 

Spearman's is more flexible measure of correlation because 1. It requires ordinal rather than cardinal variables and 2. It does not presume linear relationship (it is a measure of monotone dependence) Note: you can download a copy of my spreadsheet on our website @ www.bionicturtle.com

Regression #1: Sample regression function (SRF)

  • Length: 7:30
  • Rating Average: 4.942623 from 122 people
  • View Count: 64769
  • Author: bionicturtledotcom

Tags: Finance  Quant  Econometrics  Statistics  Regression 

The population is unobserved. We draw samples and make inferences based on the samples. Each sample has a sample regression function (SRF).

Weighted average cost of capital (WACC)

  • Length: 9:10
  • Rating Average: 5.0 from 88 people
  • View Count: 20991
  • Author: bionicturtledotcom

Tags: wacc  weighted  average  cost  of  capital  debt  equity 

WACC is a marginal cost: we can't go to full leverage because the "cost of financial distress" increases the costs of financing.

Dividend discount (Gordon growth) model

  • Length: 7:25
  • Rating Average: 5.0 from 21 people
  • View Count: 7033
  • Author: bionicturtledotcom

Tags: dividend  discount  Gordon  growth  model  CFA  chartered financial analyst  valuation 

The Gordon growth model is the simples dividend discount model. It's disadvantage is the dubious assumption that a single dividend grows at a constant rate indefinitely. (our website has the spreadsheet and the derivation)

Regression #2: Ordinary Least Squares (OLS)

  • Length: 9:28
  • Rating Average: 4.9793105 from 145 people
  • View Count: 61215
  • Author: bionicturtledotcom

Tags: Finance  Quant  Econometrics  Statistics  Regression 

OLS minimizes the residual sum of squares (RSS). RSS is the sum of each squared residual (residual = the observed Y minus the predicted "on the line" Y). Also, about the OLS: the average residual is always zero, and the line passes through the point (average X, average Y)

Treasury inflation-protected securities (TIPS)

  • Length: 6:30
  • Rating Average: 4.6666665 from 12 people
  • View Count: 1321
  • Author: bionicturtledotcom

Tags: Treasury  inflation  inflation-protected  securities  TIPS  CPI 

In a TIPS, the coupon (real yield) is fixed. The inflation-adjusted principal varies. But it redeems at the greater of [inflation-adjusted principal, initial par value]. Also, TIPS are linked to CPI, which is a government statistic and not necessarily your experience of inflation/deflation.

Standard error of estimate (SEE)

  • Length: 8:56
  • Rating Average: 4.924051 from 79 people
  • View Count: 48541
  • Author: bionicturtledotcom

Tags: Finance  Quant  Excel 

A linear regression gives us a best-fit line for a scatterplot of data. The standard error of estimate (SEE) is one of the metrics that tells us about the fit of the line to the data. The SEE is the standard deviation of the errors (or residuals)

Mortgage prepayment metrics CPR & SMM

  • Length: 8:25
  • Rating Average: 5.0 from 3 people
  • View Count: 1207
  • Author: bionicturtledotcom

Tags: mortgage  prepayment  CPR  SMM 

You can download the spreadsheet at our website. CPR (conditional or constant prepayment rate) is the annual prepayment rate; SMM (single monthly mortality) rate is the monthly equivalent.

Coefficient of determination (r-squared)

  • Length: 9:50
  • Rating Average: 4.659794 from 97 people
  • View Count: 89973
  • Author: bionicturtledotcom

Tags: Finance  Quant  Excel 

In a linear regression, you often see the R-squared quoted. To explain the R-squared (coefficient of determination), I compare it to the standard error of estimate (a measure of the line's accuracy) and the correlation (the square root of the coefficient of determination). All three, loosely...

Normal mixture distribution

  • Length: 5:50
  • Rating Average: 4.5454545 from 11 people
  • View Count: 2700
  • Author: bionicturtledotcom

Tags: probability  distribution 

A normal mixture distribution can model fat tails

Central limit theorem

  • Length: 8:49
  • Rating Average: 4.903226 from 62 people
  • View Count: 30544
  • Author: bionicturtledotcom

Tags: Financel  Quant 

The CLT says the sample mean will be normally distributed regardless of the population distribution; it's power is uncanny.

Intro to logarithms

  • Length: 9:54
  • Rating Average: 4.5825243 from 103 people
  • View Count: 53151
  • Author: bionicturtledotcom

Tags: Finance  Quant 

The inverse of a logarithmic function is an exponential functions. And if we use a base of natural e, we can compute continuously compounded returns

Gaussian copula

  • Length: 7:30
  • Rating Average: 4.7906976 from 43 people
  • View Count: 17892
  • Author: bionicturtledotcom

Tags: Gaussian  copula  distribution  normal  credit  crisis 

The Gaussian copula was gainfully employed prior to the credit crisis, and it has pretty much been shamed. Mathematically, it's an elegant way to join marginal distributions and handle default correlation. But it requires too many simplifying assumptions.

Credit default swap (CDS)

  • Length: 5:57
  • Rating Average: 4.8469386 from 98 people
  • View Count: 64359
  • Author: bionicturtledotcom

Tags: Finance  Excel  Quant 

A CDS is a bilateral contract between two counterparties. The protection buyer is buying insurance: he/she pays premiums in exchange for a payoff in case there is a CREDIT EVENT (a trigger)

How to value an interest rate swap

  • Length: 9:14
  • Rating Average: 4.9322033 from 59 people
  • View Count: 43224
  • Author: bionicturtledotcom

Tags: Finance  derivatives  interest  rate  swaps 

At inception, the value of the swap is zero or nearly zero. Subsequently, the value of the swap will differ from zero. Under this approach, we simply treat the swap as two bonds: a fixed-coupon bond and a floating-coupon bond. The value of the swap is difference between the two.

Volatility: Moving Average Approaches

  • Length: 9:15
  • Rating Average: 5.0 from 11 people
  • View Count: 10928
  • Author: bionicturtledotcom

Tags: Finance  Quant  Excel 

Within stochastic volatility, moving average is the simplest approach. It simply calculates volatility as the unweighted standard deviation of a window of X trading days. Here I show the three "flavors:" population variance (volatility = SQRT[variance]), sample, and simple

Terms about distributions: PDF, PMF and CDF

  • Length: 9:58
  • Rating Average: 4.9545455 from 44 people
  • View Count: 16759
  • Author: bionicturtledotcom

Tags: Quant  Finance  Probability 

Distributions characterize random variables. Random variables are either discrete (PMF) or continuous (PDF). About these distributions, we can ask either an "equal to" (PDF/PMF) question or a "less than" question (CDF). But all distributions have the same job: characterize the random variable.

Lognormal distribution

  • Length: 8:36
  • Rating Average: 5.0 from 45 people
  • View Count: 24206
  • Author: bionicturtledotcom

Tags: Finance  Quant  Excel 

Here I explain an idea that is confusing the first time you see it: a variable is lognormally distributed if its log (or natural log) is normally distributed. I use an example of future stock price: it the rate of return is normally distributed (it can be negative), the future stock price level...

Three approaches to value at risk (VaR)

  • Length: 5:55
  • Rating Average: 4.925 from 80 people
  • View Count: 36960
  • Author: bionicturtledotcom

Tags: finance  risk  var 

This is a brief introduction to the three basic approaches to value at risk (VaR): Historical simulation, Monte Carlo simulation, Parametric VaR (eg, delta normal)

Interest rate swap

  • Length: 7:4
  • Rating Average: 4.8333335 from 114 people
  • View Count: 80853
  • Author: bionicturtledotcom

Tags: Finance  derivatives  interest  rate  swaps 

This illustrates how an interest rate swap can transform a floating-rate obligation into a fixed-rate obligation and vice-versa

Basel II Overview

  • Length: 9:57
  • Rating Average: 5.0 from 81 people
  • View Count: 30758
  • Author: bionicturtledotcom

Tags: basel  capital  credit  market  operational  risk 

Quick overview of Basel II framework that sets capital requirements for banks. Three pillars contains the rules & support (supervisor review, market discipline) that say how much eligible regulatory capital must be held against risk-weighted assets.

Regression #3: Standard Error in Linear Regression

  • Length: 9:57
  • Rating Average: 4.9083333 from 120 people
  • View Count: 82579
  • Author: bionicturtledotcom

Tags: excel  statistics  regression  quant  quantitative 

A simple (two-variable) regression has three standard errors: one for each coefficient (slope, intercept) and one for the predicted Y (standard error of regression). While the population regression function (PRF) is singular, sample regression functions (SRF) are plural. Each sample produces a...

Put call parity

  • Length: 6:51
  • Rating Average: 4.987342 from 79 people
  • View Count: 21763
  • Author: bionicturtledotcom

Tags: Finance  Excel  Derivatives  Stock  Options 

Put call parity derives from the idea we can have two portfolios (one with an option, the other with a put) that have identical payoffs regardless of what happens to the stock. This gives a way to link the value of a call option with a put option.

Capital market line (CML)

  • Length: 10:17
  • Rating Average: 4.917526 from 97 people
  • View Count: 42888
  • Author: bionicturtledotcom

Tags: beta  capital  cml  line  market  portfolio  volatility 

The capital market line is determined by a mix of: the riskfree asset and the market portfolio. The market portfolio, in turn, consists of all risky assets (this example has only two assets).

Solvency Ratios, CFA L1 (Financial Statements)

  • Length: 8:4
  • Rating Average: 5.0 from 10 people
  • View Count: 636
  • Author: bionicturtledotcom

Tags: CFA  solvency  balance sheet 

Solvency ratis are either debt ratios (balance sheet-balance sheet) or coverage ratios (income statement-interest)

How to get yield to maturity (YTM) with Excel & TI BA II+

  • Length: 8:57
  • Rating Average: 4.910714 from 56 people
  • View Count: 50817
  • Author: bionicturtledotcom

Tags: Finance  Excel  Quant 

Yield to maturity (YTM, yield) is the bond's internal rate of return (IRR). It is the rate that discounts future cash flows to the current market price.

Contango & backwardation in commodity forward markets

  • Length: 7:47
  • Rating Average: 4.936709 from 79 people
  • View Count: 21516
  • Author: bionicturtledotcom

Tags: Finance  Derivatives  Commodities 

Contango and backwardation are about the relationship between the spot and forward price. If Forward is greater than Spot, it's contango (upward sloping forward curve). If Forward is less than Spot, it's backwardation (inverted forward curve). The "normal" prefix refers to relationship to...

Profitability Ratios, CFA L1 (Financial Statements)

  • Length: 10:31
  • Rating Average: 4.8095236 from 21 people
  • View Count: 1632
  • Author: bionicturtledotcom

Tags: CFA  ratios  gross profit  ROI  ROA  ROE 

Return on Sales (income statement) and Return on Invesmtent (returns to balance sheet).

Black-Scholes versus Binomial

  • Length: 5:47
  • Rating Average: 4.9117646 from 68 people
  • View Count: 23338
  • Author: bionicturtledotcom

Tags: Finance  Derivatives  Stock  Options 

The world's quickest summary comparison between the two common ways to price an option.

Regression #4: ANOVA table in regression

  • Length: 9:14
  • Rating Average: 4.9333334 from 105 people
  • View Count: 69851
  • Author: bionicturtledotcom

Tags: Excel  Quant  Statistics  Regression  Finance 

The ANOVA table explains the sources of variation.

Cost of carry model to price forwards & futures

  • Length: 8:33
  • Rating Average: 4.911111 from 45 people
  • View Count: 12932
  • Author: bionicturtledotcom

Tags: Finance  derivatives  commodity 

The cost of carry model is universally helpful. It summarizes the link between the spot price and the (theoretical) futures price for a commodity.

Forward rate agreement (FRA)

  • Length: 8:52
  • Rating Average: 4.824324 from 74 people
  • View Count: 27893
  • Author: bionicturtledotcom

Tags: Finance  Futures  Excel  Fixed  Income  Bonds 

An FRA is a contract that lets the buyer (who is long the rate) lock-in an interest (borrowing) rate. In this example, the FRA buyer locks in LIBOR at 3%

Intro to Quant Finance: Periodic Rate of Return

  • Length: 9:40
  • Rating Average: 4.8333335 from 36 people
  • View Count: 21069
  • Author: bionicturtledotcom

Tags: Finance  Excel  Quantitative  Quant 

Periodic rate of return

Intro to Quant Finance: Value at Risk (VaR)

  • Length: 9:48
  • Rating Average: 4.83871 from 93 people
  • View Count: 65758
  • Author: bionicturtledotcom

Tags: Finance  Excel  Quantitative  Quant 

The basic approach to VaR is delta normal: a scaled standard deviation

Liquidity Ratios, CFA L1 (Financial Statements)

  • Length: 7:32
  • Rating Average: 5.0 from 14 people
  • View Count: 706
  • Author: bionicturtledotcom

Tags: CFA  liquidity  current ratio  quick ratio  cash ratio 

Liquidity is a short-term issue (I like to think of liquidity as -running out of time.- A liquidity problem per se is one that time can fix). Liquidity ratios measure a firm's ability to meet its short-term obligations; or measure how quickly assets are converted into cash.

Two step binomial

  • Length: 8:57
  • Rating Average: 4.964286 from 28 people
  • View Count: 10874
  • Author: bionicturtledotcom

Tags: Finance  Derivatives  Stock  Options 

Here is an spreadsheet example of pricing a European call option on a stock index (eg, Dow Jones Utility) with a two step binomial. There are two basic process steps: 1. Build forward the "tree" of asset prices, 2. Then backward induction: value the option at each node as the...

Exponentially weighted moving average (EWMA)

  • Length: 8:56
  • Rating Average: 4.9259257 from 27 people
  • View Count: 25264
  • Author: bionicturtledotcom

Tags: Finance  Excel  Quant 

The EWMA approach to volatility is an improvement over simple volatility because it assigns greater weight to more recent observations (in fact, the weights are proportional)

Bayes' Formula

  • Length: 6:37
  • Rating Average: 4.8235292 from 255 people
  • View Count: 72839
  • Author: bionicturtledotcom

Tags: Finance  Quant 

Bayes' Theorem formulas an intuitive idea: we adjust our perspective (the probability set) given new, relevant information. Formally, Bayes' Theorem helps us move from an unconditional probability (what are the odds the economy will grow?) to a conditional probability (given new evidence, what...

Binomial (one step) for option price

  • Length: 6:53
  • Rating Average: 5.0 from 47 people
  • View Count: 18448
  • Author: bionicturtledotcom

Tags: Finance  Derivatives  Stock  Options  Binomial 

The binomial solves for the price of an option by creating a riskless portfolio.

Why we use log returns in finance

  • Length: 6:17
  • Rating Average: 4.9183674 from 49 people
  • View Count: 17847
  • Author: bionicturtledotcom

Tags: 0203  logreturns 

log returns

Monte carlo simulation: Brownian motion

  • Length: 9:28
  • Rating Average: 4.912409 from 137 people
  • View Count: 76195
  • Author: bionicturtledotcom

Tags: Finance  monte  carlo  simulation  value  at  risk 

This is a classic building block for Monte Carlos simulation: Brownian motion to model a stock price. The periodic return (note the return is expressed in continuous compounding) is a function of two components: 1. constant drift, and 2. random shock; ie, volatility multiplied by a randomized...

Technical Analysis, Intro: CFA L1

  • Length: 8:19
  • Rating Average: 5.0 from 14 people
  • View Count: 807
  • Author: bionicturtledotcom

Tags: technical charts candlestick 

Tenets of technical analysis; common charts

Confidence interval

  • Length: 8:16
  • Rating Average: 4.9315066 from 73 people
  • View Count: 55842
  • Author: bionicturtledotcom

Tags: Finance  Quant  Excel  Statistics  Probability 

I illustrate the confidence interval construction with an example: the P/E ratio of 28 companies. The point is to say with confidence (eg, 95%) that the "true" population lies within an interval.

Page: 1 of 6

Next Page

bionicturtledotcom