This course is designed to show you how use quantitative models to transform data into better business decisions. You’ll learn both how to use models to facilitate decision-making and also how to structure decision-making for optimum results. Two of Wharton’s most acclaimed professors will show you the step-by-step processes of modeling common business and financial scenarios, so you can significantly improve your ability to structure complex problems and derive useful insights about alternatives. Once you’ve created models of existing realities, possible risks, and alternative scenarios, you can determine the best solution for your business or enterprise, using the decision-making tools and techniques you’ve learned in this course.
Dieser Kurs ist Teil der Spezialisierung Spezialisierung Business and Financial Modeling
Decision-Making and Scenarios
von
Über diesen Kurs
46,682 kürzliche Aufrufe
Karriereergebnisse der Lernenden
20%
nahm einen neuen Beruf nach Abschluss dieser Kurse auf
21%
ziehen Sie für Ihren Beruf greifbaren Nutzen aus diesem Kurs
Kompetenzen, die Sie erwerben
Cash FlowFinancial StatementBalance SheetInvestment
Karriereergebnisse der Lernenden
20%
nahm einen neuen Beruf nach Abschluss dieser Kurse auf
21%
ziehen Sie für Ihren Beruf greifbaren Nutzen aus diesem Kurs
Zertifikat zur Vorlage
Erhalten Sie nach Abschluss ein Zertifikat
100 % online
Beginnen Sie sofort und lernen Sie in Ihrem eigenen Tempo.
Kurs 4 von 5 in
Flexible Fristen
Setzen Sie Fristen gemäß Ihrem Zeitplan zurück.
Ca. 9 Stunden zum Abschließen
Empfohlen: 4 weeks of study, 1-3 hours/week
Englisch
Untertitel: Englisch
Lehrplan - Was Sie in diesem Kurs lernen werden
2 Stunden zum Abschließen
Evaluation Criteria: Net Present Value
This module was designed to introduce you to the many potential criteria for selecting investment projects, and to explore the most effective of these criteria: Net Present Value (NPV). Through the use of concrete examples, you'll learn the key components of Net Present Value, including the time value of money and the cost of capital, the main utility of NPV, and why it is ultimately more accurate and useful for evaluating projects than other commonly used criteria. By the end of this module, you'll be able to explain why net present value analysis is the appropriate criteria for choosing whether to accept or reject a project, and why other criteria, such as IRR, payback, ROI, etc. may not lead to decisions which maximize value.
2 Stunden zum Abschließen
6 Videos (Gesamt 73 min), 2 Lektüren, 1 Quiz
6 Videos
1.1 Introduction: Criteria for Evaluating Projects6m
1.2 Time Value of Money19m
1.3 NPV Analysis of Projects16m
1.4 Other Evaluation Techniques15m
1.5 The Cost of Capital10m
2 Lektüren
PDFs of Lecture Slides10m
Excel Spreadsheets: Module 110m
1 praktische Übung
Evaluation Criteria: Module 1 Quiz20m
2 Stunden zum Abschließen
Evaluating Projects
In this module, you'll learn how to evaluate a project with emphasis on analyzing the incremental after-tax cash flows associated with the project. You'll work through a concrete example using alternative scenarios to test the effectiveness of this method. You'll also learn why only future cash flows are relevant, why to ignore financial costs, include all incidental effects, remember working capital requirements, consider the effect of taxes, forget sunk costs, remember opportunity costs, use expected cash flows, and perform sensitivity analysis. By the end of this module, you'll be able to evaluate projects more thoroughly and effectively, with emphasis on how to model the change in the company’s after-tax cash flows, so that you can make more profitable decisions.
2 Stunden zum Abschließen
5 Videos (Gesamt 63 min), 1 Lektüre, 1 Quiz
5 Videos
2.2 Analyzing Incremental After-Tax Flows - Operating Phase12m
2.3 Analyzing Incremental After-Tax Flows - Terminal Phase6m
2.4 Example: New Production Machine12m
2.5 Key Considerations in Evaluations19m
1 Lektüre
PDFs of Lecture Slides10m
1 praktische Übung
How to Evaluate Projects: Module 2 Quiz22m
1 Stunde zum Abschließen
Expressing Business Strategies in Financial Terms
This module was designed to give you the opportunity to learn how business activities, transactions and events are translated into financial statements, including balance sheets, income statements, and cash flow statements. You'll also learn how these three statements are linked to each other, and how balance sheets and income statements can help forecast the future cash flow statements. By the end of this module, you'll be able to explain how accounting systems translate business activities into financial terms, and how to use this to better forecast future cash flows, so that you can express your business strategies in these financial terms, and show "the bottom line" for your proposed plan of action.
1 Stunde zum Abschließen
3 Videos (Gesamt 52 min), 1 Lektüre, 1 Quiz
3 Videos
3.2 Balance Sheets and Income Statements15m
3.3 Cash Flow Statements17m
1 Lektüre
PDFs of Lecture Slides10m
1 praktische Übung
Financial Statements and Forecasting: Module 3 Quiz20m
2 Stunden zum Abschließen
New Product Value
In this module, you'll apply what you’ve been learning to an analysis of a new product venture. You’ll learn how to map out a plan of the business activities, transactions and events that need to happen to implement the new venture, including their timing. You'll also learn how to set up a spreadsheet to help with forecasts, and to re-calculate things automatically as we re-think our plans. You'll see how to forecast out the implied financial statements, and calculate the Net Present Value (NPV). By the end of this module, you'll be able to use spreadsheets to explore different risks a venture may face, and analyze the implications of these scenarios for NPV, so that you can make the most profitable, data-driven decision possible.
2 Stunden zum Abschließen
6 Videos (Gesamt 51 min), 2 Lektüren, 1 Quiz
6 Videos
4.2 Forecasting Future Cash Flows11m
4.3 NPV and IRR Calculations5m
4.4 Formulation and Evaluation of Alternative Scenarios15m
4.5 Expanding Beyond the Time Horizon9m
Course Conclusion28
2 Lektüren
PDFs of Lecture Slides10m
Excel Spreadsheets: Module 410m
1 praktische Übung
Calculating Value: Module 4 Quiz20m
Bewertungen
Top-Bewertungen von DECISION-MAKING AND SCENARIOS
von SRApr 22, 2017
The course material and examples are very useful. I really like the CF spreadsheet at the end of week 4 as this is very organized CF model and I can use this as reference to build my own. Thank you!
von AUFeb 6, 2020
Goooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooood
von EEOct 31, 2017
I think I would be more helpfull if you worked in more detail on the example. Rather than just reading of the slides, it would be much better if we could follow you step by step in calculatons.
von ASJun 5, 2018
Thank you for the wonderful course. It gave us substantial information to evaluate a project based on NPV and IRR. The sensitivity analyses and the consequent scenarios were spelt out lucidly.
von CEJun 11, 2019
I took 2 full semesters of accounting courses in college and did not get the understanding of the material as well as I did in these modules. This course is wonderful and very eye-opening!
von NOAug 25, 2019
The professor should add more into the calculating the present value of growing perpetuity as most of the projects are followed by other project or these go for an extended period of time.
von DAMay 26, 2016
Material is what I was looking for to model decision making in a business/project setting. More practice would have been useful and extra material such as e-books or articles.
von TRJan 21, 2018
Excellent course. This material has helped me to fine tune my skills setting up the spreadsheets and utilizing scenarios to find where the risk associated with projects are.
von SCOct 1, 2018
Best course to understand the project valuation and the concept of IRR and NPV. Awesome way of explanation with real examples.\n\nThank you coursera for being my Mentor.
von RAApr 13, 2019
Very practical, precise and applicable. Love the Excel Sheets and the explanation in helping differentiate metrics vs judging scenarios while getting the numbers right.
von DSAug 10, 2017
Module 2 quiz was really tricky and I felt the lectures should have provided a more similar example. Could not get the NPV calc in problem 5 no matter what I tried
von AJFeb 16, 2019
This is a solid course on financial decision making. Highly recommended for those who work in operations management and on strategic initiatives and projects.
von FADec 25, 2018
Fantastic course. Great depth and and breadth within the scope of the subjects covered and explained quite complex concepts very clearly and systematically
von MSSep 23, 2017
It is a nice course for those who want to revisit the concepts of NPV, IRR and those who want to understand about Financial Planning / Financial Modeling.
von EXAug 1, 2018
If anyone is interested to get a head start with excel and valuation, this is a great course. The best part is you can re-visit the videos for references.
von JPMar 14, 2017
The professors take you almost by the hand with the basic concepts but the one you must master in order to have a good solid foundation. Amazing course!!
von JLJan 10, 2020
I think that it is one of the most complete courses in the specialization, but at times it is very repetitive from what was learnt in previous courses.
von CCDec 5, 2019
Undoubtedly, this is a great course to learn the financial modelling. However, students should equip with some basic knowledge of financial accounting
von ASJun 20, 2016
Found a lot of interesting and important information for me here. Excellent information on making prognosis tied with accounting and financial reports
von DMMay 26, 2016
I liked the class and it gave good information. The professors ordered the materials well, and I would recommend anyone to take this MOOC.
Über University of Pennsylvania
The University of Pennsylvania (commonly referred to as Penn) is a private university, located in Philadelphia, Pennsylvania, United States. A member of the Ivy League, Penn is the fourth-oldest institution of higher education in the United States, and considers itself to be the first university in the United States with both undergraduate and graduate studies.
Über den Spezialisierung Business and Financial Modeling
Wharton's Business and Financial Modeling Specialization is designed to help you make informed business and financial decisions. These foundational courses will introduce you to spreadsheet models, modeling techniques, and common applications for investment analysis, company valuation, forecasting, and more. When you complete the Specialization, you'll be ready to use your own data to describe realities, build scenarios, and predict performance.
Häufig gestellte Fragen
Wann erhalte ich Zugang zu den Vorträgen und Aufgaben?
Sobald Sie sich für ein Zertifikat angemeldet haben, haben Sie Zugriff auf alle Videos, Quizspiele und Programmieraufgaben (falls zutreffend). Aufgaben, die von anderen Kursteilnehmern bewertet werden, können erst dann eingereicht und überprüft werden, wenn Ihr Unterricht begonnen hat. Wenn Sie sich den Kurs anschauen möchten, ohne ihn zu kaufen, können Sie womöglich auf bestimmte Aufgaben nicht zugreifen.
Was bekomme ich, wenn ich diese Spezialisierung abonniere?
Wenn Sie sich für den Kurs anmelden, erhalten Sie Zugriff auf alle Kurse der Spezialisierung und Sie erhalten nach Abschluss aller Arbeiten ein Zertifikat. Ihr elektronisches Zertifikat wird zu Ihrer Seite „Errungenschaften“ hinzugefügt – von dort können Sie Ihr Zertifikat ausdrucken oder es zu Ihrem LinkedIn Profil hinzufügen. Wenn Sie nur lesen und den Inhalt des Kurses anzeigen möchten, können Sie kostenlos als Gast an dem Kurs teilnehmen.
Wie erfolgen Rückerstattungen?
Ist finanzielle Unterstützung möglich?
Haben Sie weitere Fragen? Besuchen Sie das Hilfe-Center für Teiln..
