Townsend Mortgage Company 1. Fer each Loan, create calculations for \% Down (V11:F15), APR (111:1115), Monthly Payment (1I1:115), and Monthly PMII (J11-115) using the following formulas: \% Dewn Down Payment drided by Heuse Cost I Which is the frast amoust of down paymest (in dollars) would Krause nerd to make to avoid paying Mesthly PMII a. 542,000 b. 541,500 c. $40,000 2 What would be the APR if the Patel's fook out a 20 year loan? a. 3.25% b. 3.65% c. 3.75% 3 If the Beinard's toek eet a loan for 30 years imstead of 15 years, what weold their menthly payment be? a. $1,092,40 b. $1.502.49 c. $1,029,49 4 What eptien should the Recd's ceasider te reduce their meathly paymerat? a. Opt for a shorier term han b. Decrase the dows payment amount c. Opt for a lener interest rate 5 What is the differeace between Average and Median? a. Median is the total divided by the count of ilems, and Average is the differeoes between hiph and low b. Average is the midale point, and Median ss the boal dwided by the covet of ifems c. Median is the middle prim, and Average is the total divided by the count of items 6 Loeking at the Median and Average statistics, why is Average higher than the Median a. The Average is skewed by a house with a bigher cest b. Toe Median is skewed by a house with a higher cost c. The Awerage is skewed becmase of the small number of Boves