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.Â...
RATE Function - Calculate an Interest Rate in Excel
Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...
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 89: Sensitivity Analysis For Cash Flow & NPV Calculations


Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to do Sensitivity Analysis and adjust a single variable for a NPV calculation. See the NPV and SLOPE function and TRANSPOSE array Functions and how to create a X Y Scatter chart.





Got a Question? Ask it Here in the Forum.