use exce for any calculations

\begin{tabular}{|l|r|r|r|r|r|} \hline & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 \\ \hline Sales(units) & 160000 & 170000 & 130000 & 105000 & 80000 \\ \hline Depreciation rate & 0.1429 & 0.2449 & 0.1749 & 0.1249 & 0.0893 \\ \hline Sales of old PDA & 95000 & 65000 & & & \\ \hline Lost sales & 30000 & 30000 & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline Price & 575 \\ \hline VC & 245 \\ FC & 6900000 \\ \hline Price of old PDA & 385 \\ \hline Price reduction & \\ \hline of old PDA & 235 \\ \hline VC of old PDA & 155 \\ Tax nte & 0.21 \\ \hline NWC percentage & 0.2 \\ \hline Required return & 0.12 \\ \hline \end{tabular} Sensivity analysis New price 540 Quantity change 100 NOTE: Change in units per year Conch Republic Electronics, Part 2 Shelley Couts, the owner of Conch Republic Electronics, has received the capital budgeting analysis from Jay McCanless for the new smartphone the company is considering. Shelley is pleased with the results, but she still has concerns about the new smartphone. Conch Republic has used a small market research flrm for the past 20 years, but recently the founder of that firm has retired. Because of this, Shelley is not convinced the sales projections presented by the market research firm are entirely accurate. Additionally, because of rapid changes in technology. she is concerned that a competitor may enter the market. This would likely force Conch Republic to lower the sales price of its new smartphone. For these reasons, she has asked Jay to analyze how changes in the price of the new smartphone and changes in the quantity sold will affect the NPV of the project. Shelley has asked Jay to prepare a ntmo answering the following questions QUESTIONS 1. How sensitive is the NPV to changes in the price of the new smartphone? 2. How sensitive is the NPV to changes in the quantity sold of the new smartphone