Excel Forum
Similar Content
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...
PMT Function - Get the Payment Due for a Loan in Excel
Tutorial: How to calculate the payment amount for a loan or similar financial instrument that has a ...



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.