Lou Lewis, the president of Lewisville Company, has asked you to give him an analysis of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. Note: The company has a 40% effective tax rate. a. Lewisville Company is currently leasing the warehouse to another company for $5,000 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 $200,000. A commercial realtor believes that the price is likely to remain unchanged in the near future. The building originally cost $60,000 and is being depreciated at $1,500 annually. Its current net book value (NBV) is $7,500. c. Lewisville Company is seriously considering converting the warehouse into a factory outlet for furniture. The remodeling will cost $100,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 $600,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 $200,000 from the condemnation. f. Estimated annual operating data, exclusive of depreciation, are as follows: Sales (cash) Operating expenses $ 900,000 $ 500,000 g. Nonrecurring sales promotion costs at the beginning of year 1 (ie., at time 0) are expected to be $100,000. (These costs are fully deductible for tax purposes.) h. Nonrecurring termination costs at the end of year 5 are $50,000. (These costs are fully deductible for tax purposes.) i. 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 = (1+1.14%). The company is in the 40% 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. 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 Description After-tax monthly rent foregone b Current warehouse C. Remodeling cost (capitalized) Depreciation tax savings (DDB method; @40%) d. Investment in net working capital PV Cash Flows in Year 2 3 e 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 > 5 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. Note: The company has a 40% effective tax rate. a. Lewisville Company is currently leasing the warehouse to another company for $5,000 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 $200,000. A commercial realtor believes that the price is likely to remain unchanged in the near future. The building originally cost $60,000 and is being depreciated at $1,500 annually. Its current net book value (NBV) is $7,500. c. Lewisville Company is seriously considering converting the warehouse into a factory outlet for furniture. The remodeling will cost $100,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 $600,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 $200,000 from the condemnation. f. Estimated annual operating data, exclusive of depreciation, are as follows: Sales (cash) Operating expenses $ 900,000 $ 500,000 g. Nonrecurring sales promotion costs at the beginning of year 1 (ie., at time 0) are expected to be $100,000. (These costs are fully deductible for tax purposes.) h. Nonrecurring termination costs at the end of year 5 are $50,000. (These costs are fully deductible for tax purposes.) i. 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 = (1+1.14%). The company is in the 40% 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. 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 Description After-tax monthly rent foregone b Current warehouse C. Remodeling cost (capitalized) Depreciation tax savings (DDB method; @40%) d. Investment in net working capital PV Cash Flows in Year 2 3 e 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 > 5
Expert Answer:
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these accounting questions
-
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. Lewisville Company is currently leasing the warehouse to another...
-
Lou Lewis, the president of the 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...
-
a. Find the nth-order Taylor polynomials for the given function centered at the given point a, for n = 0, 1, and 2.b. Graph the Taylor polynomials and the function. f(x)=x, a = 9
-
A fair-trade farmers' cooperative in Chiapas, Mexico, is deciding how much coffee and cocoa to recommend to their members to plant. Their 1,000 member families have 7,500 total acres to farm. Because...
-
Which costs are considered direct? Indirect? Give an example of each.
-
When can the times interest earned ratio be misleading? (a) When net profit is negative. (b) When interest rates are changing. (c) When a company does not generate enough cash to cover interest...
-
AmeriPlas, Inc., produces 20-ounce plastic drinking cups that are embossed with the names of prominent beers and soft drinks. The sales data are: Date Sales Jan-13 40,358 Feb-13 45,002 Mar-13 63,165...
-
How does smart home assistant product align with broader trends or societal needs, reflecting your understanding of market dynamics and consumer behavior?
-
Read Spitzer Discussion Forum, in spring 2008, Eliot Spitzer, and then Governor of New York was caught going to a prostitution ring. In the wake of this incident, scholars and others sought to...
-
In 1970 economist Martin Shubik proposed a game that involved auctioning off a one-dollar bill with the following rules: 1. The highest bidder wins the dollar bill and pays his bid. 2. The...
-
Say that you are bidding in a sealed-bid auction and that you really want the item being auctioned. Winning it would be worth $250 to you. Say you expect the nexthighest bidder to bid $100. a. In a...
-
When consumers were given the opportunity to select a package of ground beef labeled 75% lean or a package of ground beef labeled 25% fat, most consumers chose 75% lean. Why? What concept from the...
-
Joseph Gallo, the founder of the famous wine company that bears his name, said that when he first started selling wine right after Prohibition (laws outlawing the sale of alcohol), he poured two...
-
Monsanto Corporation lost its U.S. patent protection for its highly successful herbicide Roundup in the year 2000. What do you suppose was Monsantos strategy for Roundup in the short run? In the long...
-
Select The Hershey Company, and obtain a copy of the SEC Form 10-K (2014). Then write an audit report in which you answer the following questions: a. Who are the companys external auditors? b. What...
-
r = 0.18 Find the coefficients of determination and non-determination and explain the meaning of each.
-
Cruz Manufacturing Ltds sales slumped badly in 2019. For the first time in its history, it operated at a loss. The companys income statement showed the following results from selling 600 000 units of...
-
The following are emails from various students to Dr. Destiny Sands, who is a professor in the English Department. These students are wondering if Dr. Sands would let them register for her...
-
What are some flawed assumptions about workplace communication? What is the reality for each myth?
Study smarter with the SolutionInn App