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. a. Lewisville Company is currently leasing the warehouse to another company for $5,400 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.) b. The warehouse's estimated sales value is $210,000. A commercial realtor believes that the price is likely to remain unchanged in the near future. The building originally cost $62,000 and is being depreciated at $1,700 annually. Its current net book value (NBV) is $7,700. c. Lewisville Company is seriously considering converting the warehouse into a factory outlet for furniture. The remodeling will cost $120,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.) d. The inventory and receivables (net of current liabilities) needed to open and sustain the factory outlet would be $630,000. This total is fully recoverable whenever operations terminate. e. 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 $220,000 from the condemnation. f. Estimated annual operating data, exclusive of depreciation, are as follows: Sales (cash) Operating expenses $920, 000 $520,000 g. Nonrecurring sales promotion costs at the beginning of year 1 (i.e., time 0) are expected to be $106,000. (These costs are fully deductible for tax purposes.) h. Nonrecurring termination costs at the end of year 5 are $54,000. (These costs are fully deductible for tax purposes.) i. The after-tax discount rate for capital budgeting purposes is 11%. (To calculate the present value factor for each year, i, i = 1, 5, use the following formula: PV factor; = (1 = 1.11%). The company is in the 38% tax bracket (federal and state combined). Item 5 Description After-tax monthly rent foregone All are irrelevant Remodeling cost (capitalized) Depreciation tax savings (DDB method; @38%) Investment in net working capital Recovery of net working capital After-tax cash sales Cash Flows in Year PV 0 1 2 $ (153,985) S 0 $ 40,176 $ 40,176 $ 40,176 $ 40,176 $ 40,176 $ 00S 00S 00S 00S 0S 0S 00 S (120,000) 420.000 S 0S 0S 0S 0S 0 $ 36,283 S 00S 18,240 $ 10,944 $ 6,566 $ 4,925 $ 4,925 $ (630,000) 630.000 S 00S 0S 0S 0S 00 $ 373,874 S 00S 0S 0S 0S 0S 630,000 $ 2,108,140S 0 S 570,400 $ 570,400 $ 570,400 $ 570,400 $ 570,400 (1,191,557) S o os (322,400) 322.400 (322.400) 322.400) 322.400) $ (65,720) S(65,720) S 00S 0S 0S 0S 0 $ 19,869S 0S 0S 0S 0S 0$ 33,480 $ 376,904 After-tax cash operating expenses After-tax sales promotion cost, year 0 After-tax termination cost, year 5 NPV = 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. a. Lewisville Company is currently leasing the warehouse to another company for $5,400 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.) b. The warehouse's estimated sales value is $210,000. A commercial realtor believes that the price is likely to remain unchanged in the near future. The building originally cost $62,000 and is being depreciated at $1,700 annually. Its current net book value (NBV) is $7,700. c. Lewisville Company is seriously considering converting the warehouse into a factory outlet for furniture. The remodeling will cost $120,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.) d. The inventory and receivables (net of current liabilities) needed to open and sustain the factory outlet would be $630,000. This total is fully recoverable whenever operations terminate. e. 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 $220,000 from the condemnation. f. Estimated annual operating data, exclusive of depreciation, are as follows: Sales (cash) Operating expenses $920, 000 $520,000 g. Nonrecurring sales promotion costs at the beginning of year 1 (i.e., time 0) are expected to be $106,000. (These costs are fully deductible for tax purposes.) h. Nonrecurring termination costs at the end of year 5 are $54,000. (These costs are fully deductible for tax purposes.) i. The after-tax discount rate for capital budgeting purposes is 11%. (To calculate the present value factor for each year, i, i = 1, 5, use the following formula: PV factor; = (1 = 1.11%). The company is in the 38% tax bracket (federal and state combined). Item 5 Description After-tax monthly rent foregone All are irrelevant Remodeling cost (capitalized) Depreciation tax savings (DDB method; @38%) Investment in net working capital Recovery of net working capital After-tax cash sales Cash Flows in Year PV 0 1 2 $ (153,985) S 0 $ 40,176 $ 40,176 $ 40,176 $ 40,176 $ 40,176 $ 00S 00S 00S 00S 0S 0S 00 S (120,000) 420.000 S 0S 0S 0S 0S 0 $ 36,283 S 00S 18,240 $ 10,944 $ 6,566 $ 4,925 $ 4,925 $ (630,000) 630.000 S 00S 0S 0S 0S 00 $ 373,874 S 00S 0S 0S 0S 0S 630,000 $ 2,108,140S 0 S 570,400 $ 570,400 $ 570,400 $ 570,400 $ 570,400 (1,191,557) S o os (322,400) 322.400 (322.400) 322.400) 322.400) $ (65,720) S(65,720) S 00S 0S 0S 0S 0 $ 19,869S 0S 0S 0S 0S 0$ 33,480 $ 376,904 After-tax cash operating expenses After-tax sales promotion cost, year 0 After-tax termination cost, year 5 NPV =