Reader small image

You're reading from  Hands-On Financial Modeling with Microsoft Excel 2019

Product typeBook
Published inJul 2019
PublisherPackt
ISBN-139781789534627
Edition1st Edition
Tools
Right arrow
Author (1)
Shmuel Oluwa
Shmuel Oluwa
author image
Shmuel Oluwa

Shmuel Oluwa is a financial executive and seasoned instructor, of over 25 years, in a number of finance related fields, with a passion for imparting knowledge. He has developed considerable skill in the use of Microsoft Excel and has organised training courses in Business Excel, Financial Modeling with Excel, Forensics and Fraud Detection with Excel, Excel as an Investigative Tool, Accounting for Non-Accountants, Credit Analysis with Excel amongst others. He has given classes in Nigeria, Angola, Kenya and Tanzania but his online community of students covers several continents. Shmuel divides his time between London and Lagos with his pharmacist wife. He is fluent in 3 languages. English, Yoruba and Hebrew.
Read more about Shmuel Oluwa

Right arrow

Building assumptions

Financial modeling is all about projecting results or behavior into the future.

To do this, you will need to build up a set of assumptions to bridge the gap between actual performance and future results. Although you will need to project every single item in the model, your assumptions will focus on items that will have a material effect on the final results. Other non-material items can be projected as, say, percentage of turnover (for revenue items) or a best judgement figure (for balance sheet items).

Your assumptions will need to consider whether items will increase, decrease, or stay the same. How you calculate the projected change is referred to as the growth driver. For example, for revenue items, it could be inflation, year-on-year growth, or some other indicator.

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Hands-On Financial Modeling with Microsoft Excel 2019
Published in: Jul 2019Publisher: PacktISBN-13: 9781789534627

Author (1)

author image
Shmuel Oluwa

Shmuel Oluwa is a financial executive and seasoned instructor, of over 25 years, in a number of finance related fields, with a passion for imparting knowledge. He has developed considerable skill in the use of Microsoft Excel and has organised training courses in Business Excel, Financial Modeling with Excel, Forensics and Fraud Detection with Excel, Excel as an Investigative Tool, Accounting for Non-Accountants, Credit Analysis with Excel amongst others. He has given classes in Nigeria, Angola, Kenya and Tanzania but his online community of students covers several continents. Shmuel divides his time between London and Lagos with his pharmacist wife. He is fluent in 3 languages. English, Yoruba and Hebrew.
Read more about Shmuel Oluwa