Hi,
I am working on a project that entails finding the $ value of making an
investment, but it is not a straightforward question of forecasting out and
finding the net present value. Instead, the forecast has to asume 2 diverse
scenarios which may or may not occur (let me call them A and B). Then I have
to calculate revenues and profits for both scenarios, and find an average
value to recommend to my manager.
My general questions are (Just an addition: I am pretty well versed with all
basic excel functionalities, reasonable comfortable with solver and data
tables, and use
including financial tools such as IRR, NPV etc)
1. What excel functionalities (other than the basic ones I have mentioned)
would you use to go about this project? I am also looking for bells and
whistles which will help me impress my manager! (Nb: I am not into
programming)
2. Would you incorporate probabilities into the exercise? (e.g.g probability
of event A happening) and, if so, how?
3. Any other suggestion is welcome!
I will be happy to be given links, free downloads/add ons, general
suggestions etc that point me in the right direction. I understand that
detailed replies will be time consuming for you.
Thanks!
Manish
Bookmarks