11 In cell C10, enter a database function to display the date of the apartment that had the oldest remodel date based on the filtered data. Format the result with Short Date format. 5

12 In the Loan sheet, insert formulas in the range E2:E4 to calculate the loan amount, the number of payment periods, and the monthly interest rate, respectively. Use cell references in all formulas. 6

13 In cell E5, enter a financial function to calculate the monthly payment. In cell E6, insert a financial function to calculate the cumulative total interest paid throughout the loan. Make sure the results display as positive numbers. 8

14 In cell C11, enter a formula to reference the date stored in cell B7. Insert a nested function in cell C12 to calculate the date for the next payment. Nest the YEAR, MONTH, and DAY functions within the DATE function. Add 1 to the month result. Copy the function to the range C13:C34. 6

15 In cell D11, enter a formula to reference the value stored in cell E2. Insert a formula in cell D12 that references the ending balance for the previous payment row (G11). Copy the formula in D12 to the range D13:D34. 5

16 In cell E11, enter a financial function to calculate the interest paid. Copy the formula to the range E12:E34. The result should be a positive value. 6

17 In cell F11, enter a financial function to calculate the principal payment. Copy the function to the range F12:F34. The result should be a positive value. 6

18 In cell G11, enter a formula to calculate the ending balance. Copy the formula to the range G12:G34. Adjust the width of column G, if needed, to display the values. Select the range D11:G34 and apply Accounting Number Format. 6

19 In cell I4 insert a financial function to calculate the present value of the total monthly rent you will collect for the 8 units for 30 years. Use the number of periods and monthly rate in the Summary Calculations section and the cell references in the What If section. The result should be a positive value. 5

20 In the Loan sheet, set 0.5" left and right margins and repeat row 10 on all pages. 3