Below are some "how-to" helpful walkthrough videos for you to watch before you attempt to do any of these items in the course:

Install Add Ins

Data Prep assignment

Research Matrix assignment

Hypothesis Testing assignment

Dashboard assignment

Monte Carlo Simulation assignment

Predictive Analysis - Forecast assignment

Optimization assignment

The Ford Motor Company wants to decide if the company should provide a incentive to purchasers of the Ford Fusion. Here are some details for the base case:

Year price: 

Year cost: % of the market purchases a Ford Fusion or competitive vehicle % of everybody who last purchased a Ford Fusion will purchase the same vehicle again.

% of all people who bought a competitive car will purchase a Ford Fusion for their next vehicle

The market splits half are loyal to Ford and the other half is loyal to their current preferred manufacturer Inflation rate is % annually

Profit hits the financials at the beginning of the year and The Ford Motor Company discounts the cash flows at % per year

With this information, please answer the following questions:

a) Assuming end of your cash flows and a year planning horizon, should Ford give the incentive? Why or why not?

b) Would decreasing the discount rate to % change your answer? Why or why not?

Please submit this project as a Microsoft Excel spreadsheet showing your worked answer with your response to both a and b above

Data Set