Home
DataHands-On Financial Modeling with Microsoft Excel 2019
By Shmuel Oluwa
Book
eBook$26.99$17.99
Print$38.99
Subscription$15.99$10 p/m for three months
BUY NOW
$10 p/m for first 3 months. $15.99 p/m after that. Cancel Anytime!
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook + Subscription?
Download this book in EPUB and PDF formats, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Access this title in our online reader
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with video?
Stream this video
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
What do you get with Exam Trainer?
Flashcards, Mock exams, Exam Tips, Practice Questions
Access these resources with our interactive certification platform
Mobile compatible-Practice whenever, wherever, however you want
BUY NOW$10 p/m for first 3 months. $15.99 p/m after that. Cancel Anytime!
eBook$26.99$17.99
Print$38.99
Subscription$15.99$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook + Subscription?
Download this book in EPUB and PDF formats, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Access this title in our online reader
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with video?
Stream this video
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
What do you get with Exam Trainer?
Flashcards, Mock exams, Exam Tips, Practice Questions
Access these resources with our interactive certification platform
Mobile compatible-Practice whenever, wherever, however you want
- Free ChapterSection 1: Financial Modeling - Overview
- Section 1: Financial Modeling - Overview
- Introduction to Financial Modeling and Excel
- Introduction to Financial Modeling and Excel
- The main ingredients of a financial model
- Understanding mathematical models
- Definitions of financial models
- Types of financial models
- Alternative tools for financial modeling
- Excel – the ideal tool
- Summary
- Steps for Building a Financial Model
- Steps for Building a Financial Model
- Discussions with management
- Building assumptions
- Building a template for your model
- Historical financial data
- Projecting the balance sheet and profit and loss account
- Additional schedules and projections
- Cash flow statement
- Preparing ratio analysis
- Valuation
- Summary
- Section 2: The Use of Excel - Features and Functions for Financial Modeling
- Section 2: The Use of Excel - Features and Functions for Financial Modeling
- Formulas and Functions - Completing Modeling Tasks with a Single Formula
- Formulas and Functions - Completing Modeling Tasks with a Single Formula
- Understanding functions and formulas
- Working with lookup functions
- Utility functions
- Pivot tables and charts
- Pitfalls to avoid
- Summary
- Applying the Referencing Framework in Excel
- Applying the Referencing Framework in Excel
- Introduction to the framework
- Relative referencing
- Absolute referencing
- Mixed referencing
- Implementing the referencing framework
- Summary
- Section 3: Building an Integrated Financial Model
- Section 3: Building an Integrated Financial Model
- Understanding Project and Building Assumptions
- Understanding Project and Building Assumptions
- Understanding the nature and purpose of a project
- Conducting interviews
- Building assumptions
- Summary
- Asset and Debt Schedules
- Asset and Debt Schedules
- Understanding the BASE and corkscrew concepts
- Asset schedule
- Approaches to modeling assets
- Debt schedule
- Creating a loan amortization schedule
- Summary
- Cash Flow Statement
- Cash Flow Statement
- Introduction to the cash flow statement
- Items not involving the movement of cash
- Net change in working capital
- Balancing the balance sheet
- Creating a quick cash flow statement
- Summary
- Valuation
- Valuation
- Absolute valuation
- Relative valuation – comparative company analysis
- Summary
- Ratio Analysis
- Ratio Analysis
- Understanding the meaning and benefits of ratio analysis
- Learning about the various kinds of ratios
- Interpreting ratios
- Understanding the limitations of ratio analysis
- Using ratios to find financially stable companies
- Summary
- Model Testing for Reasonableness and Accuracy
- Model Testing for Reasonableness and Accuracy
- Incorporating built-in tests and procedures
- Troubleshooting
- Understanding sensitivity analysis
- Using direct and indirect methods
- Understanding scenario analysis
- Creating a simple Monte Carlo simulation model
- Summary
- Another Book You May Enjoy
- Another Book You May Enjoy
- Leave a review - let other readers know what you think
About thisbook
Financial modeling is a core skill required by anyone who wants to build a career in finance. Hands-On Financial Modeling with Microsoft Excel 2019 explores terminologies of financial modeling with the help of Excel.This book will provides you with an overview of the steps you should follow to build an integrated financial model. You will explore the design principles, functions, and techniques of building models in a practical manner. Starting with the key concepts of Excel, such as formulas and functions, you will learn about referencing frameworks and other advanced components for building financial models. Later chapters will help you understand your financial projects, build assumptions, and analyze historical data to develop data-driven models and functional growth drivers. The book takes an intuitive approach to model testing and covers best practices and practical use cases.By the end of this book, you will have examined the data from various use cases, and have the skills you need to build financial models to extract the information required to make informed business decisions.
- Publication date:
- July 2019
- Publisher
- Packt
- Pages
- 292
- ISBN
- 9781789534627
Download code from GitHubIn this section, you will understand the meaning of financial modeling with Excel, including an overview of the broad steps to follow in building an integrated financial model.
This section comprises the following chapters:
- Chapter 1, Introduction to Financial Modeling and Excel
- Chapter 2, Steps for Building a Financial Model
Read more
About the Author
- 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.
Browse publications by this author
Latest Reviews(2 reviews total)
goede kwaliteit van cursus
4
09 September 2019Trusted Customer
Good, but it could be better if step by step expain.
4
30 August 2019chenhau fang
