Lou Lewis, the president of Lewisville Company, has asked you to give him an analyals of the best use of a warehouse the company owns. a Lewisville Company is currently leasing the warehouse to another company for $5,800 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 $220.000. A commercial realtor believes that the price is likely to remain unchanged in the near future. The building originally cost $64,000 and is being depreciated at $1.900 annually. Its current net book value (NBV is $7.900 c. Lewisville Company is seriously considering converting the warehouse into a factory outlet for furniture. The remodeling will cost $140,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 to) d. The inventory and receivables (net of current liabilities) needed to open and sustain the factory outlet would be $660,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 $240,000 from the condemnation. Estimated annual operating dato, exclusive of depreciation, are as follows: Sales (cash) Operating expenses 5940.000 3540,000 g. Nonrecurring sales promotion costs at the beginning of year 11... time) are expected to be $112.000.(These costs are fully deducible for tax purposes.) h. Nonrecurring termination costs at the end of year 5 are $58,000. (These costs are fully deductible for tax purposes.) 1. The after-tax discount rate for capital budgesing purposes is 9%. (To calculate the present value factor for each year i=1,5, use the following formula: PV factor = (1 + 1.091). 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 calculese depreciation tax savings. 2. Indicate which course of action, based only on these dato, should be taken Complete this question by entering your answers in the tabs below. Req1 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 fundin 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 doc) Cash Flows in Year Tam PV Description Ater monthly rent foregone Al are relevant Remodeling cost capitalized) Depreciation tax savings ( DB method: 30%) 1 Recovery of the working ental Atas cash sales Merax cash being a Alexsas promotion cost year Aler-lax termination coul, years h. NPV- Req2 ) 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,800 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 $220.000. A commercial realtor believes that the price is likely to remain unchanged in the near future. The building originally cost $64.000 and is being depreciated at $1,900 annually. Its current net book value (NBV) is $7.900 c. Lewisville Company is seriously considering converting the warehouse into a factory outlet for furniture. The remodeling will cost $140,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 $660,000. This total is fully recoverable whenever operations terminate. 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 Estimated annual operating data, exclusive of depreciation are as follows: Sales (cash) Operating expenses $948,000 1140,000 g. Nonrecurring sales promotion costs at the beginning of year 1ie, time OJ are expected to be $112.000. (These costs are fully deductible for tax purposes.) h. Nonrecurring termination costs at the end of year 5 are $58,000. (These costs are fully deductible for tax purposes.) 1. The after tax discount rate for capital budgeting purposes is 9% (To calculate the present value factor for each year, (1-1,5, use the following formula: PV factor = (1 + 1.091). The company is in the 30% tex 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. 2 Indicate which course of action, based only on these date, should be taken. Complete this question by entering your answers in the tabs below. Regi 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, VDS function in Excel to calculate annual depreciation charges. Use NPV function to calculate depreciation tax savings. (Negative amounts should be indicated by a mine sip. Round your answers to the nearest whole dollar) Can Flows in Year dan PV Description Albercak monthly rent foregon All are irrelevant Remodeling cost capitalized) Depreciation tax savings (DD method: 30%) Investment in newarking capital Recovery of net worting capital Martax cash sales Per tax cash operating expenses Merak sales promotion on year Miera termination cont, you NPV Reg 2 > 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,800 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 $220,000. A commercial realtor believes that the price is likely to remain unchanged in the near future. The building originally cost $64,000 and is being depreciated at $1,900 annually. Its current net book value (NBV) is $7900 c Lewisville Company is seriously considering converting the warehouse into a factory outlet for furniture. The remodeling will cost $140,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 $660,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 $240,000 from the condemnation f. Estimated annual operating data, exclusive of depreciation, are as follows: Sales (cash) Operating expenses $940,000 $540,000 g. Nonrecurring sales promotion costs at the beginning of year 1(le, time 0) are expected to be $112,000. (These costs are fully deductible for tax purposes.) h. Nonrecurring termination costs at the end of year 5 are $58,000. (These costs are fully deductible for tax purposes.) 1. The after-tax discount rate for capital budgeting purposes is 9%. (To calculate the present value factor for each year, 17=15, use the following formula: PV factor: = (1 + 1.094). 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. 2. Indicate which course of action based only on these data, should be taken. 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 P function in Excel to calculate annual depreciation charges. Use NPV function to calculate depreciation tax savings. (Negative amounts should be indicated by a mi answers to the nearest whole dollar.) Cash Flows in Year 3 5 2 Item PV a b c d Description After-tax monthly rent foregone All are irrelevant Remodeling cost capitalized) Depreciation tax savings (DDB method, 36%) Investment in net working capital Recovery of net working capital After-tax cash sales Alter-tax cash operating expenses After-tax sales promotion cost, year 0 After-tax termination cost year 5 NPV = e 1 g h Rog Reg 2 > Reg 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, VDE 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) Show less
