Provide excel formulas to get the answers to #1. Provide critical thinking answers to question #2.

Proposal A The auto airbags production division submitted a proposal for a new airbag model that would cost $2,550,000 to develop. The anticipated revenue stream for the next 10 years was $425,000 per year. Proposal B The aerospace division proposed the development of new radar surveillance equipment. The anticipated cost was $2,647,000. The anticipated revenue stream for this project was $475,000 per year for the next 10 years. Proposal C Proposal C was a second proposal from the auto airbags division. It called for special equipment to be used in the disposal of environmentally harmful waste material created in the manufacturing process. The equipment cost $154,860 and was expected to provide cost savings of $25,000 per year for 15 years. Proposal D Proposal D was a second proposal from the aerospace division. It called for the development of a new form of micro electric control system that could be used for fighter jets that were still in the design stage at another aerospace company. If the other aerospace company was successful in the development of the fighter jets, they would be sold to underdeveloped countries in various sectors of the world. The cost to produce the micro electric control system was $1,626,500 and the best guess estimate was that the investment would return $325,000 a year for the next eight years. 1. Compute the internal rate of return and the net present value for each of these four proposals. 2. Based strictly on the calculations, which proposals should be accepted or rejected. Use the appropriate divisional discount rate. The net present value provides the answer directly while the internal rate of return must be compared to the discount rate (which is the same as the required rate of return)