A business needs to purchase packaging equipment that will provide revenue of $120,000 per year for 10 years; operating costs are $40,000 per year for 10 years. The equipment costs $220,000, has an estimated useful life of 10 years, and has a salvage value of $20,000 at the end of that period. It is depreciated using the sum-of-the-years-digits method. The company pays income tax at a rate of 30%, VAT of 16% and MARR of 10%. To acquire the equipment, a loan of $70,000 is requested at a rate of 12.5% annual interest, which must be repaid in six years through equal fixed payments (Rents) each year-end, the first one a year after the purchase. Determine the NPV, IRR, EAC, COST/BENNEFIT. *Please show procedure in Excel*
3
A business needs to purchase packaging equipment that will provide revenue of $120,000 per year for 10 years; operating costs are $40,000 per year for 10 years. The equipment costs $220,000, has an estimated useful life of 10 years, and has a salvage value of $20,000 at the end of that period. It is
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images