What will I learn?
At the end of this course you will:
Curriculum - Using Financial Modelling for Analysis and Valuation
- Formatting the data, summarizing, and creating a presentable format.
- Manipulating Text and Numerical Data
- Using Pivot Tables to Sumerize Data
- Converting data into tabular format
- Identify high profit sales using conditional formatting
- Excel Best Practices
- Inputs/Assumptions Worksheet
- Preparing the 3 Financial Statements
- Preparing Depreciation & Amortization Schedule
- Preparing Debt Schedule
- Other Working Notes
- Understand the Business Model and Operating Model
- Modeling the Historical Statement
- Modeling Assumptions for Future Action
- Modeling Revenue Build-up – projecting the future revenues
- Modeling Cost Build-up – projecting the future cost
- Modeling the Asset Schedule
- Modeling the Depreciation Schedule – Book and Income Tax Depreciation
- Working Capital and Term Loan Modelling – Debt Infusion
- Equity Modelling – Equity Infusion
- WACC and Cost of Equity Analysis
- Performing Valuation using DCF
- Performing Sensitivity/Scenario Analysis
- Comparing the Valuation Summary using Different Parameters
Curriculum - Certificate Program on Investment Banking
- Introducing Investment Banking
- How Investment Bankers Sell Companies
- Role of Investment Banking in Mergers and Acquisition
- How Investment Banking Is Used in Leveraged Buyouts
- Finding Data - Document and reports.
- Making Sense of Financial Statements
- Perfecting the Financial Ratios for Investment Banking
- Sizing up the Industry.
- Understanding Stocks and Focusing on Past Transactions.
- Applying Investment Banking to Fixed Income
- Doing a Discounted Free Cash Flow Analysis
- Structuring a Leveraged Buyout.
- Determining The Strength Of A Company’s Return On Equity
- Return on Equity
- Knowing the rules
How It works
Live Online Sessions
Each session is interactive and informative, featuring case studies, quizzes, and projects
Interact, Learn and Grow
bsevarisity.com enables you to master the concepts, interact with expert faculty and other learners, and be a part of the community whilst growing.
Get Certified from bsevarisity.com. Share your success with the world
Training 5 or more people?
We provide custom courses and group sessions as well. To know more about our Customized Programs.
Try BSE Business Click here