Certified Investment Banking (Starting on 18th Jan 2025)

What You Will Learn ?

• Master Microsoft Excel and its advanced features
• Execute regular tasks quicker
• Creating financial statements from scratch from raw data
• Financial Statement and Ratio Analysis
• Acquire financial modeling skills
• Create models with multiple scenarios
• Design professional advanced charts
• Project Finance
• Interest and rent capitalization
• Debt sizing – Sculpted method and DSCR method
• Cash Waterfall
• Revolving Credit Facility (RCF)
• Real Estate Sector Financial Modeling
• Renewable Energy – Solar Financial Modeling
• Infrastructure Sector Financial Modeling
• VBA used in financial modeling
• Calculation of Equity IRR, Project IRR, NPV, Payback period, Break-even point
• Sensitivity Analysis and Data Tables
• Learn how to value a company
• DCF valuation method
• Relative valuation method
• Build valuation models from scratch

Requirements

You just need a laptop with a good internet connection and Microsoft Excel.

Description

Why Financial Modeling and Valuations?

Financial modeling and Valuation are the most important skills that are mandatory for everyone who wants to build a career in finance. It is also very important for anyone who wants to start his or her own business to ascertain whether the venture is going to be profitable or not.

Every time we need to make a financial decision, we predict the revenue that will be produced and the expenditures that will likely be paid, then we assess if that is a good choice based on those projections. To determine whether to purchase, sell, or keep a particular piece of stock, a stock market analysis uses a company’s historical performance to predict future sales, expenses, and profits.