Financial Modeling Examples Using Excel: Download Sample Tutorials

 

1x1.trans Financial Modeling Examples Using Excel: Download Sample Tutorials

Financial modeling examples
Image: Kozzi.com

 

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.

Download sample video

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.

Download sample video

MS-Excel example

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.

Download sample video

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.

Download sample video

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.

Download sample video

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.

Download sample video

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.

Download sample video

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.

Download sample video

Special Bonus on BIWS Programs from FinanceWalk

Here’s an offer on Breaking Into Wall Street (BIWS) programs:

All FinanceWalk readers will get FREE $97 Bonus – FinanceWalk’s Equity Research Program.

If you want to build a long-term career in Financial Modeling, Investment Banking, and Private Equity, I’m confident these are the only courses you’ll need. ( Because Brian (BIWS) has created world-class online financial modeling training programs that will be with you FOREVER).

If you purchase BIWS courses through FinanceWalk links, I’ll give you a FREE Bonus of FinanceWalk’s online Equity Research Program ($97 Value).

I see FinanceWalk’s Equity Research Program as a pretty perfect compliment to BIWS courses – BIWS helps you build financial modeling and investment banking skills and then I will help you build equity research and report writing skills.

To get the FREE $97 Bonus, please purchase from the following links.

Excel and Financial Modeling Fundamentals – Free $97 Bonus

Advanced Financial Modeling – Free $97 Bonus

Bank & Financial Institution Modeling – Free $97 Bonus

Oil & Gas Modeling – Free $97 Bonus

Real Estate & REIT Modeling – Free $97 Bonus

Investment Banking Networking Toolkit – Free $97 Bonus

Investment Banking Interview Guide – Free $97 Bonus

IB Networking Toolkit + IB Interview Guide $144 ( Save $50)

BIWS Platinum – Save $532 ( Save 35%) + Free $97 Bonus : The most comprehensive IB package on the market today. Includes the NEW and Improved BIWS Premium Financial Modeling Course (RRP: $497) PLUS access to the above 6 complementary courses designed to make you into an even more well-rounded IB Professional:

BIWS Premium – Excel & Modeling Fundamentals and Advanced Financial Modeling programs together – save $97 ( Save 20% ) + Free $97 Bonus

Industry Specific Course Bundle – get Bank Modeling + Oil and Gas Modeling + Real Estate Modeling for just $497 and save $244 + Free $97 Bonus

In order to get your FREE Bonus, you must:

  1. Purchase the course through FinanceWalk links.
  2. Send me an email along-with your full name and best email address to avadhut@financewalk.com so I can send you the course login details.

Click Here to Check All BIWS Programs – Free $97 Bonus

 

Free Download: Financial Modeling Videos



View All BIWS Courses –Free $97 Bonus for FinanceWalk Readers

1x1.trans Financial Modeling Examples Using Excel: Download Sample Tutorials

9 Responses to “Financial Modeling Examples Using Excel: Download Sample Tutorials”

Read below or add a comment...

Speak Your Mind

*