Financial Modeling is one the most fundamental and widely sought after skills in the finance industry. It is the art of building a model to depict financial statements and investment analysis using MS Excel. This helps arrive at optimal business solutions by analyzing various parameters. Financial models can be used to represent the performance of a business, a project or any other investment. In todays world, all decisions made are based on quantitative analysis. This is why Investment Bankers, Equity Research Analysts and Fund Managers find Financial Modeling indispensable.

Topics Covered

Topics Covered Financial Modeling in Excel Understanding Integrated Financial Models Scenario Analysis Excel Efficiency Shortcuts and formulae Cash and Interest Revolver Building Historical Financial Statements Ratio Analysis Projecting Financial Statements Valuation DCF and Comps Financial Modeling - Bonus Week Tutorial for modeling the LinkedIn IPO Short cases on Credit Risk Download case on Offset for scenarios Project Finance Modeling Real Estate (Commercial) Excel Efficiency Shortcuts and formulae a Commercial Real Estate Project Building Area Assumptions Capex and funding Schedules Circular references and modeling IDC Building Revenue and NOI schedule Modeling Valuation, IRR, Equity Returns Modeling Delays in Projects Modeling Cash flow Waterfall Scenario Analysis for key project parameters

Who should attend

This program is suitable for people in Investment banking, Project management, Equity research, Business planning &strategy, Private equity funds or commercial banking. It is also ideal for CA, CFA, FRM, MBA Finance, B .TECH and Commerce Graduates who want a career in any of the above profiles.

Pre-requisites

Using Macros for Financial Modeling

What you need to bring

Financial Modelling notes

Key Takeaways

Typically such profiles would include: Investment Bankers Commercial bankers Project finance People Equity Research PE VCs Consultants involved in strategy and business planning