16. Working capital management/1. Introduction.mp412.36MB
16. Working capital management/10. Symptoms of inefficient working capital - Trade payables.mp44.04MB
16. Working capital management/11. Symptoms of inefficient working capital - Trade receivables.mp43.48MB
16. Working capital management/2. The importance of working capital optimization case study.mp418.31MB
16. Working capital management/3. Overtrading vs. excessive investment.mp47.49MB
16. Working capital management/4. Trade receivables management.mp416.29MB
16. Working capital management/5. Re-order level.mp46.94MB
16. Working capital management/6. Economic order quantity (EOQ).mp47.36MB
16. Working capital management/7. Inventory optimization techniques.mp410.57MB
16. Working capital management/8. Trade payables management.mp44.35MB
16. Working capital management/9. Working capital optimization - a roadmap.mp411.2MB
17. Capital budgeting - The theory behind capital budgeting/1. An introduction to capital budgeting.mp45.43MB
17. Capital budgeting - The theory behind capital budgeting/10. Forecasting future cash flows.mp418.8MB
17. Capital budgeting - The theory behind capital budgeting/2. Why companies need capital budgeting.mp46.89MB
17. Capital budgeting - The theory behind capital budgeting/3. The time value of money in a capital budgeting exercise.mp46.69MB
17. Capital budgeting - The theory behind capital budgeting/4. Working with present and future cash flows.mp413.08MB
17. Capital budgeting - The theory behind capital budgeting/5. Calculating cost of debt and cost of equity.mp419.2MB
17. Capital budgeting - The theory behind capital budgeting/6. An important subtlety - project-specific beta.mp49MB
17. Capital budgeting - The theory behind capital budgeting/8. Calculating WACC.mp45.5MB
17. Capital budgeting - The theory behind capital budgeting/9. How to treat the value of residual assets at the end of the project.mp49.33MB
18. Capital budgeting - A complete case study/1. An introduction to the case study.mp48.62MB
18. Capital budgeting - A complete case study/10. Calculating cost of equity.mp413.92MB
18. Capital budgeting - A complete case study/11. Discounting cash flows.mp425.91MB
18. Capital budgeting - A complete case study/12. Performing sensitivity analysis.mp443.07MB
18. Capital budgeting - A complete case study/2. Going through the 'Drivers' sheet.mp411.05MB
18. Capital budgeting - A complete case study/3. Forecasting the savings that will be generated by the project.mp49.2MB
18. Capital budgeting - A complete case study/4. Performing a fixed asset roll forward.mp412.15MB
18. Capital budgeting - A complete case study/5. Forecasting working capital needs.mp45.36MB
18. Capital budgeting - A complete case study/6. Modeling the project's financing.mp46.19MB
18. Capital budgeting - A complete case study/7. Creating a P&L sheet.mp44.89MB
18. Capital budgeting - A complete case study/8. Cash flow calculation.mp410.14MB
18. Capital budgeting - A complete case study/9. Calculating the discount rate we will use - WACC.mp410.24MB
19. Financial reporting in Excel - Introduction to Pivot tables/1. Introduction to Pivot tables.mp44.89MB
19. Financial reporting in Excel - Introduction to Pivot tables/2. Structuring a Pivot table.mp412.07MB
19. Financial reporting in Excel - Introduction to Pivot tables/3. Pivot table formatting.mp47.69MB
19. Financial reporting in Excel - Introduction to Pivot tables/4. Modifying a Pivot table's content.mp413.77MB
19. Financial reporting in Excel - Introduction to Pivot tables/5. Using GETPIVOTDATA.mp410.18MB
19. Financial reporting in Excel - Introduction to Pivot tables/6. Learn how to work with slicers.mp414.19MB
2. What does it mean to be a finance manager/1. How we measure financial performance.mp410.54MB
2. What does it mean to be a finance manager/2. Improving performance measurement and collecting data.mp415.91MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/1. Introduction to the Case Study.mp47.9MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/10. Improving the layout of the slicers we added.mp410.45MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/11. How the dashboard can be used in practice.mp411.42MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/2. Understanding the source data.mp411.26MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/3. Mapping of the source data.mp411.89MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/4. Setting up a structure for the dashboard we'll create.mp48.05MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/5. Working on the dashboard's layout.mp49.62MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/6. Inserting calculation formulas.mp46.66MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/7. Creating the source Pivot table.mp48.28MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/8. Using GETPIVOTDATA to connect the Pivot table and the dashboard.mp419.03MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/9. Adding slicers and making our dashboard interactive.mp410.71MB