July 2012
Beginner
320 pages
9h 29m
English
book
Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, + Website
by Danielle Stein Fairhurst
Content preview from Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, + WebsiteBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
CHAPTER 12
Presenting Model Output
Once a model has been built, it’s important to display results clearly and concisely to get your message across, whether via a written report or oral presentation.
PREPARING AN ORAL PRESENTATION FOR MODEL RESULTS
As the person who knows the model best, financial modellers are often requested to communicate the results of the financial model as a formal presentation to the board or senior management. Understandably, many detail-orientated analysts often find that it is quite a challenge to distill their 20-megabyte financial model that has taken weeks to build into a 10-minute presentation.
Although most senior management may not be interested in seeing the model itself, they might like to see live and changing scenarios. If the model is built correctly, you’ll be able make a single change to the input assumptions and the audience will be able to see the effects of these changing scenarios in real time. Make sure that you test all possible inputs in advance—nothing looks less professional than a #REF! error during a live sensitivity analysis.
Not all presentations require you to use PowerPoint, but in this kind of environment, where it is necessary to convey lots of information, having the summary tables or charts on a slide behind you while you are speaking will be helpful. It can also help to take the focus off you if you are a little nervous.
Follow these basic rules of presentations:
- Only display one key message per slide. Don’t crowd it or ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.