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