• Sat, May 27 – Sun, May 28, 2023 (9AM to 5PM – IST)

Financial & Valuation Modeling

Live Virutal Class

INR 3999/-

Hurry!! 5 seats remaining at this price!!

  • Sat, April 16 – Sun, April 17, 2023 (9AM to 5PM – IST)

Financial & Valuation Modeling

Live VIrutal Class

INR 8999/-

Hurry!! 5 seats remaining at this price!!

Master financial modeling, get hired faster.

If you're a finance professional or someone looking to break into the investment banking, corporate finance, or equity research field, this program is for you.

Real-life case studies and intuitive approach:
Our virtual Zoom training is designed to provide you with a step-by-step, intuitive approach to modeling using real-life case studies. You'll learn how to build financial models and valuations the way it's done on the job. With our training, you'll gain the skills and knowledge required to succeed in your career.

Led by experienced finance professionals:
Led by experienced finance professionals, this training program is the same one used to prepare incoming analysts and associates at top financial institutions. Our training has been tried and tested by the best, and it's proven to be effective in providing participants with the skills and knowledge they need to excel in their roles.

Gain the skills needed to succeed in the finance industry:
Our training is designed to provide you with the skills and knowledge needed to succeed in the competitive finance industry. By the end of the program, you'll be able to build financial and valuation models the way it's done on the job, giving you the edge you need to advance your career.

Don't wait – sign up for our Financial Modeling Bootcamp today and take the first step towards a successful career in finance!

Our certification program is the perfect choice. By completing our boot camp, you'll earn a Certification in Financial & Valuation Modeling from top level training firm.

This certification is globally recognized and demonstrates your proficiency in key areas such as Financial Modeling, DCF, Comps, and M&A. With this certification, you'll have the skills and knowledge needed to succeed in the competitive finance industry.

Join us today and earn the certification you need to take your finance career to the next level.

Agenda

Day 1:

1. Key Excel Skills for Financial Modeling:
  • Learn basic Excel techniques and keyboard shortcuts.
  • Perform Excel's basic functions accurately without the mouse.
  • Customize Excel's default settings for effective modeling.

2. Formatting and Structuring Financial Models:
  • Learn standard modeling structures and formulas.
  • Best practices in modeling.
  • Check models for errors, accuracy and integrity.
  • Check and fix circular reference and iteration problems (#REF).
  • Tools for formula checking and auditing.

3. Presentation of Financial Statement Model:
  • Create a ratios page.Prepare a model for distribution.Summary and sensitivity analysis using data tables.

4. Building Core Statements:
  • Cash flow statement.
  • Balance sheet.
  • Income statement.
  • Supporting schedules (Debt schedule, Working capital, Interest schedule, Retained earnings, PP&E analysis).

Day 2:

1. Understanding the Interconnectivity of the Core Financial Statements:
  • Learn how the cash flow statement, income statement, and balance sheet are linked.
  • Learn to apply automatic "balance checks".
  • Treatment of non-recurring charges and tax implications on financial models.
  • Implications of new FASB regulations on financial models used by investment banks and other financial institutions.

2. DCF Modeling:
  • Valuation methodologies deconstructed.
  • Learn market-based valuation, including comparable company analysis and comparable transaction analysis using appropriate equity and enterprise value multiples (PE, EV/EBITDA, etc.).
  • Intrinsic valuation, including DCF and LBO (floor) valuation.
  • Presentation of valuation results using sensitivity analysis and data tables.
  • Enterprise value relationships.

3. M&A Modeling:
  • Building a robust merger model.
  • Setting up a control area for assumptions.
  • Inputting deal assumptions (% cash vs. stock considerations, purchase premium, asset write-ups, advisory fees, financing fees, and severance fees).
  • Calculating shares outstanding using the treasury stock method.
  • Allocating purchase price and calculating goodwill.
  • Preparing the pushed-down balance sheet.
  • Making pro forma balance sheet adjustments.
  • Calculating sources & uses of funds.
  • Inputting operating & synergy projections.
  • Calculating the stub year period.
  • Building a pro forma income statement and making appropriate deal-related adjustments to arrive at accretion/dilution per share.
  • Error-checking a merger model and inserting circuit breaker switches where appropriate.
  • Sensitivity analysis: EPS accretion/dilution in stock vs. cash deal; interest rate assumptions, premium paid.
  • Pre-tax synergies required to break-even, and break-even PE analysis.
  • Revenue, EBITDA, and Net Income contribution analysis.
  • Advanced merger accounting.
  • Understanding the differences between asset sales (including 338h10 elections) and stock sales.
  • Taxation issues, including deferred taxes created by the step-up of asset values.
  • Legal considerations in acquisitions.

Testimonials

"Wow, the Financial Statement Modeling bootcamp was amazing! The content was incredibly valuable and the instructors were very knowledgeable and engaging. I learned so much and feel much more confident in my financial modeling skills. Highly recommend!"
— Aarav
"I have taken several financial modeling courses, but this one was by far the best. The instructors were responsive and helpful, and the material was presented in a clear and concise manner. I particularly appreciated the emphasis on practical application and the use of real-world examples."
— Shivani
"As someone new to financial modeling, I was a bit intimidated going into this course. However, the instructors were patient and thorough, and the course material was very well organized. I feel much more comfortable with Excel now, and I have a much better understanding of financial modeling concepts. Thank you!"
— Kavya
"The DCF Modeling section of this bootcamp was especially helpful for me. The instructors did an excellent job of explaining complex concepts in a way that was easy to understand, and the hands-on exercises were very effective. I feel much more confident in my ability to perform DCF valuations now."
— Ved
"I really appreciated the focus on M&A Modeling in this bootcamp. The instructors were very knowledgeable and provided a lot of helpful insights. The exercises were challenging but rewarding, and I feel like I gained a lot of valuable experience in modeling merger transactions."
— Riya

Why Choose Our Boot Camp?

Comprehensive Training

Our boot camps are the same rigorous training that top financial institutions use to prepare incoming analysts. You'll receive comprehensive and intensive instruction to ensure you're fully equipped to tackle the challenges of the job.

Learn by Doing

Our "learn by doing" approach allows you to gain hands-on experience by working through practical exercises and building financial models from scratch using real-life case studies. You'll be able to apply your newly acquired knowledge immediately.

Networking Opportunity

Our boot camps provide a unique opportunity to network with other professionals from a range of industries, including investment banking, corporate development, and FP&A. You'll have the chance to build relationships and expand your professional network.

Experienced Instructors

Our instructor-practitioners are experienced bankers who bring real-world context to the training by connecting it to their own experience on the desk. You'll benefit from their expertise and learn from their practical examples.

Excel Mastery

Excel is an essential tool for investment banking analysts. Our training focuses on reinforcing speed, efficiency, and consistency in Excel, ensuring that you have the necessary skills to succeed from day one.

Continuing Ed & Webinars

Enrollment in most of our boot camps includes access to our continuing education online training platform and webinar series. You'll be able to continue your professional development long after the boot camp has ended.

Questions? We're Standing By.

To learn more about this boot camp, fill out the form below

Created with