PLEASE SHOW EXCEL WORK AND FUNCTIONS!

Conch Republic Electronics, Part 2 Shelley Couts, the owner of Conch Republic Electronics, has its new smartphone. For these reasons, she has asked Jay to received the capital budgeting analysis from Jay McCanless analyze how changes in the price of the new smartphone and for the new smartphone the company is considering. Shelley is changes in the quantity sold will affect the NPV of the project. pleased with the results, but she still has concerns about the new Shelley has asked Jay to prepare a memo answering the folsmartphone. Conch Republic has used a small market research lowing questions. firm for the past 20 years, but recently the founder of that firm has retired. Because of this, Shelley is not convinced the sales QUESTIONS projections presented by the market research firm are entirely 1. How sensitive is the NPV to changes in the price of the accurate. Additionally, because of rapid changes in technology, new smartphone? she is concerned that a competitor may enter the market. This would likely force Conch Republic to lower the sales price of 2. How sensitive is the NPV to changes in the quantity sold of the new smartphone? =