INTRODUCTION

Course Description:

This Private Equity Training course has been designed to provide a detailed overview of the Private Equity Industry. It will explain the concepts of Limited Partners and General Partners, Term Sheets and Deal Structuring; further the tutorials would teach you to perform financial modeling of private companies proficiently. This comprehensive course will guide you in subjects like learning Microsoft excel, Micro and Macroeconomics, Corporate Finance and Valuation, apart from Private Equity.

By joining this private equity training tutorial you would benefit by:

• Learning intellectual framework of Private Equity dealing such as the LP-GP‚ Private equity funds structure‚ Term Sheet‚ Deal Structuring‚ Valuation of Private Companies‚ Due Diligence
• Building a Private Equity Model
• Corporate Finance foundation and Valuation techniques.
• Understand economics and its impact on Stock Markets.

Who should join Private Equity Training?

• Professionals who want to pursue a career in the Private Equity industry
• For those who want to earn credit hours.
• Students pursuing Degree, Diploma, Engineering and commerce who want to make a career in finance/Fixed Income market.
• MBA in Finance, BBA in Finance

Prerequisites for taking Private Equity Training:

• None
• Desire to learn

Highlights of Private Equity Training:

• Excel Proficiency For Private Equity

In your career in finance as a professional, excel will be used in everyday life. Through this excel module you will understand about various excel functions which help you to save a lot of time. You will learn how to create different research charts and graphs in excel. You will learn to create List Boxes and Combo Boxes, scroll bars etc.

• Basic and advanced Accounting

Knowledge of Accounting is a must for every individual. Through this course you will be able to learn different accounting terms and accounting concepts in detail like What is income statement, balance sheet and cash flow statement, how do you prepare the financial statement, what are the different ratios to analyze the financial statements etc.

• Micro Macro Economics

Learn different concepts about macro and micro economics like Demand Supply Analysis, Perfect Competition, Monetary and Fiscal Policy, International Trade and Capital Flows, Currency Exchange Rates, Monitoring Jobs and the Price Level etc.

• Corporate Finance Foundation

Corporate finance allows you to value a project based on the time value of money. You will understand different important corporate finance concepts like payback period, NPV, IRR etc.

• Corporate Valuation

It is very important to give a correct value to a company’s equity. So through this course we will understand different valuation concepts like DCF, DDM, Relative valuation, Private Equity Valuation Approaches etc.

• Private Equity Modeling

Private equity can be broadly defines as privately negotiated transactions in public or private companies. Private equity market is an important source of funds for startup firms, private middle – market firms, firms in financial distress, and public firms seeking buyout financing. So through this module we will learn in detail about Private equity market, Understand the Fund Economics, Fund Structure and Investment Process, Deal Structuring, Constructing a Term Sheet etc. We will also learn to analyze various input parameters and prepare private equity financial modeling .

Benefits of online course:

• High Quality Content
• Learn Anywhere Anytime & at Your Pace
• 24X7 Customer Support
• Complete Student Support Throughout The Program
• Course Completion Certificate 
• Lifetime course access

For any query feel free to call

Mob - +918587999769/9818826705

CURRICULUM

Section 1: Excel Proficiency For Private Equity

1. Formatting a Financial Model
2. Paste Special Function
3. Logical functions ANDORIF
4. Arithmetic functions ABS INT LARGE MAX MIN SMALL TRUNCATE
5. Date functions DATE WEEKDAY
6. Learn to convert text to string
7. Auto Filter
8. Pivot Tables
9. Printing Setup Options
10. Comments
11. Grouping Tabs
12. Conditional Formatting
13. Protecting Worksheet
14. Data Validation
15. Cell Information
16. Creating text to column
17. Learn to convert text to string
18. Learn subtotal function
19. Check Boxes
20. Hyperlinks
21. List Boxes and Combo Boxes
22. Scroll Bar and Spinners
23. Group Boxes and Options Button

Section 2: Advanced Excel For Analysts

1. CHOOSE Function
2. VLOOKUP Function
3. HLOOKUP
4. Limitations of VLOOKUP
5. Match Index
6. Database Functions DSUM DAVERAGE DCOUNT
7. Using basic OFFSET Function
8. Dynamic Sum using OFFSET function
9. Days Today Weekday Workday Year Frac
10. Day Date Dated if network days
11. Count if Count A Count blank
12. Forecast Function Part1 2
13. One Dimensional Data Tables
14. Two dimensional Data Tables
15. Goal Seek
16. Watch Window
17. Solver
18. Adding an average
19. Creating histograms
20. Creating bar to pie charts
21. Creating Combo Charts
22. Dynamic Charts
23. Invert Negative in Chart
24. Creating scrolling charts
25. Creating thermometer charts
26. Creating Delta Charts
27. Understanding the PE Data
28. Creating the PE Graph
29. Google Inc PE Ratio Graph
30. Understanding the PE Band Chart Data
31. PE Band Chart Continued
32. Google Inc PE Band Chart
33. Setting up the Range Charts Part 1
34. Setting up the Range Charts Part 2
35. Setting up the Area Chart Part 1
36. Setting up the Area Chart Part 2
37. Funding Graph
38. Two Axis Graphs Part 1 and 2
39. Setting up Scenario Graph Part 1
40. Setting up Scenario Graph Part 2

Section 4: Accounting Foundation

1. Introduction to Accounting
2. Explaining a Business Cycle
3. Accounting for Income Statement
4. Accounting for Balance sheet
5. Accounting for Cash Flows
6. Financial Statement Analysis
7. Dividends and Share Repurchases Basics Part 1
8. Dividends and Share Repurchases Basics Part 2
9. Dividends and Share Repurchases Basics Part 3
10. Dividends and Share Repurchases Basics Part 4
11. Dividends and Share Repurchases Basics Part 5
12. Dividends and Share Repurchases Basics Part 6
13. Horizontal Analysis Vertical Analysis
14. Ratio Analysis Solvency Ratios Cash Conversion Cycle
15. Ratio Analysis Asset Turnovers
16. Ratio Analysis Operating Leverage Financial Leverage
17. Ratio Analysis ROE and Dupont Analysis
18. Ratio Analysis Case Study on Retail Sector
19. Navigating Google Asian Paints Annual Reports 1
20. Navigating Google Asian Paints Annual Reports 2
21. Navigating Google Asian Paints Annual Reports 3
22. Navigating Google Asian Paints Annual Reports 4
23. Navigating Google Asian Paints Annual Reports 5
24. Income Statement Ratio Analysis
25. BS Calculation of Solvency Ratios
26. BS Working Capital Receivables Inventory Turnover
27. BS Working Capital Payables Turnover
28. BS Cash Conversion Cycle
29. IS BS Calculation of Operating Efficiencies
30. IS BS Dupont Analysis
31. IS BS Financial Risk Ratios
32. ACC Cement Ratio Analysis part 1
33. ACC Cement Ratio Analysis part 2
34. ACC Cement Du Pont Analysis
35. Ultratech Cement Ltd Ratio Analysis
36. DuPont Analysis Ultratech Cement Ltd.

Section 5: Advanced Accounting For Analysts

1. LIFO FIFO method and analytical adjustments 1
2. LIFO FIFO method and analytical adjustments 2
3. LIFO FIFO method and analytical adjustments 3
4. LIFO FIFO method and analytical adjustments 4
5. LIFO FIFO method and analytical adjustments 5
6. Changes in Depreciation policy and analytical adjustments
7. Operating Leases Financial Leases 1
8. Operating Leases Financial Leases 2
9. Operating Leases Financial Leases 3
10. Operating Leases Financial Leases 4
11. Capitalization vs Expensing RD and Intangibles 1
12. Capitalization vs Expensing RD and Intangibles 2
13. Deferred Tax Assets Liabilities 1
14. Deferred Tax Assets Liabilities 2
15. Real Estate Financial Items Part 1
16. Real Estate Financial Items Part 2
17. Accounting Treatment of Real Estate Leases Part 1
18. Accounting Treatment of Real Estate Leases Part 2
19. Accounting Treatment of Real Estate Leases Part 3
20. Assetlevel vs Leaselevel Modelling
21. Taxes in Real Estate
22. Accounting Adjustments for NAV Calculations Part 1
23. Accounting Adjustments for NAV Calculations Part 2
24. Accounting Adjustments for NAV Calculations Part 3
25. Closure look at Annual Report analysing Balance Sheet Equity
26. Equity Analysisng Profit and Loss
27. Accounting for M A
28. Financial Reporting Quality
29. Accounting Shenanigans on the Cash Flow Statement
30. International Standards Convergence

Here is a sample for the course completion certificate which you will receive after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.

Mail us at: [email protected] with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address