9. In the range N5:N12, enter the following loan and loan conditions for the second mortgage. Similar to above,you need to format the data exactly as described below: The loan amount (or value of the principal) is$245,000 The annual interest rate is 3.875% The interest rate is compounded 12 times a year (or Show more Show more Engineering & Technology Computer ScienceShare QuestionEmailCopy link This question was created from SpreadsheetProjectDescription2019.pdf