Question

In: Finance

Objective: Students demonstrate ability to 1. Utilize several capital budgeting concepts. 2. Complete required calculations. 3....

Objective: Students demonstrate ability to

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

Scenario: D & H Enterprises is considering building a new plant overseas or expanding their product line.
                  Cost will be $3,500 million for either option. Discount rate for both projects is 11%.

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

Year

Option A: Build New

Option B: Expand Line

1

$ 1000

$ 500

2

1500

1500

3

3000

3500

4

4000

4000

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.
                                 Assume 11% as discount rate.

                         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 4% as the reinvestment rate.

            B. Compose an email to senior management of D & H Enterprises (same format as Special Problem #1)…

1. Subject line states main purpose of email

2. Open email with salutation to your senior manager.

3. First sentence is recommendation to either
    Option A: build new plant in another country
    Option B: expand product line

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

5. Close email with summary statement and sign-off appropriate for business.
                          
Use good business writing – subject line should be short and informative, body is concise,
                                  conclusion restates primary points. See rubric for details.

Solutions

Expert Solution

As per rules I am answering the first 4 subparts of the question

The cash flows and cumulative CF are as below

Year Option A: Build New Cumulative CF Option B: Expand Line Cumulative CF
0 -3500 -3500 -3500 -3500
1 $1,000 ($2,500) $500 ($3,000)
2 1500 ($1,000) 1500 ($1,500)
3 3000 $2,000 3500 $2,000
4 4000 $6,000 4000 $6,000

Accordingly the 4 answers are

Option A Option B
Payback 2.33 2.43
NPV $3,446.83 $3,361.98
IRR 41.69% 39.15%
MIRR 31.75% 31.35%

WORKINGS


Related Solutions

1. What is capital budgeting? Discuss the five stages in the capital budgeting process. 2. Suppose...
1. What is capital budgeting? Discuss the five stages in the capital budgeting process. 2. Suppose a toy manufacturer is faced with the following collection of investment projects: (a) Opening a retail outlet (b) Introducing a new line of dolls (c) Introducing a new action figure in an existing line of action figures (d) Adding another packaging line to the production process (e) Adding pollution control equipment to avoid environmental fines (f) ) Computerizing the doll-molding equipment (g) Introducing a...
Complete this question by entering your answers in the tabs below. Required 1 Required 2 Complete...
Complete this question by entering your answers in the tabs below. Required 1 Required 2 Complete the above schedule of the company’s total costs and costs per unit. (Round the per unit variable cost and fixed cost to 2 decimal places.) Units Produced and Sold 69,000 89,000 109,000 Total costs: Variable costs $213,900 Fixed costs 390,000 Total costs $603,900 $0 $0 Cost per unit: Variable cost Fixed cost Total cost per unit $0.00 $0.00 $0.00
Discuss how you understand the following concepts instrumental in capital budgeting decision making: 1.Opportunity cost 2.Cannibalization...
Discuss how you understand the following concepts instrumental in capital budgeting decision making: 1.Opportunity cost 2.Cannibalization 3.Positive externalities 4.Sunk cost. Note, providing just definitions would not satisfy requirements for this discussion. Initial response 250-300 words
Objective: Apply concepts related to contract law and contract creation (Unit 2 and 3 - CLO...
Objective: Apply concepts related to contract law and contract creation (Unit 2 and 3 - CLO 3) Description: Students will create a binding contract based on the conditions suggested by the instructor. Based on the contract students will write a descriptive essay explaining the elements and clauses in the contract. Grading: Grading Rubric has been provided.
A.    Capital Budgeting Evaluation Process 1.    2.    3.    4.    5.    B.    Cash Payback. 1.   Describe __________________
A.    Capital Budgeting Evaluation Process 1.    2.    3.    4.    5.    B.    Cash Payback. 1.   Describe __________________________________________________ ___________________________________________________________ 2.   Net annual cash flow is computed by ___________________________ ________________________________________________________. a.     Cash Payback Period = b.     The shorter the payback period, the more ___________the investment. c.     The cash payback technique recognizes that: (1) (2)    d.     In the case of uneven net annual cash flows, the company determines the cash payback period when _____________________________ _____________________________________________________ C.    Net Present Value Method. 1.    2.    3.    4.   The net present value method involves discounting net cash flows...
Capital Budgeting For the following two projects, determine the 1. Payback Period 2. Discounted Payback 3....
Capital Budgeting For the following two projects, determine the 1. Payback Period 2. Discounted Payback 3. Net Present Value 4. Profitability Index (Benefit-Cost Ratio) 5. Internal Rate of Return 6. Modified Internal Rate of Return Project A Project B Year Net Income Cash Flow Net Income Cash Flow 0 (15,000) (19,000) 1 5,000 6,000 3,000 4,000 2 5,000 6,000 5,000 6,000 3 5000 6,000 7,000 8,000 4 5,000 6,000 11,000 12,000 Risk Index 1.80 .60 The firm’s cost of capital...
1. 2 capital budgeting methods that use present value analysis and describe each. 2. 2 capital...
1. 2 capital budgeting methods that use present value analysis and describe each. 2. 2 capital budgeting methods that do not use present value analysis and describe each.
Discuss advantages and disadvantages of the following of the following capital budgeting techniques: 1.NPV 2.IRR 3.Payback...
Discuss advantages and disadvantages of the following of the following capital budgeting techniques: 1.NPV 2.IRR 3.Payback Initial response 250-300 words
Ethics involved with capital budgeting proposal (Learning Objectives 1, 2, 3, 4, & 5) Carlson Products,...
Ethics involved with capital budgeting proposal (Learning Objectives 1, 2, 3, 4, & 5) Carlson Products, Inc., is a manufacturer of a variety of construction products, including insulation, pipe, and gypsum. The company has been experiencing steady growth over the past few decades and is moderately profitable. The board of directors at Carlson has developed criteria that all capital budgeting projects undertaken at Carlson must meet in order to be approved: The project’s net present value (NPV) must be positive....
Objective: Create an Inheritance Hierarchy to Demonstrate Polymorphic Behavior 1. Create a Rectangle 2. Class Derive...
Objective: Create an Inheritance Hierarchy to Demonstrate Polymorphic Behavior 1. Create a Rectangle 2. Class Derive a Square Class from the Rectangle Class 3. Derive a Right Triangle Class from the Rectangle Class 4. Create a Circle Class 5. Create a Sphere Class 6. Create a Prism Class 7. Define any other classes necessary to implement a solution 8. Define a Program Driver Class for Demonstration (Create a Container to hold objects of the types described above Create and Add...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT