Modify the spreadsheet in Sidebar 16-2 to calculate the total interest paid over the life of the loan. Test your spreadsheet by entering the data from Example 16-9 and Problems 11 and 12. Compare your spreadsheet’s solution to the answer to these problems. Hint: You need to add the balloon payment to Eq.(16-8).