Not sure what other info you need? This is the whole question. There is no other info to give you.
Cash flows in year | ||||||||||||
Item | Description | PV Factor | PV | 0 | 1 | 2 | 3 | 4 | 5 | |||
a | After tax monthly Rent Foregone | 3.696 | -174924.29 | -47328 | -47328 | -47328 | -47328 | -47328 | ||||
($ 6800*12*0.58) | ||||||||||||
b | All are irrelevant | |||||||||||
c | Remodelling Cost | -190000 | -190000 | |||||||||
Depreciation | 0.901 | 28759.92 | ||||||||||
0.812 | 15551.424 | |||||||||||
0.731 | 8400.0672 | 31920 | 19152 | 11491.2 | 8618.4 | 8618.4 | ||||||
0.659 | 5679.5256 | |||||||||||
0.593 | 5110.7112 | |||||||||||
d | Investment in net working capital | -735000 | -735000 | |||||||||
e | Recovery of Net working Capital | 0.593 | 435855 | |||||||||
f | After Tax Cash Sales ($990,000*.58) | 3.696 | 2122243.2 | 574200 | 574200 | 574200 | 574200 | 574200 | 574200 | |||
After Tax Operating expenses($590,000*.58) | 3.696 | -1264771.2 | 342200 | 342200 | 342200 | 342200 | 342200 | 342200 | ||||
g | After Tax Sales promotion (127000*.58) | -73360 | -73360 | |||||||||
h | After Tax Termination Cost (68000*.58) | 0.593 | -23387.92 | |||||||||
NPV | 160156.56 | |||||||||||
The positive net present value $160156.56 suggest that, comparing to the leasing alternative it is financially advantageous to comparing the facility into a factory outlet. | ||||||||||||
The net present value from converting into the factory outlet is also better than the alternative of selling the warehouse for $290000 | ||||||||||||
Calculation of Depreciation | ||||||||||||
Yr | BV | Depreciation | Tax Shield | |||||||||
0 | 190000 | 0 | 0 | |||||||||
1 | 114000 | 76000*42 | 31920 | |||||||||
2 | 68400 | 45600*.42 | 19152 | |||||||||
3 | 41040 | 27360*.42 | 11491.2 | |||||||||
4 | 20520 | 20520*.42 | 8618.4 | |||||||||
5 | 0 | 20520*42 | 8618.4 | |||||||||
Not sure what other info you need? This is the whole question. There is no other...
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 company for $6,500 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.) The warehouse’s estimated sales value is $237,000. A commercial realtor believes that the price is...
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,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...
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...
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...
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...
Exercise 12-29 Value of Accelerated Depreciation: Sum-of-Years'-Digits (SYD) and Double Declining. Balance (DDB) Methods (LO 12-3) Freedom Corporation acquired a fixed asset for $100,000. Its estimated life at time of purchase was 4 years, with no estimated salvage value. Assume a discount rate of 8% and an income tax rate of 40%. (Use Exhibit 124. Appendix C. TABLE 1 and Appendix C. TABLE 2) Required: 1. What is the incremental present value of the tax benefits resulting from calculating depreciation...
Check my work Freedom Corporation acquired a fixed asset for $200,000. Its estimated life at time of purchase was 4 years, with no estimated salvage value. Assume a discount rate of 11% and an income tax rate of 40%. (Use Exhibit 12.4, Appendix C, TABLE 1 and Appendix C, TABLE 2.) 0.25 points Skipped Required: 1. What is the incremental present value of the tax benefits resulting from calculating depreciation using the sum-of-the-years’-digits (SYD) method rather than the straight-line (SLN)...
Hi I need the anwer to this question , not similar. and also the whole answer.thank you Answer each independent question, (a) through (e), below. a. Project A costs $8,000 and will generate annual after-tax net cash inflows of $3,250 for 5 years. What is the payback period for this investment under the assumption that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) b. Project B costs $8,000 and will generate after-tax cash...