• Post category:StudyBullet-15
  • Reading time:6 mins read


Learn projections, financial statements analysis, DCF valuations modeling of Social Media sector giant Twitter

What you will learn

Forecasting Financial Statement

Build valuation models from scratch

Build P&L statements from a raw data extraction

Learn many important Finance functions in Microsoft Excel

Knowledge of all the essential Excel formulas required for Financial Analysis

Use MS Excel to create and automate the calculation of Financial ratios

Description

While building a financial model, the first step is to study the company you are interested in. It means researching to get a good understanding of its financial status. To start, you can gather basic financial information about the company. It will help you better understand how it is doing before diving into its annual reports. However, ensure you get your information from a reliable source, like Yahoo Finance or Reuters. For example, let’s say you want to learn about Apple Inc. You can use Yahoo Finance to get a quick financial snapshot of the company. It’s a great way to get a sense of its financial health.


Get Instant Notification of New Courses on our Telegram channel.


If you want to learn to create a financial model in Excel, check out this course. It’ll walk you through creating a fully integrated financial model using Twitter as an example for the historical years. Let us look at how one can build a financial model from scratch. This financial modeling course will provide a step-by-step guide to creating a financial model. The primary approach taken in this financial modeling guide is Modular. The modular system essentially means building core statements like income statements, balance sheets, and cash flows using different modules/sheets. When creating a financial model in Excel, paying close attention to details is essential. You must also know your way around Excel functions and tools. You cannot just build a financial model once and be over with it. As a result, you must keep tweaking and updating your financial model to ensure accuracy and reliability. The key focus is to prepare each statement step by step and connect all the supporting programs to the core statements on completion. We understand that this may not be clear now. However, you will realize this is very easy as we move forward.

English
language

Content

Revenue Model

Twitter Data Gathering
Twitter Data Gathering Continued
Building the Revenue Model Part 1
Building the Revenue Model Part 2
Building the Revenue Model Part 3

Income Statement

Income Statement
Income Statement Continued

Cash Flow

Cash Flow Part 1
Cash Flow Part 2
Cash Flow Part 3

Balance Sheet

Balance Sheet Part 1
Balance Sheet Part 2
Balance Sheet Part 3

Debt and Capital Lease

Debt and Capital Lease Part 1
Debt and Capital Lease Part 2
Debt and Capital Lease Part 3
Shares Outstanding
Corporate

Working Capital Schedule

Working Capital Schedule Part 1
Working Capital Schedule Part 2
Working Capital Schedule Part 3
Working Capital Schedule Part 4
Depreciation Schedule
Amortization Schedule

DCF

Discounted Cash Flow
Beta
Cost of Equity
Free Cash Flow Method
NPV Calculation
Equity Value
WACC