Build & Analyze Financial Models: Twitter Case Study
Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
What you'll learn
Gather and analyze financial data, build revenue models, and link assumptions.
Prepare income statements, balance sheets, and cash flow projections.
Apply valuation methods, calculate free cash flow, and model debt/equity structures.
Details to know
12 assignments
See how employees at top companies are mastering in-demand skills
There are 3 modules in this course
By the end of this course, learners will be able to gather and analyze financial data, construct revenue models, prepare income statements and cash flow projections, and apply valuation techniques using a real-world case study of Twitter. The course equips participants with practical skills to interpret balance sheets, model debt and equity structures, calculate free cash flow, and integrate all statements into a final valuation-ready model.
Learners will benefit from a step-by-step approach that combines theory with hands-on application, ensuring they can confidently link assumptions, projections, and financial statements. This course is unique because it applies financial modeling concepts directly to a globally recognized company, providing an engaging and practical framework for learning. Through guided modules, participants will not only strengthen their technical modeling expertise but also develop the ability to critically assess business performance and corporate value. Ideal for finance students, analysts, and professionals, this course bridges the gap between classroom concepts and real-world financial decision-making.
This module introduces the essential groundwork for building Twitterβs financial model. Learners will gather and structure raw data, develop and refine revenue models, and connect them to the income statement and cash flow. By the end, participants will understand how revenue assumptions drive financial statements and prepare the foundation for integrated modeling.
What's included
10 videos4 assignments
10 videosβ’Total 100 minutes
- Twitter Data Gatheringβ’10 minutes
- Twitter Data Gathering Continuedβ’7 minutes
- Building the Revenue Model Part 1β’12 minutes
- Building the Revenue Model Part 2β’10 minutes
- Building the Revenue Model Part 3β’12 minutes
- Income Statementβ’9 minutes
- Income Statement Continuedβ’12 minutes
- Cash Flow Part 1β’10 minutes
- Cash Flow Part 2β’7 minutes
- Cash Flow Part 3β’11 minutes
4 assignmentsβ’Total 60 minutes
- Gathering and Structuring Dataβ’10 minutes
- Completing the Revenue Modelβ’10 minutes
- Linking to Cash Flowβ’10 minutes
- Graded - Revenue Foundations & Core Statementsβ’30 minutes
This module explores Twitterβs financial structures, focusing on balance sheet essentials, debt and lease obligations, share equity, and working capital. Learners will gain insights into capital planning strategies and corporate organization while mastering the integration of financial schedules into the broader model.
What's included
12 videos4 assignments
12 videosβ’Total 109 minutes
- Balance Sheet Part 1β’11 minutes
- Balance Sheet Part 2β’6 minutes
- Balance Sheet Part 3β’10 minutes
- Debt and Capital Lease Part 1β’14 minutes
- Debt and Capital Lease Part 2β’6 minutes
- Debt and Capital Lease Part 3β’11 minutes
- Shares Outstandingβ’13 minutes
- Corporateβ’6 minutes
- Working Capital Schedule Part 1β’7 minutes
- Working Capital Schedule Part 2β’10 minutes
- Working Capital Schedule Part 3β’6 minutes
- Working Capital Schedule Part 4β’9 minutes
4 assignmentsβ’Total 60 minutes
- Balance Sheet Essentialsβ’10 minutes
- Debt, Leases & Equity Baseβ’10 minutes
- Corporate Strategy & Working Capitalβ’10 minutes
- Graded - Financial Structures & Capital Planningβ’30 minutes
This module focuses on valuation techniques and final integration. Learners will develop supporting schedules, apply discounted cash flow and cost of capital methods, and consolidate Twitterβs complete financial model. By the end, participants will be able to deliver a fully integrated, valuation-ready financial framework.
What's included
9 videos4 assignments
9 videosβ’Total 102 minutes
- Depreciation Scheduleβ’11 minutes
- Amortization Scheduleβ’11 minutes
- Discounted Cash Flowβ’11 minutes
- Betaβ’12 minutes
- Cost of Equityβ’14 minutes
- Free Cash Flow Methodβ’14 minutes
- NPV Calculationβ’12 minutes
- Equity Valueβ’6 minutes
- WACCβ’12 minutes
4 assignmentsβ’Total 60 minutes
- Schedules and Cash Flow Driversβ’10 minutes
- Cost of Capital & Equity Valuationβ’10 minutes
- Comprehensive Valuation & Final Modelβ’10 minutes
- Graded - Valuation & Final Modelβ’30 minutes
Instructor
Offered by
Explore more from Finance
- Status: Preview
Course
- Status: Preview
Course
- Status: Free TrialB
Board Infinity
Course
- Status: Preview
Course
Why people choose Coursera for their career
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you canβt afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, youβll find a link to apply on the description page.
More questions
Financial aid available,
