How do I solve this in excel?

a The Executive Committee of Random Electric Vehicles is debating whether to replace its original model, the Leisure-EV, with a new model, the Adventure-EV, which would appeal to a younger audience. Whatever vehicle chosen will be produced for the next 4 years, after which time a reevaluation will be necessary. The Adventure-EV has passed through the concept and initial design phases and is ready for final design and manufacturing. Final development costs are estimated to be $75 million, and the new fixed costs for tooling and manufacturing are estimated to be $600 million. The Adventure-EV is expected to sell for $30,000. The first-year sales for the Adventure-EV are estimated to be 60,000, with a sales growth for the subsequent years of 6% per year. The variable cost per vehicle is un- certain until the design and supply- chain decisions are finalized but is estimated to be $22,000. Next-year sales for the Leisure-EV are estimated to be 50,000, but the sales are expected to decrease at a rate of 10% for each of the next 3 years. The selling price is $28.000. Variable costs per vehicle are $21,000. Since the model has been in production, the fixed costs for development have already been recovered. Develop a 4-year model to recommend the best decision using a net present value discount rate of 5%. 1. Create a table for calculating net present value as shown in Figure 11.9 on page 352 in the textbook for the Adventure-EV. 2. Create another table for calculating net present value as shown in Figure 11.9 on page 352 in the textbook for the Leisure-EV. Place this table directly under the table created in the previous step 3. Create another cell under the two tables that will present the difference between the Adventure-EV and Leisure-EV. Make sure to place a label next to the cell that has the formula. 4. Directly under the cell you created in step 3 place an IF function that will indicate which option, either the Leisure-EV or the Adventure-EV would be the better choice. (See Figure 11.2 on page 344 in the textbook.) 5. Copy everything on your spreadsheet to a new spreadsheet. 6. Using the worksheet with the copied material to answer the following question making sure to place your answer to the question at the top of the worksheet. Question: How sensitive is the result to the estimated variable cost of the Adventure- EV? a The Executive Committee of Random Electric Vehicles is debating whether to replace its original model, the Leisure-EV, with a new model, the Adventure-EV, which would appeal to a younger audience. Whatever vehicle chosen will be produced for the next 4 years, after which time a reevaluation will be necessary. The Adventure-EV has passed through the concept and initial design phases and is ready for final design and manufacturing. Final development costs are estimated to be $75 million, and the new fixed costs for tooling and manufacturing are estimated to be $600 million. The Adventure-EV is expected to sell for $30,000. The first-year sales for the Adventure-EV are estimated to be 60,000, with a sales growth for the subsequent years of 6% per year. The variable cost per vehicle is un- certain until the design and supply- chain decisions are finalized but is estimated to be $22,000. Next-year sales for the Leisure-EV are estimated to be 50,000, but the sales are expected to decrease at a rate of 10% for each of the next 3 years. The selling price is $28.000. Variable costs per vehicle are $21,000. Since the model has been in production, the fixed costs for development have already been recovered. Develop a 4-year model to recommend the best decision using a net present value discount rate of 5%. 1. Create a table for calculating net present value as shown in Figure 11.9 on page 352 in the textbook for the Adventure-EV. 2. Create another table for calculating net present value as shown in Figure 11.9 on page 352 in the textbook for the Leisure-EV. Place this table directly under the table created in the previous step 3. Create another cell under the two tables that will present the difference between the Adventure-EV and Leisure-EV. Make sure to place a label next to the cell that has the formula. 4. Directly under the cell you created in step 3 place an IF function that will indicate which option, either the Leisure-EV or the Adventure-EV would be the better choice. (See Figure 11.2 on page 344 in the textbook.) 5. Copy everything on your spreadsheet to a new spreadsheet. 6. Using the worksheet with the copied material to answer the following question making sure to place your answer to the question at the top of the worksheet. Question: How sensitive is the result to the estimated variable cost of the Adventure- EV