please provide excel instructions, fill up the template in the picture attached and answer the rest of the question as well

please.

Conch Republic Electronics Monch Republic Electronics is a midsized electronics Umanufacturer located in Key West, Florida. The com- pany president is Shelly Couts, who inherited the com pany. The company originally repaired radios and other household appliances when it was founded more than 70 years ago. Over the years, the company has ex. panded, and it is now a reputable manufacturer of vart ous specialty clectronic Items Jay McCanless, a recent MBA graduate, has been hired by the company in its nance department One of the major revenue-producing items manu factured by Conch Republic is a smartphone. Conch Re- public currently has one smartphone model on the market and sales have been excellent. The smartphone is a unique them in that comes in a variety of tropical colors and is preprogrammed to play Jimmy Buffett mu. sic. However, as with any electronic item, technology changes rapidly, and the current smartphone has limited features in comparison with new models. Conch Ro public spent $1.2 million to develop a prototype for a new smartphone that has all the features of the existing one but adds new features such as Wis tethering. The company has spent a further $250,000 for a marketing study to determine the expected sales figures for the new smartphone Conch Republic can manufacture the new smart- phone for $210 each in variable costs. Fored costs for the operation are estimated to run 55.3 million per Year The estimated sales volumes are 64,000, 106,000 87.000 78,000, and 54,000 per year for each of the next five years, respectively. The unit price of the new smartphone will be $515. The necessary equipment can be purchased for $38.5 million and will be depreci- ated on a seven-year MACRS schedule. It is believed the value of the equipment in five years will be 558 mon Net working capital for the smartphones will be 20 percent of sales and will occur with the timing of the cash flows for the year , there is no initial outlay for NWC) Changes in NWCthus will occur first in Year with the first year's sales. Conch Republic has a 22 percent corporate tax rate and a required return of 12 percent Shelly has asked Jay to prepare a report that answers the following questions QUESTIONS 1. What is the payback period of the project? 2. What is the profitability index of the project? 3. What is the IRR of the pro 4. What is the NPV of the prod? 5. How sensitive is the NPV to changes in the price of the new smartphone? 6. How sensitive is the NPV to changes in the quan ity sold? 7. Should Conch Republic produce the new smartphone? 3. Suppose Conch Republic loses sales on other models because of the introduction of the new please provide excel instructions as well earch G H Year 2 Year 3 Year 4 Year 5 4 Sales 5 VC 6 Fixed costs 7 Dep 8 EBT 9 Tax 11 +Dep 12 OCF 14 NWC 15 Beg 16 End 17 NWC CF 6592000 -6592000 19 Net CF 21 Salvage 22 BV of equipment 23 Taxes 24 Salvage CF 26 Net CF 29 For Quantity Sensitivity, add 100 units to each year Sheet1