Excel Forum
Similar Content
Excel Macro Class 3 - Looping through Ranges & Working with Cells
Tutorial: Excel Macro Class 3 - How to loop through ranges of data and work with the cells in those...
PV Function - Get the Present Value in Excel
Tutorial: The Present Value (PV) function in Excel will return the current value of an investment.Â...
NPER Function - Calculate Number of Periods Needed for a Set of Payments in Excel
Tutorial: How to calculate the number of periods required for an investment in order to get the desi...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Finance Class 83: Estimating Cash Flows For NPV calculation


Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn the basics of how to estimate future cash flows for an investment in order to calculate Net Present Value, Internal Rate Of Return and Payback. See how to calculate an pro forma income statement, estimate depreciation, estimate Operating Cash Flows, Capital Spending and how to use the NPV and IRR functions as well as a Payback calculation.





Got a Question? Ask it Here in the Forum.