How to Download The ABCs of DCF Valuation & Modeling ~ Simplified: (Live and Practice Model included) MOBI
Who is this book for?This book, ABC of DCF Modeling is for anyone interested in understanding and using the discounted cash-flow valuation method to value assets. Although primarily written for MBA and undergraduate business students, anyone interested in understanding discounted cash-flow valuation will find this book useful. This book is an introductory level book. As the title indicates with the word ‘ABC’, this book is meant for beginners trying to understand and build a DCF valuation model in Microsoft Excel or a Google Spreadsheet. This book assumes that the reader is familiar with basic accounting and finance concepts. For example, the reader is expected to know the structure of an income statement, the meaning of the term working capital, etc. We will cover some of these concepts only briefly as the focus is on the DCF valuation model. The reader is NOT expected to be an expert in Microsoft Excel or Google sheets but must be reasonably familiar with these tools. This book will teach you how to build a simple DCF model. Once you can confidently build a simple DCF model, you can add many bells and whistles to make your model more detailed. Our focus is on helping you understand the foundations of building a good DCF model well.ABC of DCF Modeling is based on Senith Mathews’ experience tutoring students and executives in DCF modeling over 10 years and building models as a management consultant with Arthur Andersen and Mercer Management Consulting (now Oliver Wyman). ABC of DCF Modeling narrowly focusses on teaching readers how to build a basic DCF model in a spreadsheet. It does not go in-depth into the underlying finance and accounting concepts or rules. How to use this bookABC of DCF Modeling is built on our modeling boot camp experience and so it is best you adopt a hands-on boot camp attitude as you read this book. This will help you maximize your learning from this book. You should be confident of building a basic DCF model on your own in an hour after working through this book. You should read this book at least twice to really understand how to build a basic DCF model. Your first read is meant to give you a quick overview of the entire process. You should follow the model spreadsheet as you progress through the book. Read each section one by one. Once you have read a section, review the corresponding region in the Microsoft Excel model. Change the relevant input assumptions to see how that section changes. Dig into each cell of the Microsoft Excel model row by row so you understand the formula and relationships section by section.Your second read is when you should open the blank workbook and build the exact DCF valuation model yourself. We recommend that you re-read the book from the beginning. As you re-read each section re-create that section in a blank workbook. Begin by setting up the same input assumptions and build the projected financial statement section by section. Check each section of your model and proceed to the next section only after you are sure it reflects the sample model. Your final model should reflect the sample model when you are done. Change the relevant input assumptions in your model to check that the model returns reflect the changes throughout the entire model. Building a DCF valuation model from scratch should give you the confidence to build a DCF valuation model on your own. Now you are ready to value a business or company using the DCF valuation method. Don’t stop there. Practice as much as you can on real companies. We recommend you work on these valuation exercises with a friend or a tutor so that you get instant feedback so you get good timely feedback which speeds up your learning.Enjoy financial modeling!
