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.
提供方
教学大纲 - 您将从这门课程中学到什么
周
1完成时间为 2 小时
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.
6 个视频 （总计 73 分钟）, 2 个阅读材料, 1 个测验
6 个视频
1.1 Introduction: Criteria for Evaluating Projects6分钟
1.2 Time Value of Money19分钟
1.3 NPV Analysis of Projects16分钟
1.4 Other Evaluation Techniques15分钟
1.5 The Cost of Capital10分钟
2 个阅读材料
PDFs of Lecture Slides10分钟
Excel Spreadsheets: Module 110分钟
1 个练习
Evaluation Criteria: Module 1 Quiz20分钟
周
2完成时间为 2 小时
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.
5 个视频 （总计 63 分钟）, 1 个阅读材料, 1 个测验
5 个视频
2.2 Analyzing Incremental After-Tax Flows - Operating Phase12分钟
2.3 Analyzing Incremental After-Tax Flows - Terminal Phase6分钟
2.4 Example: New Production Machine12分钟
2.5 Key Considerations in Evaluations19分钟
1 个阅读材料
PDFs of Lecture Slides10分钟
1 个练习
How to Evaluate Projects: Module 2 Quiz22分钟
周
3完成时间为 1 小时
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.
3 个视频 （总计 52 分钟）, 1 个阅读材料, 1 个测验
3 个视频
3.2 Balance Sheets and Income Statements15分钟
3.3 Cash Flow Statements17分钟
1 个阅读材料
PDFs of Lecture Slides10分钟
1 个练习
Financial Statements and Forecasting: Module 3 Quiz20分钟
周
4完成时间为 2 小时
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.
6 个视频 （总计 51 分钟）, 2 个阅读材料, 1 个测验
6 个视频
4.2 Forecasting Future Cash Flows11分钟
4.3 NPV and IRR Calculations5分钟
4.4 Formulation and Evaluation of Alternative Scenarios15分钟
4.5 Expanding Beyond the Time Horizon9分钟
Course Conclusion28
2 个阅读材料
PDFs of Lecture Slides10分钟
Excel Spreadsheets: Module 410分钟
1 个练习
Calculating Value: Module 4 Quiz20分钟
4.6
129 个审阅23%
完成这些课程后已开始新的职业生涯
26%
通过此课程获得实实在在的工作福利
热门审阅
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!
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.
讲师
Richard Lambert
Professor of AccountingAccounting- Wharton School
Robert W. Holthausen
ProfessorAccounting
关于 宾夕法尼亚大学
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.
关于 商业与金融建模 专项课程
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.
常见问题
我什么时候能够访问课程视频和作业？
注册以便获得证书后，您将有权访问所有视频、测验和编程作业（如果适用）。只有在您的班次开课之后，才可以提交和审阅同学互评作业。如果您选择在不购买的情况下浏览课程，可能无法访问某些作业。
我订阅此专项课程后会得到什么？
您注册课程后，将有权访问专项课程中的所有课程，并且会在完成课程后获得证书。您的电子课程证书将添加到您的成就页中，您可以通过该页打印您的课程证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容，可以免费旁听课程。
退款政策是如何规定的？
有助学金吗？
还有其他问题吗？请访问 学生帮助中心。
