Excel Forum



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.