Please answer with an excel screenshot with formulas.

A B C D E F G H K M N 0 F Q R S T 1 The Executive Committee of Reder Electric Vehicles is debating whether to replace its original model, the REV-Touring. with a new model, the REV-Sport, which would appeal to a younger audience. Whatever vehicle chosen will be produced for the 2 next 4 years, after which time a reevaluation will be necessary. The REV-Sport has passed through the concept and initial design phases and is ready for final design and manufacturing. Fixed development costs are estimated to be $80 million, and the new fixed costs for tooling and manufacturing are estimated to be $580,000. The REV-Sport is expected to sell for $32,000. The first year sales for the REV-Sport is estimated to be 62,500, with a sales growth for the subsequent years of 6%% per year. The variable cost per vehicle is uncertain unti the design and supply chain decisions are finalized, but is estimated to be $23,000. Next-year sales for the REV-Touring are estimated to be 52,500, but the sales are expected to decrease at a rate 5 of 10% for each of the next 3 years. The selling price is $30,000. Variable cost per vehicle are $22,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 7 Reder Electric Vehicles 9 REV-Sport REV-Touring 10 Selling Price $32,000 Selling Price $30,000 11 First Year Sales 62.500 First Year Sales 52.500 12 Variable Cost $23,000 Variable Cost $22,000 13 Fixed Development Cost $80,000,000 Sales Volume Shrink Rate 10% 14 ed Tooling and Manufacturing Cost $580,000 15 Sales Volume Growth Rate 6% 16 17 Financial Analysis Financial Analysis 18 19 Year 1 Year 2 Year 3 Year 4 Year 1 Year 2 Year 3 Year 4 20 Annual Sales 62500.0 Annual Sales 21 Revenue Revenue 22 Total Variable Cost $23,000 Total Variable Cost 23 Net Profit Net Profit 24 25 Net Present Value Net Present Value 26 C 27 28 29 30 31 32 33