ASA Corporate Catalyst India Private Limited

1. Future and present values in Excel

2. Calculating the rate of return of an investment with the IRR function

3. Calculating a complete loan schedule in Excel

4. Date functions in Excel

1. Introduction to Pivot Tables and the way they are applied

2. Creating Pivot Tables easily!

3. Give your Excel Pivot Tables a makeover

4. Modifying and pivoting fields to obtain the Pivot Table you need

5. Learn more about GETPIVOTDATA - A very important Excel function

6. An introduction to slicers - The modern-day Pivot Table filters

1. Case study - Build a P&L from scratch - Welcome lecture

2. Introduction to the case study

3. Understand your data source before you start working on it

4. Order the source worksheets

5. Create a code the best way to organize your data and work efficiently with it

6. Learn how to create a database

7. Use VLOOKUP to fill the database sheet

8. 50% completed!

9. Use SUMIF to complete the database sheet

11. Use INDEX & MATCH as a substitute for VLOOKUP

12. Mapping the rows in the database sheet

13. In case you have any doubts about the Mapping exercise

14. Building the structure of the P&L sheet

15. Formatting sets You apart from the competition in Excel - A Practical Example

16. Populate the P&L sheet with SUMIF

18. Learn how to find mistakes with COUNTIF

19. Calculating year-on-year percentage variations the proper way

1. How to insert a chart in Excel

2. Editing Excel charts

3. Excel chart formatting

4. How to create a bridge chart in Excel

5. New ways to visualize your data - Treemap charts

6. Sparklines

1. Create professional and good-looking charts - Introduction

2. Build a column stacked chart with a secondary line axis in Excel

3. Learn how to build effective doughnut charts in Excel

4. Learn how to build an area chart in Excel

5. Learn how to create bridge charts

6. Learn how to create bridge charts in Excel 2007, 2010, and 2013

8. Course Challenge - Apply your skills in practice!

1. Trend Analysis in Excel

2. Comparative Analysis in Excel

3. Value-based analysis in Excel

4. Correlation analysis in Excel

5. Time series analysis in Excel

6. Regression analysis in Excel

1. Introduction to the Case Study

2. Preliminary mapping of the data extraction

3. Working with an SAP data extraction

4. Creating an output structure of the FMCG model

5. Improving the layout and appearance of the FMCG report

6. Inserting formulas and automating calculations

7. Creating a Master Pivot Table The main data source for the FMCG report

8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table

9. A potential error with GETPIVOTDATA you might encounter and its fix

11. Combining Slicers and GETPIVOTDATA The key to our success

12. Getting fancy with Excel slicers - Good-looking Excel slicers

13. This is how the report can be used in practice by high-level executives

1. Financial modeling basics - Welcome lecture

2. What is a financial model

3. Why use financial models

4. Financial modeling - worst practices - things you should avoid

5. Financial modeling - best practices

6. Financial modeling - The types of models that are built in practice

8. Financial modeling The right level of detail in a model

9. Financial modeling Forecasting guidelines

11. Building a complete model - Important considerations

12. Modeling the Income statement

13. Modeling the Balance sheet - Part 1

14. Modeling the Balance sheet - Part 2

1. Valuation Case study - Welcome lecture

2. Introduction to the DCF exercise

3. The stages of a complete DCF Valuation

4. Description of the structure of the DCF model

5. A glimpse at the company we are valuing - Cheeseco

6. Modeling the top line

7. Introducing scenarios to the model with Choose

8. Modeling other items Other revenues and Cogs

9. Modeling other items Operating expenses and D&A

10. Modeling other items Interest expenses, Extraordinary items and Taxes

11. Forecasting Balance sheet items

12. An introduction to the Days methodology

13. Calculation of DSO, DPO and DOI for the historical period

14. Forecasting DSO, DPO and DOI

15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities

16. Creating an output P&L sheet

17. Populating the output P&L sheet

18. Populating the output BS sheet

19. Completing the output BS sheet for the historical period

20. Creating a structure for the calculation of Unlevered free cash flows

21. Bridging Unlevered free cash flow to Net cash flow

22. Calculating Unlevered free cash flow

23. Calculating Net cash flow

24. Obtaining the rest of the cash flows through Find and Replace

25. Introducing Weighted average cost of capital and Perpetuity growth

26. Discounting Unlevered free cash flows to obtain their Present value

27. Calculating Continuing value and Enterprise value of the business

28. Calculating Equity value

29. Sensitivity analysis for WACC and perpetuity growth

30. A possible application of Goal seek

31. Using charts to summarize the results of the DCF model

32. You made it!

1. Organizing external inputs in a 'Drivers' sheet

2. The input data we will work with

3. Forecasting Tesla's expected deliveries

4. Comparing delivery figures with the ones of industry peers

5. Estimating an average selling price of Tesla vehicles

6. Calculating automotive revenue

7. Peer comparison Gross profit %

8. Calculating automotive gross profit

9. Calculating automotive cost of sales

10. Forecasting 'energy' and 'services' revenue

11. Calculating 'energy' and 'services' gross profit and cost of sales

12. Forecasting operating expenses

13. Building a fixed asset roll forward estimating Capex

14. Building a fixed asset roll forward D&A schedule

15. Peer comparison D&A as a percentage of revenues

17. Calculating DSO, DIO, DPO

18. Producing a clean P&L output sheet

19. Fill in the P&L output sheet

20. Calculating investments in working capital

21. Forecasting Unlevered free cash flow

22. Forecasting other assets

23. Forecasting other liabilities

24. Completing Unlevered free cash flow

25. Modeling Tesla's financing needs in the forecast period

26. Calculating Net income

27. Bridging Unlevered free cash flow to Net cash flow

28. Balancing the Balance sheet

29. Estimating Weighted average cost of capital (WACC)

30. Performing discounted cash flow valuation (DCF)

31. Calculating enterprise value, equity value, and price per share

32. Final comments

1. Introduction to Capital budgeting

2. Why we need Capital budgeting

3. The time value of money

4. Calculating future and present value

5. Calculating cost of equity

6. Coming up with project-specific beta

7. Weighted average cost of capital (WACC)

8. The type of cash flows we will have in a project

9. Estimating the project's cash flows

1. Introduction to the Capital budgeting exercise

2. Organizing an Inputs sheet

3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy

4. Fixed asset rollforward

5. The impact of working capital

6. Modeling debt financing

7. Adding a P&L sheet

8. Calculating project cash flows

9. Estimating the weighted average cost of capital (WACC)

10. Finding cost of equity

11. Discounting the project's cash flows and residual value

12. Performing sensitivity analysis and completing the exercise

15. Congratulations!!

1. Overview of Excel

2. Basic manipulations with rows and columns

3. The Excel ribbon

4. Data entry in Excel

6. Introduction to Excel formulas

7. Introduction to Excel functions

8. Cut, copy, & paste

9. Paste special

5. Introduction to formatting

1. Initial formatting of an Excel sheet to render it professional

2. Fast scrolling through Excel sheets

3. Introduction to fixing of cell references

4. Learn how to use the Wrap Text button

5. Create a drop-down list by using Data Validation

6. Using Custom-sort in order to sort multiple columns within a table

7. Create a great Index page at the beginning of your models - Hyperlinks

8. Fix the top row of your table with Freeze Panes

9. Macros are a great timesaver! Here's why!

10. Find and select special types of cells with Select Special (F5)

11. Assign custom formats to specific cells within a financial model (e.g Multiples)

12. Define a named range in Excel

13. Learn how to organize your data with Text to Columns

14. Learn how to assign dynamic names within a financial model

15. Create easily printable documents in Excel by using Set Print Area

16. Using the 'Alt + Enter' combination

1. Keyboard shortcuts Save LOTS of time in Excel 2010

1. Key Excel functions SUM, SUMIF and SUMIFS

2. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS

3. Key Excel functions AVERAGE and AVERAGEIF

4. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE

5. Find the minimum or maximum value in a range of cells in Excel

6. Include ROUND in your financial models

7. Key Excel functions VLOOKUP and HLOOKUP

8. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP

9. Using Excel's IFERROR function to trap spreadsheet errors

10. Learn how to render your models flexible with CHOOSE

11. Use Goal Seek to find the result that you are looking for

12. Include sensitivity analysis in your models through Data Tables

13. Excel's dynamic and interactive tables Pivot tables