Below SIX PROJECTS USING PAYBACK OF 5 YEARS OR LESS While

Below : SIX PROJECTS , USING PAYBACK OF 5 YEARS OR LESS

While the management reviews both the IRR and NPV for all projects, the decision is generally based on the NPV provided the IRR meets the minimum criteria.

A & B are mutually exclusive and one of them must be chosen before any of the others are considered for selection.

The others can be accepted regardless of which others are chosen, depending on remaining funding. Additionally, to the change in the cost of capital related to issuing stock, the company would reduce the payback period to 4.5 years.   

This is information I have been provided and calculated.

Would appreciate help on which projects to choose & why. Also (HOW-TO / WHICH #\'s to use) calculating the selected projects NPV. (My own calculations weren\'t working.)

What would be the impact of changing the WACC assumptions?

RETAINED EARNINGS
Source Historical Weights Cost of Capital Weighted Cost
DEBT 40% 0.20% 0.08%
PREFERRED 20% 13.09% 2.62%
COMMON 40% 13.16% 5.26%
26.45% 7.96%
ISSUING SHARES
Source Historical Weights Cost of Capital Weighted Cost
DEBT 40% 0.20% 0.08%
PREFERRED 20% 13.09% 2.62%
COMMON 40% 16.27% 6.51%
29.56% 9.21%

Solution

Here I am taking highers WACC of 9.21% to choose between the projects.

NPV of Proj B is more so choose that project.

If WACC is changed NPV wil change and if WACC > IRR, viable project will become unviable.

-525000 -750000
73253.37 137350.0595
83844.62 125766.9257
99805.88 115160.6315
101933.8 105448.7973
96555.99 96555.99055
55994.99 88413.14032
43177.07 80957.00057
34593.84 74129.65898
27151.23 67878.08715
22789.7
114100.5 141660.2915 NPV

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site