Financial Modeling Books
The Procrastinator's Guide to Financial Modeling
Here comes another earnings season. Have you updated your forecast for your favorite companies? Of course not. Who has time to build a model for every company they follow? Whether you are a student, analyst, or investor, the story is typically the same. You set out with good intentions to do your “homework,” but life gets in the way. Fear not, your solution has arrived: The Procrastinator’s Guide to Financial Modeling. In this new book series, I perform the tedious parts of the model building process, freeing you up to focus on the creative aspects: developing your thesis and producing a unique forecast.
This first edition to the series will cover Starbucks Corp (NASDAQ:SBUX). What an exciting time to model Starbucks’ financials. Having announced a long-term reinvention plan, the company is expecting double-digit earnings growth along with significant global store expansion. This story has something for everyone. Whether you are following macroeconomic developments and the impact of rising inflation and interest rates. Political stories around share repurchase programs or the unionization of employees. The lingering impacts of the COVID recovery with changing restrictions in China. There are many opportunities for you to develop and express your unique opinions within the Starbucks model.
Here comes another earnings season. Have you updated your forecast for your favorite companies? Of course not. Who has time to build a model for every company they follow? Whether you are a student, analyst, or investor, the story is typically the same. You set out with good intentions to do your “homework,” but life gets in the way. Fear not, your solution has arrived: The Procrastinator’s Guide to Financial Modeling. In this new book series, I perform the tedious parts of the model building process, freeing you up to focus on the creative aspects: developing your thesis and producing a unique forecast.
This first edition to the series will cover Starbucks Corp (NASDAQ:SBUX). What an exciting time to model Starbucks’ financials. Having announced a long-term reinvention plan, the company is expecting double-digit earnings growth along with significant global store expansion. This story has something for everyone. Whether you are following macroeconomic developments and the impact of rising inflation and interest rates. Political stories around share repurchase programs or the unionization of employees. The lingering impacts of the COVID recovery with changing restrictions in China. There are many opportunities for you to develop and express your unique opinions within the Starbucks model.
Financial Modeling for Equity Research
This book demonstrates step-by-step how to create a financial model, similar to the models maintained by Wall Street equity research analysts. The accompanying spreadsheets demonstrate the key concepts and can be used as templates to create an earnings model for nearly any company. Readers without prior financial analysis experience will gain a fundamental understanding of exactly what modeling entails and will learn how to create a basic form of an earnings model. Advanced readers will be introduced to more complex topics such as linking the financial statements, future period calibration, and incorporating macroeconomic variables into discounted valuation analysis through the equity risk premium and application of the capital asset pricing model.
NOTE: This book was published in 2019 using FedEx Corp as a subject company. Market circumstances have changed significantly since the book was published, and FedEx has reported years of updated financial statements. Despite this fact, the book remains relevant as an example of the financial modeling process.
This book demonstrates step-by-step how to create a financial model, similar to the models maintained by Wall Street equity research analysts. The accompanying spreadsheets demonstrate the key concepts and can be used as templates to create an earnings model for nearly any company. Readers without prior financial analysis experience will gain a fundamental understanding of exactly what modeling entails and will learn how to create a basic form of an earnings model. Advanced readers will be introduced to more complex topics such as linking the financial statements, future period calibration, and incorporating macroeconomic variables into discounted valuation analysis through the equity risk premium and application of the capital asset pricing model.
NOTE: This book was published in 2019 using FedEx Corp as a subject company. Market circumstances have changed significantly since the book was published, and FedEx has reported years of updated financial statements. Despite this fact, the book remains relevant as an example of the financial modeling process.