Problem: Congratulations! Your work on understanding and managing the costs and profitability of Claire's Antiques has resulted in record-breaking sales volume and profits. As a result, senior management is considering two new warehouse locations in order to serve its customers in the North and West more efficiently. Unfortunately, the company only has sufficient funds to invest into only one warehouse location at this time. Each warehouse will require that a new building be constructed. Claire's Antiques expects to use the warehouse for five (5) years before building a new production facility in that area. Senior management hired a consulting firm to research the potential warehouse locations. You were at a meeting with the researchers and they gave you the results of the research.
Create a power point presentation that you will make to management. Use the following assumptions:
Assume the risk-adjusted cost of capital is 10% and its tax rate is 40%. Compute the net present value (NPV) for each warehouse proposal. Include the cash flows from salvage value and the tax benefits of depreciation (assume 5-year straight-line). Incorporate the research data and graphs and charts into your presentation for support to your recommendation.
Include in your presentation recommendations on the desired warehouse location for senior management. Specify how your recommendation is affected by your assumptions for cost of capital and expected contribution margin (that is, perform a sensitivity analysis)?
The PowerPoint should include notes and graphs. Complete the calculations for cash flow and discounting in Excel.
Objective: Use capital budgeting to evaluate investment proposals.