A B D E F Green text $240,000.00 represent inputs $20,000.00 $2,000.00 Purple text represent $700.00 outputs $50,000.00 1 Borrower info: 2 Income (annual) 3 Income (monthly) 4 Monthly debt (average) 5 Monthly Taxes + Insurance 6 Down Payment 7 8 Loan terms: 9 Annual Interest Rate 10 Periodic Interest Rate 11 maximum FE monthly DTI 12 maximum BE monthly DTI 13 maximum LTV 14 maximum loan/DP 15 Mortgage Closing Costs 16 Mortgage Buydown Points 17 Maximum PMT given FE DTI limit Maximum PMT given BE DTI limit Maximum PMT given both FE & BEDTI limits Maximum loan given FE & BEDTI limits Maximum loan given LTV limit and down-payment Maximum loan given income & collateral tests Maximum payment given income & collateral tests How much house can Ann afford? Total Mortgage Costs 4.00% 0.33% 28.00% 36.00% 95.00% 19.00 $5,000.00 1.75% 30 18 19 Term (years) 20 Payments per year 21 Total Number of Payments 22 Balloon 12 360 0 A B D E F Green text $240,000.00 represent inputs $20,000.00 $2,000.00 Purple text represent $700.00 outputs $50,000.00 1 Borrower info: 2 Income (annual) 3 Income (monthly) 4 Monthly debt (average) 5 Monthly Taxes + Insurance 6 Down Payment 7 8 Loan terms: 9 Annual Interest Rate 10 Periodic Interest Rate 11 maximum FE monthly DTI 12 maximum BE monthly DTI 13 maximum LTV 14 maximum loan/DP 15 Mortgage Closing Costs 16 Mortgage Buydown Points 17 Maximum PMT given FE DTI limit Maximum PMT given BE DTI limit Maximum PMT given both FE & BEDTI limits Maximum loan given FE & BEDTI limits Maximum loan given LTV limit and down-payment Maximum loan given income & collateral tests Maximum payment given income & collateral tests How much house can Ann afford? Total Mortgage Costs 4.00% 0.33% 28.00% 36.00% 95.00% 19.00 $5,000.00 1.75% 30 18 19 Term (years) 20 Payments per year 21 Total Number of Payments 22 Balloon 12 360 0