Excel Finance Free Course - Cash Flow Analysis, Stocks, Bonds and Model Building.
Master Excel for Finance: Unlock the Power of Spreadsheets to Analyze, Calculate, and Manage Your Financial Goals with 100+ Engaging Lessons!
4.0
(1)
8 learners
What you'll learn
- Gain proficiency in Excel financial functions and formulas.
- Understand the fundamentals of corporate financial management.
- Analyze investment criteria and financial statement ratios.
- Master asset valuation techniques using Excel tools.
This course includes
- 20.5 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 114 lessons • 20.5 hours of video
Master Excel Finance: From Basics to Advanced Analysis
114 lessons
• 20.5 hours
Master Excel Finance: From Basics to Advanced Analysis
114 lessons
• 20.5 hours
- Free Excel Finance Course at YouTube01:22
- Excel Finance Class 01: Introduction to To Excel 2007 & 201014:49
- Excel Finance Class 02: Getting Started with Formulas, Functions, Formula Inputs and Cell References20:39
- Excel Finance Class 03: Math Operators and Order of Operations24:50
- Excel Finance Class 04: The Importance Of Number Formatting In Financial Calculations13:14
- Excel Finance Class 05: Percent, Percent Change / Increase / Decrease Percentage Number Formatting11:34
- Excel Finance Class 06: Relative and Absolute Cell References in Copied Formulas07:59
- Excel Finance Class 07: Stylistic Formatting03:46
- ACCTG 455: Excel Finance Class 08: Intro To Corporate Financial Management46:24
- ACCTG 455: Excel Finance Class 09: Balance Sheet, Working Capital, Liquidity, Debt, Equity, Market V34:47
- ACCTG 455: Excel Finance Class 10 Income Statement, NonCash Depreciation Expense, Matching Principal21:35
- ACCTG 455: Excel Finance Class 11: Finance Cash Flow From Accounting Information38:26
- ACCTG 455: Excel Finance Class 12: Cash Flow Advantage To Debt & Average and Marginal Tax Rates13:11
- ACCTG 455: Excel Finance Class 13: Banks, Fundamental Problem With Banks, & The Big Short06:15
- ACCTG 455: Excel Finance Class 14: Financial Statement Ratio Analysis - #1 Trick For Ratio Analysis30:17
- ACCTG 455: Excel Finance Class 15: Common Sized Financial Statements11:23
- ACCTG 455: Excel Finance Class 16: Liquidity, Current Ratio and How Current Ratio Can Be Manipulated14:10
- ACCTG 455: Excel Finance Class 17: Leverage & Solvency Ratios: Debt To Equity, Equity Multiplier & m19:21
- ACCTG 455: Excel Finance Class 18: Asset Efficiency Ratio and Cash Cycle In Days18:10
- ACCTG 455: Excel Finance Class 18.5: Ratios For Cash Cycle In Days.08:55
- Excel Finance Class 19:Profitablility Rations: Return On Equity & Return On Assets & DuPont Analysis17:03
- ACCTG 455: Excel Finance Class 20: Growth Ratios and Market Value Ratios14:53
- ACCTG 455: Excel Finance Class 21: Future Value Lump Sum Calculations31:40
- ACCTG 455: Excel Finance Class 22: Present Value Lump Sum Calculations and PV Function17:24
- ACCTG 455: Excel Finance Class 23: Solve For Total Number of Periods When You Know PV, FV & P. Rate05:06
- ACCTG 455 Excel Finance Class 24: Solve For Period Rate & Annual Rate When You Know PV, FV & Periods11:58
- ACCTG 455: Excel Finance Class 25: Future Value For Lender Or Borrower03:41
- ACCTG 455: Excel Finance Class 26: Multiple Cash Flow Valuation, Future Value & Present Value20:52
- ACCTG 455: Excel Finance Class 27: Asset Valuation Using Discounted Cash Flow Analysis & PV Function07:18
- ACCTG 455: Excel Finance Class 28: Relationship Between APR, Period Rate and Effective Annual Rate19:40
- ACCTG 455: Excel Finance Class 29: Calculate Future Value Of An Annuity (FV Function)17:49
- ACCTG 455: Excel Finance Class 30: Future Value For Interest Paid Daily, But Deposits Made Monthly05:51
- ACCTG 455: Excel Finance Class 31: Calculate PMT for Future Value of Annuity (PMT Function)08:20
- ACCTG 455: Excel Finance Class 32: Calculate Present Value of Annuity (PV Function)10:24
- ACCTG 455: Excel Finance Class 33: Full Life Retirement Plan with PV Annuity & FV Annuity09:49
- ACCTG 455: Excel Finance Class 34: Present Value Of Annuity For Asset Valuation03:28
- ACCTG 455: Excel Finance Class 35: PMT for Present Value of Annuity PMT Function for Loan Payment02:46
- ACCTG 455: Excel Finance Class 36: PMT Function 7 Examples & Adjusted APR w/ Points & RATE function14:50
- ACCTG 455: Excel Finance Class 37: How Much Do I Get Each Month During Retirement?03:22
- ACCTG 455: Excel Finance Class 38: Calculate APR and EAR Given Cash Flows From Annuity02:31
- ACCTG 455: Excel Finance Class 39: How Long To Pay Off Credit Card With Minimum Payment02:52
- ACCTG 455: Excel Finance Class 40: Perpetuity (consol) Preferred Stock Valuation Formula03:07
- ACCTG 455: Excel Finance Class 41: Interest Only Loan Schedule.01:55
- ACCTG 455: Excel Finance Class 42: Consumer Amortized Loans08:41
- ACCTG 455: Excel Finance Class 43: Business Amortized Loans03:12
- ACCTG 455: Excel Finance Class 44: Deep Discount Loans06:03
- ACCTG 455: Excel Finance Class 45: Interest Rates: Real, Nominal, Inflation and the Fisher Effect17:56
- ACCTG 455 Excel Finance Class 46: Bonds: Set Of Cash Flows Discounted At Market Rate, Coupon or Zero27:38
- ACCTG 455 Excel Finance Class 47: Selling Bond When Coupon Rate Not Equal To Discount Rate: YTM Rate07:33
- ACCTG 455 Excel Finance Class 48: Calculate YTM and Effective Annual Yield From Bond Cash Flows03:54
- ACCTG 455: Excel Finance Class 49: Bond Quoted Price & Yield To Market05:54
- ACCTG 455 Excel Finance Class 50: Bond Rates Are Inversely Related To Bond Price, Excel Chart Visual07:17
- ACCTG 455: Excel Finance Class 51: Par - Discount - Premium Bonds09:51
- ACCTG 455: Excel Finance Class 52: Bond Discount Or Premium Amortization Table.06:59
- ACCTG 455: Excel Finance Class 53: Bond Discount Or Premium Journal Entries07:49
- ACCTG 455: Excel Finance Class 54: Bonds & Interest Rate Risk10:44
- ACCTG 455: Excel Finance Class 55: Tax Advantage of Muni Bond03:12
- ACCTG 455: Excel Finance Class 56: Tax Implications For Zero Coupon Bonds.08:14
- ACCTG 455: Excel Finance Class 57: Compare Cash Flows For a Coupon & A Zero Coupon Bond11:15
- ACCTG 455: Excel Finance Class 58: After Tax Cash Flows & After Tax Interest Rates06:24
- ACCTG 455: Excel Finance Class 59: Common & Preferred Stock15:32
- ACCTG 455: Excel Finance Class 60: Basics Of Financial Markets14:54
- ACCTG 455: Excel Finance Class 61: Stock Value Based on Present Value of Future Dividend Cash Flows.08:49
- ACCTG 455: Excel Finance Class 62: Preferred Stock Valuation as A Perpetuity03:27
- ACCTG 455: Excel Finance Class 63: Stock Valuation with Dividend Growth Model04:52
- ACCTG 455 Excel Finance Class 64: How Stock Value Changes for Dividend Growth Model as Inputs Change07:57
- ACCTG 455: Excel Finance Class 65: Calculate Stock Price at Time t using Dividend Growth Model06:29
- ACCTG 455: Excel Finance Class 66: Calculate Implied Return using Dividend Growth Model03:55
- ACCTG 455: Excel Finance Class 67: Irregular Dividend PMTs and Constant Growth: Stock Valuation.13:17
- ACCTG 455: Excel Finance Class 68: Net Present Value, NPV Excel Function & Capital Budgeting16:34
- ACCTG 455: Excel Finance Class 69: Net Present Value Profile: Table & Chart, Learn NPV Function18:41
- ACCTG 455: Excel Finance Class 70: Investment Criteria: Net Present Value03:03
- ACCTG 455: Excel Finance Class 71: Investment Criteria: Payback Rule09:36
- ACCTG 455: Excel Finance Class 72: Investment Criteria: Average Accounting Return08:01
- ACCTG 455: Excel Finance Class 73: Investment Criteria: Internal Rate Of Return IRR Function & Chart19:23
- ACCTG 455: Excel Finance Class 74: IRR & Non-conventional Cash Flows, Plot Chart To See Multiple IRR07:04
- ACCTG 455: Excel Finance Class 75: IRR & Mutually Exclusive Projects, Chart To See Cross Over Rate10:06
- ACCTG 455: Excel Finance Class 76: Investment Criteria: MIRR - Modified Internal Rate of Return09:09
- ACCTG 455: Excel Finance Class 77: Investment Criteria: Profitability Index02:29
- ACCTG 455: Excel Finance Class 78: NPV Irregular Cash Flows & Time Period: XNPV, NPV, PV Functions06:40
- ACCTG 455: Excel Finance Class 79: Investment Criteria: NPV, IRR, Payback, AAR, Profitability Index08:50
- ACCTG 455: Excel Finance Class 80: Recognizing Cash Flow Patterns in Discounted Cash Flow Analysis07:46
- ACCTG 455: Excel Finance Class 81: XNPV Function XIRR Function - See Algorithm That XNPV uses12:40
- ACCTG 455 Excel Finance Class 82 Discounted Relevant Costs Cash Flow Analysis Incremental Cash Flows17:06
- ACCTG 455: Excel Finance Class 83: Estimating Cash Flows For NPV calculation16:45
- ACCTG 455: Excel Finance Class 84: Undoing Accrual Accounting to Get Cash Flows For Estimating NPV07:10
- ACCTG 455: Excel Finance Class 85: MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows10:37
- ACCTG 455: Excel Finance Class 86: Estimating Cash Flows For NPV Calculation Comprehensive Example.22:11
- ACCTG 455: Excel Finance Class 87: Cost Savings Example Estimating Cash Flows For NPV calculation07:33
- ACCTG 455: Excel Finance Class 88: Scenario Analysis For Cash Flow & NPV Calculations14:06
- ACCTG 455: Excel Finance Class 89: Sensitivity Analysis For Cash Flow & NPV Calculations10:55
- ACCTG 455: Excel Finance Class 90: Period (Holding) Returns For Stock05:45
- ACCTG 455: Excel Finance Class 91: Period (Holding) Nominal, Real & Dollar Returns For Coupon Bond04:18
- ACCTG 455: Excel Finance Class 92: Period (Holding) Returns For Zero Bond03:51
- ACCTG 455: Excel Finance Class 93: Period (Holding) Returns For Preferred Stock02:41
- ACCTG 455: Excel Finance Class 94: Period (Holding) Returns For Less Than 1 Year, APR and EAR04:41
- ACCTG 455: Excel Finance Class 95: Use Past Period Holding Returns to Estimate Future Returns: Mean03:56
- ACCTG 455: Excel Finance Class 96: Compare Geometric Mean & Arithmetic Mean For Average Stock Return15:59
- ACCTG 455: Excel Finance Class 97: Using Geometric Mean & Arithmetic Mean to Estimate Future Returns03:52
- ACCTG 455: Excel Finance Class 98: Stock Return Risk Measured with Standard Deviation10:46
- ACCTG 455: Excel Finance Class 99: US Capital Market History 5 Types Investments (2 Good Lessons)21:07
- ACCTG 455: Excel Finance Class 100: Real Rate and Inflation or Deflation For T-bills.03:30
- ACCTG 455: Excel Finance Class 101: Average Real Return For A Stock Based On Historical Data02:58
- ACCTG 455: Excel Finance Class 102: Short Run Financial Markets Can Be Inefficient Mispriced Assets04:15
- ACCTG 455: Excel Finance Class 103: 2 Ways To Calculate Geometric Mean04:46
- ACCTG 455: Excel Finance Class 104: Expected Return & Standard Deviation For 1 Stock11:44
- ACCTG 455: Excel Finance Class 105: Expected Return & Standard Deviation For Portfolio10:48
- ACCTG 455: Excel Finance Class 106: Market & Asset Specific Risk, Diversification, Beta14:00
- ACCTG 455: Excel Finance Class 107: Calculating Beta (2 Methods)11:16
- ACCTG 455: Excel Finance Class 108: Reward To Risk Ratio - Treynor Index06:18
- ACCTG 455: Excel Finance Class 109: Beta For Portfolio03:59
- ACCTG 455: Excel Finance Class 110: Security Market Line (SML) & Capital Asset Pricing Model (CAPM)09:17
- ACCTG 455: Excel Finance Class 111: Treynor Index & CAPM03:03
- Dynamic Spilled Array Formulas for Future Value Cash Flow SIP Step Up. Excel Magic Trick 1699.18:53
