Excel Finance Class 01: Introduction to To Excel 2007 & 2010

Excel Finance Class 02: Getting Started with Formulas, Functions, Formula Inputs and Cell References

Excel Finance Class 03: Math Operators and Order of Operations

Excel Finance Class 04: The Importance Of Number Formatting In Financial Calculations

Excel Finance Class 05: Percent, Percent Change / Increase / Decrease Percentage Number Formatting

Excel Finance Class 06: Relative and Absolute Cell References in Copied Formulas

Excel Finance Class 07: Stylistic Formatting

ACCTG 455: Excel Finance Class 08: Intro To Corporate Financial Management

ACCTG 455: Excel Finance Class 09: Balance Sheet, Working Capital, Liquidity, Debt, Equity, Market V

ACCTG 455: Excel Finance Class 10 Income Statement, NonCash Depreciation Expense, Matching Principal

ACCTG 455: Excel Finance Class 11: Finance Cash Flow From Accounting Information

ACCTG 455: Excel Finance Class 12: Cash Flow Advantage To Debt & Average and Marginal Tax Rates

ACCTG 455: Excel Finance Class 13: Banks, Fundamental Problem With Banks, & The Big Short

ACCTG 455: Excel Finance Class 14: Financial Statement Ratio Analysis - #1 Trick For Ratio Analysis

ACCTG 455: Excel Finance Class 15: Common Sized Financial Statements

ACCTG 455: Excel Finance Class 16: Liquidity, Current Ratio and How Current Ratio Can Be Manipulated

ACCTG 455: Excel Finance Class 17: Leverage & Solvency Ratios: Debt To Equity, Equity Multiplier & m

ACCTG 455: Excel Finance Class 18: Asset Efficiency Ratio and Cash Cycle In Days

ACCTG 455: Excel Finance Class 18.5: Ratios For Cash Cycle In Days.

Excel Finance Class 19:Profitablility Rations: Return On Equity & Return On Assets & DuPont Analysis

ACCTG 455: Excel Finance Class 20: Growth Ratios and Market Value Ratios

ACCTG 455: Excel Finance Class 21: Future Value Lump Sum Calculations

ACCTG 455: Excel Finance Class 22: Present Value Lump Sum Calculations and PV Function

ACCTG 455: Excel Finance Class 23: Solve For Total Number of Periods When You Know PV, FV & P. Rate

ACCTG 455 Excel Finance Class 24: Solve For Period Rate & Annual Rate When You Know PV, FV & Periods

ACCTG 455: Excel Finance Class 25: Future Value For Lender Or Borrower

ACCTG 455: Excel Finance Class 26: Multiple Cash Flow Valuation, Future Value & Present Value

ACCTG 455: Excel Finance Class 27: Asset Valuation Using Discounted Cash Flow Analysis & PV Function

ACCTG 455: Excel Finance Class 28: Relationship Between APR, Period Rate and Effective Annual Rate

ACCTG 455: Excel Finance Class 29: Calculate Future Value Of An Annuity (FV Function)

ACCTG 455: Excel Finance Class 30: Future Value For Interest Paid Daily, But Deposits Made Monthly

ACCTG 455: Excel Finance Class 31: Calculate PMT for Future Value of Annuity (PMT Function)

ACCTG 455: Excel Finance Class 32: Calculate Present Value of Annuity (PV Function)

ACCTG 455: Excel Finance Class 33: Full Life Retirement Plan with PV Annuity & FV Annuity

ACCTG 455: Excel Finance Class 34: Present Value Of Annuity For Asset Valuation

ACCTG 455: Excel Finance Class 35: PMT for Present Value of Annuity PMT Function for Loan Payment

ACCTG 455: Excel Finance Class 36: PMT Function 7 Examples & Adjusted APR w/ Points & RATE function

ACCTG 455: Excel Finance Class 37: How Much Do I Get Each Month During Retirement?

ACCTG 455: Excel Finance Class 38: Calculate APR and EAR Given Cash Flows From Annuity

ACCTG 455: Excel Finance Class 39: How Long To Pay Off Credit Card With Minimum Payment

ACCTG 455: Excel Finance Class 40: Perpetuity (consol) Preferred Stock Valuation Formula

ACCTG 455: Excel Finance Class 41: Interest Only Loan Schedule.

ACCTG 455: Excel Finance Class 42: Consumer Amortized Loans

ACCTG 455: Excel Finance Class 43: Business Amortized Loans

ACCTG 455: Excel Finance Class 44: Deep Discount Loans

ACCTG 455: Excel Finance Class 45: Interest Rates: Real, Nominal, Inflation and the Fisher Effect

ACCTG 455 Excel Finance Class 46: Bonds: Set Of Cash Flows Discounted At Market Rate, Coupon or Zero

ACCTG 455 Excel Finance Class 47: Selling Bond When Coupon Rate Not Equal To Discount Rate: YTM Rate

ACCTG 455 Excel Finance Class 48: Calculate YTM and Effective Annual Yield From Bond Cash Flows

ACCTG 455: Excel Finance Class 49: Bond Quoted Price & Yield To Market

ACCTG 455 Excel Finance Class 50: Bond Rates Are Inversely Related To Bond Price, Excel Chart Visual

ACCTG 455: Excel Finance Class 51: Par - Discount - Premium Bonds

ACCTG 455: Excel Finance Class 52: Bond Discount Or Premium Amortization Table.

ACCTG 455: Excel Finance Class 53: Bond Discount Or Premium Journal Entries

ACCTG 455: Excel Finance Class 54: Bonds & Interest Rate Risk

ACCTG 455: Excel Finance Class 55: Tax Advantage of Muni Bond

ACCTG 455: Excel Finance Class 56: Tax Implications For Zero Coupon Bonds.

ACCTG 455: Excel Finance Class 57: Compare Cash Flows For a Coupon & A Zero Coupon Bond

ACCTG 455: Excel Finance Class 58: After Tax Cash Flows & After Tax Interest Rates

ACCTG 455: Excel Finance Class 59: Common & Preferred Stock

ACCTG 455: Excel Finance Class 60: Basics Of Financial Markets

ACCTG 455: Excel Finance Class 61: Stock Value Based on Present Value of Future Dividend Cash Flows.

ACCTG 455: Excel Finance Class 62: Preferred Stock Valuation as A Perpetuity

ACCTG 455: Excel Finance Class 63: Stock Valuation with Dividend Growth Model

ACCTG 455 Excel Finance Class 64: How Stock Value Changes for Dividend Growth Model as Inputs Change

ACCTG 455: Excel Finance Class 65: Calculate Stock Price at Time t using Dividend Growth Model

ACCTG 455: Excel Finance Class 66: Calculate Implied Return using Dividend Growth Model

ACCTG 455: Excel Finance Class 67: Irregular Dividend PMTs and Constant Growth: Stock Valuation.

ACCTG 455: Excel Finance Class 68: Net Present Value, NPV Excel Function & Capital Budgeting

ACCTG 455: Excel Finance Class 69: Net Present Value Profile: Table & Chart, Learn NPV Function

ACCTG 455: Excel Finance Class 70: Investment Criteria: Net Present Value

ACCTG 455: Excel Finance Class 71: Investment Criteria: Payback Rule

ACCTG 455: Excel Finance Class 72: Investment Criteria: Average Accounting Return

ACCTG 455: Excel Finance Class 73: Investment Criteria: Internal Rate Of Return IRR Function & Chart

ACCTG 455: Excel Finance Class 74: IRR & Non-conventional Cash Flows, Plot Chart To See Multiple IRR

ACCTG 455: Excel Finance Class 75: IRR & Mutually Exclusive Projects, Chart To See Cross Over Rate

ACCTG 455: Excel Finance Class 76: Investment Criteria: MIRR - Modified Internal Rate of Return

ACCTG 455: Excel Finance Class 77: Investment Criteria: Profitability Index

ACCTG 455: Excel Finance Class 78: NPV Irregular Cash Flows & Time Period: XNPV, NPV, PV Functions

ACCTG 455: Excel Finance Class 79: Investment Criteria: NPV, IRR, Payback, AAR, Profitability Index

ACCTG 455: Excel Finance Class 80: Recognizing Cash Flow Patterns in Discounted Cash Flow Analysis

ACCTG 455: Excel Finance Class 81: XNPV Function XIRR Function - See Algorithm That XNPV uses

ACCTG 455 Excel Finance Class 82 Discounted Relevant Costs Cash Flow Analysis Incremental Cash Flows

ACCTG 455: Excel Finance Class 83: Estimating Cash Flows For NPV calculation

ACCTG 455: Excel Finance Class 84: Undoing Accrual Accounting to Get Cash Flows For Estimating NPV

ACCTG 455: Excel Finance Class 85: MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows

ACCTG 455: Excel Finance Class 86: Estimating Cash Flows For NPV Calculation Comprehensive Example.

ACCTG 455: Excel Finance Class 87: Cost Savings Example Estimating Cash Flows For NPV calculation

ACCTG 455: Excel Finance Class 88: Scenario Analysis For Cash Flow & NPV Calculations

ACCTG 455: Excel Finance Class 89: Sensitivity Analysis For Cash Flow & NPV Calculations

ACCTG 455: Excel Finance Class 90: Period (Holding) Returns For Stock

ACCTG 455: Excel Finance Class 91: Period (Holding) Nominal, Real & Dollar Returns For Coupon Bond

ACCTG 455: Excel Finance Class 92: Period (Holding) Returns For Zero Bond

ACCTG 455: Excel Finance Class 93: Period (Holding) Returns For Preferred Stock

ACCTG 455: Excel Finance Class 94: Period (Holding) Returns For Less Than 1 Year, APR and EAR

ACCTG 455: Excel Finance Class 95: Use Past Period Holding Returns to Estimate Future Returns: Mean

ACCTG 455: Excel Finance Class 96: Compare Geometric Mean & Arithmetic Mean For Average Stock Return

ACCTG 455: Excel Finance Class 97: Using Geometric Mean & Arithmetic Mean to Estimate Future Returns

ACCTG 455: Excel Finance Class 98: Stock Return Risk Measured with Standard Deviation

ACCTG 455: Excel Finance Class 99: US Capital Market History 5 Types Investments (2 Good Lessons)

ACCTG 455: Excel Finance Class 100: Real Rate and Inflation or Deflation For T-bills.

ACCTG 455: Excel Finance Class 101: Average Real Return For A Stock Based On Historical Data

ACCTG 455: Excel Finance Class 102: Short Run Financial Markets Can Be Inefficient Mispriced Assets

ACCTG 455: Excel Finance Class 103: 2 Ways To Calculate Geometric Mean

ACCTG 455: Excel Finance Class 104: Expected Return & Standard Deviation For 1 Stock

ACCTG 455: Excel Finance Class 105: Expected Return & Standard Deviation For Portfolio

ACCTG 455: Excel Finance Class 106: Market & Asset Specific Risk, Diversification, Beta

ACCTG 455: Excel Finance Class 107: Calculating Beta (2 Methods)

ACCTG 455: Excel Finance Class 108: Reward To Risk Ratio - Treynor Index

ACCTG 455: Excel Finance Class 109: Beta For Portfolio

ACCTG 455: Excel Finance Class 110: Security Market Line (SML) & Capital Asset Pricing Model (CAPM)

ACCTG 455: Excel Finance Class 111: Treynor Index & CAPM

Excel Magic Trick 1121: Excel 2013 RRI Function: Calculate Compounding Rate/Geometric Mean

Excel Magic Trick 1128: Aging Accounts Receivable Reports On Multiple Sheets With Array Formula

Excel Magic Trick 1428: VLOOKUP, COUNTIFS & IF Helper Column to Calculate Asset Current Value

Excel Magic Trick 1427: DAX GEOMEANX function: Average Compounding Rate per Period for FV Calc

Excel Magic Trick 1431: XNPV, OFFSET & VLOOKUP to Get Dates & Cash Flows for NPV & IRR Calculations

Excel Magic Trick 1430: DAX Functions XNPV & XIRR for Irregular Cash Flow Net Present Value & IRR