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: Option A: Build New $ 1000 1500 3000 4000 Option B: Expand Line $500 1500 3500 4000 Year 4 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 reference:s 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 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 C. Submit both the Excel file and the Word document to Blackboard 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: Option A: Build New $ 1000 1500 3000 4000 Option B: Expand Line $500 1500 3500 4000 Year 4 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 reference:s 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 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 C. Submit both the Excel file and the Word document to Blackboard