playlistduration

Excel Finance Free Course - Cash Flow Analysis, Stocks, Bonds and Model Building.

by excelisfun · 114 videos

Total watch time

20h 58m

at 1× speed · exactly 20 hours, 57 minutes, 42 seconds at 1×

1×20h 57m 42s
1.25×16h 46m 10s
1.5×13h 58m 28s
1.75×11h 58m 41s
2×10h 28m 51s
Average video11m 2s
Longest46m 24s
Shortest1m 22s
Compare Open on YouTube JSON

Plan to finish

About 21 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 21 days. Turn on JavaScript to plan around your week.

Videos (114)

20h 58m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

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

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 20h 58m · 114 videos

Markdown
[![Watch time: 20h 58m · 114 videos](https://playlistduration.com/badge/playlist/PL90E1F26C7B85E78F.svg)](https://playlistduration.com/playlist/PL90E1F26C7B85E78F)
HTML
<a href="https://playlistduration.com/playlist/PL90E1F26C7B85E78F"><img src="https://playlistduration.com/badge/playlist/PL90E1F26C7B85E78F.svg" alt="Watch time: 20h 58m · 114 videos" width="217" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PL90E1F26C7B85E78F returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.