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 FREE CHAPTER

2. Introduction to Financial Modeling and Excel

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 2: The Use of Excel - Features and Functions for Financial Modeling

In this section, you will learn about the various tools and features of Excel that are regularly used in financial modeling. These will be explained in detail to allow you to start using them confidently.

This section comprises the following chapters:

Chapter 3, Formulas and Functions – Completing Modeling Tasks with a Single Formula
Chapter 4, Applying the Referencing Framework in Excel

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 $19.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