Please complete by Saturday, January 13th in an excel spreadsheet and in word with an executive summary explaining. Also need a business report of the findings. Below are the details…Thank you

1. Capital Budgeting Case – From the given case information (see attachment)
   1. Calculate the firm’s WACC then use the WACC to calculate NPV and evaluate IRR for proposed capital budgeting projects with a capital rationing constraint.
   2. After you choose the project(s), recalculate the capital structure based on the assumption that the project(s) are implemented and determine if the new capital structure will signal the investors either positively, negatively, or not at all.
   3. Write a business report on your findings. Include an executive summary and appendices if applicable.

NOTE: See rubric for specific graded criteria. Click on the attached document for additional information.

RUBRIC

Content, Research, and Analysis

Requirements – The Portfolio includes all of the required components, as specified in the assignment.

Content – Demonstrates strong or adequate knowledge of the materials; correctly represents knowledge from the readings and sources.

Purpose of the proposal – Purpose of the proposal is well defined, supported and articulated.

Explanation of Financing – Company’s WACC, capital structure, dividend policy if applicable, and the reason for the change in financing are clearly explained. Alternatives that meet the company’s expectations for increasing shareholder value are presented.

Report of Presentation Structure – Quantitative findings are clearly stated and well integrated into the written report or presentation. Executive summary is complete and one page or less.

Quantitative Calculations – WACC (NPV and IRR, if applicable) are included and calculated correctly. Financing and other calculations are included and correct.

Common Core

Critical Thinking – Applies critical thinking and reasoning skills for effective analysis.

Ethics – Prescribes actions to effectively address a variety of ethical situations that support social responsibility.

Leadership – Demonstrates effective leadership and teamwork skills.

Technology – Selects current technology applications and applies to specific problems and challenges in the work place and professional skills.

Mechanics and Writing

Organization – Project is clearly organized, well written, and in proper essay format including an introduction, body, and conclusion. Conforms to project requirements.

Grammar and Style – Strong sentence and paragraph structure; few or no minor errors in grammar and spelling; appropriate writing style; clear and concise with no unsupported comments.