Complete the sheet using the techniques learned in class. Please note that all data have to be calculated by formulas or functions unless it is explicitly given. The "Mortgage White Paper" sheet is optional for practice.

Key practices:

Formulas

Financial Functions "PMT"

Copy of formulas

Documentation Mortgage Calculator Mortgage White Paper A Mortgage Payment Calculator Mortgage Calculator Amount $50,000 # of Years 5 Payment per Year 12 Interest Rate (APR) 5.00% $50,000 31 12 4.50% Installment Payment The Mortgage White Paper Mortgage Calculator 15-Year Fixed 30-Year Fixed 15 2.85% Years Interest Rate (APR) 30 3.48% 15-Year Fixed 30-Year Fixed Loan Amount 100,000 110,000 120,000 130,000 140,000 150,000 160,000 170,000 180,000 190,000 200,000 210,000 220,000 230,000 240,000 250,000 The Mortgage White Paper Mortgage Calculator 15-Year Fixed 30-Year Fixed Years 15 30 Interest Rate (APR) 2.85% 3.48% Loan Amount 100,000 110,000 120,000 130,000 140,000 150,000 160,000 170,000 180,000 190,000 200,000 210,000 220,000 230,000 240,000 250,000 15-Year Fixed $683.39 $751.73 $820.07 $888.41 $956.75 $1,025.09 $1,093.42 $1,161.76 $1,230.10 $1,298.44 $1,366.78 $1,435.12 $1,503.46 $1,571.80 $1,640.14 $1,708.48 30-Year Fixed $447.93 $492.72 $537.51 $582.31 $627.10 $671.89 $716.69 $761.48 $806.27 $851.07 $895.86 $940.65 $985.44 $1,030.24 $1,075.03 $1,119.82