Gutenberg Research
  • Home
  • Education
    • Books >
      • Procrastinator's Guide - SBUX
      • Book Registration - Third Edition
      • Book Registration - Second Edition >
        • Book Registration
  • About
    • Contact
    • Email Distribution Sign-up
    • Terms of Use
    • Privacy Policy

Financial Modeling For Equity Research - Third Edition
Template Download Page


From the author: "Hello reader. Just wanted to take a moment to thank you for purchasing my book, and welcome you to the Gutenberg community! All of the files used in the textbook are included on this page. If you have any questions feel free to reach out to me directly anytime."
​ 
John Moschella
[email protected]
linkedin.com/in/john-moschella

Chapter 2: Building the Income Statement 

File 1-Blank Model.xlsx
File Size: 99 kb
File Type: xlsx
Download File

File 2-Historic Income Statement (Step 3).xlsx
File Size: 141 kb
File Type: xlsx
Download File

File 3-Segment Details (Step 4).xlsx
File Size: 180 kb
File Type: xlsx
Download File

File 4-Income Statement Forecast Equations (Through Step_6).xlsx
File Size: 215 kb
File Type: xlsx
Download File

File 19 - Textbook Concept Quiz Questions
File Size: 48 kb
File Type: xlsx
Download File


Chapter 3: Balance Sheet and Cash Flow Modeling

File 5-Historic Balance Sheet and Cash Flow (Step 7).xlsx
File Size: 232 kb
File Type: xlsx
Download File

File 6-Balance Sheet Forecast Equations (Through Step 10).xlsx
File Size: 248 kb
File Type: xlsx
Download File

File 7-Cash Flow Forecast Equations (Step 12).xlsx
File Size: 266 kb
File Type: xlsx
Download File

File 19-Class Wrap-Ups.xlsx
File Size: 46 kb
File Type: xlsx
Download File


Chapter 4: Model Calibration & Forecasting

File 8-Forecast (Steps 13 through 18).xlsx
File Size: 284 kb
File Type: xlsx
Download File

File 19-Class Wrap-Ups.xlsx
File Size: 46 kb
File Type: xlsx
Download File


Chapter 5: The DCF Inputs (Beta, ERP, CAPM & WACC)

File 16-Equity Risk Premium Model (Step 19).xlsx
File Size: 1704 kb
File Type: xlsx
Download File

File 19-Class Wrap-Ups.xlsx
File Size: 46 kb
File Type: xlsx
Download File

File 17-FDX Beta Calculation (Step 20).xlsx
File Size: 290 kb
File Type: xlsx
Download File


Chapter 6: Discounted Cash Flow Valuation

File 9-Valuation (Steps 21 through 30).xlsx
File Size: 284 kb
File Type: xlsx
Download File

File 19-Class Wrap-Ups.xlsx
File Size: 46 kb
File Type: xlsx
Download File


Chapter 7: Market Multiple-Based Valuation

File 9-Valuation (Steps 21 through 30).xlsx
File Size: 284 kb
File Type: xlsx
Download File

File 19-Class Wrap-Ups.xlsx
File Size: 46 kb
File Type: xlsx
Download File

File 22-FedEx Model (Appendix 2-Step 1 F2Q2019 Preview).xlsx
File Size: 429 kb
File Type: xlsx
Download File


Chapter 8: How to Use Your Earnings Model

File 10-Sensitivity (Step 32).xlsx
File Size: 284 kb
File Type: xlsx
Download File

File 11-Release Prep (Steps 33 and 34).xlsx
File Size: 299 kb
File Type: xlsx
Download File

File 12-F1Q2019 Actuals (Step 35a).xlsx
File Size: 299 kb
File Type: xlsx
Download File

File 13-Pension Recast & Updated Forecast (Steps 35c & 35d).xlsx
File Size: 303 kb
File Type: xlsx
Download File

File 14-NTM EPS (Step 35e).xlsx
File Size: 303 kb
File Type: xlsx
Download File

File 15-FedEx Model (Step 36 after F1Q2019).xlsx
File Size: 430 kb
File Type: xlsx
Download File

File 20-FDX Beta Calculation (Chapter 8 Step 34 F1Q2019 Preview).xlsx
File Size: 297 kb
File Type: xlsx
Download File

File 19-Class Wrap-Ups.xlsx
File Size: 46 kb
File Type: xlsx
Download File


Appendix 1: Using Regression Analysis to Predict Earnings

File 18-Regression Models (Appendix 1).xlsx
File Size: 143 kb
File Type: xlsx
Download File

File 19-Class Wrap-Ups.xlsx
File Size: 46 kb
File Type: xlsx
Download File


Appendix 2: FedEx Fiscal 2Q2019 Earnings Release

File 21-FDX Beta Calculation (Appendix 2-Step 1 F2Q2019 Preview).xlsx
File Size: 298 kb
File Type: xlsx
Download File

File 22-FedEx Model (Appendix 2-Step 1 F2Q2019 preview).xlsx
File Size: 429 kb
File Type: xlsx
Download File

File 23-FDX Model (Appendix 2-Step 2 F2Q2019 Review).xlsx
File Size: 435 kb
File Type: xlsx
Download File

File 25-FDX Model (Appendix 2-Step 3 F2Q2019 Recalibration).xlsx
File Size: 449 kb
File Type: xlsx
Download File

File 26-FDX Beta Calculation (Appendix 2-Step 3 F2Q2019 Recalibration).xlsx
File Size: 301 kb
File Type: xlsx
Download File


Appendix 3: Equity Risk Premium Update (December-2018)

File 24-Equity Risk Premium Model (Appendix 3 Dec-2018 FOMC Meeting Update).xlsx
File Size: 1730 kb
File Type: xlsx
Download File

File 27-Equity Risk Premium Model (Appendix 3-December 2018 Update).xlsx
File Size: 1734 kb
File Type: xlsx
Download File


Appendix 4: FedEx Fiscal 3Q2019 Earnings Release (March-2019)

File 28-FDX Beta Calculation (Appendix 4 Step 1 F3Q2019 Preview).xlsx
File Size: 306 kb
File Type: xlsx
Download File

File 29-FDX Model (Appendix 4-Step 1 F3Q2019 Preview).xlsx
File Size: 459 kb
File Type: xlsx
Download File

File 30-FDX Model (Appendix 4-Step 2 F3Q2019 Review).xlsx
File Size: 461 kb
File Type: xlsx
Download File


Appendix 5: Equity Risk Premium Model Update (February-2019)

File 31-Equity Risk Premium Model (Appendix 5 February-2019 Update).xlsx
File Size: 2043 kb
File Type: xlsx
Download File


Appendix 6: Equity Risk Premium Model Update (March-2019)

File 32-Equity Risk Premium Model (Appendix 6 March-2019 Update).xlsx
File Size: 2046 kb
File Type: xlsx
Download File


Appendix 7: Equity Risk Premium Model Update (May-2019)

File 33-Equity Risk Premium Model (Appendix 7 April-2019 Update).xlsx
File Size: 2049 kb
File Type: xlsx
Download File


Appendix 8: Equity Risk Premium Model Update (June-2019)

File 34-Equity Risk Premium Model (Appendix 8 June-2019 Update).xlsx
File Size: 2095 kb
File Type: xlsx
Download File


Appendix 9: FedEx Fiscal 4Q2019 Earnings Release (June-2019)

File 35-FDX Beta Calculation (Appendix 9-Step 1 F4Q2019 Preview).xlsx
File Size: 313 kb
File Type: xlsx
Download File

File 36-FDX Model (Appendix 9 Step 1 F4Q2019 Preview).xlsx
File Size: 461 kb
File Type: xlsx
Download File

File 37-FDX Model (Appendix 9 Step 2&3 F4Q2019 Review).xlsx
File Size: 495 kb
File Type: xlsx
Download File


Appendix 10: ​Equity Risk Premium Model Update (July-2019)

File 38 Equity Risk Premium Model (Appendix 10 July-2019 Update).xlsx
File Size: 2130 kb
File Type: xlsx
Download File


Textbook Corrections

Textbook Corrections (2021).pdf
File Size: 85 kb
File Type: pdf
Download File

file_37-fdx_model__appendix_9-step_2___3_f4q2019_review__corrected_.xlsx
File Size: 497 kb
File Type: xlsx
Download File

Gutenberg Research is a media and education company. The information presented on our website and within Gutenberg Research models, files, or other content does not represent investment advice. Data and information presented on this website, or on third party websites posted by us, within our models, files, and other content is for demonstration only, and is presented “as is”. Neither Gutenberg Research nor any Gutenberg Research agents or associates are liable for any errors, delays, incompleteness of data presented, or for actions taken based on reliance on any information contained on this website or within Gutenberg Research models or other content. Investors should consult a professional investment adviser prior to making investment decisions. By accessing this site and/or receiving our models or other content you are deemed to have read and agreed to our Terms of Use posted on this website. This website uses Cookies, refer to our Privacy Policy for details. The Gutenberg Research logo is among the registered and unregistered trademarks of Gutenberg Research LLC. © Gutenberg Research LLC 2023. All Rights Reserved.