MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)

In the car NPV example, determine the following:

• The direct dependents and all dependents of the interest rate.

• The direct dependents and all dependents of the tax rate.

• The direct precedents and all precedents for Year 4 unit sales.

• The direct precedents and all precedents for Year 3 costs.