Required: 1. Show how you would handle the individual items in determining whether the company should...

Transcribed Image Text:

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. Complete this question by entering your answers in the tabs below. Req 1 Req 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.) Item a. Description After-tax monthly rent foregone b. Current warehouse C. Remodeling cost (capitalized) Depreciation tax savings (DDB method; @34%) d. Investment in net working capital e. Recovery of net working capital 117 Cash Flows in Year PV 0 1 2 3 4 5 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 > 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. Complete this question by entering your answers in the tabs below. Req 1 Req 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.) Item a. Description After-tax monthly rent foregone b. Current warehouse C. Remodeling cost (capitalized) Depreciation tax savings (DDB method; @34%) d. Investment in net working capital e. Recovery of net working capital 117 Cash Flows in Year PV 0 1 2 3 4 5 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 >