Faculty: Bora Ozkan Tags: calculationsinterestIRRloanMicrosoft ExcelNPVpaymentpayment schedulePrincipal
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.1 Total Running Time: 15:45 calculations, fixed cash flows, internal rate of return, IRR, Microsoft Excel, net present value, NPV Basic Financial Calculation – pt.1
Bills of Lading Total Running Time: 13:54 delivery, document, goods, inherent, international, movement, payment, risk, title, transaction, transportation Bills of Lading
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
Competitive Balance in Sports Total Running Time: 11:13 baseball, home field advantage, Microsoft Excel, uncertain of outcome hypotheses Competitive Balance in Sports
Credit Scores Total Running Time: 06:30 credit bureau, credit reports, credit score, loan Credit Scores
Current Liabilities and Contigencies I Total Running Time: 22:55 accrued, advance collection, issuance, long term liability, noncurrent obligation, notes, payment, recorded Current Liabilities and Contigencies I
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 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 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
Financing: Debt vs Equity Total Running Time: 07:39 cash flow, debt, Dividends, equity, loan, risk Financing: Debt vs Equity
Formulas: Relative & Absolute Addressing Total Running Time: 05:37 create formulas and functions, Microsoft Excel Formulas: Relative & Absolute Addressing
Graduate Student Financial Services Total Running Time: 13:36 aid, billing, FERPA, financial services, Graduate Sfs, Graduate Student Financial Services, loan, Loans, sfs Graduate Student Financial Services
Loan Amortization Table Total Running Time: 08:22 finance, Loan Balance, payment, Principle Payment Loan Amortization Table
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
Partnership Accounting-Income Allocation Total Running Time: 13:28 bonus, interest, net loss, remainder, salaries Partnership Accounting-Income Allocation
Pivot Tables Using Excel Total Running Time: 12:43 Business Insight, Data Analysis, Microsoft Excel, Pivot Tables Pivot Tables Using Excel
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
Sparklines Total Running Time: 03:27 how to format sparkline, Microsoft Excel, three types of sparkline Sparklines
Text Manipulation Total Running Time: 02:36 Microsoft Excel, transfer Text File Formats Text Manipulation
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 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
Fox Video Vault
vault.temple.edu