Question: Please show computations in Excel formula. Hampton Manufacturing estimates that its WACC is 12.5%. The company is considering the following investment projects: Project Size IRR

Please show computations in Excel formula.

Hampton Manufacturing estimates that its WACC is 12.5%. The company is considering the following investment projects:

Project	Size	IRR
A	$750,000	14.0%
B	$1,050,000	13.2%
C	$1,000,000	11.0%
D	$1,250,000	10.7%
E	$750,000	13.2%
F	$650,000	12.7%
G	$500,000	10.2%

a. Assume that each of the projects is independent and that each is just as risky as the firms existing assets. Which set of projects should be accepted, and what is the firms optimal capital budget?

b. Now assume that Projects A and B are mutually exclusive. Which set of projects should be accepted, and what is the firms optimal capital budget?

c. Management has decided to adopt capital rationing for the next year. The budget limit for the next year is $3million. Assume that all projects are independent. Which set of project should be accepted, and what is the proposed capital budget total for the coming year?

Please show computations in Excel formula.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Homework must be summitted in excel. Please provide answers on how they would be entered in excel. Thank you. 13-5 OPTIMAL CAPITAL BUDGET Hampton Manufacturing estimates that its WACC is 12.5%. The...

OPTIMAL CAPITAL BUDGET Hampton Manufacturing estimates that its WACC is 12,5%. The company is considering the following seven investment projects; Size IRR A $750,000 14.0% 8 1,250,00 13.5 ?...

OPTIMAL CAPITAL BUDGET Hampton Manufacturing estimates that its WACC is 12.5%. The company is considering the following seven investment projects: Project Size IRR A $750,000 14.0% B 1,250,000 13.5 C...

The Paulson Company's year-end balance sheet is shown below. Its cost of common equity is 18%, its before-tax cost of debt is 9%, and its marginal tax rate is 25%. Assume that the firm's long-term...

OPTIMAL CAPITAL BUDGET Hampton Manufacturing estimates that its WACC is 12.5%. The company is considering the following seven investment projects: Project Size $750,000 1,250,000 1,250,000 1,250,000...

OPTIMAL CAPITAL BUDGET Hampton Manufacturing estimates that its WACC is 12.5%. The company is considering the following seven investment projects; Project Size $750,000 1,250,000 1,250,000 1,250,000...

Hampton Manufacturing estimates that its WACC is 12.5%. The company is considering the following seven investment projects: Project Size IRR A $750,000 14.0% B 1,250,000 13.5 C 1,250,000 13.2 D...

Hampton Manufacturing estimates that its WACC is 12.5%. The company is considering the following seven investment projects: Project Size IRR A $ 800,000 14.0 % B 1,000,000 13.5 C 1,000,000 12.9 D...

While the imaginal disks are growing (Exercise 63), the yolk of the egg is shrinking according to Y(t) = 4.0e-1.2t. Create graphs comparing S1(t) and Y(t). The following pairs of measurements can be...

In order to create a new marketing plan for Chipotle Mexican Grill, the company has completed a detailed SWOT analysis to assess the current strengths, weaknesses, opportunities, and threats to the...

A firm's dividend policy has typically resulted in a low dividend yeld. and that crcumstance is expected to continue. As a result, the majority of the firm's shareholders are individuals who prefer...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...