Basic Financial Calculation – pt.1

Arbitrage and Financial Decision Making

Total Running Time: 09:13

analysis of cost benefits, Net Present Value (NPV), no arbitrage condition, the law of one price, time value of money, value additivity

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, payment schedule, Principal

Basic Financial Calculation – pt.2

Calculating Expected Values in Excel

Total Running Time: 06:28

Expected Values, Microsoft Excel, SUMPRODUCT

Calculating Expected Values in Excel

Capital Budgeting Decision Models

Total Running Time: 24:16

crossover, Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), mutually exclusive, 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

Accounting Rate of Return (ARR), capital budgeting, decision making, discount rate, Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), Net Present Value (NPV), opportunity cost of capital, 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, discounted payback, incremental cash flows, Internal Rate of Return (IRR), investment decision rules, 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

Decision Rule, 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

home field advantage, Microsoft Excel, uncertain of outcome hypotheses

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, yield to maturity

Cost of Capital III: Cost of Debt

Customer Aquisition Costs

Total Running Time: 09:52

cost, Customer, key lifetime value, marketing campaign, Net Present Value (NPV)

Customer Aquisition Costs

Data Analysis Add-In

Total Running Time: 05:23

descriptive statistics, frequency distribution, 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

Cross-over Rate (COR), 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

cross-over rate (CCR), 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, statistical functions

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, quick instant charts

Excel Charts

Excel Formulas in Financial Statements

Total Running Time: 29:16

apply formulas, final statement, 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

copy grouped data, Microsoft Excel, multiple categories

Excel Subtotals

Exponential Smoothing with Excel

Total Running Time: 16:23

Exponential Smoothing Forecast, MAD, Microsoft Excel, MPE, Smoothing Constant

Exponential Smoothing with Excel

Financial Investment Criteria PT1

Total Running Time: 11:58

Economically Independent Projects, Mutually Exclusive Projects, Net Present Value (NPV), Profitable Project

Financial Investment Criteria PT1

Financial Investment Criteria PT2

Total Running Time: 24:30

Crossover Rate, Internal Rate of Return (IRR), NPV Payoff Profile, Resource Constraints, The Scale Problem, The Timing Problem

Financial Investment Criteria PT2

Formulas: Relative & Absolute Addressing

Total Running Time: 05:37

create formulas and functions, 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, multi level formulas

Group and Outline

IF Functions

Total Running Time: 04:46

Microsoft Excel

IF Functions

Linear Programming Examples

Total Running Time: 05:50

Excel OM, Excel Solver, Microsoft Excel, sensitivity report

Linear Programming Examples

Measuring Shareholder Value Creation – Net Present Value Model

Total Running Time: 10:54

Free Cash Flow (FCF), interpreting NPV results, measuring investment returns, Net Present Value (NPV), setting firm discount rate

Measuring Shareholder Value Creation – Net Present Value Model

Moneyball and Excel

Total Running Time: 12:21

applications of regressions, Microsoft Excel, multiple regressions, regressions, simple regressions

Moneyball and Excel

Moving Averages in Excel

Total Running Time: 24:55

Mean Absolute Deviation, Mean Percentage Error, Microsoft Excel, Moving Average

Moving Averages in Excel

Multi Regression using Excel

Total Running Time: 13:46

Data Analysis Tool Pak, forecasting, Microsoft Excel, Multi Regression, 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

decision models, 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

manipulations, Microsoft Excel

Pivot Tables

Pivot Tables Using Excel

Total Running Time: 12:43

Business Insight, Data Analysis, Microsoft Excel, Pivot Tables

Pivot Tables Using Excel

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

data range, Microsoft Excel, shortcuts

Selecting Efficiently in Excel

Sentiment Analysis Using Excel

Total Running Time: 08:59

Automatic Sentiment Analysis, Manual Sentiment Analysis, Microsoft Excel, Sentiment Analysis

Sentiment Analysis Using Excel

Simple Statistical Regression

Total Running Time: 08:07

Linear Regression, Microsoft Excel, scatter chart

Simple Statistical Regression

Sorting Data

Total Running Time: 03:20

Microsoft Excel, single and multiple parameters

Sorting Data

Sparklines

Total Running Time: 03:27

how to format sparkline, Microsoft Excel, three types of sparkline

Sparklines

Taxes as Transaction Costs Part 1

Total Running Time: 06:16

Cash Inflows and Outflows, 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, transfer Text File Formats

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

exact match, Microsoft Excel, Range Lookup, Vlookup function

VLookup Tables

What-if Analysis – Data Table

Total Running Time: 09:42

Break-Even Point (BEP), Microsoft Excel, one and two way data tables, sensitivity analysis

What-if Analysis – Data Table

What-If Analysis – Goal Seek

Total Running Time: 05:44

decision analysis and modeling, Microsoft Excel

What-If Analysis – Goal Seek