An $80,000 recycled paper baling machine was purchased 2 years ago. The projected market value of the machine and the projected net revenue from its operation are shown in the table below. If the company's MARR is 9%, what is the best time for the company to abandon the recycled paper baling project to maximize its present worth?
End of Year: 1 2 3 4
Net Revenue: $20000 $18000 $12000 $3000
Machine Market Value: $35000 $25000 $18000 $10000
Statement showing present worth at the end of different years :
Year | Net revenue (a) | Market value (b) | Present value factor at 9% (c) | Present value net revenue (a × c) | Accumulated present value of net revenue (d) | Present value of market value (e = b × c) | Present value of total cash inflows (d + e) |
1 | 20000 | 35000 | 0.92 | 18400 | 18400 | 32200 | 50600 |
2 | 18000 | 25000 | 0.84 | 15120 | 33520 | 21000 | 54520 |
3 | 12000 | 18000 | 0.77 | 9240 | 42760 | 13860 | 56620 |
4 | 3000 | 10000 | 0.71 | 2130 | 44890 | 7100 | 51990 |
It is beneficial to abandon the machine at the end of year 3 as present worth is maximum in the year 3.
Note : calculations of present value factor
Present value factor = 1/(1+r)n
Where, r = rate of interest and n = number of years.
present value factor at the end of year 1at 9% = 1/(1+0.09)1 = 1/(1.09)1 = 1/(1.09) = 0.92
At the end of year 2 = 1/(1.09)2 = 0.84
At the end of year 3 = 1/(1.09)3 =0.77
At the end of year 4 = 1/(1.09)4 = 0.71
An $80,000 recycled paper baling machine was purchased 2 years ago. The projected market value of...
please use Excel sheet template to solve the problem Economic Life 13-1 An injection-molding machine has a first cost of $1,050,000 and a salvage value of $225,000 in any year. The maintenance and operating cost is $235,000 with an annual gradient of $75,000. The MARR is 10%. What is the most economic life? A В D E F G H 19 13-37 MARR% 21 First Cost 20% 200000 Year Market Value Lost MV Оper Cost Maint. Lost Int. Total MC...
please show how to solve this in Excel. I posted the Excel sheet format it should look like 13-37 Big-J Construction Company, Inc. is conducting a routine periodic review of existing field equipment. They use a MARR of 20%. This includes a replace- ment evaluation of a paving machine now in use. The machine was purchased 5 years ago for $200,000, The paver's current market value is $65,000, and yearly operating and maintenance costs are as follows. Year, n Operating...
You purchased land 3 years ago for $40000 and believe its market value is now $75000. You are considering building a hotel on this land instead of selling it. To build the hotel, it will initially cost you $165000, an expense that you plan to depreciate straight line over the next three years. Wells Fargo offered you a loan for $60,000 at an 8% interest rate to be repaid over the next 4 years. You anticipate that the hotel will...
A CNC machining center was purchased 6 years ago for $100,000. The current market value is $200,000, which will decline as follows over the next 5 years: $140,000, $130,000, $120,000, $100,000, and $80,000. The O&M costs are estimated to be $36,000 this year. These costs are expected to increase by $5,000 per year starting year 2. MARR = 10% Reference: Case Study 13 The foregone interest in year 4 is O A. $13,000 OB. $14,000 OC. $12,000 OD. $8,000
A CNC machining center was purchased 6 years ago for $100,000. The current market value is $200,000, which will decline as follows over the next 5 years: $140,000, $130,000, $120,000, $100,000, and $80,000. The O&M costs are estimated to be $36,000 this year. These costs are expected to increase by $5,000 per year starting year 2. MARR = 10% Reference: Case Study 13 The EUAC for defender in year 2 is O A. $85,182 OB. $91,715 OC. $81,642 OD. $105,240
Robinson Corporation currently processes seafood with a machine it purchased several years ago. The machine, which originally cost $1,000,000, currently has a book value of $400,000. Robinson is considering replacing the machine with a newer, more efficient one. The new machine will cost $1,400,000 and will require an additional $100,000 for delivery and installation. The new machine will also require Robinson to increase its investment in receivables and inventory by $400,000. The new machine will be depreciated on a straight-line...
Robinson Corporation currently processes seafood with a machine it purchased several years ago. The machine, which originally cost $1,000,000, currently has a book value of $400,000. Robinson is considering replacing the machine with a newer, more efficient one. The new machine will cost $1,400,000 and will require an additional $100,000 for delivery and installation. The new machine will also require Robinson to increase its investment in receivables and inventory by $400,000. The new machine will be depreciated on a straight-line...
The Everly Equipment Company's flange-lipping machine was purchased 5 years ago for $80,000. It had an expected life of 10 years when it was bought and its remaining depreciation is $8,000 per year for each year of its remaining life. As older flange-lippers are robust and useful machines, this one can be sold for $20,000 at the end of its useful life. A new high-efficiency digital-controlled flange-lipper can be purchased for $130,000, including installation costs. During its 5-year life, it...
A high-speed electronic assembly machine was purchased two years ago for $50,000. At the present time, it can be sold for $26,000 and replaced by a newer model having a purchase price of $42,500; or it can be kept in service for a maximum of one more year. The new assembly machine, if purchased, has a useful life of not more than two years. If the before-tax MARR is 18%, when should the old assembly machine be replaced? Use the...
Replacement Analysis The Everly Equipment Company's flange-lipping machine was purchased 5 years ago for $80,000. It had an expected life of 10 years when it was bought and its remaining depreciation is $8,000 per year for each year of its remaining life. As older flange-lippers are robust and useful machines, this one can be sold for $20,000 at the end of its useful life. A new high-efficiency digital-controlled flange-lipper can be purchased for $150,000, including installation costs. During its 5-year...