Question

In: Finance

Your company purchased new equipment. The old equipment is at the end of its life. The...

Your company purchased new equipment. The old equipment is at the end of its life. The new equipment cost $140,000 and has a five-year useful life, with an estimated value of $57,000 after five years. It will be depreciated using a 5-year MACRS schedule. Sales will increase to $47,000 per year and costs will average 38% of sales. Inventory will increase by $4,000 due to increased sales. Your firm’s marginal tax rate is 28%. The discount rate is 9%. What is the NPV, IRR, and Payback Period, PV, PI for this investment?

Solutions

Expert Solution

Please see the table below. All financials are in $. Please see the second column to understand the mathematics. The cells colored in yellow contain your answer. Adjacent cell in blue shows the excel formula used to get the answer. I have explained how payback period has been calculated at the end once again.

Payback Period: See the row containing cumulative cash flows. It's  -27,650.56 in year 4. See the cash flows row. It's  72,794.56 for year 5. Hence, the payback period = 4 + 27,650.56 / 72,794.56 = 4.38 years

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

Your company purchased new equipment. The old equipment is at the end of its life. The...
Your company purchased new equipment. The old equipment is at the end of its life. The new equipment cost $140,000 and has a five-year useful life, with an estimated value of $57,000 after five years. It will be straight-line depreciated to zero. Sales will increase to $47,000 per year and costs will average 38% of sales. Inventory will increase by $4,000 due to increased sales. Your firm’s marginal tax rate is 28%. The discount rate is 9%. What is the...
On July 1, 2019, Oriole Company purchased new equipment for $80,000. Its estimated useful life was...
On July 1, 2019, Oriole Company purchased new equipment for $80,000. Its estimated useful life was 8 years with a $8,000 salvage value. On January 1, 2022, before making its depreciation entry for 2022, the company estimated the remaining useful life to be 10 years beyond December 31, 2022. The new salvage value is estimated to be $5,000. Prepare the journal entry to record depreciation on December 31, 2019. (Credit account titles are automatically indented when amount is entered. Do...
On July 1, 2019, Crane Company purchased new equipment for $90,000. Its estimated useful life was...
On July 1, 2019, Crane Company purchased new equipment for $90,000. Its estimated useful life was 7 years with a $13,000 salvage value. On December 31, 2022, the company estimated that the equipment’s remaining useful life was 10 years, with a revised salvage value of $5,000. Prepare the journal entry to record depreciation on December 31, 2019. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for...
BCK company purchased new equipment with an estimated useful life of four years. The cost of...
BCK company purchased new equipment with an estimated useful life of four years. The cost of the equipment was $50,000, and the salvage value was estimated to be $5,000 at the end of four years. The company uses the double-declining-balance method for book depreciation. (i) What is the amount of depreciation for the fourth year of use? (ii) What is the book value of the asset at the end of the third year?
New equipment is purchased for $40,000. It has a residual value of at the end of...
New equipment is purchased for $40,000. It has a residual value of at the end of the 10 years $2,500.00. Desired rate of return 12%. Operating expenses are expected to be $2000.00 the first year and increase by $500.00 each year during the life of the equipment. Is this a good investment assuming equivalent annual methods.
An equipment costs Php 2,329,961. At the end of its economic life of 17 years, its...
An equipment costs Php 2,329,961. At the end of its economic life of 17 years, its salvage value is Php 60,758. Using Sum of the Years Digit Method of Depreciation, what will be its depreciation charge for year 8? MANUAL SOLUTIONS
A company purchased new equipment for $270,000 including installation. The company estimates that the equipment will...
A company purchased new equipment for $270,000 including installation. The company estimates that the equipment will have a residual value (salvage value) of $24,000 and estimates it will use the machine for six years or about 12,000 total hours. Prepare a depreciation schedule for three years using the following methods: Straight line Activity based Actual use per year was as follows: Year Hours Used 1 3,100 2 1,100 3 1,200 2. Assume the equipment was purchased on August 1. What...
Q12) A company has purchased an equipment costing $84,300. The equipment has a useful life of...
Q12) A company has purchased an equipment costing $84,300. The equipment has a useful life of 3 years with a salvage value of $34,100. CCA will be taken using a rate of 30.00%. The tax rate is 29.00%, while the discount rate is 9.00%. Assuming the company takes all available CCA every year and there will be some assets remaining in the CCA class after year 3, what is the EAC of this equipment? 16,741 17,194 17,646 18,099 18,551
Diamond Autobody purchased some new equipment. The new equipment cost $90,000. The company estimates the equipment...
Diamond Autobody purchased some new equipment. The new equipment cost $90,000. The company estimates the equipment will have a residual value of $10,000. Diamond also estimates it will use the equipment for eight years or about 5,000 total hours. Required: Prepare a depreciation schedule for eight years using the following methods: 1. Straight-line. 2. Double-declining-balance. 3. Activity-based. Actual use per year was as follows: Year Hours Used 1 850 2 750 3 800 4 730 5 700 6 625 7...
Laverne purchased a new piece of equipment to be used in its new facility. The $385,000...
Laverne purchased a new piece of equipment to be used in its new facility. The $385,000 piece of equipment was purchased with a $57,750 down payment and with cash received through the issuance of a $327,250, 7%, 5-year mortgage payable issued on January 1, 2017. The terms provide for annual installment payments of $79,813 on December 31. Prepare an installment payments schedule for the first five payments of the notes payable. Prepare the journal entry to record the mortgage loan...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT