quiz 5
mwesigward
L5_quiz.xlsxProblem 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: |
