Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Hands-On Financial Modeling with Microsoft Excel 2019 Build practical models for forecasting, valuation, trading, and growth analysis using Excel 2019

Product type Paperback

Published in Jul 2019

Publisher Packt

ISBN-13 9781789534627

Length 292 pages

Edition 1st Edition

Tools

Excel

Concepts

Financial Technology

Author (1):

Shmuel Oluwa

View More author details

Table of Contents (15) Chapters

Preface

1. Section 1: Financial Modeling - Overview

2. Introduction to Financial Modeling and Excel FREE CHAPTER

3. Steps for Building a Financial Model

4. Section 2: The Use of Excel - Features and Functions for Financial Modeling

5. Formulas and Functions - Completing Modeling Tasks with a Single Formula

6. Applying the Referencing Framework in Excel

7. Section 3: Building an Integrated Financial Model

8. Understanding Project and Building Assumptions

9. Asset and Debt Schedules

10. Cash Flow Statement

11. Valuation

12. Ratio Analysis

13. Model Testing for Reasonableness and Accuracy

14. Another Book You May Enjoy

Leave a review - let other readers know what you think

Section 3: Building an Integrated Financial Model

A financial model is integrated when the various sections that define it are linked together in such a way that any alteration will ripple right through the model and update all the relevant values. This section will take you through the stages to follow when you're building your model in a systematic fashion.

This section comprises the following chapters:

Chapter 5, Understanding Project and Building Assumptions
Chapter 6, Asset and Debt Schedules
Chapter 7, Cash Flow Statement
Chapter 8, Ratio Analysis
Chapter 9, Valuation
Chapter 10, Model Testing for Reasonableness and Accuracy

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (1)

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.

See other products by Shmuel Oluwa