Narrative 14-1 For Problems in This Section, Use Table 14-1 from Your

question 26

Multiple Choice

Narrative 14-1
For problems in this section, use Table 14-1 from your text to find the monthly mortgage payments, when necessary.
-Refer to Narrative in your text 14-1. Garrison takes out a $62,500 mortgage at 6% for 15 years. Prepare an amortization schedule for the first 3 months. Find the loan balance after 3 payments.

• A) $61,851.77
• B) $61,872.89
• C) $61,936.76
• D) $62,003.24

---

Definitions:

CONCAT

A function in many programming languages and databases used to join two or more strings together.

Statistical Functions

Functions built into software that perform calculations on data sets for the purpose of statistical analysis, such as mean, median, variance, and standard deviation.

COUNTIF

A function in spreadsheet applications that counts the number of cells within a range that meet a specified condition.

AVERAGEIF

An Excel function that calculates the average of all numbers in a range that meet specified criteria.