eduzhai > Applied Sciences > Engineering >

Sensitivity and Simulation Analysis in Excel Without Programming

  • Save

... pages left unread,continue reading

Document pages: 11 pages

Abstract: Most finance textbooks talk about the benefits of conducting sensitivity and or Monte Carlo simulation analyses in financial modeling, but mostly limit coverage to commenting on these techniques in passing. This is particularly true when it comes to simulation analysis, which typically requires the use of a third-party add-in or a significant level of programming expertise in VBA. We provide an extensive, step-by-step guide demonstrating how data tables in Excel can be used to easily implement sensitivity and simulation analyses. This approach requires only minor modifications to the base-case model; without the need for any programming experience.

Please select stars to rate!

         

0 comments Sign in to leave a comment.

    Data loading, please wait...
×