Financial Modeling, Excel,Real Estate Modeling,Oil & Gas Modeling,Bank Modeling,Investment Banking
View All Courses – Free $47 Bonus for FinanceWalk Readers
Most “self-study” financial modeling training programs are little more than hundreds of pages of text and screenshots.
Not too exciting – or effective.
But not everyone can afford the time and money to go to live seminars and in-person training, especially if you’re not in the industry yet.
That’s why FinanceWalk has partnered with Breaking into Wall Street to make you an expert in financial modeling, valuation, networking and interviews.
BIWS bridges that gap by providing video-based training on accounting, 3-statement modeling, valuation, discounted cash flow analysis, merger models, and LBO models.
Everything is based on case studies of real companies – Apple, Research in Motion, Microsoft, Yahoo, JP Morgan, Exxon Mobil, XTO Energy, and AvalonBay – and you work through models the way you would at a real bank, using equity research and SEC filings.
Everything You Need to Break Into Investment Banking.
Here’s the team of experts.
Brian DeChesare created Mergers & Inquisitions in 2007 based on his experiences starting Internet-based businesses, working in technology, and then in investment banking. He has been a featured speaker on business, finance, and recruiting at leading universities and business schools around the world.
Peter Yu is a former management consultant-turned-M&A-banker who also assists with technical question support on BIWS. He’s also a co-founder of The GMAT Pill, an innovative online video approach to the GMAT exam.
Jerry Chi worked in equities and fixed income trading in Tokyo, and then left to start his own prop trading firm in Beijing, where he successfully grew the company and sold it in early 2009. Currently he is attending The Lauder Institute at Wharton.
Ed Fu is a venture capitalist and recent Harvard Business School graduate. Before that, he was an engineer turned technology investment banker.
Kevin Gao created Management Consulted, the web’s leading resources on management consulting, in 2008. He has also been involved with several other online ventures, including Kleiner Perkins-backed Shopkick, since leaving the McKinsey New York office.
Eric Hu defied the odds to break into investment banking coming from the “non-target” school of UCSD. Since finishing his time in banking, he has worked in corporate development at a large Internet company, focusing on partnerships, M&A, and expansion into China.
Our Guarantee – No Risk
We guarantee that the following courses are of tremendous value, and they give you skills that market demands. To make this a risk-free purchase, you’ll have access to course materials, bonus ebooks for 60 days … and if you’re not happy by the end of that week, just ask and we’ll immediately grant you a full, 100% refund, no questions asked.
All products come with 60-day 100% money-back guarantees. If you’re unsatisfied with anything, you can simply ask for your money back within 60 days of signing up.
This Premium Financial Modeling Program includes the 2 core products – Excel & Modeling Fundamentals and Advanced Modeling – and teaches you everything you need to know about financial modeling, from how to use Excel to Accounting 101, to how to model and value companies, and how to create merger models and LBO models.
In addition to learning everything you need for interviews, internships, and full-time work, you’ll also go back in time and pretend the Microsoft-Yahoo acquisition happened – and you’ll learn how to build a detailed operating model, value the company, and complete advanced merger/LBO models, using real 10-K/10-Q filings and real equity research from Morgan Stanley, Credit Suisse, and other banks.
Program Modules
Module 1: Navigation & Data Manipulation
Module 2: Formatting
Module 3: Formulas
Module 4: Accounting Fundamentals
Module 5: Creating 3-Statement Projections
Module 6: Equity Value, Enterprise Value & Multiples
Module 7: Valuation Overview & Comparables
Module 8: Discounted Cash Flow Analysis
Module 9: Valuation Summary
Module 10: Merger Model
Module 11: LBO Model
Module 12: More Advanced LBO Model
Module 13: Advanced Financial Modeling: Yahoo! Operating Model
Module 14: Advanced Financial Modeling: Yahoo! Valuation
Module 15: Advanced Financial Modeling: Microsoft / Yahoo! Merger Model
Module 16: Advanced Financial Modeling: Yahoo! LBO Model
Module 17: Advanced Financial Modeling: Deal Commentary & Pitch Book
What do you get when you sign up for the course?
✓Financial Modeling lessons cover Accounting 101 up through 3-Statement Models,Valuation, DCF Analysis, Merger Models, and LBO Models.
✓248 videos total (63 hours of footage).
✓Excel lessons include navigation, data manipulation, formatting, formulas, and advanced topics like pivot tables, macros, and custom shortcuts.
✓Both Excel 2003 and Excel 2007 / 2010 shortcuts are covered.
✓Operating Model lessons teach you how to create a detailed 3-statement model, including revenue and expense builds, noncontrolling and equity interests, PP&E schedules, deferred taxes, and quarterly projections.
✓Valuation lessons cover how to spread comps, adjust for non-recurring charges, calendarize financials, how to value NOLs and equity investments, and how to complete advanced DCF analysis including mid-year discounts and stub periods; you’ll also learn future share price analysis, sum-of-the-parts valuation, and liquidation valuation.
✓Advanced Merger Model covers how to combine all 3 statements, multiple scenarios, advanced purchase price allocation, how to calculate revenue and expense synergies by segment, and book taxes, cash taxes, and Section 382 NOLs.
✓Advanced LBO Model covers how to modify an operating model to make it into an LBO model, 7 debt tranches, multiple capital structure scenarios, and an advanced debt schedule with mandatory and optional repayments.
✓Includes sample pitch book and PowerPoint crash course as well as commentary on the deal.
✓You receive instant access when you sign up because everything is delivered online – no shipping charges or physical products to worry about.
✓Free lifetime updates and support.
Here’s a bonus for you.
If you enroll to this program through this page, you will get :
✓ PowerPoint Pro Program to create M& A Pitch Books ($ 47) absolutely FREE!!!
Click on Sign Up Now to register through my blog.
Advanced Financial Modeling teaches you how investment bankers model companies in real life. Everything is based on a case study of Microsoft’s offer to acquire Yahoo, and real SEC filings and equity research from banks such as Credit Suisse and Morgan Stanley are used throughout the course.
You’ll learn advanced modeling skills by completing a detailed operating model, a full valuation using 9 methodologies, an advanced merger model that combines all 3 statements and an advanced LBO model with support for 7 tranches of debt.
Program Modules
Module 1: Advanced Financial Modeling: Yahoo! Operating Model
Module 2: Advanced Financial Modeling: Yahoo! Valuation
Module 3: Advanced Financial Modeling: Microsoft / Yahoo! Merger Model
Module 4: Advanced Financial Modeling: Yahoo! LBO Model
Module 5: Advanced Financial Modeling: Deal Commentary & Pitch Book
What do you get when you sign up for the course?
✓Lessons cover advanced operating models, valuation based on SEC filings and equity research, complex merger model, advanced LBO model, and pitch book / deal commentary.
✓100 videos total (36 hours of footage).
✓Operating Model lessons teach you how to create a detailed 3-statement model, including revenue and expense builds, noncontrolling and equity interests, PP&E schedules, deferred taxes, and quarterly projections.
✓Valuation lessons cover how to spread comps, adjust for non-recurring charges, calendarize financials, how to value NOLs and equity investments, and how to complete advanced DCF analysis including mid-year discounts and stub periods; you’ll also learn future share price analysis, sum-of-the-parts valuation, and liquidation valuation.
✓Advanced Merger Model covers how to combine all 3 statements, multiple scenarios, advanced purchase price allocation, how to calculate revenue and expense synergies by segment, and book taxes, cash taxes, and Section 382 NOLs.
✓Advanced LBO Model covers how to modify an operating model to make it into an LBO model, 7 debt tranches, multiple capital structure scenarios, and an advanced debt schedule with mandatory and optional repayments.
✓Includes sample pitch book and PowerPoint crash course as well as commentary on the deal.
✓You receive instant access when you sign up because everything is delivered online – no shipping charges or physical products to worry about.
✓Free lifetime updates and support.
Here’s a bonus for you.
If you enroll to this program through this page, you will get :
✓PowerPoint Pro Program to create M& A Pitch Books ($ 47) absolutely FREE!!!
Click on Sign Up Now to register.
Excel & Financial Modeling Fundamentals teaches you Excel and financial modeling from the ground up – everything you need to ace your investment banking and private equity interviews.
The course is based on a case study of Apple and Research in Motion, using real SEC filings and equity research from investment banks such as Credit Suisse.
You’ll learn everything from Accounting 101 and Valuation all the way up through Merger Models and PE interview-ready LBO Models.
On the Excel side, you’ll start with navigation basics and formatting and go all the way up to formulas, macros, and advanced topics like pivot tables.
You’ll also get to practice yourself with the exercises included within each course – and all the videos are captioned with the key Excel shortcuts you need.
What do you get when you sign up for the course?
✓Financial Modeling Fundamentals Lessons cover Accounting, 3-Statement Projections, Equity Value, Enterprise Value & Multiples, Valuation, Discounted Cash Flow Analysis, Merger Models, and Basic and More Advanced LBO Modeling.
✓Excel Lessons cover navigation, manipulating data and worksheets, formatting, formulas, and advanced topics like lookup functions, pivot tables, macros, and custom shortcuts.
✓148 videos total (27 hours of footage).
✓Both Excel 2003 and Excel 2007 / 2010 shortcuts are covered.
✓11 lessons on data manipulation, 10 lessons on formatting, and 12 lessons on formulas.
✓24 lessons on Accounting fundamentals and over a dozen accounting interview questions; 15 lessons on building 3-statement models and balancing a balance sheet.
✓12 lessons on Equity Value, Enterprise Value & Multiples and 11 lessons on public company comparables, precedent transactions, and valuation.
✓14 Discounted Cash Flow lessons covering projections, terminal value, discount methodology, and calculating WACC.
✓14 Merger Model lessons on accretion / dilution, synergies, pro-forma balance sheet adjustments, and sensitivity tables.
✓25 LBO Model lessons covering both a basic model (no balance sheet) and a more advanced model with all 3 statements, pro-forma balance sheet, and debt schedules with 5 tranches of debt from Revolver to PIK.
✓You receive instant access when you sign up because everything is delivered online – no shipping charges or physical products to worry about.
✓Free lifetime updates and support.
Here’s a bonus for you.
If you enroll to this program through this page, you will get :
✓ PowerPoint Pro Program to create M& A Pitch Books ($ 47) absolutely FREE!!!
Click on Sign Up Now to register.
Real Estate & REIT Modeling teaches you how to model property development and acquisitions, and how to project and value real estate investment trusts (REITs).
The program is based on case studies of an office development & sale, a hotel acquisition & renovation, and a REIT operating model and valuation for AvalonBay Communities, where we use real SEC filings and equity research from banks like Citi and JP Morgan to support the numbers.
You’ll start with a crash-course on real estate development and REITs, and then move into the office development and hotel acquisition case studies, where you’ll learn how to estimate a property’s size, financial performance, and returns to investors.
After that, we’ll jump into a detailed 3-statement model for AvalonBay with support for their different real estate segments, and conclude with a full valuation, including the usual methodologies as well as real estate-specific ones such as the Net Asset Value (NAV) model.
What do you get when you sign up for the course?
✓Prerequisites: Excel & Financial Modeling Fundamentals or equivalent (this is an advanced course).
✓Lessons cover property development and acquisitions, key real estate terminology and metrics, how a REIT’s financial statements differ, and REIT valuation.
✓63 videos total (24 hours of footage).
✓7 quick reference guide PDFs on key topics – from key terms and accounting through property modeling, REIT financial statements, and valuation.
✓Overview lessons cover real estate key terms, how to model an apartment complex, how a REIT operates, and how to link properties and REITs.
✓Office Development & Sale lessons teach you how to estimate building size, hard costs and soft costs, project the financial statements of a property, build debt and equity draw schedules, calculate the sale proceeds, and allocate investor returns using a waterfall schedule, factoring in developer promotes.
✓Hotel Acquisition & Renovation lessons cover how to project a hotel’s financial statements, estimate the impact of property renovation, and calculate returns based on the purchase price, selling cap rate, and capital structure.
✓REIT Operating Model videos teach you how to project a REIT’s rental income and net operating income (NOI) from same-store properties, development/redevelopment, acquisitions, and dispositions; you’ll also learn how to create a complex debt schedule, link and project the statements, and calculate FFO, AFFO, and dividends issued.
✓REIT Valuation lessons cover public comps, precedent transactions, and the Discounted Cash Flow Analysis (DCF) and Dividend Discount Model (DDM) for REITs, as well as real estate-specific models such as the Net Asset Value (NAV) and Replacement Cost methods.
✓You receive instant access when you sign up because everything is delivered online – no shipping charges or physical products to worry about.
✓Free lifetime updates and support.
Here’s a bonus for you.
If you enroll to this program through this page, you will get :
✓PowerPoint Pro Program to create M& A Pitch Books ($ 47) absolutely FREE!!!
Click on Sign Up Now to register.
Oil & Gas Modeling teaches you how to value and model natural resource companies and how they’re different from normal companies.
Everything is based on a case study of Exxon Mobil’s $41 billion acquisition of XTO Energy – one of the largest energy M&A deals ever – and the entire program is integrated with real SEC filings and equity research from banks like JP Morgan, Credit Suisse, and Deutsche Bank.
You’ll start with a crash-course on oil & gas accounting, production, and reserves, and then you’ll get to create operating models for both Exxon Mobil and XTO based on their energy production levels.
After that, we’ll jump into a full valuation of XTO including the Net Asset Value (NAV) model, before completing a detailed 3-statement merger model between Exxon Mobil and XTO and concluding with a hypothetical leveraged buyout model.
What do you get when you sign up for the course?
✓Prerequisites: Excel & Financial Modeling Fundamentals or equivalent (this is an advanced course).
✓Lessons cover the 3 financial statements for oil & gas companies, production and reserves, operating models, valuation via public comps, precedent transactions, DCF and Net Asset Value (NAV), oil & gas merger models, and LBO modeling.
✓54 videos total (21 hours of footage).
✓6 quick reference guide PDFs on key topics – from accounting through valuation, merger models, and LBO models.
✓Overview and Operating Model lessons teach you how to project and work with production and reserves, successful efforts vs. full cost accounting, and how to link revenue and expenses to hedging, price realization and unit of production assumptions; complex debt schedule and alternative operating model for Exxon Mobil are also covered.
✓Valuation course covers public comps and precedent transactions for energy companies, the key metrics and multiples to use, how a DCF is different, and how to create a full Net Asset Value (NAV) model based on data in filings and equity research.
✓Merger Model lessons teach you how to use the actual Exxon Mobil – XTO Merger Agreement to make assumptions, how to combine the 3 statements for oil & gas companies, and how acquisition effects, synergies, contribution analyses, and accretion / dilution differ for energy companies.
✓LBO Modeling course covers the key differences when modeling oil & gas companies, how to modify XTO’s debt schedules to support refinancing and 7 new debt tranches, and how to analyze returns based on commodity prices.
✓You receive instant access when you sign up because everything is delivered online – no shipping charges or physical products to worry about.
✓Free lifetime updates and support.
Here’s a bonus for you.
If you enroll to this program through this page, you will get :
✓PowerPoint Pro Program to create M& A Pitch Books ($ 47) absolutely FREE!!!
Click on Sign Up Now to register.
Bank & Financial Institution Modeling teaches you how to model and value financial institutions and how they’re different from normal companies.
Everything is based on a case study of JP Morgan, and the entire program is integrated with real SEC filings and equity research from banks like Morgan Stanley.
You’ll start with a crash-course on accounting, credit losses, and regulatory capital for banks, and then you’ll get to create a detailed operating model for JP Morgan based on its loan portfolio. We conclude with a full valuation and the dividend discount and residual income models.
What do you get when you sign up for the course?
✓Prerequisites: Excel & Financial Modeling Fundamentals or equivalent (this is an advanced course).
✓Lessons cover the 3 financial statements for a bank, credit loss accounting, regulatory capital, loan portfolio and operating model projections, and valuation via public comps / precedent transactions and the residual income and dividend discount models.
✓29 videos total (12 hours of footage).
✓5 quick reference guide PDFs on key topics – from accounting through valuation.
✓Overview lessons cover a bank’s financial statements, interest-earning assets and interest-bearing liabilities, how to calculate the provision for credit losses and allowance for loan losses, and how to determine risk-weighted assets and key metrics such as the Tier 1 Capital Ratio.
✓Operating Model lessons teach you how to project JP Morgan’s loan portfolio and credit losses, and how you use those to drive its balance sheet, IEA and IBL, and income statement and cash flow statement; advanced topics such as the circular calculation for dividends and share repurchases are also covered.
✓Valuation course covers public comps and precedent transactions for a bank, the key metrics and multiples to use, and both simplified and complex versions of the dividend discount model and residual income (excess returns) model.
✓You receive instant access when you sign up because everything is delivered online – no shipping charges or physical products to worry about.
✓Free lifetime updates and support.
The Investment Banking Interview Guide 2.0 teaches you everything you need to know to land investment banking offers. You’ll learn how to tell your “story,” how to discuss deals and transaction experience, and what interviewees do right and wrong in sample investment banking interviews.
In addition to all that, you’ll get 400 investment banking interview questions & answers, on all topics – from the “fit” questions to expect to Restructuring and Distressed M&A to technical questions on everything from accounting to LBO models.
The Investment Banking Interview Guide 2.0 teaches you everything you need to know to land investment banking offers. You’ll learn how to tell your “story,” how to discuss deals and transaction experience, and what interviewees do right and wrong in sample investment banking interviews.
In addition to all that, you’ll get 400 investment banking interview questions & answers, on all topics – from the “fit” questions to expect to Restructuring and Distressed M&A to technical questions on everything from accounting to LBO models.
The Investment Banking Interview Guide 2.0 teaches you everything you need to know to land investment banking offers. You’ll learn how to tell your “story,” how to discuss deals and transaction experience, and what interviewees do right and wrong in sample investment banking interviews.
In addition to all that, you’ll get 400 investment banking interview questions & answers, on all topics – from the “fit” questions to expect to Restructuring and Distressed M&A to technical questions on everything from accounting to LBO models.
Here’s a bonus for you.
If you enroll to this program through this page, you will get :
✓PowerPoint Pro Program to create M& A Pitch Books ($ 47) absolutely FREE!!!
Click on Sign Up Now to register.
The Investment Banking Interview Guide 2.0 teaches you everything you need to know to land investment banking offers. You’ll learn how to tell your “story,” how to discuss deals and transaction experience, and what interviewees do right and wrong in sample investment banking interviews.
In addition to all that, you’ll get 400 investment banking interview questions & answers, on all topics – from the “fit” questions to expect to Restructuring and Distressed M&A to technical questions on everything from accounting to LBO models.
What do you get when you sign up for the course?
✓Lessons cover how to tell your story, how to discuss deal experience, and what interviewees get right and wrong in 5 sample interviews.
✓400 investment banking interview questions & answers covering “fit” and technical questions.
✓103 industry-specific questions & answers covering banks & financial institutions (52 questions) and oil, gas & mining (51 questions).
✓12 video tutorials (nearly 4 hours of total footage).
✓7 sample interview discussions (2.5 hours of audio with full transcripts) with analysis & critiques.
✓4 “story” templates you can modify and use to tell your own story in interviews – along with a video tutorial for each one.
✓2 sample “deal discussions” (for a sell-side divestiture and for a buy-side M&A deal) with full critiques.
✓108 “fit” questions & answers covering how to discuss your background, answer team / leadership / strength / weakness questions, and prove you know something about investment banking.
✓15 transaction experience questions & answers and 39 Restructuring questions & answers covering how to discuss all types of deals and the key concepts you need for Restructuring / Distressed M&A interviews.
✓238 technical questions, split into basic and advanced for each topic – accounting, equity & enterprise value, valuation, DCF, merger model, and LBO model.
✓You receive instant access when you sign up because everything is delivered online – no shipping charges or physical products to worry about.
✓Access to free lifetime updates and new additions once you sign up.
Click on Sign Up Now to register.
Here’s a bonus for you.
If you enroll to this program through this page, you will get :
✓PowerPoint Pro Program to create M& A Pitch Books ($ 47) absolutely FREE!!!
Click on Sign Up Now to register.
The Networking Ninja Toolkit teaches you how to go from “Networking Newbie” to Networking Ninja. You’ll learn how to find names and contact information, how to plan your informational interviews and cold-calls, and how to break into finance without killing yourself.
In addition to learning how to request, conduct, and follow-up on informational interviews and how to convert relationships into offers, you’ll learn how to cold-call your way into Wall Street, how to rock your information sessions, how to take your networking efforts to the next level with weekend trips, and how to network with co-workers and advance once you’re on the job.
What do you get when you sign up for the course?
✓Lessons cover the Networking Process; Lead Generation; Tracking Your Networking; Requesting, Conducting, and Following Up on Informational Interviews; Cold Calls & Cold Emails; The Information Session Playbook; Weekend Trips; and Co-Worker Networking.
✓Names and descriptions for 4,000 investment banks, 6,000 private equity firms, and 3,000 hedge funds (note: these are names, descriptions, and main line phone numbers/addresses – NOT the names/phone numbers of specific people at each firm).
✓32 videos/MP3s total (7.5 hours of footage).
✓Multiple formats for each lesson – video, audio, text, and interactive diagrams.
✓Email templates: Requesting Informational Interviews, Following-Up, Cold-Emailing to Ask for Interviews, Following Up After Information Sessions and Weekend Trips, and Making Requests of Your Co-Workers.
✓3 Sample Cold-Calls: Positive Response, Negative Response, and Voicemail, with Analysis for each one.
✓2 Sample Informational Interviews: 1 at the undergraduate level and 1 at the MBA level, with Analysis for each one.
✓ Scripts: Referral to buy-side jobs, referral to investment banking group, introduction to headhunters, and a sample elevator pitch and analysis.
✓ 75-question Networking Ninja quiz to test your knowledge and make sure you know all the ninja tactics you need to succeed.
✓You receive instant access when you sign up because everything is delivered online – no shipping charges or physical products to worry about.
✓Access to free lifetime updates and new additions once you sign up.
Here’s a bonus for you.
If you enroll to this program through this page, you will get :
✓PowerPoint Pro Program to create M& A Pitch Books ($ 47) absolutely FREE!!!
Click on Sign Up Now to register.
