Statistical Analysis, Capital Budgeting, and Risk Analysis Introduction: Learning exercise 1 will…

Statistical Analysis, Capital Budgeting, and Risk Analysis
Introduction:
Learning exercise 1 will serve as an introduction to statistical analysis and introduce the basics of corporate finance including capital budgeting models, bond and stock valuation, and risk analysis. This learning exercise will use data from the Wharton Database to perform specific statistical analysis using Excel.1) Using the following information determine the NPV, Profitability Index, and IRR of the following project. For simplicity assume that the company only has debt and equity and all of the company’s debt is in 15 year bonds. Would the company move forward with the project? Please explain.