Please help!! 
An electric vehicle company is debating whether to replace its original model, the REV-Touring, with a new model, the REV-Sport. Using the accompanying information, develop a four-year model to predict the profitability of each vehicle and recommend the best decision using a net present value discount rate of 6%. How sensitive is the result to the estimated variable cost of the REV-Sport? How might this affect the decision? Click the icon to view the REV-Sport and REV-Touring information. Create a model for the REV-Sport REV-Sport and REV-Touring Whatever vehicle is chosen will be produced for the next four years, after which time a reevaluation will be necessary. The REV-Sport is ready for the final design and manufacturing phases. Final development costs are estimated to be $70 million and the new fixed costs for retooling are estimated to be $550 million. The REV-Sport is expected to sell for $40,000. The first-year sales for the REV-Sport is estimated to be 60,000 , with a sales growth for the subsequent years of 7% per year. The variable cost per vehicle is uncertain until the design and supply-chain decisions are finalized, but is estimated to be $32,000. Next-year sales for the REV-Touring are estimated to be 50,000 , but the sales are expected to decrease at a rate of 10% for each of the next three years. The selling price is $38,000. Variable costs per vehicle are $31,000. Since the model has been in production, the fixed costs for development have already been recovered. renorm the calculations from the spreadsheet that was created in the previous step and then convert your answer into millions of dollars The net present value for REV-Sport is \$ million. (Round to the nearest million dollars as needed.) Extend the same spreadsheet to create a model for the REV-Touring. An electric vehicle company is debating whether to replace its original model, the REV-Touring, with a new model, the REV-Sport Using Perform the calculations from the spreadsheet that was created in the previous step and then convert your answer into miliions of dollars. The net present value for REV.Touring is $0 mailion Click the icon to view the REV-Sport and REV-Touring information. The net present value for REV-Touring is $ million. (Round to the nearest million dollars as needed.) Using a net present value discount rate of 6%, the best decision is to produce the because it has a net present value. If the variable cost of the REV-Sport was increased by a small amount, say $1,000 per vehicle, the best decision is to produce the because it has a net present value. This indicates that it be risky to produce the REV-Sport, because a small change in the variable cost the. decision when comparing net present values
