Question

In: Finance

1) Use an Excel spreadsheet to evaluate the Pear Computer Company proposal. 2) Conduct a sensitivity...

1) Use an Excel spreadsheet to evaluate the Pear Computer Company proposal. 2) Conduct a sensitivity analysis that focuses on the cost of capital. For a best case scenario, decrease the cost of capital by three percentage points. For a worst case scenario, increase the cost of capital by three percentage points. 3) You must provide one spreadsheet for each of the three situations—the base case estimate, the best case, and the worst case. 4) What do you recommend? Explain. You may type your recommendation and explanation on the Excel sheet.

Pear Computer’s research and development (R&D) department has developed a proposal for a new generation of tablet-sized computers. 1. Project’s useful life: 4 years. 2. Capital expenditures: $25,000,000. 3. Depreciation: straight-line over 4 years. 4. Sales: 25000 units in year 1, 95,000 in year 2, 70,000 in year 3, 25,000 in year 4. The sales price is expected to remain constant at $580. 5. Cost of goods sold (not counting depreciation): 60% of sales. 6. Selling, general and administrative expenses: $1,500,000 the first year, $1,750,000 the second year, $1,000,000 the third, and $500,000 the 4th . 7. R&D: $1,500,000 spent one year ago. 8. Initial investment in net working capital: $1,250,000. Then it increases by $10,000 for each of three years and finally is fully recovered in the final year. 9. Tax rate: 38%. 10. Cost of Capital: 14%

Solutions

Expert Solution

Answer 1:

Base Case:

Answer 2 (a):

Sensitivity analysis:

Best Case:

Cost of capital = 14% - 3% = 11%

Answer 2(b)

Worst case:

Cost of capital = 14% + 3% = 17%

Answer 3:

Separate evaluations as required are given in above answers.

Answer 4:

As we observe above:

Base case NPV is positive at $1,746,303.92

Worst case NPV is also positive at $47,632.78

Hence Project should be accepted.


Related Solutions

1) Use an Excel spreadsheet to evaluate the Pear Computer Company proposal (info below). 2) Conduct...
1) Use an Excel spreadsheet to evaluate the Pear Computer Company proposal (info below). 2) Conduct a sensitivity analysis that focuses on the cost of capital. For a best case scenario, decrease the cost of capital by three percentage points. For a worst case scenario, increase the cost of capital by three percentage points. 3) You must provide one spreadsheet for each of the three situations—the base case estimate, the best case, and the worst case. 4) What do you...
1) Use an Excel spreadsheet to evaluate the ABCD Company proposal. 2) Conduct a sensitivity analysis...
1) Use an Excel spreadsheet to evaluate the ABCD Company proposal. 2) Conduct a sensitivity analysis that focuses on the cost of capital. For a best case scenario, decrease the cost of capital by three percentage points. For a worst case scenario, increase the cost of capital by three percentage points. 3) You must provide one spreadsheet for each of the three situations—the base case estimate, the best case, and the worst case. 4) What do you recommend? Explain. You...
Evaluate the Pear Computer Company proposal. 2) Conduct a sensitivity analysis that focuses on the cost...
Evaluate the Pear Computer Company proposal. 2) Conduct a sensitivity analysis that focuses on the cost of capital. For a best case scenario, decrease the cost of capital by three percentage points. For a worst case scenario, increase the cost of capital by three percentage points. 3) You must provide one spreadsheet for each of the three situations—the base case estimate, the best case, and the worst case. 4) What do you recommend? Explain. You may type your recommendation and...
,10. ***( I NEED TO SOLVE THIS WITH EXCEL SPREADSHEET AND SENSITIVITY REPORT) *** Grave City...
,10. ***( I NEED TO SOLVE THIS WITH EXCEL SPREADSHEET AND SENSITIVITY REPORT) *** Grave City is considering the relocation of several police substations to obtain better enforcement in high-crime areas. The locations under consideration together Potential Locations for Substations: Areas Covered: A 1,5,7 B 1,2,5,7 C 1,3,5 D 2,4,5 E 3,4,6 F 4,5,6 G 1,5,6,7 a. Formulate an integer programming model that could be used to find the minimum number of locations necessary to provide coverage to all areas....
I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to...
I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to solve problem #31 (the PUTZ, Inc. project) for Chapter 10 in the textbook. 2) Conduct a sensitivity analysis that focuses on the sales price by increasing the price by 10% above the best estimate, and then by decreasing the price by 10% below the best estimate. 3) You must provide one spreadsheet for each of the three situations—the base case estimate, the best case,...
Please use Excel to solve the assignment and submit as an excel spreadsheet. Bethesda Mining Company...
Please use Excel to solve the assignment and submit as an excel spreadsheet. Bethesda Mining Company Based on a Mini Case presented in the textbook Ross, S.A., R.W. Westerfield and J. Jaffe, Corporate Finance, McGraw Hill/Irwin. Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the...
1. Understand how to use EXCEL Spreadsheet (a)  Develop proforma Income Statement Using Excel Spreadsheet (b)  Compute  Net Project...
1. Understand how to use EXCEL Spreadsheet (a)  Develop proforma Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cashflows, NPV,  and IRR (c) Develop problem-solving and  critical thinking skills and make long-term investment decisions 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $200,000 2) New equipment cost $(200,000) 9) Sales increase per year 5% 3) Equipment ship & install cost $(35,000) 10) Operating cost (60% of Sales) $(120,000) 4) Related start up cost $(5,000)     (as a percent...
a. Use the multiple regression spreadsheet provided in the Excel spreadsheet to do the following: create...
a. Use the multiple regression spreadsheet provided in the Excel spreadsheet to do the following: create a new data set that is a subset of this larger provided data set. The new data set should include the dependent variable (VALUE) and the following independent variables (AGE, LOTSIZE, RMS, MOD KITCH, MOD BATH, AIRCON and FIREPL). b. For this new data set, use the Correlation option of Data Analysis in Excel and produce the correlation matrix associated with the dependent variable...
Need Excel Format and screenshot The attached printout of an Excel spreadsheet shows the use of...
Need Excel Format and screenshot The attached printout of an Excel spreadsheet shows the use of six financial formulas related to the time-value-of-money concepts discussed in Chapter 5. Your task is to reproduce the spreadsheet using Excel financial formulas in the red cells, which have the names shown in blue in the adjacent cells. You can find the financial formulas in Excel by clicking on Formulas at the top of the spreadsheet, and then clicking on Financial. You will submit...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the following investments. Investment A B Initial Investment $                8,500.00 $      9,500.00 End of Year Income 1 $                2,500.00 $      2,000.00 2 $                2,500.00 $      2,500.00 3 $                2,500.00 $      3,000.00 4 $                2,500.00 $      3,500.00 5 $                2,500.00 $      4,000.00
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT