I recently started sharing videos on financial modeling examples.
Many of you want to know how to use financial modeling using Excel.
So, in this post, I’m going to share some sample tutorials of financial modeling examples.
Before you watch the following samples, please read this financial modeling basics post.
You’ll understand various types of financial models and the situations where you can these models.
In this post, you’ll learn:
- How to Create Financial Models
- Free Financial Modeling in Excel
- Financial Modeling Tutorial
- Financial Modeling Sample
Financial modeling examples
Here are some financial modeling examples videos:
Advanced merger model
In this lesson, you’ll learn how to properly “divide up” and allocate the purchase price in a merger model, how to calculate new goodwill created, how to adjust for intangible and tangible asset write-ups, and how to create and write-up / write-down deferred tax assets and deferred tax liabilities, as well as deferred revenue write-downs.
Bank & financial institution modeling
Once we know JP Morgan’s capital levels, we can back into the amount of dividends they can issue and the share repurchases they can make each year – and that’s what you’ll learn how to do in this lesson.
You’ll see why this calculation is inherently circular and how to link these numbers to the rest of our model.
This video will teach you how to clean up poorly formatted data in Excel – a very common scenario when you’re working with clients in finance.
Cash flow statement modeling
In this lesson, you’ll learn why the Cash Flow Statement is necessary and how to create one based on the company’s other financial statements; you’ll also learn which items are projected on the CFS vs. which ones flow in from elsewhere.
Investment banking interviews sample
In this lesson, you’ll learn how to discuss a sell-side M&A deal in investment banking interviews – and how you can apply the same strategies to discussing IPOs, debt issuances, and other types of deals.
Investment banking networking sample
We’ll walk through a sample information session in this lesson and show you who to approach, who to avoid, and what to say to make a great first impression and win interviews.
Oil and gas financial modeling examples
This lesson will teach you how to take into account the impact of hedging on realized sale prices, and how to set up base, downside, and upside cases.
Then we’ll tie together all the revenue assumptions to calculate the total revenue by segment for XTO.
Real estate financial modeling Excel sample tutorial
In this lesson, you’ll learn how to allocate the funds required between equity and debt tranches, and how you can ensure that the proper amounts are drawn each month. You will also learn how to project optional debt repayments.