Save 40% on Coursera Plus Annual
Excel Finance - Cash Flow Analysis, Stocks, Bonds and Model Building

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

ExcelIsFun via YouTube Direct link

Dynamic Spilled Array Formulas for Future Value Cash Flow SIP Step Up. Excel Magic Trick 1699.

114 of 114
Previous

114 of 114

Dynamic Spilled Array Formulas for Future Value Cash Flow SIP Step Up. Excel Magic Trick 1699.

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

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

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.