Question 3.What are the NPV, IRR, MIRR, payback period, and discounted payback period for Boeing's new plane?

Transcribed Image Text:

A New Aircraft Project at Boeing, Inc. Boeing announced the production of a new passenger aircraft in the wake of the Boeing 737 MAX debacle. The new plane project was an enormous undertaking, and much of the preliminary work has already been done. Research and development began two and a half years earlier and cost about $5 billion. Production facilities and personnel training would require an additional $2 billion, and an additional $1.7 billion in working capital would begin in six years. The Exhibit 1 provides profit, depreciation, and capital expenditure projections for the project. Also, the financial analysis team has the following data for Boeing: Boeing's beta 1.56 Boeing's market-value debt ratio 0.09 Boeing's new issue rate for long-term debt 4.75% Riskless return 3.75% Market risk premium 5.00% Boeing's marginal income tax rate 21% Please answer the following questions: 1. What are the after-tax cash flows for the project? 2. What is the cost of equity capital and the weighted average cost of capital (WACC) for Boeing? 3. What are the NPV, IRR, MIRR, payback period, and discounted payback period for Boeing's new plane? 4. Construct an NPV profile like Figure 9-3 in the textbook, including titles for the axes and the graph's name. 5. Based on your analysis in #2 and #3, would you undertake the plane project? Why? Complete the Excel worksheet template (on Canvas) to answer questions #1 - #4. Show all calculations in Excel using the built-in arithmetic and financial function formulas. No credit will be given for mathematical calculations not done in the Excel worksheet. Save your file in .xlsx format with the file name: last name, first name initial, and the assignment (Boeing). (eg Winkler D Boeing) A New Aircraft Project at Boeing, Inc. Boeing announced the production of a new passenger aircraft in the wake of the Boeing 737 MAX debacle. The new plane project was an enormous undertaking, and much of the preliminary work has already been done. Research and development began two and a half years earlier and cost about $5 billion. Production facilities and personnel training would require an additional $2 billion, and an additional $1.7 billion in working capital would begin in six years. The Exhibit 1 provides profit, depreciation, and capital expenditure projections for the project. Also, the financial analysis team has the following data for Boeing: Boeing's beta 1.56 Boeing's market-value debt ratio 0.09 Boeing's new issue rate for long-term debt 4.75% Riskless return 3.75% Market risk premium 5.00% Boeing's marginal income tax rate 21% Please answer the following questions: 1. What are the after-tax cash flows for the project? 2. What is the cost of equity capital and the weighted average cost of capital (WACC) for Boeing? 3. What are the NPV, IRR, MIRR, payback period, and discounted payback period for Boeing's new plane? 4. Construct an NPV profile like Figure 9-3 in the textbook, including titles for the axes and the graph's name. 5. Based on your analysis in #2 and #3, would you undertake the plane project? Why? Complete the Excel worksheet template (on Canvas) to answer questions #1 - #4. Show all calculations in Excel using the built-in arithmetic and financial function formulas. No credit will be given for mathematical calculations not done in the Excel worksheet. Save your file in .xlsx format with the file name: last name, first name initial, and the assignment (Boeing). (eg Winkler D Boeing)

Answer rating: 100% (QA)

Sure lets delve deeper into each question 1 Aftertax cash flows for the project To calculate the aftertax cash flows you need to first determine the c... View the full answer