Канал: Jonathan Godbey

Georgia FinTech Ecosystem - Female Founders

Georgia FinTech Ecosystem - Female Founders

DDM Solution

DDM Solution

Three D Data Table

Three D Data Table

NPV IRR Example

NPV IRR Example

Stock Returns and Prices

Stock Returns and Prices

Simple Macro Recording

Simple Macro Recording

Simple Retirement

Simple Retirement

Asset Allocation part 1

Asset Allocation part 1

Retirement Random Quick2

Retirement Random Quick2

Retirement Random Quick

Retirement Random Quick

Clemson M1 22 26

Clemson M1 22 26

Graphing the Efficient Frontier

Graphing the Efficient Frontier

Three Clients Two Assets

Three Clients Two Assets

Two Risky Assets

Two Risky Assets

CovarianceCorrelation

CovarianceCorrelation

Weights Given Risk

Weights Given Risk

IOS and Return

IOS and Return

Retirement Simulation VBA

Retirement Simulation VBA

Shilah Oct 8

Shilah Oct 8

INDEX&MATCH

INDEX&MATCH

Rolling Beta

Rolling Beta

Capital Budgeting

Capital Budgeting

FinCalculator

FinCalculator

NEXUS

NEXUS

Taxes Finished

Taxes Finished

Tax Calculation

Tax Calculation

IfValidation

IfValidation

IfMaxMin

IfMaxMin

Shortcut Key Practice

Shortcut Key Practice

AbsoluteRelative

AbsoluteRelative

Portfolio Evaluation

Portfolio Evaluation

Organizing Data

Organizing Data

All three

All three

H model on paper

H model on paper

H model in Excel

H model in Excel

DDM NonConstant

DDM NonConstant

DDM Example

DDM Example

DDM Theory

DDM Theory

Formulas Data Table Cond Format

Formulas Data Table Cond Format

Present Value 3 Ways

Present Value 3 Ways

PV Annuity Data Table

PV Annuity Data Table

Future Value 3 Ways

Future Value 3 Ways

Formulas with Named Ranges

Formulas with Named Ranges

Formulas with Named Cells

Formulas with Named Cells

Formulas part 1

Formulas part 1

Dates

Dates

Fast Copy

Fast Copy

Autofill

Autofill

Novel Intro WACC

Novel Intro WACC

Present Value Annuity on VBA

Present Value Annuity on VBA

Present Value Annuity on Paper

Present Value Annuity on Paper

Present Value Lump Sum on Paper

Present Value Lump Sum on Paper

Present Value Lump Sum VBA

Present Value Lump Sum VBA

Future Value Lump Sum VBA

Future Value Lump Sum VBA

Future Value Lump Sum on Paper

Future Value Lump Sum on Paper

Future Value Annuity VBA

Future Value Annuity VBA

Future Value Annuity on Paper

Future Value Annuity on Paper

Porfolio Construction Uncut Version No Shorts

Porfolio Construction Uncut Version No Shorts

Porfolio Construction Uncut Version Shorts

Porfolio Construction Uncut Version Shorts

Single Index Model Overview

Single Index Model Overview

Single Index Model Example

Single Index Model Example

Specific Volatility More Than Two Assets

Specific Volatility More Than Two Assets

Specific Return More Than Two Assets

Specific Return More Than Two Assets

Graph for More Than Two Assets

Graph for More Than Two Assets

Covariance Matrix for Asset Allocation

Covariance Matrix for Asset Allocation

VBA Example

VBA Example

Portfolio Performance

Portfolio Performance

Solver for Portfolios

Solver for Portfolios

Four Frontier

Four Frontier

The Math of Drawing the Efficient Frontier

The Math of Drawing the Efficient Frontier

The Math Behind Using the Efficient Frontier

The Math Behind Using the Efficient Frontier

Using the Efficient Frontier

Using the Efficient Frontier

Correlation in Excel

Correlation in Excel

Covariance

Covariance

TVM I Problems 1 9

TVM I Problems 1 9

TVM Problems 10 17

TVM Problems 10 17

TVM Problems 18 21

TVM Problems 18 21

TVM I Problems 22 30

TVM I Problems 22 30

CSD Timeline1

CSD Timeline1

CSD Timeline2

CSD Timeline2

Running a Regression

Running a Regression

Pivot Table

Pivot Table

Tax Solution

Tax Solution

DDM Solution

DDM Solution

DDms Template

DDms Template

Three DDMs

Three DDMs

Data Table Conditional Formatting

Data Table Conditional Formatting

Vlookup

Vlookup

Nested If Data Validation

Nested If Data Validation

FI 3300 Practice Final part 4

FI 3300 Practice Final part 4

FI 3300 Practice Final part 3

FI 3300 Practice Final part 3

FI 3300 Practice Final part 2

FI 3300 Practice Final part 2

FI 3300 Practice Final part 1

FI 3300 Practice Final part 1

FI 4080 User Defined Function

FI 4080 User Defined Function

FI 4080 Quadratic

FI 4080 Quadratic

FI 4080 3 Clients

FI 4080 3 Clients

FI 4080 EfficientFrontier 5

FI 4080 EfficientFrontier 5

FI 4080W Optimal Portfolio 8 Stocks

FI 4080W Optimal Portfolio 8 Stocks

FI 4080 Matrix Mult

FI 4080 Matrix Mult

FI 4080H CapBudMonte

FI 4080H CapBudMonte

FI 4080 Random Numbers etc

FI 4080 Random Numbers etc

FI 4080W Practice Mid 1

FI 4080W Practice Mid 1

FI 4080 Sharpe

FI 4080 Sharpe

FI 4080 DDM part 2

FI 4080 DDM part 2

FI 4080 DDM part 1

FI 4080 DDM part 1

FI 4080 Taxes

FI 4080 Taxes

FI 3300 Chapter 3 part 2

FI 3300 Chapter 3 part 2

FI 3300 Chapter 3 part 1

FI 3300 Chapter 3 part 1

FI 4080 Nested If Statement

FI 4080 Nested If Statement

FI 4080 Vlookup

FI 4080 Vlookup

FI 4080 Data Table

FI 4080 Data Table

FI 4080 Data Validation

FI 4080 Data Validation

FI 4080 Conditional Formatting

FI 4080 Conditional Formatting

FI 3300 Statement of Cash Flows

FI 3300 Statement of Cash Flows

FI 3300 Corporate Finance Overview

FI 3300 Corporate Finance Overview

FI 3300 Income Statement & Balance Sheet

FI 3300 Income Statement & Balance Sheet

Novel Intro Ch 7 CAPM

Novel Intro Ch 7 CAPM

Novel Intro Ch 4 Financial Statements

Novel Intro Ch 4 Financial Statements

Novel Intro Ch 4 Ratios

Novel Intro Ch 4 Ratios

Novel Intro Ch 3 Loan Amortization

Novel Intro Ch 3 Loan Amortization

Novel Intro Ch 3 TVM with a Twist

Novel Intro Ch 3 TVM with a Twist

Novel Intro Ch 3 Future Value Annuity

Novel Intro Ch 3 Future Value Annuity

Novel Intro Ch 3 Present Value Annuity

Novel Intro Ch 3 Present Value Annuity

Novel Intro Ch 3 Perpetuities

Novel Intro Ch 3 Perpetuities

Novel Intro Conflicts and the Goal of the Firm

Novel Intro Conflicts and the Goal of the Firm

Novel Intro Ch 2 Future Value

Novel Intro Ch 2 Future Value

Novel Intro Ch 2 Inflation

Novel Intro Ch 2 Inflation

Novel Intro Ch 2 Present Value

Novel Intro Ch 2 Present Value

Novel Intro Ch 8 Capital Budgeting NPV IRR etc

Novel Intro Ch 8 Capital Budgeting NPV IRR etc

Novel Intro Ch 9 Capital Budgeting Cash Flows

Novel Intro Ch 9 Capital Budgeting Cash Flows

Novel Intro Ch 9 Capital Budgeting Product Cannibalization

Novel Intro Ch 9 Capital Budgeting Product Cannibalization

FI 8000 Black Scholes Example

FI 8000 Black Scholes Example

FI 8000 Binomial Euro Example

FI 8000 Binomial Euro Example

FI 8000 Binomial American

FI 8000 Binomial American

FI 8000 Midterm1 part 1

FI 8000 Midterm1 part 1

FI 8000 Midterm 1 part 2

FI 8000 Midterm 1 part 2

FI 3300 part 2

FI 3300 part 2

Time Value of Money

Time Value of Money

FI 8000 Jan 28 part 3

FI 8000 Jan 28 part 3

FI 8000 Jan 28 part 2

FI 8000 Jan 28 part 2

FI 8000 Jan 28 part 1

FI 8000 Jan 28 part 1

FI 8240 Dec 6

FI 8240 Dec 6

FI 8240 Bonds with Embedded Options

FI 8240 Bonds with Embedded Options

FI Portfolio Construction & Evaluation

FI Portfolio Construction & Evaluation

FI 8000 Spot Rates

FI 8000 Spot Rates

FI 8240 Black Litterman

FI 8240 Black Litterman

Portfolio project 2

Portfolio project 2

Portfolio project 1

Portfolio project 1

FI 4240 Performance Attribution

FI 4240 Performance Attribution

FI 4240 Covariance, etc

FI 4240 Covariance, etc

Sample problems part 1

Sample problems part 1

Sample problems part 2

Sample problems part 2

Novel Intro Ch 7 Stock Valuation

Novel Intro Ch 7 Stock Valuation

FI 4080 Pivot Table

FI 4080 Pivot Table

FI 4080 H model

FI 4080 H model

FI 4080 DDM

FI 4080 DDM

FI 8240 Single Index Model

FI 8240 Single Index Model

FI 4240 Portfolio with Riskless Asset

FI 4240 Portfolio with Riskless Asset

FI 8240 Covariance

FI 8240 Covariance

Two Risky Assets

Two Risky Assets

FI 4240 Portfolio 1

FI 4240 Portfolio 1

FI 4240 MVP derivation

FI 4240 MVP derivation

FI 4000 pre test

FI 4000 pre test

Novel Intro The Goal of the Firm

Novel Intro The Goal of the Firm

Novel Intro Conflicts

Novel Intro Conflicts

Novel Intro Corporate Finance in 9 Minutes

Novel Intro Corporate Finance in 9 Minutes

FI 8000 Covered Interest Arbitrage

FI 8000 Covered Interest Arbitrage

FI 8000 Swaps

FI 8000 Swaps

FI 8000 Futures Marking to Market

FI 8000 Futures Marking to Market

Fi 8000 Futures Spot Futures Parity

Fi 8000 Futures Spot Futures Parity

FI 8000 Binomial Option Pricing Model Puts

FI 8000 Binomial Option Pricing Model Puts

FI 8000 Binomial Option Pricing Model Calls

FI 8000 Binomial Option Pricing Model Calls

FI 8000 Binomial Option Pricing Model 1

FI 8000 Binomial Option Pricing Model 1

Novel Intro Chapter 9 Problems 12 13

Novel Intro Chapter 9 Problems 12 13

Novel Intro Chapter 9 Problems 9 11

Novel Intro Chapter 9 Problems 9 11

Novel Intro Chapter 9 Problems 7 8

Novel Intro Chapter 9 Problems 7 8

Novel Intro Chapter 9 Problems 4 6

Novel Intro Chapter 9 Problems 4 6

Novel Intro Chapter 9 Problems 1 3

Novel Intro Chapter 9 Problems 1 3

Novel Intro Chapter 8 Lecture

Novel Intro Chapter 8 Lecture

Novel Intro Ch 3 Retirement

Novel Intro Ch 3 Retirement

Novel Intro Chapter 3 Problems 1 8

Novel Intro Chapter 3 Problems 1 8

Novel Intro Chapter 3 Problems 48 50

Novel Intro Chapter 3 Problems 48 50

Novel Intro Chapter 3 Problems 44 47

Novel Intro Chapter 3 Problems 44 47

Novel Intro Chapter 3 Problems 38 43

Novel Intro Chapter 3 Problems 38 43

Novel Intro Ch 6 Bonds

Novel Intro Ch 6 Bonds

Novel Intro Ch 5 Cash Flows

Novel Intro Ch 5 Cash Flows

Novel Intro Chapter 2 part 2

Novel Intro Chapter 2 part 2

Novel Intro Chapter 2 part 1

Novel Intro Chapter 2 part 1

FI 8240 Performance

FI 8240 Performance

FI 8240 Swaps

FI 8240 Swaps

FI 8240 EmbedOptions

FI 8240 EmbedOptions

FI 8240 CIA

FI 8240 CIA

FI 8000 CAPM Mkt Eff

FI 8000 CAPM Mkt Eff

FI 8000 put call parity

FI 8000 put call parity

FI 8000 Option Strategies

FI 8000 Option Strategies

FI 8000 Call & Puts

FI 8000 Call & Puts

FI 8240 Callable Bonds

FI 8240 Callable Bonds

Intro to Corporate Finance

Intro to Corporate Finance

FI 4240 Bootstrapping

FI 4240 Bootstrapping

FI 8000 Duration

FI 8000 Duration