Decision-Making and Scenarios

About this course: 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.

Created by:  University of Pennsylvania

• Taught by:  Richard Lambert, Professor of Accounting

  Accounting- Wharton School

• Taught by:  Robert W. Holthausen, Professor

  Accounting

Basic Info Course 4 of 5 in the Business and Financial Modeling Specialization Commitment 4 weeks of study, 1-3 hours/week Language English How To Pass Pass all graded assignments to complete the course. User Ratings 4.6 stars Average User Rating 4.6See what learners said Trabajo del curso

Cada curso es como un libro de texto interactivo, con videos pregrabados, cuestionarios y proyectos.

Ayuda de tus compañeros

Conéctate con miles de estudiantes y debate ideas y materiales del curso, y obtén ayuda para dominar los conceptos.

Certificados

Obtén reconocimiento oficial por tu trabajo y comparte tu éxito con amigos, compañeros y empleadores.

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.

Syllabus


WEEK 1


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 videos, 2 readings expand

1. Video: Course Introduction & Overview
2. Video: 1.1 Introduction: Criteria for Evaluating Projects
3. Video: 1.2 Time Value of Money
4. Video: 1.3 NPV Analysis of Projects
5. Video: 1.4 Other Evaluation Techniques
6. Video: 1.5 The Cost of Capital
7. Leyendo: PDFs of Lecture Slides
8. Leyendo: Excel Spreadsheets: Module 1

Graded: Evaluation Criteria: Module 1 Quiz

WEEK 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 videos, 1 reading expand

1. Video: 2.1 Introduction and Analyzing Incremental After-Tax Cash Flows - Initial Investment Phase
2. Video: 2.2 Analyzing Incremental After-Tax Flows - Operating Phase
3. Video: 2.3 Analyzing Incremental After-Tax Flows - Terminal Phase
4. Video: 2.4 Example: New Production Machine
5. Video: 2.5 Key Considerations in Evaluations
6. Leyendo: PDFs of Lecture Slides

Graded: How to Evaluate Projects: Module 2 Quiz

WEEK 3


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 videos, 1 reading expand

1. Video: 3.1 Introduction to Financial Statements
2. Video: 3.2 Balance Sheets and Income Statements
3. Video: 3.3 Cash Flow Statements
4. Leyendo: PDFs of Lecture Slides

Graded: Financial Statements and Forecasting: Module 3 Quiz

WEEK 4


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 videos, 2 readings expand

1. Video: 4.1 Introduction and Speadsheet Setup
2. Video: 4.2 Forecasting Future Cash Flows
3. Video: 4.3 NPV and IRR Calculations
4. Video: 4.4 Formulation and Evaluation of Alternative Scenarios
5. Video: 4.5 Expanding Beyond the Time Horizon
6. Video: Course Conclusion
7. Leyendo: PDFs of Lecture Slides
8. Leyendo: Excel Spreadsheets: Module 4

Graded: Calculating Value: Module 4 Quiz