• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sensitivity Analysis

S

saadferoze

New Member
My boss has told me to run the sensitivity analysis to see the range of traiff rate at which we maintain the current margins. How is it possible to show the changing tariff rate without changing the current margins. Its a 30 year project and being conservative we have one tariff rate and we have not applied indexing but in cost per unit we have applied inflation but cost remains uchanged.


Please guide


regards

Saad
 
Saad

I think the Excel Data Table function is your friend here

Have a look at: http://chandoo.org/wp/2010/05/06/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/
 
Yea if you can master the link Hui mentioned your golden. But it will take some time to understand and think about, as well as set up.


Data tables will do just fine for your sensitivity analysis. Monte Carlo is probably not needed, as this may be overkill.
 
You must log in or register to reply here.
Back
Top