Final answer:
Using net present value (NPV), the XYZ Company should choose between the two warehouses by calculating and comparing the NPVs for location A, including the upfront fee and monthly payments, and location B, with just the monthly lease costs, both against the steady monthly revenue.
Step-by-step explanation:
To determine which warehouse is the better choice for the XYZ Company, we must calculate the net present value (NPV) for each option over the 3-year period, considering the estimated 10% annual rate of return. The present value of an amount 'P' to be received in the future, 'n' years from now, at an interest rate 'r' is given by the formula PV = P / (1 + r)^n.
For location A, the total lease cost is the $2000 upfront fee plus $1000 per month for 36 months. The NPV for location A is the sum of the present values of these costs. The revenues from the warehouse ($1500 per month) must also be considered in the calculation for the net result.
For location B, the monthly lease cost is $1200, without any upfront fee. As this is a monthly arrangement, we must calculate the present value of each monthly lease payment separately and sum them for the total NPV. Again, the monthly revenue must be considered in the net NPV calculation.
After calculating the NPVs for both locations A and B, taking into account the respective costs and the consistent monthly revenue, the location with the higher NPV will be the more cost-effective choice for the XYZ Company.