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: 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 signand 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 #2: 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.
Bonus #3: 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.
Bonus #4: 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.
Bonus #5: 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 #6: 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 #7: 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.
Bonus #8: Real estate financial modeling sample
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.