About Gutenberg ResearchWe are an interactive earnings modeling community, driving the evolution of equity research. Our mission is to make dynamic earnings models, available to everyone. We are currently experimenting with new ways to engage our community of modelers. Our focus this winter will be on our Learn, Work, & Play program, which offers exciting new opportunities for our community to participate in our coverage of the earnings season. Please register here to join in on the fun.
|
Modeling Training ProgramOur Cooperative Modeling Program is a real-world, real-time financial modeling experience. Our students build a three-statement financial model and project earnings for a public company prior to the quarterly filing. Then on the night of the company’s earnings release, our class analyzes the results, listens to the conference call, and updates the model together as a group. This approach helps give the students a true sell-side research experience...continue reading
|
Popular Models
Microsoft Corp (NASDAQ:MSFT)
To forecast revenue, this model applies growth rates to the four reportable segments: Productivity & Business Processes, Intelligent Cloud, More Personal Computing, and Corporate. |
Meta Platforms (NASDAQ:META)
This model uses Monthly Active User growth rates and Average Revenue Per User to project future Revenue. Ratio analysis is used to complete the financial statements. |
Alphabet Inc (NASDAQ:GOOGL)
This model breaks down Alphabet’s results by segment. Revenue is shown gross and net of Traffic Acquisition Costs (TAC). Ratio analysis is used to complete the financial statements. |
Apple Inc (NASDAQ:AAPL)
This model uses iPhone, iPad, Mac, services, and Wearables, Home & Accessories growth rates to project future revenue. Ratio analysis is used to complete the Income Statement. |
Netflix Inc (NASDAQ:NFLX)
This model breaks down Netflix’s earnings by segment: Domestic Streaming, International Streaming, and DVD. Growth in users and revenue per user are used to estimate future earnings. |
Equity Risk Premium Model
In this spreadsheet we estimate the market Equity Risk Premium (ERP) using the Constant Sharpe approach, and forecasts for interest rates, volatility, and equity market returns. |
Tesla Inc (NASDAQ:TSLA)
This model uses vehicle production, delivery, Average Selling Price (ASP), and ratio analysis to forecast earnings. |
Starbucks Corp (NASDAQ:SBUX)
This model uses estimates of new stores and revenue per store by geographic region to project future revenue. |