zhongziso
搜索
zhongziso
首页
首页
功能
磁力转BT
BT转磁力
关于
使用教程
免责声明
磁力助手
[FreeCourseSite.com] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation
magnet:?xt=urn:btih:cf7dd8960c6b7c655b414780d9e1f63299c7b247&dn=[FreeCourseSite.com] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation
磁力链接详情
文件列表详情
cf7dd8960c6b7c655b414780d9e1f63299c7b247
infohash:
188
文件数量
2.32 GB
文件大小
2019-1-21 23:11
创建日期
2024-6-26 10:11
最后访问
相关分词
FreeCourseSite
com
Udemy
-
Beginner
to
Pro
in
Excel
Financial
Modeling
and
Valuation
1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp4 8.95 MB
1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The approach to take this course.mp4 7.83 MB
10. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp4 12.05 MB
10. Case Study - Building an FMCG Model from Scratch/10. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 17.12 MB
10. Case Study - Building an FMCG Model from Scratch/11. This is how the report can be used in practice by high-level executives.mp4 19.81 MB
10. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp4 22.6 MB
10. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4 21.96 MB
10. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp4 11.66 MB
10. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp4 13.51 MB
10. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp4 8.83 MB
10. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.mp4 13.82 MB
10. Case Study - Building an FMCG Model from Scratch/8. GetPivotData is great! Extracting data from the Master Pivot Table.mp4 31.05 MB
10. Case Study - Building an FMCG Model from Scratch/9. Combining Slicers and GetPivotData The key to our success.mp4 17.83 MB
11. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.mp4 2.1 MB
11. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.mp4 6.44 MB
11. Financial Modeling Fundamentals/12. Modeling the Income statement.mp4 12.44 MB
11. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.mp4 5.22 MB
11. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.mp4 9.38 MB
11. Financial Modeling Fundamentals/2. What is a financial model.mp4 4.6 MB
11. Financial Modeling Fundamentals/3. Why use financial models.mp4 7.69 MB
11. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.mp4 19.91 MB
11. Financial Modeling Fundamentals/5. Financial modeling - best practices.mp4 17.22 MB
11. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.mp4 12.5 MB
11. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.mp4 5.68 MB
11. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.mp4 6.44 MB
14. Learn how to build a Discounted Cash Flow model in Excel/1. Valuation Case study - Welcome lecture.mp4 1.78 MB
14. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 5.14 MB
14. Learn how to build a Discounted Cash Flow model in Excel/11. Forecasting Balance Sheet items.mp4 1012.43 KB
14. Learn how to build a Discounted Cash Flow model in Excel/12. An introduction to the Days methodology.mp4 2.28 MB
14. Learn how to build a Discounted Cash Flow model in Excel/13. Calculation of DSO, DPO and DOI for the historical period.mp4 2.69 MB
14. Learn how to build a Discounted Cash Flow model in Excel/14. Forecasting DSO, DPO and DOI.mp4 3.95 MB
14. Learn how to build a Discounted Cash Flow model in Excel/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 4.73 MB
14. Learn how to build a Discounted Cash Flow model in Excel/16. Creating an output P&L sheet.mp4 3.74 MB
14. Learn how to build a Discounted Cash Flow model in Excel/17. Populating the output P&L sheet.mp4 5.36 MB
14. Learn how to build a Discounted Cash Flow model in Excel/18. Populating the output BS sheet.mp4 3.39 MB
14. Learn how to build a Discounted Cash Flow model in Excel/19. Completing the output BS sheet for the historical period.mp4 7.53 MB
14. Learn how to build a Discounted Cash Flow model in Excel/2. Introduction to the DCF exercise.mp4 4.5 MB
14. Learn how to build a Discounted Cash Flow model in Excel/20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4 4.07 MB
14. Learn how to build a Discounted Cash Flow model in Excel/21. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 2.73 MB
14. Learn how to build a Discounted Cash Flow model in Excel/22. Calculating Unlevered Free Cash Flow.mp4 10.79 MB
14. Learn how to build a Discounted Cash Flow model in Excel/23. Calculating Net Cash Flow.mp4 7.1 MB
14. Learn how to build a Discounted Cash Flow model in Excel/24. Obtaining the rest of the cash flows through Find and Replace.mp4 9.74 MB
14. Learn how to build a Discounted Cash Flow model in Excel/25. Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp4 2.71 MB
14. Learn how to build a Discounted Cash Flow model in Excel/26. Discounting Unlevered Free Cash Flows to obtain their Present Value.mp4 3.97 MB
14. Learn how to build a Discounted Cash Flow model in Excel/27. Calculating Continuing Value and Enterprise Value of the business.mp4 3.45 MB
14. Learn how to build a Discounted Cash Flow model in Excel/28. Calculating Equity Value.mp4 2.48 MB
14. Learn how to build a Discounted Cash Flow model in Excel/29. Sensitivity analysis for WACC and perpetuity growth.mp4 8.61 MB
14. Learn how to build a Discounted Cash Flow model in Excel/3. The various stages of a complete DCF Valuation.mp4 8.58 MB
14. Learn how to build a Discounted Cash Flow model in Excel/30. A possible application of Goal Seek.mp4 3.2 MB
14. Learn how to build a Discounted Cash Flow model in Excel/31. Using charts to summarize the results of the DCF model.mp4 8.24 MB
14. Learn how to build a Discounted Cash Flow model in Excel/32. You Made It!.mp4 7.6 MB
14. Learn how to build a Discounted Cash Flow model in Excel/4. Description of the structure of the DCF model.mp4 4.48 MB
14. Learn how to build a Discounted Cash Flow model in Excel/5. A glimpse at the company we are valuing - Cheeseco.mp4 1.74 MB
14. Learn how to build a Discounted Cash Flow model in Excel/6. Modeling the top line.mp4 5.14 MB
14. Learn how to build a Discounted Cash Flow model in Excel/7. Introducing scenarios to the model with Choose.mp4 3.2 MB
14. Learn how to build a Discounted Cash Flow model in Excel/8. Modeling other items Other revenues and Cogs.mp4 7.42 MB
14. Learn how to build a Discounted Cash Flow model in Excel/9. Modeling other items Operating expenses and D&A.mp4 5.27 MB
15. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp4 31.01 MB
15. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.mp4 25.3 MB
15. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 26.8 MB
15. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp4 34.45 MB
15. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp4 56.59 MB
15. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp4 54.2 MB
15. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.mp4 13.61 MB
15. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.mp4 17.51 MB
15. Tesla valuation - Complete practical exercise/17. Producing a clean P&L output sheet.mp4 8.43 MB
15. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.mp4 18.34 MB
15. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.mp4 19.03 MB
15. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp4 15.81 MB
15. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered Free Cash Flow.mp4 55.93 MB
15. Tesla valuation - Complete practical exercise/21. Forecasting other assets.mp4 45.24 MB
15. Tesla valuation - Complete practical exercise/22. Forecasting other liabilities.mp4 21.97 MB
15. Tesla valuation - Complete practical exercise/23. Completing Unlevered Free Cash Flow.mp4 40.88 MB
15. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.mp4 42.36 MB
15. Tesla valuation - Complete practical exercise/25. Calculating Net income.mp4 14.8 MB
15. Tesla valuation - Complete practical exercise/26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 50.73 MB
15. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.mp4 13.27 MB
15. Tesla valuation - Complete practical exercise/28. Estimating Weighted Average Cost of Capital (WACC).mp4 44.27 MB
15. Tesla valuation - Complete practical exercise/29. Performing Discounted Cash Flow valuation (DCF).mp4 34.9 MB
15. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4 114.91 MB
15. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.mp4 22.56 MB
15. Tesla valuation - Complete practical exercise/31. Final comments.mp4 44.88 MB
15. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.mp4 20.93 MB
15. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp4 41.92 MB
15. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp4 46.57 MB
15. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.mp4 17.17 MB
15. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp4 27.76 MB
15. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.mp4 17.49 MB
16. Capital budgeting - The theory/1. Introduction to Capital budgeting.mp4 5.43 MB
16. Capital budgeting - The theory/2. Why we need Capital budgeting.mp4 6.88 MB
16. Capital budgeting - The theory/3. The time value of money.mp4 6.69 MB
16. Capital budgeting - The theory/4. Calculating future and present Value.mp4 13.09 MB
16. Capital budgeting - The theory/5. Calculating cost of equity.mp4 19.2 MB
16. Capital budgeting - The theory/6. Coming up with project-specific beta.mp4 9.01 MB
16. Capital budgeting - The theory/7. Weighted Average Cost of Capital (WACC).mp4 5.51 MB
16. Capital budgeting - The theory/8. The type of cash flows we will have in a project.mp4 9.33 MB
16. Capital budgeting - The theory/9. Estimating the project's cash flows.mp4 18.79 MB
17. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital Budgeting exercise.mp4 8.63 MB
17. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.mp4 13.92 MB
17. Capital Budgeting - A Complete Case Study/11. Discounting the project's cash flows and residual value.mp4 22.54 MB
17. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.mp4 34.11 MB
17. Capital Budgeting - A Complete Case Study/14. Congratulations!!.mp4 2.31 MB
17. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.mp4 11.05 MB
17. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4 9.21 MB
17. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.mp4 12.16 MB
17. Capital Budgeting - A Complete Case Study/5. The impact of working capital.mp4 5.36 MB
17. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.mp4 6.18 MB
17. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.mp4 4.88 MB
17. Capital Budgeting - A Complete Case Study/8. Calculating project cash flows.mp4 10.14 MB
17. Capital Budgeting - A Complete Case Study/9. Estimating the weighted average cost of capital (WACC).mp4 5.58 MB
2. Introduction to Excel/1. Introduction to Excel - welcome lecture.mp4 1.99 MB
2. Introduction to Excel/11. Introduction to Excel functions.mp4 12.06 MB
2. Introduction to Excel/12. Cut, copy, & paste.mp4 7.57 MB
2. Introduction to Excel/14. Paste special.mp4 6.69 MB
2. Introduction to Excel/2. Overview of Excel.mp4 13.96 MB
2. Introduction to Excel/4. Basic manipulations with rows and columns.mp4 6.9 MB
2. Introduction to Excel/6. The Excel ribbon.mp4 8.8 MB
2. Introduction to Excel/7. Data entry in Excel.mp4 10.39 MB
2. Introduction to Excel/8. Introduction to formatting.mp4 24.75 MB
2. Introduction to Excel/9. Introduction to Excel formulas.mp4 5.85 MB
3. Useful tips and tools for your work in Excel/1. Excel best practices - Welcome lecture.mp4 2.13 MB
3. Useful tips and tools for your work in Excel/10. Learn how to use the Wrap Text button.mp4 908.39 KB
3. Useful tips and tools for your work in Excel/11. Create easily printable documents in Excel by using Set Print Area.mp4 1.71 MB
3. Useful tips and tools for your work in Excel/12. Find and select special types of cells with Select Special (F5).mp4 3.04 MB
3. Useful tips and tools for your work in Excel/14. Learn how to assign dynamic names within a financial model.mp4 2.33 MB
3. Useful tips and tools for your work in Excel/16. Define a named range in Excel.mp4 2.12 MB
3. Useful tips and tools for your work in Excel/17. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4 2.14 MB
3. Useful tips and tools for your work in Excel/18. Macros are a great timesaver! Here's why!.mp4 4.33 MB
3. Useful tips and tools for your work in Excel/2. Initial formatting of an Excel sheet to render it professional.mp4 3.35 MB
3. Useful tips and tools for your work in Excel/20. Create a drop-down list by using Data Validation.mp4 3.3 MB
3. Useful tips and tools for your work in Excel/21. Using Custom-sort in order to sort multiple columns within a table.mp4 2.79 MB
3. Useful tips and tools for your work in Excel/22. Create a great Index page at the beginning of your models - Hyperlinks.mp4 1.9 MB
3. Useful tips and tools for your work in Excel/23. Fix the top row of your table with Freeze Panes.mp4 5.2 MB
3. Useful tips and tools for your work in Excel/24. Filter by color - an excellent tool.mp4 9.87 MB
3. Useful tips and tools for your work in Excel/25. Working with conditional formatting.mp4 15.09 MB
3. Useful tips and tools for your work in Excel/3. Fast scrolling through Excel sheets.mp4 6.26 MB
3. Useful tips and tools for your work in Excel/5. Introduction to fixing of cell references.mp4 6.13 MB
3. Useful tips and tools for your work in Excel/7. Using the 'Alt + Enter' combination.mp4 1.46 MB
3. Useful tips and tools for your work in Excel/8. Learn how to organize your data with Text to Columns.mp4 3.94 MB
4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.mp4 30.43 MB
5. Excel's key functions and functionalities made easy/1. Excel's key functions - Welcome lecture.mp4 2.32 MB
5. Excel's key functions and functionalities made easy/10. Include Round in your financial models.mp4 1.23 MB
5. Excel's key functions and functionalities made easy/11. Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp4 12.11 MB
5. Excel's key functions and functionalities made easy/12. Index, Match and their combination - the perfect substitute for Vlookup.mp4 12.81 MB
5. Excel's key functions and functionalities made easy/13. A great Excel technique Index, Match, Match.mp4 11.76 MB
5. Excel's key functions and functionalities made easy/15. Using Excel's Iferror function to trap spreadsheet errors.mp4 2.62 MB
5. Excel's key functions and functionalities made easy/16. Learn how to render your models flexible with Choose.mp4 3.39 MB
5. Excel's key functions and functionalities made easy/17. Use Goal Seek to find the result that you are looking for.mp4 3.02 MB
5. Excel's key functions and functionalities made easy/19. Include sensitivity analysis in your models through Data Tables.mp4 5.43 MB
5. Excel's key functions and functionalities made easy/21. Excel's dynamic and interactive tables Pivot tables.mp4 5.32 MB
5. Excel's key functions and functionalities made easy/3. Key Excel functions Sum, Sumif and Sumifs.mp4 6.73 MB
5. Excel's key functions and functionalities made easy/4. Key Excel functions Count, Counta, Countif, Countifs.mp4 6 MB
5. Excel's key functions and functionalities made easy/5. Key Excel functions Average and Averageif.mp4 2.77 MB
5. Excel's key functions and functionalities made easy/7. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.mp4 6.31 MB
5. Excel's key functions and functionalities made easy/9. Find the minimum or maximum value in a range of cells in Excel.mp4 1.9 MB
6. Update! 15 December - Exercise/2. Exercise - Excel's Sumifs function - solved & explained.mp4 12.68 MB
7. Financial functions in Excel/1. Future and present values in Excel.mp4 14.96 MB
7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.mp4 7.58 MB
7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.mp4 14.82 MB
7. Financial functions in Excel/4. Date functions in Excel.mp4 11.36 MB
8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.mp4 6 MB
8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.mp4 19.37 MB
8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.mp4 11.27 MB
8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4 23.01 MB
8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GetPivotData - A very important Excel function.mp4 18.06 MB
8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp4 22.16 MB
9. Case study - Building a complete P&L from scratch in Excel/1. Case study - Build a P&L from scratch - Welcome lecture.mp4 3.13 MB
9. Case study - Building a complete P&L from scratch in Excel/10. Use Index & Match as a substitute for Vlookup.mp4 12.66 MB
9. Case study - Building a complete P&L from scratch in Excel/11. Mapping the rows in the Database sheet.mp4 9.41 MB
9. Case study - Building a complete P&L from scratch in Excel/12. Building the structure of the P&L sheet.mp4 3.91 MB
9. Case study - Building a complete P&L from scratch in Excel/13. Formatting sets You apart from the competition in Excel - A Practical Example.mp4 5.71 MB
9. Case study - Building a complete P&L from scratch in Excel/14. Populate the P&L sheet with Sumif.mp4 6.43 MB
9. Case study - Building a complete P&L from scratch in Excel/15. Learn how to find mistakes with Countif.mp4 7.47 MB
9. Case study - Building a complete P&L from scratch in Excel/16. Calculating year-on-year percentage variations the proper way.mp4 6.83 MB
9. Case study - Building a complete P&L from scratch in Excel/17. Create professional and good-looking charts - Introduction.mp4 1.19 MB
9. Case study - Building a complete P&L from scratch in Excel/18. Build a Column Stacked chart with a secondary line axis in Excel.mp4 11.3 MB
9. Case study - Building a complete P&L from scratch in Excel/19. Learn how to build effective Doughnut charts in Excel.mp4 7.48 MB
9. Case study - Building a complete P&L from scratch in Excel/2. Introduction to the case study.mp4 2.42 MB
9. Case study - Building a complete P&L from scratch in Excel/20. Learn how to build an Area chart in Excel.mp4 8.02 MB
9. Case study - Building a complete P&L from scratch in Excel/21. Learn how to create Bridge charts.mp4 18.77 MB
9. Case study - Building a complete P&L from scratch in Excel/23. Course Challenge - Apply your skills in practice!.mp4 7.92 MB
9. Case study - Building a complete P&L from scratch in Excel/3. Understand your data source before you start working on it.mp4 6.78 MB
9. Case study - Building a complete P&L from scratch in Excel/4. Order the source worksheets.mp4 5.68 MB
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.mp4 5.99 MB
9. Case study - Building a complete P&L from scratch in Excel/6. Learn how to create a database.mp4 5.45 MB
9. Case study - Building a complete P&L from scratch in Excel/7. Use Vlookup to fill the Database sheet.mp4 14.65 MB
9. Case study - Building a complete P&L from scratch in Excel/8. 50% Completed!.mp4 4.3 MB
9. Case study - Building a complete P&L from scratch in Excel/9. Use SUMIF to complete the Database sheet.mp4 13.29 MB
其他位置