NEWS has decided to purchase a new piece of capital equipment in order to expand operations and retake the competitive advantage. They have selected two vendors with differing costs and loan terms. Use the loan amortization schedule table developed in the 6-2 Homework Introduction to answer these NEWS lending questions by substituting the data within the inputs and observing the outcomes. Use the data presented below and your previously created spreadsheet to complete Tasks 1 and 2. Tip: While it is not required, you may wish to duplicate your spreadsheet tab in order to easily compare and contrast the two alternatives. Equipment Vendor Equipment Vendor One Two Annual interest rate Loan term (in years) 8% 10% 12 11 Payments per year Loan amount 12 12 $44,500.00 $39,000.00