Resources FINANCEWALK

Resources

Welcome to Your Download Page!

Welcome to the family. A few things you’ll want to know.

As a FinanceWalk member, you have access to my best resources and material. You will learn how to read financial statements, build financial models from the scratch, write equity research reports, create your winning resume and much more. All for free.

Now, for the bonuses, you signed up for!

Bonus #1: Download eBook- A Guide to Careers in Finance

Bonus #2: Advanced merger model

Purchase Price Allocation Example – Advanced Tutorial

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

Bonus #3: Bank & financial institution modeling

Dividends Issued & Share Issuances Excel Tutorial – Shawbrook Case Study (23:56)

In this lesson, you’ll learn how to project dividends and stock issuances for a bank based on its targeted Common Equity Tier 1 Ratio and Risk-Weighted Assets, among other assumptions; you’ll also see how our numbers compare to consensus estimates at the end.

Download sample video

Bonus #4: MS-Excel example

Football Field Valuation Chart: How to Create It

In this lesson, you’ll learn how to create the infamous “football field” valuation graph that shows a company’s implied per share value across different methodologies and assumptions, and the 25th quartile to 75th quartile for each one. To complete this graph, we’ll combine the graphing tools we just learned with the LOOKUP and TRANSPOSE functions from the previous module.
Download sample video

Bonus #5: Cash flow statement modeling

Free Cash Flow and What to Do With It (26:52)

In this lesson, you’ll learn what “Free Cash Flow” (FCF) means, why it’s such an important metric when analyzing and valuing companies, how to interpret positive vs. negative FCF, and what different numbers over time mean – using a comparison between Wal-Mart, Amazon, and Salesforce as our example.

Download sample video

Bonus #6: 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

Bonus #7: 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

Bonus #8: 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 the 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

Bonus #9: Real estate financial modeling sample

Real Estate Development Modeling: Equity, Debt Draws, and Optional Repayment

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

 

Check our YouTube Channel

Liked these sample financial modeling videos?

Special offer: Join any Breaking Into Wall Street (BIWS) program and get $97 Bonus ONLY for FinanceWalk readers.

Sign Up Now and Get the Bonus

Go to Courses Page

Login to your account below

Fill the forms bellow to register

Retrieve your password

Please enter your username or email address to reset your password.

>

The World's No.1 Financial Modeling and Investment Banking Online Courses.