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 4
Forecasting Performance
Chapter 4 deals with the mechanics of forecasting and specifically the methods behind the development of an integrated set of financial forecasts that reflect the company's expected performance.
Firstly, a dashboard-like control panel is designed with the proper financial indicators that need to be monitored according to the specific problem the model is required to solve. For example, in order to deal with liquidity issues one needs to focus on working capital parameters. Secondly, the basic statistical methods used to forecast sales are examined. Almost all financial statement models are sales driven, in that they assume that many of the balance sheet and income statement items are directly or indirectly related to sales. So forecasting sales is one of the greatest challenges for the business modeller. Regression analysis (a statistical method that enables one to fit a straight line that on average represents the best possible graphical relationship between sales and time) is used in order to extrapolate future sales based on the past sales trend. Moreover regression analysis is used to look at the relationship between any 2 measures, say, sales and CAPital EXpenditures (CAPEX), sales and costs, and so on. These relationships can be the best possible proxies for many P&L and balance sheet figures when combined with sales, especially in the absence of any analytical working about these figures.
4.1 INTRODUCTION: DESIGNING A DASHBOARD-LIKE CONTROL ...
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.