Blog

The simple model above is used to calculate a students grade point average (GPA). Which formula in cell B17 would correctly calculate the GPA while using best practices for spreadsheet modeling?

What is the minimum incremental change that can be used in a spin button?

Using the worksheet shown below, what value would be returned by the following formula? =SUM(INDEX(B2:D4,0,MATCH(“Large”,B1:D1,0)))

Recall the Moore Pharmaceuticals example from the lectures. You want to create a data table to evaluate the net present value at different levels of Discount Rate. The parameters of the data table are already set up in the screenshot below. What cell should you select as the Column input cell?

Recall the affordable home purchase example from the Spreadsheet Modeling Lab. You want to create a data table to evaluate the maximum home price at different levels of Down payment (%) and Monthly Installment Debt. The parameters of the data table are already set up in the screenshot below. What cell should you select as the Column input cell?

Recall the Moore Pharmaceuticals example from the lectures. You want to evaluate the Year 4 Cumulative Net Profit at different levels of Year 1 Market Size, Unit revenue, and Unit cost. Which What-If Analysis tool will allow you to do this?

Which of the approaches to diversifying discussed in class best describes Aldi’s move into the sale of Aldi-branded services through its online platform?

UW sends an email to 2,000 enrolled students inviting them to participate in an online survey about student housing satisfaction. After one week, the research team observes the following: 1,500 students opened the email and clicked the link to start the survey. 1,200 students finished every question and submitted their responses. Based on the definition used in marketing research, the completion rate for this study is best defined as: a. The percentage of students who were invited and completed the survey (2,0001,200​=60%). b. Is the best indicator of the quality of the research effort. c. The percentage of respondents who completed the survey once they started it (1,5001,200​=80%). d. The number of students who completed the survey divided by the number who opened the email.

Is the competition between Aldi & LDL an example of 1st and 2nd mover advantages?  If so, which is the 2nd mover?  If not, what type of competition is it?  Be sure to explain your answer for full credit.

One of the problems with achieving acquisition success is that the acquiring firm’s stock often decreases in value on the announcement of the acquisition.  This question has two parts: Why does this decrease in stock value occur? Why does it impact the ability of the acquisition to be successful?