Please See Attached. Please Follow Directions Carefully
Please See Attached. Please Follow Directions Carefully.
Evaluating Costs and BenefitsGarrison Appliances Inc.Read the information below and complete Parts All BOLDED Font ExercisesYou will set up and use an Excel spreadsheet for all your calculations for the problemsbelow, and the spreadsheet you develop should be what you turn in.Garrison Appliances, Inc., is considering expanding its international presence. It sells 25% of allthe toaster ovens sold in the United States, but only 3% of the toaster ovens sold outside of theUnited States. The company believes that it can sell more of its product if it has a productionfacility located overseas.1) Prepare a written report for the board of directors detailing exactly how youcomputed each item in the chart below for each proposal and then explain indetail the conclusion you reached regarding the feasibility of each proposal. If theboard decides to invest in only one location, explain which one it should be andwhy.______________________________________________________________________2) What other factors should be considered before making a decision and why?3) Evaluate and prepare calculation of the proposed locations using each of thefollowing: PREPARE CALCULATION FOR ALL 5 OF THE CATEGORIES USE THECHART BELOW TO COMPUTE:average rate of return on investmentpayback periodnet present valueprofitability indexinternal rate of return.Estimates concerning two possible locations, Mumbai and Bangalore are belowPossible LocationMumbaiBangaloreInitial cash outlay$5,000,000 $2,800,000Useful life20 years20 yearsNet cash inflows excluding depreciation $1,100,000 $860,000The cost of capital9%9%Tax rate40%40%
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
