Where should Claire's Antiques buld their new warehouse?
Not what you're looking for?
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.
The results of their research
Proposal 1 Proposal 2
New Warehouse Location North Warehouse West Warehouse
Estimated first year revenue increase $650,000 $900,000
Estimated annual revenue growth 7% 8%
Estimated contribution margin % 55% 45%
Marginal tax rate 40% 40%
Estimated annual fixed costs $100,000 $120,000
Investment in facility $1,500,000 $1,700,000
One-time advertising in year 0 $140,000 $150,000
Estimated salvage value in year 6 $125,000 $120,000
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)?
Table Method (10%)
Period
1 0.9091
2 0.8264
3 0.7513
4 0.6830
5 0.6209
6 0.5645
7 0.5132
8 0.4665
9 0.4241
10 0.3885
15 0.2394
20 0.1486
25 0.0923
Purchase this Solution
Solution Summary
The solution explains how to make the selection between the North Warehouse and the South Warehouse in an attached Excel file.
Solution Preview
The calculations are in the attached file.
With the given data, both the warehouse have negative NPV. The NPV remains negative even at 0% cost of ...
Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.