I need my answer to be in an excel format

Question:

Base Case Year 1 Year 2 Year 3 Year 4 Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 ($ values in thousands) Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Develoment Cost -10000 -10000 -10000 -10000 Ramp-Up Cost -200 -200 Marketing & Support Cost -500 -500 -500 -500 -500 -500 -500 -500 -500 -500 -500 -500 Production Cost -1313 -1313 -1313 -1313 -1313 -1313 -1313 -1313 -1313 -1313 -1313 Production Volume 150000 150000 150000 150000 150000 150000 150000 150000 150000 150000 150000 Unit Production Cost -0.00875 -0.00875 -0.00875 -0.00875 -0.00875 -0.00875 -0.00875 -0.00875 -0.00875 -0.00875 -0.00875 Sales Revenue 6382.5 6382.5 6382.5 6382.5 6382.5 6382.5 6382.5 6382.5 6382.5 6382.5 6382.5 Sales Volume 150000 150000 150000 150000 150000 150000 150000 150000 150000 150000 150000 Unit Price 0.04255 0.04255 0.04255 0.04255 0.04255 0.04255 0.04255 0.04255 0.04255 0.04255 0.04255 Period Cash Flow -10000 -10000 -10000 -10200 -700 4570 4570 4570 4570 4570 4570 4570 4570 4570 4570 4570 FV Year 1, r=10% -10000 -9756 -9518 -9472 -634 4039 3941 3845 3751 3659 3570 3483 3398 3315 3234 3155 Project NPV, $ 11SCENARIO INPUT PARAMETERS . Development Costs _ $35,000,000 / year Sales & Production Volume L7500,000 units / year . Unit Production Volume 150 / unit Ramp--up Cost $500,000 / quarter : Marketing & Support Cost $2,500,000 / year The software giant would like to build a quantitative nancial model for the development and commercialization of the proposed Virtual Reality (VR) entertainment system. Nominal (base case) costs and schedules for the project are as follows: Costs (\"Magnitude"): - Development Costs: $50,000,000 / year - Sales and Production Volume: 450,000 units / year - Unit Sales Price: not specied (see part (a) below) - Unit Production cost: $175 / unit - Ramp-up cost: $600,000 / quarter - Marketing and Support cost: $1,750,000 / year Schedule (\"Timing\"): - Development: 12 months (Year 1, Ql-Q4) - Ramp-up: 6 months (Year 1, Q4; Year 2, Q1) - Marketing and Support: ongoing (starts Year 2, Q1 until Year 4, Q4) - Production and Sales: ongoing (starts Year 2, Q2 until Year 4, Q4) The software giant has asked you to model the impact of the unit sales price on the Net Present Value (NPV) of the expected prot for the project. Perform a four-year quarterly NPV analysis (assume a discount factor of 10% per year) in order to determine the following: a) The minimum value of the unit sales price for the product that will result in a positive NPV by the end of year 4. (Hint:rst set unit sales price equal to the unit production cost and then aclfust the sales price until the NPVz's equal to zero) b) What is the trade-off law between NPV and unit sales price? 0) What price would you recommend that the software giant charge a wholesale distributor (e. g. Costco) for 1 unit of the VR entertainment system? Explain your answer. d) What is the NPV of the expected prot, based on your recommended sales price from part (C)