L5_quiz.xlsx

Problem 1

Mortgage Loan Worksheet
Input Cells
Purchase Price: $409,000
Down Payment: 20%
Loan Term (Months): 360
Interest Rate (APR): 4.00%
Result Cells
Loan Amount: $327,200
Monthly Payment: $1,562
Total Payments: $562,357
Total Interest: $235,157

Problem 2

2w - 3x + 5y + z = 41
7w + 2x - y = -28
-w + 2x - 7y -2z = 46
3w + 7x - 6y + z = 31
Formula Desired Value
Equation 1:
Equation 2:
Equation 3:
Equation 4:
Variable Value
w:
x:
y:
z: