Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Objective: Students demonstrate ability to 1. Utilize several capital budgeting concepts. 2. Complete required calculations. 3. Present oral recommendation to senior management based on resulting

image text in transcribed

Objective: Students demonstrate ability to

1. Utilize several capital budgeting concepts. 2. Complete required calculations. 3. Present oral recommendation to senior management based on resulting data.

Scenario: HW Enterprises is considering building a new warehouse or expanding overseas. Cost of either option is $20,000 million. Discount rate for building new warehouse is 11%. Senior management determines that risk of expanding overseas is greater. Therefore, discount rate for expanding overseas should be 13.5%.

Cash inflows for each options are below. Shown in millions:

Year

Option A: New Warehouse

Option B: Expand Overseas

1

$ 5,750

$ 2,000

2

7,250

6,000

3

8,500

12,000

4

10,000

12,000

Directions: Utilizing cell references and formulas, use the data in the Excel file provided to prepare

A. Calculations use the tabs provided for details of calculations move final values to summary tab using cell references.

1. Payback period calculation. Textbook page 384 has example. You need to use Excel to make your calculations.

2. Net Present Value work the process step-by-step then utilize the NPV formula under the Formulas, Financials, tab. *See Table 12.4 in text page 386 for example.

Note: you will be calculating the NPV using the two methods shown on Table 12.4. Use discount rate specified above.

3. Internal Rate of Return and Modified Internal Rate of Return utilize the IRR and MIRR formulas under the Formulas, Financial, tab in Excel. *See Table 12.5 in text page 388 for example. Assume 2% as the reinvestment rate.

B. Prepare written report of your teams recommendation to senior management of HW Enterprise. Be ready to discuss recommendation in class.

1. State how circumstances have changed related to the baseline case. Describe how that changed the results and why.

2. Recommend a course of action to senior management.

3. Support your recommendation with facts based on your Excel calculations. Refer to computations in Excel file provided as attachment.

4. Close statement by re-stating recommendation.

HW Enterprises' senior management is trying to determine if they should purchase a new warehouse or expand overseas. Both require a $20,000 million investment. Calculate payback period, net present value, IRR, and MIRR. Then develop a recommendation, with explanation, to senior management. The recommendation should be in email-format. Submit Excel file and Word document. Purchase warehouse Expand overseas Initial Investment - Year O ($20,000,000) ($20,000,000) Cash Flow Year 1 5,750,000 2,000,000 Cash Flow Year 2 7,250,000 6,000,000 Cash Flow Year 3 8,500,000 12,000,000 Cash Flow Year 4 10,000,000 12,000,000 Total Cash Inflows 31,500,000 32,000,000 C10 WACC - both options 9% Reinvestment rate 2%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction To Derivatives And Risk Management

Authors: Don M. Chance, Roberts Brooks

7th Edition

0324321392, 9780324321395

More Books

Students also viewed these Finance questions

Question

Use KrgerVink notation to show 1.ZnO (Zn 1+x O) 2.Fe 2 O 3

Answered: 1 week ago