dfa07
05-25-2021, 01:24 PM
Dear all,
Glad to join this forum. Very helpful and useful tool, especially for someone like me who is new to VBA.
I would like to get some clarity on how to create a "Sensitivity Analysis" button that can run and calculate multiple outcomes (IRR for example), derived from a financial feasibility, by changing the revenue (+ or - 5%, 10% and 15%) and the total cost (+ or - 5%, 10% and 15%).
Appreciate if anyone can guide me on how to initiate this exercise.
Thanks
Glad to join this forum. Very helpful and useful tool, especially for someone like me who is new to VBA.
I would like to get some clarity on how to create a "Sensitivity Analysis" button that can run and calculate multiple outcomes (IRR for example), derived from a financial feasibility, by changing the revenue (+ or - 5%, 10% and 15%) and the total cost (+ or - 5%, 10% and 15%).
Appreciate if anyone can guide me on how to initiate this exercise.
Thanks