this is just a screenshot. i do not have the excel formulas. please help.

"2014 Fanie Mae Guidelines" Annual Income $ Debt To Income Credit Standard for Total Payments Credit Standards for Mortgage Payment 50% 30% Max Total Payments Max Mortgage Payments 60,000.00 $ 30,000.00 $ 18,000.00 Mothly Payment $ 2,500.00 $ 1,500.00 Student Loan PMT Credit Card Car Loan 300 0 0 $ 1,500.00 Payment Maximum Mortgage Payment (With Escrowed) Escrows (PMI and Real Estate Tax) Maximum Mortgage Payment (Without Escrowed) 2,200.00 $ 1500 150 1350 Mortgage Rate 4.50% Mortgage Year 30 Mortgage Qualification Amount ($266,437.56) You need a new car. What is the maximum car loan payment that will not impact your mortgage qualification? "2014 Fanie Mae Guidelines" Annual Income $ Debt To Income Credit Standard for Total Payments Credit Standards for Mortgage Payment 50% 30% Max Total Payments Max Mortgage Payments 60,000.00 $ 30,000.00 $ 18,000.00 Mothly Payment $ 2,500.00 $ 1,500.00 Student Loan PMT Credit Card Car Loan 300 0 0 $ 1,500.00 Payment Maximum Mortgage Payment (With Escrowed) Escrows (PMI and Real Estate Tax) Maximum Mortgage Payment (Without Escrowed) 2,200.00 $ 1500 150 1350 Mortgage Rate 4.50% Mortgage Year 30 Mortgage Qualification Amount ($266,437.56) You need a new car. What is the maximum car loan payment that will not impact your mortgage qualification