Yahoo! Revenue Model: Other Revenue & Linking the Model
In this lesson, you’ll complete the revenue model for Yahoo! by estimating their revenue from subscription fees, affiliate sites, and other sources, and then linking together the entire model.
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 final part of this advanced modeling tutorial, you’re going to learn how to estimate Yahoo’s Other Revenue using percentage estimates, and how to link the entire model together.
We’ll start by gathering the appropriate data from their 10-K, investor presentation, and equity research, and then show you how to make the calculations, link the model properly, and then check our numbers against Morgan Stanley’s estimates and Yahoo’s own expectations.
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 get to hear more about the complete financial modeling program from some early users and from some recent customers – and whether it’s right for you.
-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:
