Please create an excel spreadsheet worksheet of this problem (answering ALL Parts a - d). The NPV car example is also below.

The following is the GIVEN Sheet 1, 2, and 3 of the NPV car example.

Sheet 1:Original Model

Sheet 2: Direct dep of Price Growth

Sheet 3: all pre Year 1 bT Profit

I am aware all three of these charts have the same data but I am not sure why that is the case either. But, this is the data I was given.

Thanks for any help!

1. In the car NPV example, determine the following: a. The direct dependents and all the dependents of the interest rate b. The direct dependents and all the dependents of the c. The direct precedents and all the precedents for Year d. The direct precedents and all the precedents for Year tax rate. 4 unit sales. 3 costs