Model Like a Boss: An Excel Tutorial for Financial Modeling

Author(s): Julie Suh

Edition: 1

Copyright: 2017

Pages: 218

Choose Your Format

Ebook

$46.20

ISBN 9781524934545

Details Electronic Delivery EBOOK 180 days

Do you dream of becoming an investment banker or financial analyst one day? Is your lack of MS Excel skills holding you back in your career?

 

Model Like a Boss is an easy-to-follow textbook that will take you from 0 to 60 in no time. Designed as a self-study guide, this book will teach you step-by-step how to build a simplified discounted cash flow model. While building this model, you will be learning how to structure a flexibile and dynamic financial model (versus a static spreadsheet), while learning specific MS Excel functions, formulas, and tools. Model Like a Boss is packed with tips on keyboard shortcuts and exercises that will deepen your understanding of financial modeling, giving you the competitive advantage to take your career to the next level.

About the Author

Acknowledgments

Introduction

PART 1: BACKGROUND AND SETUP

Chapter 1: What Is a DCF?

Chapter 2: Blueprinting Your Model

PART 2: BUILDING THE MODEL

Chapter 3: Step 1: Build a README Tab

Chapter 4: Step 2: Build the Assumptions Tab

Chapter 5: Step 3: Build the Historical Performance Tab

Chapter 6: Step 4: Build the Analysis Tab

PART 3: BELLS, WHISTLES, AND GOAL SEEK

Chapter 7: Adding Dynamic Flair to Your Model

Chapter 8: Playtime with Your Model

CONCLUSION

Julie Suh

Do you dream of becoming an investment banker or financial analyst one day? Is your lack of MS Excel skills holding you back in your career?

 

Model Like a Boss is an easy-to-follow textbook that will take you from 0 to 60 in no time. Designed as a self-study guide, this book will teach you step-by-step how to build a simplified discounted cash flow model. While building this model, you will be learning how to structure a flexibile and dynamic financial model (versus a static spreadsheet), while learning specific MS Excel functions, formulas, and tools. Model Like a Boss is packed with tips on keyboard shortcuts and exercises that will deepen your understanding of financial modeling, giving you the competitive advantage to take your career to the next level.

About the Author

Acknowledgments

Introduction

PART 1: BACKGROUND AND SETUP

Chapter 1: What Is a DCF?

Chapter 2: Blueprinting Your Model

PART 2: BUILDING THE MODEL

Chapter 3: Step 1: Build a README Tab

Chapter 4: Step 2: Build the Assumptions Tab

Chapter 5: Step 3: Build the Historical Performance Tab

Chapter 6: Step 4: Build the Analysis Tab

PART 3: BELLS, WHISTLES, AND GOAL SEEK

Chapter 7: Adding Dynamic Flair to Your Model

Chapter 8: Playtime with Your Model

CONCLUSION

Julie Suh