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 YouTube 01:22
- Excel Finance Class 01: Introduction to To Excel 2007 & 2010 14:49
- Excel Finance Class 02: Getting Started with Formulas, Functions, Formula Inputs and Cell References 20:39
- Excel Finance Class 03: Math Operators and Order of Operations 24:50
- Excel Finance Class 04: The Importance Of Number Formatting In Financial Calculations 13:14
- Excel Finance Class 05: Percent, Percent Change / Increase / Decrease Percentage Number Formatting 11:34
- Excel Finance Class 06: Relative and Absolute Cell References in Copied Formulas 07:59
- Excel Finance Class 07: Stylistic Formatting 03:46
- ACCTG 455: Excel Finance Class 08: Intro To Corporate Financial Management 46:24
- ACCTG 455: Excel Finance Class 09: Balance Sheet, Working Capital, Liquidity, Debt, Equity, Market V 34:47
- ACCTG 455: Excel Finance Class 10 Income Statement, NonCash Depreciation Expense, Matching Principal 21:35
- ACCTG 455: Excel Finance Class 11: Finance Cash Flow From Accounting Information 38:26
- ACCTG 455: Excel Finance Class 12: Cash Flow Advantage To Debt & Average and Marginal Tax Rates 13:11
- ACCTG 455: Excel Finance Class 13: Banks, Fundamental Problem With Banks, & The Big Short 06:15
- ACCTG 455: Excel Finance Class 14: Financial Statement Ratio Analysis - #1 Trick For Ratio Analysis 30:17
- ACCTG 455: Excel Finance Class 15: Common Sized Financial Statements 11:23
- ACCTG 455: Excel Finance Class 16: Liquidity, Current Ratio and How Current Ratio Can Be Manipulated 14:10
- ACCTG 455: Excel Finance Class 17: Leverage & Solvency Ratios: Debt To Equity, Equity Multiplier & m 19:21
- ACCTG 455: Excel Finance Class 18: Asset Efficiency Ratio and Cash Cycle In Days 18: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 Analysis 17:03
- ACCTG 455: Excel Finance Class 20: Growth Ratios and Market Value Ratios 14:53
- ACCTG 455: Excel Finance Class 21: Future Value Lump Sum Calculations 31:40
- ACCTG 455: Excel Finance Class 22: Present Value Lump Sum Calculations and PV Function 17:24
- ACCTG 455: Excel Finance Class 23: Solve For Total Number of Periods When You Know PV, FV & P. Rate 05:06
- ACCTG 455 Excel Finance Class 24: Solve For Period Rate & Annual Rate When You Know PV, FV & Periods 11:58
- ACCTG 455: Excel Finance Class 25: Future Value For Lender Or Borrower 03:41
- ACCTG 455: Excel Finance Class 26: Multiple Cash Flow Valuation, Future Value & Present Value 20:52
- ACCTG 455: Excel Finance Class 27: Asset Valuation Using Discounted Cash Flow Analysis & PV Function 07:18
- ACCTG 455: Excel Finance Class 28: Relationship Between APR, Period Rate and Effective Annual Rate 19: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 Monthly 05: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 Annuity 09:49
- ACCTG 455: Excel Finance Class 34: Present Value Of Annuity For Asset Valuation 03:28
- ACCTG 455: Excel Finance Class 35: PMT for Present Value of Annuity PMT Function for Loan Payment 02:46
- ACCTG 455: Excel Finance Class 36: PMT Function 7 Examples & Adjusted APR w/ Points & RATE function 14: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 Annuity 02:31
- ACCTG 455: Excel Finance Class 39: How Long To Pay Off Credit Card With Minimum Payment 02:52
- ACCTG 455: Excel Finance Class 40: Perpetuity (consol) Preferred Stock Valuation Formula 03:07
- ACCTG 455: Excel Finance Class 41: Interest Only Loan Schedule. 01:55
- ACCTG 455: Excel Finance Class 42: Consumer Amortized Loans 08:41
- ACCTG 455: Excel Finance Class 43: Business Amortized Loans 03:12
- ACCTG 455: Excel Finance Class 44: Deep Discount Loans 06:03
- ACCTG 455: Excel Finance Class 45: Interest Rates: Real, Nominal, Inflation and the Fisher Effect 17:56
- ACCTG 455 Excel Finance Class 46: Bonds: Set Of Cash Flows Discounted At Market Rate, Coupon or Zero 27:38
- ACCTG 455 Excel Finance Class 47: Selling Bond When Coupon Rate Not Equal To Discount Rate: YTM Rate 07:33
- ACCTG 455 Excel Finance Class 48: Calculate YTM and Effective Annual Yield From Bond Cash Flows 03:54
- ACCTG 455: Excel Finance Class 49: Bond Quoted Price & Yield To Market 05:54
- ACCTG 455 Excel Finance Class 50: Bond Rates Are Inversely Related To Bond Price, Excel Chart Visual 07:17
- ACCTG 455: Excel Finance Class 51: Par - Discount - Premium Bonds 09: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 Entries 07:49
- ACCTG 455: Excel Finance Class 54: Bonds & Interest Rate Risk 10:44
- ACCTG 455: Excel Finance Class 55: Tax Advantage of Muni Bond 03: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 Bond 11:15
- ACCTG 455: Excel Finance Class 58: After Tax Cash Flows & After Tax Interest Rates 06:24
- ACCTG 455: Excel Finance Class 59: Common & Preferred Stock 15:32
- ACCTG 455: Excel Finance Class 60: Basics Of Financial Markets 14: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 Perpetuity 03:27
- ACCTG 455: Excel Finance Class 63: Stock Valuation with Dividend Growth Model 04:52
- ACCTG 455 Excel Finance Class 64: How Stock Value Changes for Dividend Growth Model as Inputs Change 07:57
- ACCTG 455: Excel Finance Class 65: Calculate Stock Price at Time t using Dividend Growth Model 06:29
- ACCTG 455: Excel Finance Class 66: Calculate Implied Return using Dividend Growth Model 03: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 Budgeting 16:34
- ACCTG 455: Excel Finance Class 69: Net Present Value Profile: Table & Chart, Learn NPV Function 18:41
- ACCTG 455: Excel Finance Class 70: Investment Criteria: Net Present Value 03:03
- ACCTG 455: Excel Finance Class 71: Investment Criteria: Payback Rule 09:36
- ACCTG 455: Excel Finance Class 72: Investment Criteria: Average Accounting Return 08:01
- ACCTG 455: Excel Finance Class 73: Investment Criteria: Internal Rate Of Return IRR Function & Chart 19:23
- ACCTG 455: Excel Finance Class 74: IRR & Non-conventional Cash Flows, Plot Chart To See Multiple IRR 07:04
- ACCTG 455: Excel Finance Class 75: IRR & Mutually Exclusive Projects, Chart To See Cross Over Rate 10:06
- ACCTG 455: Excel Finance Class 76: Investment Criteria: MIRR - Modified Internal Rate of Return 09:09
- ACCTG 455: Excel Finance Class 77: Investment Criteria: Profitability Index 02:29
- ACCTG 455: Excel Finance Class 78: NPV Irregular Cash Flows & Time Period: XNPV, NPV, PV Functions 06:40
- ACCTG 455: Excel Finance Class 79: Investment Criteria: NPV, IRR, Payback, AAR, Profitability Index 08:50
- ACCTG 455: Excel Finance Class 80: Recognizing Cash Flow Patterns in Discounted Cash Flow Analysis 07:46
- ACCTG 455: Excel Finance Class 81: XNPV Function XIRR Function - See Algorithm That XNPV uses 12:40
- ACCTG 455 Excel Finance Class 82 Discounted Relevant Costs Cash Flow Analysis Incremental Cash Flows 17:06
- ACCTG 455: Excel Finance Class 83: Estimating Cash Flows For NPV calculation 16:45
- ACCTG 455: Excel Finance Class 84: Undoing Accrual Accounting to Get Cash Flows For Estimating NPV 07:10
- ACCTG 455: Excel Finance Class 85: MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows 10: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 calculation 07:33
- ACCTG 455: Excel Finance Class 88: Scenario Analysis For Cash Flow & NPV Calculations 14:06
- ACCTG 455: Excel Finance Class 89: Sensitivity Analysis For Cash Flow & NPV Calculations 10:55
- ACCTG 455: Excel Finance Class 90: Period (Holding) Returns For Stock 05:45
- ACCTG 455: Excel Finance Class 91: Period (Holding) Nominal, Real & Dollar Returns For Coupon Bond 04:18
- ACCTG 455: Excel Finance Class 92: Period (Holding) Returns For Zero Bond 03:51
- ACCTG 455: Excel Finance Class 93: Period (Holding) Returns For Preferred Stock 02:41
- ACCTG 455: Excel Finance Class 94: Period (Holding) Returns For Less Than 1 Year, APR and EAR 04:41
- ACCTG 455: Excel Finance Class 95: Use Past Period Holding Returns to Estimate Future Returns: Mean 03:56
- ACCTG 455: Excel Finance Class 96: Compare Geometric Mean & Arithmetic Mean For Average Stock Return 15:59
- ACCTG 455: Excel Finance Class 97: Using Geometric Mean & Arithmetic Mean to Estimate Future Returns 03:52
- ACCTG 455: Excel Finance Class 98: Stock Return Risk Measured with Standard Deviation 10: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 Data 02:58
- ACCTG 455: Excel Finance Class 102: Short Run Financial Markets Can Be Inefficient Mispriced Assets 04:15
- ACCTG 455: Excel Finance Class 103: 2 Ways To Calculate Geometric Mean 04:46
- ACCTG 455: Excel Finance Class 104: Expected Return & Standard Deviation For 1 Stock 11:44
- ACCTG 455: Excel Finance Class 105: Expected Return & Standard Deviation For Portfolio 10:48
- ACCTG 455: Excel Finance Class 106: Market & Asset Specific Risk, Diversification, Beta 14:00
- ACCTG 455: Excel Finance Class 107: Calculating Beta (2 Methods) 11:16
- ACCTG 455: Excel Finance Class 108: Reward To Risk Ratio - Treynor Index 06:18
- ACCTG 455: Excel Finance Class 109: Beta For Portfolio 03: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 & CAPM 03:03
- Dynamic Spilled Array Formulas for Future Value Cash Flow SIP Step Up. Excel Magic Trick 1699. 18:53
Related learning topics
Take this course with you
Download the app to continue lessons from your phone anytime.
