For an N-month $100,000 loan with monthly payments at a 10 percent annual rate, use the SEQUENCE function to determine each month’s contribution to principal and interest. If you change the number of months in the loan, your spreadsheet should display the correct information for an N-month loan.

Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure your answers will automatically update if new data is added.