Lou Lewis, the president of Lewisville Company, has asked you to give him an analysis of the best use of a warehouse the company owns.

1. Lewisville Company is currently leasing the warehouse to another company for $5,900 per month on a year-to-year basis. (Hint: Use the PV function in Excel to calculate, on an after-tax basis, the PV of this stream of monthly rental receipts.)
2. The warehouses estimated sales value is $222,000. A commercial realtor believes that the price is likely to remain unchanged in the near future. The building originally cost $64,500 and is being depreciated at $1,950 annually. Its current net book value (NBV) is $7,950.
3. Lewisville Company is seriously considering converting the warehouse into a factory outlet for furniture. The remodeling will cost $145,000 and will be modest because the major attraction will be rock-bottom prices. The remodeling cost will be depreciated over the next 5 years using the double-declining-balance method. (Note: Use the VDB function in Excel to calculate depreciation charges. The advantage of using the VDB, rather than the DDB, function is that there is a (default) option in the former that provides an automatic switch to the straight-line method when it is advantageous to do so.)
4. The inventory and receivables (net of current liabilities) needed to open and sustain the factory outlet would be $670,000. This total is fully recoverable whenever operations terminate.
5. Lou is fairly certain that the warehouse will be condemned in 10 years to make room for a new highway. The firm most likely would receive $245,000 from the condemnation.
6. Estimated annual operating data, exclusive of depreciation, are as follows:

Sales (cash)	$	945,000
Operating expenses	$	545,000

7. Nonrecurring sales promotion costs at the beginning of year 1 (i.e., time 0) are expected to be $114,000. (These costs are fully deductible for tax purposes.)
8. Nonrecurring termination costs at the end of year 5 are $59,000. (These costs are fully deductible for tax purposes.)
9. The after-tax discount rate for capital budgeting purposes is 14%. (To calculate the present value factor for each year, i, i = 1, 5, use the following formula: PV factor_i = (1 1.14ⁱ). The company is in the 36% tax bracket (federal and state combined).

Required:

1. Show how you would handle the individual items in determining whether the company should continue to lease the space or convert it to a factory outlet. Use PV function in Excel, VDB function in Excel to calculate annual depreciation charges. Use NPV function to calculate depreciation tax savings.

Req 1 Reg 2 Show how you would handle the individual items in determining whether the company should continue to lease the space or convert it to a factory outlet. Use PV function in Excel, VDB function in Excel to calculate annual depreciation charges. Use NPV function to calculate depreciation tax savings. (Negative amounts should be indicated by a minus sign. Round your answers to the nearest whole dollar.) Cash Flows in Year 2 3 PV 0 1 4 5 Item Description a. After-tax monthly rent foregone b. All are irrelevant C Remodeling cost (capitalized) Depreciation tax savings (DDB method; @36%) d Investment in net working capital Recovery of net working capital f. After-tax cash sales After-tax cash operating expenses g After-tax sales promotion cost, year 0 h. After-tax termination cost, year 5 NPV = . Req 1 Req 2 > Req 1 Reg 2 Show how you would handle the individual items in determining whether the company should continue to lease the space or convert it to a factory outlet. Use PV function in Excel, VDB function in Excel to calculate annual depreciation charges. Use NPV function to calculate depreciation tax savings. (Negative amounts should be indicated by a minus sign. Round your answers to the nearest whole dollar.) Cash Flows in Year 2 3 PV 0 1 4 5 Item Description a. After-tax monthly rent foregone b. All are irrelevant C Remodeling cost (capitalized) Depreciation tax savings (DDB method; @36%) d Investment in net working capital Recovery of net working capital f. After-tax cash sales After-tax cash operating expenses g After-tax sales promotion cost, year 0 h. After-tax termination cost, year 5 NPV = . Req 1 Req 2 >