Resources FINANCEWALK
Friday, September 21, 2018

# Resources

### 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.

### 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.

### 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.

### 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.

### 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.

### 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.

### 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.

### 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.

### 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.