16. Working capital management/1. Introduction.mp412.36MB
16. Working capital management/10. Symptoms of inefficient working capital - Trade payables.mp44.05MB
16. Working capital management/11. Symptoms of inefficient working capital - Trade receivables.mp43.47MB
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.3MB
16. Working capital management/5. Re-order level.mp46.95MB
16. Working capital management/6. Economic order quantity (EOQ).mp47.36MB
16. Working capital management/7. Inventory optimization techniques.mp410.58MB
16. Working capital management/8. Trade payables management.mp44.36MB
16. Working capital management/9. Working capital optimization - a roadmap.mp411.21MB
17. Capital budgeting - The theory behind capital budgeting/1. An introduction to capital budgeting.mp45.44MB
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.21MB
17. Capital budgeting - The theory behind capital budgeting/6. An important subtlety - project-specific beta.mp49.01MB
17. Capital budgeting - The theory behind capital budgeting/8. Calculating WACC.mp45.51MB
17. Capital budgeting - The theory behind capital budgeting/9. How to treat the value of residual assets at the end of the project.mp49.34MB
18. Capital budgeting - A complete case study/1. An introduction to the case study.mp48.63MB
18. Capital budgeting - A complete case study/10. Calculating cost of equity.mp413.93MB
18. Capital budgeting - A complete case study/11. Discounting cash flows.mp422.57MB
18. Capital budgeting - A complete case study/12. Performing sensitivity analysis.mp434.12MB
18. Capital budgeting - A complete case study/2. Going through the 'Drivers' sheet.mp411.06MB
18. Capital budgeting - A complete case study/3. Forecasting the savings that will be generated by the project.mp49.21MB
18. Capital budgeting - A complete case study/4. Performing a fixed asset roll forward.mp412.16MB
18. Capital budgeting - A complete case study/5. Forecasting working capital needs.mp45.37MB
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.88MB
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.25MB
19. Financial reporting in Excel - Introduction to Pivot tables/1. Introduction to Pivot tables.mp44.9MB
19. Financial reporting in Excel - Introduction to Pivot tables/2. Setting up the structure of 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.78MB
19. Financial reporting in Excel - Introduction to Pivot tables/5. Using GETPIVOTDATA.mp410.19MB
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.55MB
2. What does it mean to be a finance manager/2. Improving performance measurement and collecting data.mp415.9MB
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 will create.mp48.05MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/5. Working on the dashboard's layout.mp49.63MB
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.29MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/8. Using GETPIVOTDATA to connect the Pivot table and the dashboard.mp419.04MB
20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)/9. Adding slicers and making our dashboard interactive.mp410.72MB