You're reading from Hands-On Financial Modeling with Excel for Microsoft 365 - Second Edition

Product type Book

Published in Jun 2022

Publisher Packt

ISBN-13 9781803231143

Pages 346 pages

Edition 2nd Edition

Languages

Concepts

Financial Technology

Author (1):

Shmuel Oluwa

Table of Contents (19) Chapters

Preface

1. Part 1 – Financial Modeling Overview

2. Chapter 1: An Introduction to Financial Modeling and Excel

3. Chapter 2: Steps for Building a Financial Model

4. Part 2 – The Use of Excel Features and Functions for Financial Modeling

5. Chapter 3: Formulas and Functions – Completing Modeling Tasks with a Single Formula

6. Chapter 4: Referencing Framework in Excel

7. Chapter 5: An Introduction to Power Query

8. Part 3 – Building an Integrated 3-Statement Financial Model with Valuation by DCF

9. Chapter 6: Understanding Project and Building Assumptions

10. Chapter 7: Asset and Debt Schedules

11. Chapter 8: Preparing a Cash Flow Statement

12. Chapter 9: Ratio Analysis

13. Chapter 10: Valuation

14. Chapter 11: Model Testing for Reasonableness and Accuracy

15. Part 4 – Case Study

16. Chapter 12: Case Study 1 – Building a Model to Extract a Balance Sheet and Profit and Loss from a Trial Balance

17. Chapter 13: Case Study 2 – Creating a Model for Capital Budgeting

18. Other Books You May Enjoy

Discussions with management

This is where you determine or confirm the scope and target of your model. Management is also the primary source of information about future plans and trends.

Usually, it's not possible to get all of the details at the first time of asking. You should, therefore, be prepared to go back to the section heads and ask the same, or similar, questions from a position of better understanding.

The following paragraphs describe the steps to take to ensure that you get the most out of your discussions with management, as well as where to concentrate your attention.

Gauging management expectations

While discussing with management, you need to get a clear understanding of their expectations from the assignment and what they hope will be achieved.

If all that is required is a projected cash flow, then a full-blown valuation model would be a waste of time and resources, and you probably wouldn't get paid for the extra work. We will take a detailed...