PLEASE FILL OUR SPREADSHEETS thank you

Assignment 1 Part 2 - Economic Analysis of Product Development Projects ( 30 pts) VidMark, a manufacturer of cellphones, is developing a new model (VidPhone X70) that will be released on the market when development is complete. This phone will be revolutionary in that it will allow the user to place group video phone calls. VidMark is concerned about the development cost and time. They are also worried about market estimates of the sales of the new VidPhone X70. The cost estimates and forecast are given in the table below: Use the data above to develop a base case analysis. The project schedule is shown below with timings of the cash flows. There are several questions that need to be answered for VidMark on this project: a. What are the yearly cash flows and their present value (PV, discounted at 12% ) of this project? What is the net present value (NPV)? b. What is the impact on VidMark if their sales estimates are off by 20% ? c. What is the impact on VidMark if their unit production cost is $85