Subjects finance, algebra

Mortgage Affordability

Step-by-step solutions with LaTeX - clean, fast, and student-friendly.

Search Solutions

Mortgage Affordability


1. **State the problem:** Edgar wants to buy a house priced at P1,500,000 but must add P152,000 for extra costs. He has P680,000 for the down payment and will receive a monthly housing subsidy of P2,500. He can get a 20-year mortgage at 12.5% annually compounded monthly. He is willing to spend up to one third of his gross monthly salary of P30,000 on payments. 2. **Calculate total upfront payment needed:** $$\text{Total upfront} = P680,000 + P152,000 = P832,000$$ 3. **Calculate loan amount (principal) required:** $$\text{Loan} = P1,500,000 - P832,000 = P668,000$$ 4. **Calculate the maximum monthly payment Edgar can afford:** $$\text{Max monthly payment} = \frac{1}{3} \times 30,000 = P10,000$$ 5. **Calculate monthly interest rate:** $$i = \frac{12.5\%}{12} = 1.0417\% = 0.010417$$ 6. **Calculate total number of monthly payments:** $$n = 20 \times 12 = 240$$ 7. **Calculate monthly mortgage payment using formula:** $$P = \text{loan principal} = 668,000$$ $$M = P \times \frac{i(1+i)^n}{(1+i)^n - 1}$$ Calculate numerator: $$i(1+i)^n = 0.010417 \times (1.010417)^{240}$$ Approximate: $$(1.010417)^{240} \approx e^{240 \times \ln(1.010417)} \approx e^{240 \times 0.010365} = e^{2.4876} \approx 12.03$$ Thus, $$i(1+i)^n = 0.010417 \times 12.03 \approx 0.1254$$ Calculate denominator: $$(1+i)^n -1 = 12.03 -1 = 11.03$$ So, $$M = 668,000 \times \frac{0.1254}{11.03} = 668,000 \times 0.01137 = P7,596.16$$ 8. **Add monthly housing subsidy to affordability:** Since Edgar receives P2,500 subsidy, his effective affordable payment is: $$10,000 + 2,500 = P12,500$$ 9. **Decision:** Monthly mortgage payment is P7,596.16 which is less than P12,500 affordable monthly budget. So, Edgar can afford the payments under these conditions. **Final Answer:** Edgar should buy the house as the monthly mortgage payment fits within his affordable budget.