March 2015
Intermediate to advanced
232 pages
7h 27m
English
book
Financial Forecasting, Analysis and Modelling: A Framework for Long-Term Forecasting
by Michael Samonas
Content preview from Financial Forecasting, Analysis and Modelling: A Framework for Long-Term Forecasting
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,
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 1
Introduction
Chapter 1 answers some simple questions about financial modelling, such as: What is it? Who does it? What are the steps in building a financial model? But above all, why is financial modelling the single most important skill-set for the aspiring finance professional?
The framework for the development of a spreadsheet-based financial model is illustrated by using a simple concrete example. A spreadsheet is used in order to calculate the funding needs of a 2/10 net 30 credit policy on a certain turnover. The inputs and the output of the model are defined. Building this model is relatively straightforward. The model-builder needs to input estimates for certain items (i.e. turnover) and then make sure that the mathematical formulae are correct. From this simple base, the steps of the financial modelling process are described in order to build sophisticated and interconnected models for the income statement, balance sheet, and cash-flow statement, as well as “good/bad/base” scenarios that can be changed with a simple click or two. This ability of spreadsheets to deal with a lot of numbers, work with them, and produce answers is stressed, as well as the use of Excel as the ideal tool for financial modelling.
1.1 WHAT IS FINANCIAL MODELLING?
If you Google the term “financial model” you will get approximately 350 million hits. Yes, that's right. Financial modelling has become the single most important skill-set for the aspiring finance professional. But what exactly ...
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.