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 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
Get step-by-step solutions from verified subject matter experts
