solve for mortgage qualification

3 E G C B D A 1 2 3 Credit Standard for Total Payments 4 Credit Standards for Mortgage Payment 5 Annual Income 6 Student Loan PMT 7 Credit Card 8 Car Loan 9 Escrows (PMI and Real Estate Tax ) 10 Mortgage Rate 11 Mortgage Years 12 13 Mortgage Qualification 14 15 Scenario "A" Scenario "B" Scenario "C" Scenario "D" Scenario "E" 43% 43% 35% 50% 40% 31% 31% 28% 35% 29% $ 75,000,00 $ 75,000.00 $ 45,000.00 $ 55,000.00 $ 80,000.00 400 400 400 500 300 75 200 200 150 0 0 0 500 550 400 150 200 150 100 200 4.50% 5% 6.50% 3.50% 6% 30 15 30 30 15