You must login before you can view videos.

Basic Financial Calculation – pt.1

Name: Basic Financial Calculation – pt.1
Uploaded: 2016-05-04T15:56:45-04:00
Duration: T15M45S
Description: Basic Financial Calculation – pt.1

Home
Topics
1. Finance
Basic Financial Calculation – pt.1

Faculty:
- Bora Ozkan
Tags:

Related Videos

Refine Videos

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

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

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

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