Calculate annual depreciation charges

Reference no: EM132841244

Question - 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 $6,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.)

2. The warehouse's estimated sales value is $245,000. A commercial realtor believes that the price is likely to remain unchanged in the near future. The building originally cost $69,000 and is being depreciated at $2,400 annually. Its current net book value (NBV) is $8,400.

3. Lewisville Company is seriously considering converting the warehouse into a factory outlet for furniture. The remodeling will cost $190,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 $735,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 $290,000 from the condemnation.

6. Estimated annual operating data, exclusive of depreciation, are as follows:

Sales (cash) $990,000

Operating expenses $590,000

1. Nonrecurring sales promotion costs at the beginning of year 1 (i.e., time 0) are expected to be $127,000. (These costs are fully deductible for tax purposes.)

2. Nonrecurring termination costs at the end of year 5 are $68,000. (These costs are fully deductible for tax purposes.)

3. 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 factori = (1 ÷ 1.11i). The company is in the 42% 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.

Reference no: EM132841244

Questions Cloud

Improve the profitability of the company : In your accounting courses, you have learned that inventory is an asset and has book value, increasing the overall worth of a company.

What nonacademic data are available to teacher : Are these achievement results consistent across subgroups and are there subgroups who are undeserved? What nonacademic data are available to teacher?

What would be the expected sale price of property at the end : What would be the expected sale price of property at the end of year 10 if the terminal cap rate is estimated from the sales of old "Comparable" properties?

What corporate-level strategies is toms following : 1. What business-level strategy does Toms appear to be following? Why? 2. What corporate-level strategies is Toms following? Why?

Calculate annual depreciation charges : Use PV function in Excel, VDB function in Excel to calculate annual depreciation charges. Use NPV function to calculate depreciation tax savings

Find the maturity value of a note dated april : Find the maturity value of a note dated April 20 if it bears interest at 9% and matures on June 25. The face value is $2,240. How much would the customer repay?

How the results will affect lesson planning : How the results will affect lesson planning for this group of students. How you plan to apply what you learned about administering the assessment and analyzing.

What is their taxable income : The state income tax they paid in 2020 is $18,000. Neither Sam nor Susan participates in an employer sponsored pension plan. What is their taxable income

What differentiation was identified during instruction : What differentiation was identified during instruction? What adjustments would you have made in the classrooms? What technology resources would you utilize?

User Account

All Pages