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

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadlines.


Order a Similar Paper Order a Different Paper

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.

Document Preview:

Name ________________________ MFP Cycle 11 Learning Exercise 1: General Comments: Please use your own words and document resources used in answering all of the following questions. To answer the questions, just expand the area under the questions in this document. With the empirical work please copy or past it into the document or embed the answers in the Word document. Also remember to write your name on the document. The document should be submitted to the Assignment folder under LE 1. A Reading List will also be provided in the assignment section under the LE 1 folder. Don’t worry about getting the exact answer for all of the questions, it is a learning process. I would like you to solve the problems using the formulas to insure that you understand the process. 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. Data: Price of 15-year bond is $1,075, face value of the bond is $1,000, and the coupon rate is 5.35% and the coupon payments are paid annually. The EPS of the company is $9.76, the dividend payout ratio is 32%, and the stock price is $67.89 (Assume a constant growth model) Assume the debt equity ratio is .35 The Net Cash Outlay (NCO) of the project is – $18,750, 000 After tax cash flows for year 1 = – $2,278,000 After tax cash flows for year 2 = …

Attachments:

"Is this question part of your assignment? We can help"

ORDER NOW
Writerbay.net

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper