Project #31444 - Excel Spreadsheet: Evaluating Costs and Benefits

Decisions involving capital expenditures often require managers to weigh the costs and benefits of different options related to the same goal or project. For instance, deciding whether to replace, repair, or do nothing to existing equipment is a capital expenditure decision that involves calculations, projections, and deliberations. Similarly in HR management, deciding whether to train from within or outsource involves alternate expenses. Managers must be able to quantitatively analyze different options for capital expenditure to identify the best business decisions having the greatest estimated long term ROI. For this Application, you will have the opportunity to utilize the information in this week’s Resources to make a recommendation in regard to a capital expenditure.

 

You will set up and use an Excel spreadsheet for all your calculations for the problems below, and the spreadsheet you develop should be what you turn in for the Application. Note: The Resources section includes tutorials for those who might need help in designing and using an Excel spreadsheet.

 

Garrison Appliances Inc.
Read the information below and complete Parts I, II and III

 

Garrison Appliances, Inc., is considering expanding its international presence. It sells 25% of all the toaster ovens sold in the United States, but only 3% of the toaster ovens sold outside of the United States. The company believes that it can sell more of its product if it has a production facility located overseas. Estimates concerning two possible locations, Mumbai and Bangalore, follow:

 

Possible LocationMumbaiBangalore
Initial cash outlay $5,000,000 $2,800,000
Useful life 20 years 20 years
Net cash inflows excluding depreciation $1,100,000 $860,000
The cost of capital 9% 9%
Tax rate 40% 40%



Evaluate each of the proposed locations using each of the following: 1) average rate of return on investment, 2) payback period, 3) net present value, 4) profitability index, and 5) internal rate of return.

Part I: Prepare a written report for the board of directors detailing exactly how you computed each item for each proposal and then explain in detail the conclusion you reached regarding the feasibility of each proposal. If the board decides to invest in only one location, explain which one it should be and why.

Part II: What other factors should be considered before making a decision and why?

Part III What HRM considerations might be included in this specific capital budgeting analysis? Be specific, how could cash inflows and outflows be analyzed.

Subject Business
Due By (Pacific Time) 06/05/2014 12:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy