Basic Financial Calculation – pt.1

Arbitrage and Financial Decision Making

Total Running Time: 09:13

analysis of cost benefits, net present value, no arbitrage condition, NPV, the law of one price, time value of money, value additivity

Arbitrage and Financial Decision Making

Auto Filter

Total Running Time: 03:16

Microsoft Excel, numbers text filters by color

Auto Filter

AutoFill

Total Running Time: 06:15

custom list, Microsoft Excel

AutoFill

Basic Financial Calculation – pt.2

Total Running Time: 12:53

calculations, interest, IRR, loan, Microsoft Excel, 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, MIRR, modified internal rate of return, mutually exclusive, net present value, NPV

Capital Budgeting Decision Models

Capital Budgeting Decisions

Total Running Time: 07:49

IRR, MIRR, NPV, payback period

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, MIRR, modified internal rate of return, net present value, NPV, opportunity cost of capital, PI, profitability index

Capital Budgeting Introduction

Capital Budgeting Techniques (Part 1)

Total Running Time: 08:40

Cash Flows, 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 determination, discounted payback, incremental cash flows, investment decision rules, IRR, IRR problems, MIRR, NPV, payback period, profitability index, risk evaluation

Capital Budgeting – Rules and Application

Cash Flow Models and Capital Investment Decisions

Total Running Time: 07:25

Decision Rule, internal rate of return, net present value, time value of money

Cash Flow Models and Capital Investment Decisions

Choosing a Discount Rate

Total Running Time: 01:08

Expected return, Holding period return, internal rate of return, Realized return

Choosing a Discount Rate

Competitive Balance in Sports

Total Running Time: 11:13

baseball, home field advantage, Microsoft Excel, uncertain of outcome hypotheses

Competitive Balance in Sports

Conditional Formatting

Total Running Time: 04:18

conditional and advanced formatting, Microsoft Excel

Conditional Formatting

Customer Aquisition Costs

Total Running Time: 09:52

cost, Customer, key lifetime value, marketing campaign, net present value

Customer Aquisition Costs

Data Analysis Add-In

Total Running Time: 05:23

descriptive statistics, frequency distribution, histogram, Microsoft Excel

Data Analysis Add-In

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, Capital Budgeting Process, internal rate of return, IRR, MIRR, modified internal rate of return, net present value, NPV, payback period

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

course overview, 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

Excel Spreadsheet, 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, NPV Payoff Profile, Resource Constraints, Risk Criteria, 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

Lookup Tables

Total Running Time: 07:09

exact match, Microsoft Excel, Range Lookup, Vlookup function

Lookup Tables

Measuring Shareholder Value Creation – Net Present Value Model

Total Running Time: 10:54

deriving period free cash flows, FCFs, interpreting NPV results, measuring investment returns, 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, name, 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

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 return, internal rate of return, 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, 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, payback period, Rate of Return

The Four Capital Budgeting Methods

What-if Analysis – Data Table

Total Running Time: 09:42

BEP, Break-Even Point Chart, 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