Question: Please give me a direction on how to do this exercise. I have done it before, but I cannot find the correct answer. Also, please

 Please give me a direction on how to do this exercise.
I have done it before, but I cannot find the correct answer.
Please give me a direction on how to do this exercise. I have done it before, but I cannot find the correct answer. Also, please explain. How did you apply an Excel?
i need a quick and correct answer.

Please open the Excel spreadsheet and enter these given data in the appropriate fields. Then complete the calculations in the yellow fields to eventually calculate the net present value and price per share impact. Good Luck Project information: XXX Motors is evaluating a large investment into a self-driving/safety project. Relevant costs and benefits are listed below - remember that some of these are inflows and others are outflows of cash: Cost to develop the technology $8,000,000,000. Additional revenue per vehicle sold $1200. Number of cars sold with this feature 2,000,000 Fixed Cost to update the technology $100,000,000 Variable cost of installation per vehicle $100 Amortization of the cost to develop the technology $80,000,000. Tax rate 28% Disposition value of technology $0 Weighted average cost of capital 8.00% Number of shares outstanding 500,000,000 Net present value --Week 4 -- Practice Set: Acquisition stage cash flow: Coul of wome Operating stage cash flow in one of 2023 2004 2005/ 2006 2020 2020 2020 2031 Number of unsold with four not in million Premium charge pervice Alus below we Se on Feed Content Variable Casting technology Artion development Telecome Thom After lux income Add to Operating cowhow Disposition stage cash flow Techto Per Rut Present Value Number of share of common sek buttanding Expected nereste in vale per share

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!