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.
Sales (cash) $975,000
Operating expenses $575,000
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.
Cash flows in year |
|||||||||
Item |
Description |
PV factor |
PV |
0 |
1 |
2 |
3 |
4 |
5 |
a. |
Foregone rent (6500*12*67%) |
3.791 |
(198118) |
(52260) |
(52260) |
(52260) |
(52260) |
(52260) |
|
b. |
All are irrelevant |
(175000) |
(175000) |
||||||
C. |
Remodelling |
||||||||
Depreciation |
0.909 |
25452 |
28000 |
||||||
0.826 |
13877 |
16800 |
|||||||
0.751 |
7570 |
10080 |
|||||||
0.683 |
5163 |
7560 |
|||||||
0.621 |
4695 |
7560 |
|||||||
d. |
Investment in inventory |
1.000 |
(715000) |
(715000) |
715000 |
||||
Recovery |
0.621 |
444015 |
|||||||
e. |
Irrelevant |
||||||||
f. |
Sales (975000*67%) |
3.791 |
2476471 |
653250 |
653250 |
653250 |
653250 |
653250 |
|
Operating expenses (575000*67%) |
3.791 |
(1460483) |
(385250) |
(385250) |
(385250) |
(385250) |
(385250) |
||
g. |
Sales promotion (123000*67%) |
(82410) |
(82410) |
||||||
h. |
Termination (65000*67%) |
0.621 |
(27055) |
(43550) |
|||||
NPV |
$319177 |
175000*16% = 28000
175000*9.6% = 16800
175000*5.76% = 10080
175000*4.32% = 7560
175000*4.32% = 7560
The positive NPV of $319177 indicates that it is financially advantageous to convert the facility into the factory outlet instead of leasing. Moreover, it is better option than selling warehouse for $237000
Lou Lewis, the president of Lewisville Company, has asked you to give him an analysis of the best use of a warehouse the...
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,600 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 $215,000. A commercial realtor believes that the...
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 $6,100 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 $227,000. A commercial realtor believes that...
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...
Not sure what other info you need? This is the whole question. There is no other info to give you. 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 $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...
I'm pretty sure about all input areas needing a value in them and I corrected some of the mistakes from the previous tutor's answer but I'm still getting some of the numbers incorrect. Can someone help me with the remaining incorrect inputs? 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 $6,800...
A computer chip manufacturer spent $2,500,000 to develop a special-purpose molding machine. The machine has been used for one year and is expected to be obsolete after an additional 3 years. The company uses straight-line (SLN) depreciation for this machine At the beginning of the second year, a machine salesperson offers a new, vastly more efficient machine. This machine will cost $2,000,000, reduce annual cash manufacturing costs from $1,800,000 to $1,000,000, and have zero disposal value at the end of...
A computer chip manufacturer spent $2,540,000 to develop a special-purpose molding machine. The machine has been used for one year and is expected to be obsolete after an additional 3 years. The company uses straight-line (SLN) depreciation for this machine. At the beginning of the second year, a machine salesperson offers a new, vastly more efficient machine. This machine will cost $2,040,000, reduce annual cash manufacturing costs from $1,840,000 to $1,040,000, and have zero disposal value at the end of...
New-Project Analysis The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department The equipment's basic price is $190,000, and it would cost another $47,500 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $66,500. Use of the equipment would require an increase in net working capital (spare parts inventory)...
New-Project Analysis The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm's R&D department. The equipment's basic price is $190,000, and it would cost another $28,500 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $47,500. The MACRS rates for the first 3 years are 0.3333, 0.4445 and 0.1481. Use of...
New-Project Analysis The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm's R&D department. The equipment's basic price is $76,000, and it would cost another $16,500 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $30,400. The MACRS rates for the first 3 years are 0.3333, 0.4445 and 0.1481. Use of...