- Please Help 1 (99.09 KiB) Viewed 40 times
PLEASE HELP
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
PLEASE HELP
PLEASE HELP
B D E F G Green text $240,000.00 represent inputs $20,000.00 $2,000.00 Purple text $700.00 represent outputs $50,000.00 A 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 & BE DTI limits Maximum loan given FE & BE DTI 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% 18 19 Term (years) 20 Payments per year 21 Total Number of Payments 22 Balloon 30 12 360 0 i N o T Q Q Ñ o 25 26 27 28 Underwriting FA AMORTIZATION SCHEDULE FA CHARTS PA AMORTIZATION SCHEDULE PA ... +
B D E F G Green text $240,000.00 represent inputs $20,000.00 $2,000.00 Purple text $700.00 represent outputs $50,000.00 A 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 & BE DTI limits Maximum loan given FE & BE DTI 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% 18 19 Term (years) 20 Payments per year 21 Total Number of Payments 22 Balloon 30 12 360 0 i N o T Q Q Ñ o 25 26 27 28 Underwriting FA AMORTIZATION SCHEDULE FA CHARTS PA AMORTIZATION SCHEDULE PA ... +