种子简介

种子名称： [FreeAllCourse.Com] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation
文件类型： 视频
文件数目： 210个文件
文件大小： 3.9 GB
收录时间： 2020-1-19 00:31
已经下载： 3次
资源热度： 198
最近下载： 2024-5-8 02:30

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:a48fb43c3535bdb21c9f85718a694476bc609572&dn=[FreeAllCourse.Com] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeAllCourse.Com] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation.torrent

1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp48.94MB

1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.mp417.62MB

10. Introduction to Excel charts/1. How to insert a chart in Excel.mp422.27MB

10. Introduction to Excel charts/2. Editing Excel charts.mp426.05MB

10. Introduction to Excel charts/3. Excel chart formatting.mp432.74MB

10. Introduction to Excel charts/4. How to create a bridge chart in Excel.mp413.66MB

10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.mp411.49MB

10. Introduction to Excel charts/6. Sparklines.mp427.56MB

11. P&L Case Study continued - Let's create some great-looking professional charts/1. Create professional and good-looking charts - Introduction.mp46.2MB

11. P&L Case Study continued - Let's create some great-looking professional charts/2. Build a column stacked chart with a secondary line axis in Excel.mp446.37MB

11. P&L Case Study continued - Let's create some great-looking professional charts/3. Learn how to build effective doughnut charts in Excel.mp438MB

11. P&L Case Study continued - Let's create some great-looking professional charts/4. Learn how to build an area chart in Excel.mp428.58MB

11. P&L Case Study continued - Let's create some great-looking professional charts/5. Learn how to create bridge charts.mp452.07MB

11. P&L Case Study continued - Let's create some great-looking professional charts/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4136.11MB

11. P&L Case Study continued - Let's create some great-looking professional charts/8. Course Challenge - Apply your skills in practice!.mp47.92MB

12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp412.05MB

12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.mp417.83MB

12. Case Study - Building an FMCG Model from Scratch/11. Getting fancy with Excel slicers - Good-looking Excel slicers.mp417.11MB

12. Case Study - Building an FMCG Model from Scratch/12. This is how the report can be used in practice by high-level executives.mp419.8MB

12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp422.6MB

12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp421.95MB

12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp411.65MB

12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp413.5MB

12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp48.83MB

12. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.mp413.82MB

12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp431.04MB

12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.mp413.76MB

13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.mp42.09MB

13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.mp46.43MB

13. Financial Modeling Fundamentals/12. Modeling the Income statement.mp412.43MB

13. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.mp45.22MB

13. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.mp49.38MB

13. Financial Modeling Fundamentals/2. What is a financial model.mp44.6MB

13. Financial Modeling Fundamentals/3. Why use financial models.mp47.69MB

13. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.mp419.92MB

13. Financial Modeling Fundamentals/5. Financial modeling - best practices.mp417.22MB

13. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.mp412.51MB

13. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.mp45.69MB

13. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.mp46.44MB

16. Learn how to build a Discounted Cash Flow model in Excel/1. Valuation Case study - Welcome lecture.mp41.78MB

16. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp430.01MB

16. Learn how to build a Discounted Cash Flow model in Excel/11. Forecasting Balance sheet items.mp44.66MB

16. Learn how to build a Discounted Cash Flow model in Excel/12. An introduction to the Days methodology.mp410.08MB

16. Learn how to build a Discounted Cash Flow model in Excel/13. Calculation of DSO, DPO and DOI for the historical period.mp412.11MB

16. Learn how to build a Discounted Cash Flow model in Excel/14. Forecasting DSO, DPO and DOI.mp420.86MB

16. Learn how to build a Discounted Cash Flow model in Excel/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp422.62MB

16. Learn how to build a Discounted Cash Flow model in Excel/16. Creating an output P&L sheet.mp418.8MB

16. Learn how to build a Discounted Cash Flow model in Excel/17. Populating the output P&L sheet.mp425.53MB

16. Learn how to build a Discounted Cash Flow model in Excel/18. Populating the output BS sheet.mp416.93MB

16. Learn how to build a Discounted Cash Flow model in Excel/19. Completing the output BS sheet for the historical period.mp438.03MB

16. Learn how to build a Discounted Cash Flow model in Excel/2. Introduction to the DCF exercise.mp47.87MB

16. Learn how to build a Discounted Cash Flow model in Excel/20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp422.76MB

16. Learn how to build a Discounted Cash Flow model in Excel/21. Bridging Unlevered free cash flow to Net cash flow.mp414.58MB

16. Learn how to build a Discounted Cash Flow model in Excel/22. Calculating Unlevered free cash flow.mp459.72MB

16. Learn how to build a Discounted Cash Flow model in Excel/23. Calculating Net cash flow.mp437.9MB

16. Learn how to build a Discounted Cash Flow model in Excel/24. Obtaining the rest of the cash flows through Find and Replace.mp446.73MB

16. Learn how to build a Discounted Cash Flow model in Excel/25. Introducing Weighted average cost of capital and Perpetuity growth.mp413.2MB

16. Learn how to build a Discounted Cash Flow model in Excel/26. Discounting Unlevered free cash flows to obtain their Present value.mp420.22MB

16. Learn how to build a Discounted Cash Flow model in Excel/27. Calculating Continuing value and Enterprise value of the business.mp417.72MB

16. Learn how to build a Discounted Cash Flow model in Excel/28. Calculating Equity value.mp412.2MB

16. Learn how to build a Discounted Cash Flow model in Excel/29. Sensitivity analysis for WACC and perpetuity growth.mp440.48MB

16. Learn how to build a Discounted Cash Flow model in Excel/3. The stages of a complete DCF Valuation.mp449.24MB

16. Learn how to build a Discounted Cash Flow model in Excel/30. A possible application of Goal seek.mp415.62MB

16. Learn how to build a Discounted Cash Flow model in Excel/31. Using charts to summarize the results of the DCF model.mp432.88MB

16. Learn how to build a Discounted Cash Flow model in Excel/32. You made it!.mp411.26MB

16. Learn how to build a Discounted Cash Flow model in Excel/4. Description of the structure of the DCF model.mp418.53MB

16. Learn how to build a Discounted Cash Flow model in Excel/5. A glimpse at the company we are valuing - Cheeseco.mp415.67MB

16. Learn how to build a Discounted Cash Flow model in Excel/6. Modeling the top line.mp426.3MB

16. Learn how to build a Discounted Cash Flow model in Excel/7. Introducing scenarios to the model with Choose.mp417.83MB

16. Learn how to build a Discounted Cash Flow model in Excel/8. Modeling other items Other revenues and Cogs.mp444.56MB

16. Learn how to build a Discounted Cash Flow model in Excel/9. Modeling other items Operating expenses and D&A.mp426.33MB

17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp431MB

17. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.mp425.3MB

17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp426.81MB

17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp434.91MB

17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp456.58MB

17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp454.2MB

17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.mp413.61MB

17. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.mp417.51MB

17. Tesla valuation - Complete practical exercise/17. Producing a clean P&L output sheet.mp48.43MB

17. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.mp418.34MB

17. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.mp419.04MB

17. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp415.8MB

17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.mp455.93MB

17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.mp445.24MB

17. Tesla valuation - Complete practical exercise/22. Forecasting other liabilities.mp421.97MB

17. Tesla valuation - Complete practical exercise/23. Completing Unlevered free cash flow.mp440.88MB

17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.mp442.36MB

17. Tesla valuation - Complete practical exercise/25. Calculating Net income.mp414.8MB

17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.mp450.72MB

17. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.mp413.26MB

17. Tesla valuation - Complete practical exercise/28. Estimating Weighted average cost of capital (WACC).mp444.26MB

17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).mp434.9MB

17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4114.9MB

17. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.mp422.55MB

17. Tesla valuation - Complete practical exercise/31. Final comments.mp444.88MB

17. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.mp420.93MB

17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp441.92MB

17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp446.56MB

17. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.mp417.17MB

17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp427.76MB

17. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.mp417.5MB

18. Capital budgeting - The theory/1. Introduction to Capital budgeting.mp45.44MB

18. Capital budgeting - The theory/2. Why we need Capital budgeting.mp46.89MB

18. Capital budgeting - The theory/3. The time value of money.mp46.7MB

18. Capital budgeting - The theory/4. Calculating future and present Value.mp413.09MB

18. Capital budgeting - The theory/5. Calculating cost of equity.mp419.21MB

18. Capital budgeting - The theory/6. Coming up with project-specific beta.mp49MB

18. Capital budgeting - The theory/7. Weighted average cost of capital (WACC).mp45.5MB

18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.mp49.34MB

18. Capital budgeting - The theory/9. Estimating the project's cash flows.mp418.79MB

19. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital budgeting exercise.mp48.62MB

19. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.mp413.92MB

19. Capital Budgeting - A Complete Case Study/11. Discounting the project's cash flows and residual value.mp425.9MB

19. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.mp443.04MB

19. Capital Budgeting - A Complete Case Study/14. Congratulations!!.mp42.3MB

19. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.mp411.05MB

19. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp49.21MB

19. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.mp412.15MB

19. Capital Budgeting - A Complete Case Study/5. The impact of working capital.mp45.36MB

19. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.mp46.18MB

19. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.mp44.88MB

19. Capital Budgeting - A Complete Case Study/8. Calculating project cash flows.mp410.14MB

19. Capital Budgeting - A Complete Case Study/9. Estimating the weighted average cost of capital (WACC).mp45.58MB

2. Introduction to Excel/1. Introduction to Excel.mp41.99MB

2. Introduction to Excel/11. Introduction to Excel functions.mp412.05MB

2. Introduction to Excel/12. Cut, copy, & paste.mp47.56MB

2. Introduction to Excel/14. Paste special.mp46.7MB

2. Introduction to Excel/2. Overview of Excel.mp413.95MB

2. Introduction to Excel/4. Basic manipulations with rows and columns.mp46.91MB

2. Introduction to Excel/6. The Excel ribbon.mp48.8MB

2. Introduction to Excel/7. Data entry in Excel.mp410.39MB

2. Introduction to Excel/8. Introduction to formatting.mp424.75MB

2. Introduction to Excel/9. Introduction to Excel formulas.mp418.76MB

3. Useful tips and tools for your work in Excel/1. Excel best practices - Welcome lecture.mp42.13MB

3. Useful tips and tools for your work in Excel/11. Learn how to use the Wrap Text button.mp4908.39KB

3. Useful tips and tools for your work in Excel/12. Create easily printable documents in Excel by using Set Print Area.mp41.71MB

3. Useful tips and tools for your work in Excel/13. Find and select special types of cells with Select Special (F5).mp43.04MB

3. Useful tips and tools for your work in Excel/15. Learn how to assign dynamic names within a financial model.mp42.33MB

3. Useful tips and tools for your work in Excel/17. Define a named range in Excel.mp42.11MB

3. Useful tips and tools for your work in Excel/18. Assign custom formats to specific cells within a financial model (e.g Multiples).mp42.14MB

3. Useful tips and tools for your work in Excel/19. Macros are a great timesaver! Here's why!.mp44.34MB

3. Useful tips and tools for your work in Excel/2. Initial formatting of an Excel sheet to render it professional.mp43.35MB

3. Useful tips and tools for your work in Excel/20. How to save macros and use them across several workbooks.mp412.78MB

3. Useful tips and tools for your work in Excel/22. Create a drop-down list by using Data Validation.mp43.29MB

3. Useful tips and tools for your work in Excel/23. Using Custom-sort in order to sort multiple columns within a table.mp42.79MB

3. Useful tips and tools for your work in Excel/24. Create a great Index page at the beginning of your models - Hyperlinks.mp41.9MB

3. Useful tips and tools for your work in Excel/25. Fix the top row of your table with Freeze Panes.mp45.2MB

3. Useful tips and tools for your work in Excel/26. Filter by color - an excellent tool.mp49.87MB

3. Useful tips and tools for your work in Excel/27. Working with conditional formatting.mp415.08MB

3. Useful tips and tools for your work in Excel/28. A neat trick - Multiply by 1.mp414.85MB

3. Useful tips and tools for your work in Excel/3. Fast scrolling through Excel sheets.mp46.26MB

3. Useful tips and tools for your work in Excel/30. Find and replace - references.mp424.03MB

3. Useful tips and tools for your work in Excel/31. Find and replace - formatting.mp413.78MB

3. Useful tips and tools for your work in Excel/32. Removing (automatic) green arrows.mp412.6MB

3. Useful tips and tools for your work in Excel/33. Beauty saving - The professional way of saving files.mp414.03MB

3. Useful tips and tools for your work in Excel/34. Formula auditing with F2.mp417.74MB

3. Useful tips and tools for your work in Excel/4. Be even quicker F5 + Enter.mp419.78MB

3. Useful tips and tools for your work in Excel/6. Introduction to fixing of cell references.mp46.12MB

3. Useful tips and tools for your work in Excel/8. Using the 'Alt + Enter' combination.mp41.46MB

3. Useful tips and tools for your work in Excel/9. Learn how to organize your data with Text to Columns.mp43.94MB

4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.mp430.43MB

5. Excel's key functions and functionalities made easy/1. Excel's key functions - Welcome lecture.mp42.31MB

5. Excel's key functions and functionalities made easy/11. Working with text in Excel.mp416MB

5. Excel's key functions and functionalities made easy/12. Find the minimum or maximum value in a range of cells in Excel.mp41.9MB

5. Excel's key functions and functionalities made easy/13. Include ROUND in your financial models.mp41.23MB

5. Excel's key functions and functionalities made easy/14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp412.11MB

5. Excel's key functions and functionalities made easy/15. How to enlarge the formula bar.mp46.26MB

5. Excel's key functions and functionalities made easy/16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp412.81MB

5. Excel's key functions and functionalities made easy/17. A great Excel technique INDEX, MATCH, MATCH.mp411.76MB

5. Excel's key functions and functionalities made easy/19. Using Excel's IFERROR function to trap spreadsheet errors.mp42.62MB

5. Excel's key functions and functionalities made easy/20. RANK is a valuable tool when using Excel for Financial and Business analysis.mp423.24MB

5. Excel's key functions and functionalities made easy/21. Learn how to render your models flexible with CHOOSE.mp43.4MB

5. Excel's key functions and functionalities made easy/22. Use Goal Seek to find the result that you are looking for.mp43.01MB

5. Excel's key functions and functionalities made easy/24. Include sensitivity analysis in your models through Data Tables.mp45.42MB

5. Excel's key functions and functionalities made easy/26. Excel's dynamic and interactive tables Pivot tables.mp423.19MB

5. Excel's key functions and functionalities made easy/3. Key functions in Excel IF.mp416.65MB

5. Excel's key functions and functionalities made easy/4. Key Excel functions SUM, SUMIF and SUMIFS.mp46.73MB

5. Excel's key functions and functionalities made easy/5. = and + are interchangeable when you start typing a formula.mp45.79MB

5. Excel's key functions and functionalities made easy/6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp46MB

5. Excel's key functions and functionalities made easy/7. Key Excel functions AVERAGE and AVERAGEIF.mp42.77MB

5. Excel's key functions and functionalities made easy/9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp46.3MB

6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.mp412.69MB

7. Financial functions in Excel/1. Future and present values in Excel.mp414.96MB

7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.mp47.57MB

7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.mp414.81MB

7. Financial functions in Excel/4. Date functions in Excel.mp411.35MB

8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.mp46MB

8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.mp419.37MB

8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.mp411.27MB

8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.mp423MB

8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GETPIVOTDATA - A very important Excel function.mp418.06MB

8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp422.16MB

9. Case study - Building a complete P&L from scratch in Excel/1. Case study - Build a P&L from scratch - Welcome lecture.mp43.14MB

9. Case study - Building a complete P&L from scratch in Excel/10. Use INDEX & MATCH as a substitute for VLOOKUP.mp449.58MB

9. Case study - Building a complete P&L from scratch in Excel/11. Mapping the rows in the Database sheet.mp432.48MB

9. Case study - Building a complete P&L from scratch in Excel/12. In case you have any doubts about the Mapping exercise.mp438.56MB

9. Case study - Building a complete P&L from scratch in Excel/13. Building the structure of the P&L sheet.mp420.85MB

9. Case study - Building a complete P&L from scratch in Excel/14. Formatting sets You apart from the competition in Excel - A Practical Example.mp425.42MB

9. Case study - Building a complete P&L from scratch in Excel/15. Populate the P&L sheet with SUMIF.mp430.26MB

9. Case study - Building a complete P&L from scratch in Excel/16. Learn how to find mistakes with COUNTIF.mp427.87MB

9. Case study - Building a complete P&L from scratch in Excel/17. Calculating year-on-year percentage variations the proper way.mp429.97MB

9. Case study - Building a complete P&L from scratch in Excel/2. Introduction to the case study.mp410.2MB

9. Case study - Building a complete P&L from scratch in Excel/3. Understand your data source before you start working on it.mp428.16MB

9. Case study - Building a complete P&L from scratch in Excel/4. Order the source worksheets.mp426.54MB

9. Case study - Building a complete P&L from scratch in Excel/5. Create a code the best way to organize your data and work efficiently with it.mp424.48MB

9. Case study - Building a complete P&L from scratch in Excel/6. Learn how to create a database.mp420.69MB

9. Case study - Building a complete P&L from scratch in Excel/7. Use VLOOKUP to fill the Database sheet.mp461.57MB

9. Case study - Building a complete P&L from scratch in Excel/8. 50% Completed!.mp44.3MB

9. Case study - Building a complete P&L from scratch in Excel/9. Use SUMIF to complete the Database sheet.mp447.94MB