playlistduration

Excel Corporate Free Finance Class: The Power of NPV Cash Flow Analysis

by excelisfun · 135 videos

Total watch time

19h 58m

at 1× speed · exactly 19 hours, 57 minutes, 54 seconds at 1×

1×19h 57m 54s
1.25×15h 58m 19s
1.5×13h 18m 36s
1.75×11h 24m 31s
2×9h 58m 57s
Average video8m 52s
Longest46m 24s
Shortest1m
Compare Open on YouTube JSON

Plan to finish

About 20 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 20 days. Turn on JavaScript to plan around your week.

Videos (135)

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

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

Videos to
Watched
1 Highline College Excel Corporate Finance ACCTG 455 Class 2025 Winter by Mike "excelisfun" Girvin 5:37 2025-01-06
2 ACCTG 455: Excel Finance Class 08: Intro To Corporate Financial Management 46:24 2010-09-23
3 ACCTG 455: Excel Finance Class 09: Balance Sheet, Working Capital, Liquidity, Debt, Equity, Market V 34:47 2010-09-24
4 ACCTG 455: Excel Finance Class 10 Income Statement, NonCash Depreciation Expense, Matching Principal 21:35 2010-09-23
5 ACCTG 455: Excel Finance Class 11: Finance Cash Flow From Accounting Information 38:26 2010-09-23
6 ACCTG 455: Excel Finance Class 12: Cash Flow Advantage To Debt & Average and Marginal Tax Rates 13:11 2010-09-23
7 ACCTG 455: Excel Finance Class 13: Banks, Fundamental Problem With Banks, & The Big Short 6:15 2010-09-30
8 ACCTG 455, Excel Finance Class 13.5: Financial Statement Cash Flow Equation Algebra Hint for HW 19 3:16 2025-01-17
9 ACCTG 455: Excel Finance Class 14: Financial Statement Ratio Analysis - #1 Trick For Ratio Analysis 30:17 2010-09-30
10 ACCTG 455 Excel Finance Class 14.5: Common Size Income Statement Spilled Array Formula #Short EMT 28 1:01 2025-01-16
11 ACCTG 455: Excel Finance Class 15: Common Sized Financial Statements 11:23 2010-09-30
12 ACCTG 455 Excel Finance Class 15.5: Formula for Multiple Common Sized Income Statements #Short ET 29 1:00 2025-01-17
13 ACCTG 455 Excel Finance Class 15.75: Three Common Sized Balance Sheet: Single Formula #Short EMT 30 1:00 2025-01-18
14 ACCTG 455: Excel Finance Class 16: Liquidity, Current Ratio and How Current Ratio Can Be Manipulated 14:10 2010-09-30
15 ACCTG 455: Excel Finance Class 17: Leverage & Solvency Ratios: Debt To Equity, Equity Multiplier & m 19:21 2010-09-30
16 ACCTG 455: Excel Finance Class 18: Asset Efficiency Ratio and Cash Cycle In Days 18:10 2010-09-30
17 ACCTG 455: Excel Finance Class 18.5: Ratios For Cash Cycle In Days. 8:55 2010-10-07
18 Excel Finance Class 19:Profitablility Rations: Return On Equity & Return On Assets & DuPont Analysis 17:03 2010-09-30
19 ACCTG 455: Excel Finance Class 19.5: Why DuPont ROE Analysis is So Clever! 1:50 2025-01-21
20 ACCTG 455: Excel Finance Class 19.75: DuPont ROE Analysis. EMT Short #33. 1:51 2025-01-21
21 ACCTG 455: Excel Finance Class 20: Growth Ratios and Market Value Ratios 14:53 2010-09-30
22 Excel Formulas: Arrow Keys or Mouse? Return on Assets & Return on Equity Show the Best! #Short ET 37 1:15 2025-01-24
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 Excel Spilled Loan Amortization Table. #Short Excel Trick 40. ACCTG 455. 1:39 2025-01-30
46 ACCTG 455: Excel Finance Class 43: Business Amortized Loans 3:12 2010-10-14
47 Excel Spilled Equal Principal Payment Amortization Table . #Short Excel Trick 41. ACCTG 455. 1:20 2025-01-31
48 ACCTG 455: Excel Finance Class 44: Deep Discount Loans 6:03 2010-10-14
49 Deep Discount Loan Spilled Amortization Table (Treasury Bonds) . #Short Excel Trick 42. ACCTG 455. 1:23 2025-02-01
50 ACCTG 455: Excel Finance Class 45: Interest Rates: Real, Nominal, Inflation and the Fisher Effect 17:56 2010-10-25
51 ACCTG 455 Excel Finance Class 46: Bonds: Set Of Cash Flows Discounted At Market Rate, Coupon or Zero 27:38 2010-10-25
52 ACCTG 455 Excel Finance Class 47: Selling Bond When Coupon Rate Not Equal To Discount Rate: YTM Rate 7:33 2010-10-25
53 ACCTG 455 Excel Finance Class 48: Calculate YTM and Effective Annual Yield From Bond Cash Flows 3:54 2010-10-25
54 ACCTG 455: Excel Finance Class 49: Bond Quoted Price & Yield To Market 5:54 2010-10-25
55 ACCTG 455 Excel Finance Class 50: Bond Rates Are Inversely Related To Bond Price, Excel Chart Visual 7:17 2010-10-25
56 Conditional Formatting for Bond Sold at Discount or Premium. #Short Excel Trick 43. ACCTG 455 # 50.1 1:23 2025-02-02
57 IFS Function for Bond Value "Par", "Discount", or "Premium". #Short Excel Trick 44. ACCTG 455 # 50.2 1:23 2025-02-03
58 Spill Bond Valuation PV Function Formula Across YTM Rates. #Short Excel Trick 45. ACCTG 455 #50.3 1:21 2025-02-04
59 Visualize Inverse Relationship for Bond Price & YTM Rate. #Short Excel Trick 46. ACCTG 455 50.4 1:13 2025-02-05
60 ACCTG 455: Excel Finance Class 51: Par - Discount - Premium Bonds 9:51 2010-10-25
61 ACCTG 455: Excel Finance Class 52: Bond Discount Or Premium Amortization Table. 6:59 2010-10-25
62 ACCTG 455: Excel Finance Class 53: Bond Discount Or Premium Journal Entries 7:49 2010-10-25
63 ACCTG 455: Excel Finance Class 54: Bonds & Interest Rate Risk 10:44 2010-10-25
64 Bond Rate Risk: Longer Maturity, More YTM Affects Bond Price. #Short 47. ACCTG 455 #54.1 2:05 2025-02-06
65 Bond Rate Risk: Lower Coupon Rate, The More YTM Affects Bond Price. #Short 48. ACCTG 455 #54.2 1:45 2025-02-08
66 ACCTG 455: Excel Finance Class 55: Tax Advantage of Muni Bond 3:12 2010-10-25
67 ACCTG 455: Excel Finance Class 56: Tax Implications For Zero Coupon Bonds. 8:14 2010-10-26
68 ACCTG 455: Excel Finance Class 57: Compare Cash Flows For a Coupon & A Zero Coupon Bond 11:15 2010-10-26
69 ACCTG 455: Excel Finance Class 58: After Tax Cash Flows & After Tax Interest Rates 6:24 2010-10-29
70 ACCTG 455: Excel Finance Class 59: Common & Preferred Stock 15:32 2010-11-01
71 ACCTG 455: Excel Finance Class 60: Basics Of Financial Markets 14:54 2010-11-01
72 An Inside Look At The New York Stock Exchange · Benzinga 16:43 2022-10-13
73 Why the NYSE Trading Floor Is a Lot Quieter These Days · TheStreet 2:04 2023-07-06
74 ACCTG 455: Excel Finance Class 61: Stock Value Based on Present Value of Future Dividend Cash Flows. 8:49 2010-11-01
75 ACCTG 455: Excel Finance Class 62: Preferred Stock Valuation as A Perpetuity 3:27 2010-10-31
76 ACCTG 455: Excel Finance Class 63: Stock Valuation with Dividend Growth Model 4:52 2010-11-01
77 Visualize How Stock Values Changes as Dividend Growth Rate Changes. #Short 49. ACCTG 455 #63.1 1:11 2025-02-09
78 Visualize How Stock Values Changes as Required Rate of Return Changes. #Short 50. ACCTG 455 #63.2 1:56 2025-02-10
79 ACCTG 455 Excel Finance Class 64: How Stock Value Changes for Dividend Growth Model as Inputs Change 7:57 2010-10-31
80 ACCTG 455: Excel Finance Class 65: Calculate Stock Price at Time t using Dividend Growth Model 6:29 2010-10-31
81 ACCTG 455: Excel Finance Class 66: Calculate Implied Return using Dividend Growth Model 3:55 2010-10-31
82 ACCTG 455: Excel Finance Class 67: Irregular Dividend PMTs and Constant Growth: Stock Valuation. 13:17 2010-10-31
83 ACCTG 455: Excel Finance Class 68: Net Present Value, NPV Excel Function & Capital Budgeting 16:34 2010-11-08
84 Build Text Formula for Dynamic Label For Financial Model. #Short 51. ACCTG 455 #68.1 1:41 2025-02-11
85 Net Present Value: Do We Buy Asset? PV or NPV Function? #Short 52. ACCTG 455 #68.2 2:20 2025-02-12
86 Internal Rate of Return = IRR (Rate at Which NPV = 0). #Short 53. ACCTG 455 #68.3 1:27 2025-02-13
87 Net Present Value Profile Spilled Formula: Table and X-Y Scatter Chart. #Short 54. ACCTG 455 #68.4 2:30 2025-02-14
88 ACCTG 455: Excel Finance Class 70: Investment Criteria: Net Present Value 3:03 2010-11-08
89 ACCTG 455: Excel Finance Class 71: Investment Criteria: Payback Rule 9:36 2010-11-08
90 ACCTG 455: Excel Finance Class 72: Investment Criteria: Average Accounting Return 8:01 2010-11-08
91 ACCTG 455: Excel Finance Class 73: Investment Criteria: Internal Rate Of Return IRR Function & Chart 19:23 2010-11-08
92 ACCTG 455: Excel Finance Class 74: IRR & Non-conventional Cash Flows, Plot Chart To See Multiple IRR 7:04 2010-11-08
93 ACCTG 455: Excel Finance Class 75: IRR & Mutually Exclusive Projects, Chart To See Cross Over Rate 10:06 2010-11-08
94 ACCTG 455: Excel Finance Class 76: Investment Criteria: MIRR - Modified Internal Rate of Return 9:09 2010-11-11
95 ACCTG 455: Excel Finance Class 77: Investment Criteria: Profitability Index 2:29 2010-11-08
96 ACCTG 455: Excel Finance Class 79: Investment Criteria: NPV, IRR, Payback, AAR, Profitability Index 8:50 2010-11-08
97 ACCTG 455: Excel Finance Class 80: Recognizing Cash Flow Patterns in Discounted Cash Flow Analysis 7:46 2010-11-14
98 Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761 3:46 2021-10-18
99 Why Excel NPV and XNPV Function Give Different Answers for Cash Flow Analysis. EMT 1762 8:19 2021-10-22
100 ACCTG 455: Excel Finance Class 81: XNPV Function XIRR Function - See Algorithm That XNPV uses 12:40 2010-11-14
101 ACCTG 455 Excel Finance Class 82 Discounted Relevant Costs Cash Flow Analysis Incremental Cash Flows 17:06 2010-11-14
102 ACCTG 455: Excel Finance Class 83: Estimating Cash Flows For NPV calculation 16:45 2010-11-14
103 ACCTG 455: Excel Finance Class 84: Undoing Accrual Accounting to Get Cash Flows For Estimating NPV 7:10 2010-11-14
104 ACCTG 455: Excel Finance Class 85: MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows 10:37 2010-11-14
105 ACCTG 455: Excel Finance Class 86: Estimating Cash Flows For NPV Calculation Comprehensive Example. 22:11 2010-11-14
106 ACCTG 455: Excel Finance Class 87: Cost Savings Example Estimating Cash Flows For NPV calculation 7:33 2010-11-14
107 ACCTG 455: Excel Finance Class 88: Scenario Analysis For Cash Flow & NPV Calculations 14:06 2010-11-14
108 ACCTG 455: Excel Finance Class 89: Sensitivity Analysis For Cash Flow & NPV Calculations 10:55 2010-11-14
109 ACCTG 455: Excel Finance Class 90: Period (Holding) Returns For Stock 5:45 2010-11-20
110 ACCTG 455: Excel Finance Class 91: Period (Holding) Nominal, Real & Dollar Returns For Coupon Bond 4:18 2010-11-20
111 ACCTG 455: Excel Finance Class 92: Period (Holding) Returns For Zero Bond 3:51 2010-11-20
112 ACCTG 455: Excel Finance Class 93: Period (Holding) Returns For Preferred Stock 2:41 2010-11-20
113 ACCTG 455: Excel Finance Class 94: Period (Holding) Returns For Less Than 1 Year, APR and EAR 4:41 2010-11-20
114 ACCTG 455: Excel Finance Class 95: Use Past Period Holding Returns to Estimate Future Returns: Mean 3:56 2010-11-20
115 ACCTG 455: Excel Finance Class 96: Compare Geometric Mean & Arithmetic Mean For Average Stock Return 15:59 2010-11-20
116 ACCTG 455: Excel Finance Class 97: Using Geometric Mean & Arithmetic Mean to Estimate Future Returns 3:52 2010-11-20
117 ACCTG 455: Excel Finance Class 98: Stock Return Risk Measured with Standard Deviation 10:46 2010-11-20
118 ACCTG 455: Excel Finance Class 99: US Capital Market History 5 Types Investments (2 Good Lessons) 21:07 2010-11-20
119 ACCTG 455: Excel Finance Class 100: Real Rate and Inflation or Deflation For T-bills. 3:30 2010-11-20
120 ACCTG 455: Excel Finance Class 101: Average Real Return For A Stock Based On Historical Data 2:58 2010-11-20
121 ACCTG 455: Excel Finance Class 102: Short Run Financial Markets Can Be Inefficient Mispriced Assets 4:15 2010-11-22
122 Excel's Amazing SCAN Function: Spill Formula That Acts On Previous Spilled Value!?! #Short Excel 55 2:10 2025-02-17
123 Create Column of 8 Excel Text Formulas from Rectangle Range with Single Spilled Formula. #Short 56 1:53 2025-02-18
124 ACCTG 455: Excel Finance Class 103: 2 Ways To Calculate Geometric Mean 4:46 2010-11-30
125 ACCTG 455: Excel Finance Class 104: Expected Return & Standard Deviation For 1 Stock 11:44 2010-11-30
126 Expected Return & Standard Deviation for 2 Stocks: Single Cell Excel Spilled Array Formula #Short 57 2:28 2025-02-19
127 ACCTG 455: Excel Finance Class 105: Expected Return & Standard Deviation For Portfolio 10:48 2010-11-30
128 Expected Return & Standard Deviation 4 Portfolio of Stocks Single Cell Excel Array Formula #Short 58 2:10 2025-02-20
129 ACCTG 455: Excel Finance Class 106: Market & Asset Specific Risk, Diversification, Beta 14:00 2010-11-30
130 ACCTG 455: Excel Finance Class 107: Calculating Beta (2 Methods) 11:16 2010-12-03
131 ACCTG 455: Excel Finance Class 108: Reward To Risk Ratio - Treynor Index 6:18 2010-11-30
132 ACCTG 455: Excel Finance Class 109: Beta For Portfolio 3:59 2010-11-30
133 Stock Portfolio Expected Return & Beta with single cell array formula. Bonus Trick Too! #Short 59 1:39 2025-02-21
134 ACCTG 455: Excel Finance Class 110: Security Market Line (SML) & Capital Asset Pricing Model (CAPM) 9:17 2010-11-30
135 ACCTG 455: Excel Finance Class 111: Treynor Index & CAPM 3:03 2010-11-30

Embed a badge

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

Watch time: 19h 58m · 135 videos

Markdown
[![Watch time: 19h 58m · 135 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0ly_v86mHHjoE1SwVs0vRV4.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0ly_v86mHHjoE1SwVs0vRV4)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0ly_v86mHHjoE1SwVs0vRV4"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0ly_v86mHHjoE1SwVs0vRV4.svg" alt="Watch time: 19h 58m · 135 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/PLrRPvpgDmw0ly_v86mHHjoE1SwVs0vRV4 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.