Yahoo! Revenue Model: Display Advertising
In this tutorial, you’ll learn how to estimate Yahoo’s Display Advertising Revenue by using a bottoms-up model that starts from how many web pages they display and the revenue earned from each page.
Other Formats:
- View Large Version
- Download Large Version
- Download iPad Version
- Download iPhone Version
- Download iPod Version
Excel Files:
Links & Other Resources:
Hey there,
In the second part of this advanced modeling tutorial, you’re going to learn how to create a bottoms-up model to estimate Yahoo’s Display Advertising Revenue.
We’ll start by estimating how many individual web pages they display daily, and then estimate revenue earned from each page to arrive at the total revenue.
You can follow along using the “Before” Excel file above and then check your work with the “After” Excel file.
Coming up next, you’ll learn how to estimate Yahoo’s miscellaneous revenue and income from other sources, and how to tie everything together in our model.
-Brian
Learn to Model Like a Veteran Banker and Leave the Competition in the Dust – in Interviews and On the Job.
Learn the advanced skills you'll need at work before you even step foot in the office – and prepare yourself for buy-side, lateral, and more advanced interviews…Breaking Into Wall Street Advanced Financial Modeling Package
Advanced Financial Modeling teaches you how investment bankers model companies in real life. Everything is based on a case study of Microsoft's offer to acquire Yahoo, and real SEC filings and equity research from banks such as Credit Suisse and Morgan Stanley are used throughout the course.
You'll learn advanced modeling skills by completing a detailed operating model, a full valuation using 9 methodologies, an advanced merger model that combines all 3 statements and an advanced LBO model with support for 7 tranches of debt.
On the Excel side, you'll start with navigation basics and formatting and go all the way up to formulas, macros, and advanced topics like pivot tables.
Our Customers Love BIWS Advanced Financial Modeling
Over 6,000 students and finance professionals have used Breaking Into Wall Street to master modeling, win interviews, and land offers in investment banking, private equity, hedge funds, equity research, and more."I Got the Job!"
This customer found out about a private equity interview a few days beforehand, and only managed to get through a few lessons – but he won the offer anyway. And this was with an older, preview version of the site:
