Excel Finance Class 83: Estimating Cash Flows For NPV calculation
Loading...
Loading...
3,643
Loading...
Link to this comment:
Share to:
Uploader Comments (ExcelIsFun)
see all
All Comments (8)
-
Add back Depr, but the Interest and Dividend cash flows are not considered cash Flow From/To Assets. They are considered as a Cash Flow From/To Creditors and Stockholders. Usually, interest is not considered part of OCF for Cash Flow NPV calculation.
Please see the remaining videos for this chapter #83 to #89 for more details...
-
what would one do if there was Interest when calculating the Annual Projected OCF? Do we add back the Depreciation AND Interest minus Tax or something else?
Loading...
- 17:06
Excel Finance Class 82: Relevant Costs For Discounted Cash Flow Analysis = Incremental Cash Flowsby ExcelIsFun2,348 views
- 7:10
Excel Finance Class 84: Undoing Accrual Accounting to Discover Cash Flows For Estimating NPVby ExcelIsFun1,020 views
- 10:37
Excel Finance Class 85: MACRS Depreciation & Asset Sale Impacts on NPV Cash Flowsby ExcelIsFun2,259 views
- 22:11
Excel Finance Class 86: Estimating Cash Flows For NPV calculation Comprehensive Example.by ExcelIsFun1,824 views
- 3:58
Sensitive Analysis on Excelby ezselflearning5,429 views
- 1:59
Calculating NPV using Excelby ProfCoram3,025 views
- 10:54
Excel Finance Class 89: Sensitivity Analysis For Cash Flow & NPV Calculationsby ExcelIsFun8,785 views
- 9:17
Excel Finance Class 110: Security Market Line (SML) & Capital Asset Pricing Model (CAPM)by ExcelIsFun4,776 views
- 9:17
How to do a simple cashflow forecast - http://www.growyourtherapybusiness.comby gillwarren1322,897 views
- 1:54
Internal Rate of Returnby AuditExcel19,175 views
- 5:16
Toolkit: Discounted cash flowby bionicturtledotcom7,561 views
- 1:46
Discounted Payback Period (Preview) - Payback Periodby MBAbullshitDotCom10,461 views
- 5:20
Discounted Payback.aviby 1021kimberlygaither4,083 views
- 10:48
Excel Finance Class 105: Expected Return & Standard Deviation For Portfolio -- Estimating Futureby ExcelIsFun5,266 views
- 12:40
Excel Finance Class 81: XNPV Function XIRR Function - See Algorithm That XNPV usesby ExcelIsFun2,059 views
- 3:29
Excel Finance Trick 14: NPV function Capital Invest Decisionby ExcelIsFun10,120 views
- 1:55
how to calculate project npv (net present value)by TheTrojanTrainingTV3,386 views
- 0:52
How to use the IRR function in Excel 2010by LearnMeSomething331,010 views
- 2:21
Pro-Forma Financials (Ben Blau)by UtahStateCES485 views
- 11:43
Excel Finance Class 104: Expected Return & Standard Deviation For 1 Stock -- Estimating Futureby ExcelIsFun3,527 views
thanks for sharing
hanajierong 8 months ago
You are welcome!
ExcelIsFun 8 months ago
Thank you so much! I stumbled on your videos a few days ago and they are helping me tremendously with corporate finance and Excel!
One question: how would you handle inflation in this example? I will search through your other videos to see if I can find the answer. You teach so clearly! That's the only question I have. Thanks again!
ChauEmi 11 months ago
An inflation premium is part of the discount rate.
ExcelIsFun 11 months ago
Thanks :) im having a couple issues with my coursework at the moment but your videos are helping me out alot!
PassionateVipez 1 year ago
You are welcome! I am glad to help!
ExcelIsFun 1 year ago