What Will I Learn
At the end of this course you will:
|
Curriculum
- 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
How It works
|
Live Online Sessions Each session is interactive and informative, featuring case studies, quizzes and projects |
|
Interact, Learn and Grow bsevarsity.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 Get Certified from bsevarsity.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