Question 2 Youre considering purchasing a house. Youve estimated that the maximum monthly payment you can afford is $3,500. Your local bank is currently charging 0.4% monthly interest for a 30-year (360 month) mortgage. What is the most you can borrow? (Hint: Use solver/goalseek to find the mortgage amount that makes the final ending balance equal to zero).

	Mortgage Amount		(using solver)
	Monthly Payment	$3,500.00
Month	Beginning Balance	Payment	Ending Balance
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30