E
ExcelMania
Folks,
How can I model multiple scenarios in Excel elegantly? I have a model
that runs over several worksheets and calculates say 12 different costs, over
12 different time periods (Quarterly for 3 years) and over 6 geographies. Now
I am trying to do some ROI analysis for investments such that say 3 different
costs are affected for the geographies and time periods.. This is ADhoc,
since a different investment can change some other costs? Is there an elegant
way to model this in excel?
Excel offers scenario planning but I feel this requirement might me a lot
more than what scenario planning can offer..OR may be I am wrong, if you have
done this using scenario planning
Pl help!!
How can I model multiple scenarios in Excel elegantly? I have a model
that runs over several worksheets and calculates say 12 different costs, over
12 different time periods (Quarterly for 3 years) and over 6 geographies. Now
I am trying to do some ROI analysis for investments such that say 3 different
costs are affected for the geographies and time periods.. This is ADhoc,
since a different investment can change some other costs? Is there an elegant
way to model this in excel?
Excel offers scenario planning but I feel this requirement might me a lot
more than what scenario planning can offer..OR may be I am wrong, if you have
done this using scenario planning
Pl help!!