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 88: Scenario Analysis For Cash Flow & NPV Calculations


Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to spread the numbers with scenario analysis so we have a pessimistic and optimistic range of values. We can use 10% and adjust our cost and revenue numbers accordingly. Optimistic: sales and units up and costs down. Pessimistic: sales and units down and costs up. See Excel's Scenario Manager also.





Got a Question? Ask it Here in the Forum.