| 1. The Guiding Principles of Spreadsheet Modelling.mp4 | 67.4 MB | ||
| 1. The Guiding Principles of Spreadsheet Modelling.srt | 8.7 KB | ||
| 10. The Cashflow Model.mp4 | 40.4 MB | ||
| 10. The Cashflow Model.srt | 5.4 KB | ||
| 11. Example Cashflow Model.mp4 | 50.9 MB | ||
| 11. Example Cashflow Model.srt | 4.4 KB | ||
| 12. Considerations when creating an Income Statement and Balance Sheet.mp4 | 14.9 MB | ||
| 12. Considerations when creating an Income Statement and Balance Sheet.srt | 2.4 KB | ||
| 13. Exercise Cashflow Model with Income Statement and Balance Sheet.mp4 | 105.7 MB | ||
| 13. Exercise Cashflow Model with Income Statement and Balance Sheet.srt | 12.7 KB | ||
| 14. Spreadsheet Models for the Project Lifecycle.mp4 | 65.9 MB | ||
| 14. Spreadsheet Models for the Project Lifecycle.srt | 9.3 KB | ||
| 15. Selecting a Discount Rate for Net Present Value.mp4 | 61.4 MB | ||
| 15. Selecting a Discount Rate for Net Present Value.srt | 8.4 KB | ||
| 16. Project Lifecycle Example.mp4 | 69 MB | ||
| 16. Project Lifecycle Example.srt | 7.7 KB | ||
| 17. Comparing Projects.mp4 | 16.9 MB | ||
| 17. Comparing Projects.srt | 3.5 KB | ||
| 18. The Discounted Cashflow Valuation Model.mp4 | 56 MB | ||
| 18. The Discounted Cashflow Valuation Model.srt | 7.1 KB | ||
| 19. Valuing Camberwick Green Care Home.mp4 | 59.8 MB | ||
| 19. Valuing Camberwick Green Care Home.srt | 6.8 KB | ||
| 2. Type of Financial Model.mp4 | 32.4 MB | ||
| 2. Type of Financial Model.srt | 7.2 KB | ||
| 20. Example Investment Options.mp4 | 75 MB | ||
| 20. Example Investment Options.srt | 9.7 KB | ||
| 3. Getting Started with Spreadsheet Model Building.mp4 | 85.2 MB | ||
| 3. Getting Started with Spreadsheet Model Building.srt | 13.8 KB | ||
| 4. Exercise Getting Started with a Model.mp4 | 56.4 MB | ||
| 4. Exercise Getting Started with a Model.srt | 8.6 KB | ||
| 4.1 Financial Modelling Worksheets.xlsx | 119.7 KB | ||
| 5. Building a Pricing Model.mp4 | 49.4 MB | ||
| 5. Building a Pricing Model.srt | 7.8 KB | ||
| 6. Pricing Example 1 New Product Pricing.mp4 | 40.9 MB | ||
| 6. Pricing Example 1 New Product Pricing.srt | 5 KB | ||
| 7. Pricing Example 2 Cresswell's Biscuits.mp4 | 43.5 MB | ||
| 7. Pricing Example 2 Cresswell's Biscuits.srt | 5.7 KB | ||
| 8. Pricing Example 3 Caraway's Takeaway.mp4 | 76.4 MB | ||
| 8. Pricing Example 3 Caraway's Takeaway.srt | 6.2 KB | ||
| 9. Exercise Trumpton Town Cafe.mp4 | 81 MB | ||
| 9. Exercise Trumpton Town Cafe.srt | 12 KB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 43 total files | |||
Spreadsheet Models: Cashflow, Net Present Value and Pricing
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 20 lectures (2h 12m) | Size: 851.1 MB
Usi good spreadsheet modelling practice to build three types of spreadsheet model
What you'll learn:
The guiding principles of spreadsheet model building
The work involved in getting ready to build a spreadsheet model, including identifying stakeholders and defining the problem that the model will address
How to develop models for pricing decisions including identifying the profit-maximising price for a business
How to build a cashflow model to support a wide variety of business situations
How to extend the cashflow model to include an Income Statement and Balance Sheet
The project lifecycle
How to select an appropriate discount rate for use in Net Present Value analysis
How to compare projects using Net Present Value
How to apply the Discounted Cashflow Valuation Model to business projects
How to compare investment opportunities
Requirements
There are no pre-course requirements
Description
In this course, we use good spreadsheet modelling practice to build three types of spreadsheet model - a pricing decision model; a cashflow statement; and a project lifecycle analysis using discounted cashflows.
This course is a companion to my course Building a Spreadsheet Forecasting Model which covers the structure for building a spreadsheet forecasting or planning model. You do not need to have completed that course to undertake this course. The focus of this course - Spreadsheet Models: Cashflow, Net Present Value and Pricing - is practical examples of some of the most important spreadsheet models.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - Excel For Absolute Beginners - From Zero To Spreadsheet Hero! Posted by
freecoursewb in Other
|
470 MB | freecoursewb | 1 year | 2 | 0 |
| 1.6 GB | freecoursewb | 4 years | 0 | 0 | |
| 1.5 GB | freecoursewb | 4 years | 0 | 0 | |
|
Udemy - Excel with Python - Working with Excel Spreadsheet from Python Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 4 years | 0 | 0 |
| 529 MB | freecoursewb | 4 years | 0 | 0 |
All Comments