Numerical problem

NUMERIC PROBLEM

Below is your numeric problem and you must complete the problem in Microsoft Excel and submit it in that format to the submission area. You may use any of your course materials in addition to the tutorial video to help you. For this problem, you will need to calculate the Weighted Average Cost of Capital and apply capital budgeting decision rules. This assignment is due by 11:59 p.m. (ET) on Sunday of Module/Week 7.

NUMERIC PROBLEM – Search online for a sport organization of your choice, similar to previous assignments. Be certain the organization has plenty of fiscal data available to complete the following calculations in Microsoft Excel:

Cost of Debt, Preferred Stock/Common Stock and the Weighted Average of Capital.

Payback Rule and Rationale

Discounted Payback Rule and Rationale

NPV Rule and Rationale

IRR Rule and Rationale

Explanation of the Decision-Making for these previous decisions.