Financial Modeling in Excel For Dummies, 2nd Edition

Chapter 9

Charting and Presenting Model Output

IN THIS CHAPTER

Deciding on the key message to convey

Using Excel’s charting tools

Making charts interactive and dynamic

Presenting your financial model to an audience

The final stage of the model-building process is to present the outcome of the model. You’ve spent a lot of time on the calculations, making sure that the inputs and assumptions are correct and that all your scenarios are lined up ready for the decision makers to use. If you don’t present the outputs of the model clearly, however, the users won’t be able to understand what the model is showing, so they might not use it or, even worse, they might use it and misinterpret what the model is saying.

A well-designed report or presentation is the best way to display the model results clearly and concisely and get its message across. The output and presentation of the results are just as important as the rest of the model-building process. There’s no point in having a beautifully designed, fantastically built model that none of the decision makers know (or care) about!

In this ...