From the course: Financial Forecasting with Big Data
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Perform stress testing - Microsoft Excel Tutorial
From the course: Financial Forecasting with Big Data
Perform stress testing
- [Instructor] Now that we've built our hedonic pricing model, we want to go through and we want to stress test it to determine how different changes in our business practices will impact our sales. In particular, Dianne is interested in looking at how a change in price, and by extension a change in the net promoter score, will impact sales at the firm. I'm in the 04_03 folder looking at the begin financial data file. Now as you can see, we've built a model which shows us that given these particular inputs, our expected output for sales is $751.53 million. So I'm going to create a little chart down here that shows us what our sales are under a variety of scenarios. So our base case is 751.5 million. Now, Dianne is recommending that the firm lower their price. Doing that, she believes, will raise the net promoter score from 0.001 to 0.04. As we can see with the bolded number at the top, doing that results in the firm's sales rising to $816.8 million. If we lower the price, that's the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.