Basic Financial Calculation – pt.1

Arbitrage and Financial Decision Making

Total Running Time: 09:13

Net Present Value (NPV), time value of money

Arbitrage and Financial Decision Making

Basic Financial Calculation – pt.2

Total Running Time: 12:53

interest, Internal Rate of Return (IRR), loan, Microsoft Excel, Net Present Value (NPV), payment

Basic Financial Calculation – pt.2

Calculating Expected Values in Excel

Total Running Time: 06:28

Microsoft Excel

Calculating Expected Values in Excel

Capital Budgeting Decision Models

Total Running Time: 24:16

Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), Net Present Value (NPV)

Capital Budgeting Decision Models

Capital Budgeting Decisions

Total Running Time: 07:49

Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), Net Present Value (NPV), Payback Period (PBP)

Capital Budgeting Decisions

Capital Budgeting Introduction

Total Running Time: 11:22

capital budgeting, decision making, discount rate, Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), Net Present Value (NPV), Profitability Index (PI)

Capital Budgeting Introduction

Capital Budgeting Techniques (Part 1)

Total Running Time: 08:40

cash flow, Internal Rate of Return (IRR), Net Present Value (NPV), present value

Capital Budgeting Techniques (Part 1)

Capital Budgeting: Rules and Application

Total Running Time: 22:21

cash flow, incremental cash flows, Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), Net Present Value (NPV), Payback Period (PBP), Profitability Index (PI)

Capital Budgeting: Rules and Application

Cash Flow Models and Capital Investment Decisions

Total Running Time: 07:25

Internal Rate of Return (IRR), Net Present Value (NPV), time value of money

Cash Flow Models and Capital Investment Decisions

Choosing a Discount Rate

Total Running Time: 01:08

Expected return, holding period returns, Internal Rate of Return (IRR), Realized return

Choosing a Discount Rate

Competitive Balance in Sports

Total Running Time: 11:13

Microsoft Excel

Competitive Balance in Sports

Cost of Capital III: Cost of Debt

Total Running Time: 10:57

cost of capital, Cost of Debt, coupon rate, Internal Rate of Return (IRR), Preferred Stock

Cost of Capital III: Cost of Debt

Customer Aquisition Costs

Total Running Time: 09:52

cost, Customer, Net Present Value (NPV)

Customer Aquisition Costs

Data Analysis Add-In

Total Running Time: 05:23

histogram, Microsoft Excel

Data Analysis Add-In

Decision Criteria: Internal Rate of Return (IRR)

Total Running Time: 12:19

Internal Rate of Return (IRR), Limitations of the IRR method, Modified Internal Rate of Return (MIRR), NPV profile

Decision Criteria: Internal Rate of Return (IRR)

Decision Criteria: Internal Rate of Return (IRR) Excel

Total Running Time: 06:16

Internal Rate of Return (IRR), Limitations of the IRR method, Modified Internal Rate of Return (MIRR), NPV profile

Decision Criteria: Internal Rate of Return (IRR) Excel

Decision Criteria: IRR and Mutually Exclusive Projects

Total Running Time: 02:56

Internal Rate of Return (IRR), Mutually Exclusive Projects, Net Present Value (NPV), NPV profile

Decision Criteria: IRR and Mutually Exclusive Projects

Decision Criteria: IRR and Mutually Exclusive Projects Excel

Total Running Time: 09:42

Internal Rate of Return (IRR), Mutually Exclusive Projects, Net Present Value (NPV), NPV profile

Decision Criteria: IRR and Mutually Exclusive Projects Excel

Decision Criteria: NPV

Total Running Time: 05:30

Net Present Value (NPV), Profitability Index (PI)

Decision Criteria: NPV

Decision Criteria: NPV Excel

Total Running Time: 08:18

Net Present Value (NPV), Profitability Index (PI)

Decision Criteria: NPV Excel

Decision Criteria: NPV Excel

Total Running Time: 08:18

Net Present Value (NPV), Profitability Index (PI)

Decision Criteria: NPV Excel

Descriptive Statistics

Total Running Time: 03:44

Microsoft Excel

Descriptive Statistics

Example of Capital Budgeting Problems

Total Running Time: 08:43

capital budgeting, Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), Net Present Value (NPV), Payback Period (PBP)

Example of Capital Budgeting Problems

Excel Charts

Total Running Time: 07:58

Microsoft Excel, pie chart

Excel Charts

Excel Formulas in Financial Statements

Total Running Time: 29:16

Microsoft Excel

Excel Formulas in Financial Statements

Excel Proficiency – Introduction

Total Running Time: 03:08

Microsoft Excel

Excel Proficiency – Introduction

Excel Scenario Manager

Total Running Time: 08:58

Microsoft Excel

Excel Scenario Manager

Excel Solver Part 1

Total Running Time: 12:31

Microsoft Excel, spreadsheet

Excel Solver Part 1

Excel Solver Part 2

Total Running Time: 14:33

Microsoft Excel

Excel Solver Part 2

Excel Subtotals

Total Running Time: 04:16

Microsoft Excel

Excel Subtotals

Exponential Smoothing with Excel

Total Running Time: 16:23

Microsoft Excel

Exponential Smoothing with Excel

Financial Investment Criteria PT1

Total Running Time: 11:58

Mutually Exclusive Projects, Net Present Value (NPV)

Financial Investment Criteria PT1

Financial Investment Criteria PT2

Total Running Time: 24:30

Internal Rate of Return (IRR), Resource Constraints

Financial Investment Criteria PT2

Formulas: Relative & Absolute Addressing

Total Running Time: 05:37

Microsoft Excel

Formulas: Relative & Absolute Addressing

Frequency Distribution

Total Running Time: 04:58

charts, Microsoft Excel

Frequency Distribution

Group and Outline

Total Running Time: 03:38

Microsoft Excel

Group and Outline

IF Functions

Total Running Time: 04:46

Microsoft Excel

IF Functions

Linear Programming Examples

Total Running Time: 05:50

Excel OM, Microsoft Excel

Linear Programming Examples

Measuring Shareholder Value Creation – Net Present Value Model

Total Running Time: 10:54

Free Cash Flow (FCF), Net Present Value (NPV)

Measuring Shareholder Value Creation – Net Present Value Model

Moneyball and Excel

Total Running Time: 12:21

Microsoft Excel

Moneyball and Excel

Moving Averages in Excel

Total Running Time: 24:55

Microsoft Excel

Moving Averages in Excel

Multi Regression using Excel

Total Running Time: 13:46

forecasting, Microsoft Excel, statistics

Multi Regression using Excel

Naming Cells and Ranges

Total Running Time: 07:04

functions, Microsoft Excel, modeling, statistics

Naming Cells and Ranges

Naming Cells: Meaningful Modeling

Total Running Time: 04:52

Microsoft Excel, presentations

Naming Cells: Meaningful Modeling

Options Pricing: Logical Breakthrough

Recognize why Net Present Value (NPV) fails to properly value some assets and strategies; Explain the key differences between the discounted cash flow and op... Watch Now

Total Running Time: 16:04

Net Present Value (NPV)

Options Pricing: Logical Breakthrough

Pivot Tables

Total Running Time: 08:20

Microsoft Excel

Pivot Tables

Return Concepts

Total Running Time: 06:08

Expected return, holding period returns, Internal Rate of Return (IRR), Realized return

Return Concepts

Selecting Efficiently in Excel

Total Running Time: 02:42

Microsoft Excel

Selecting Efficiently in Excel

Simple Statistical Regression

Total Running Time: 08:07

Linear Regression, Microsoft Excel

Simple Statistical Regression

Sorting Data

Total Running Time: 03:20

Microsoft Excel

Sorting Data

Sparklines

Total Running Time: 03:27

Microsoft Excel

Sparklines

Taxes as Transaction Costs Part 1

Total Running Time: 06:16

Net Present Value (NPV), present value, time value of money

Taxes as Transaction Costs Part 1

Text Manipulation

Total Running Time: 02:36

Microsoft Excel

Text Manipulation

The Four Capital Budgeting Methods

Total Running Time: 03:50

Net Present Value (NPV), Payback Period (PBP), Rate of Return

The Four Capital Budgeting Methods

VLookup Tables

Total Running Time: 07:09

Microsoft Excel

VLookup Tables

What-if Analysis – Data Table

Total Running Time: 09:42

Break-Even Point (BEP), Microsoft Excel, sensitivity analysis

What-if Analysis – Data Table

What-If Analysis – Goal Seek

Total Running Time: 05:44

Microsoft Excel

What-If Analysis – Goal Seek