80.2K

Verified Solution

Link Copied!

AutoSave Project Spreadsheet Excel Amina Hong File Home Insert Draw Page Layout Formulas Data Review View Help Calibri - AA EE 29 General 2.29 0 th f Us Conditional Formatas Call Formatting Table Styles Styles Dolete - Format Sort & Find a Filter fact Gipboard Font 19 Alignment Number Cole F11 B D 1 Borrower info: 2 Income (annual) $240,000.00 Green text Maximum PMT given FE DTI limit 2 Income (monthly $20,000.00 represent inputs Maximum PMT given BE DTI limit 4 Monthly debt (average) $2,000.00 Purple text Maximum PMT given both FE & BEDTI limits 5 Monthly Taxes + Insurance $700.00 represent Maximum loan given FE & BE DTI limits 6 Down Payment $50,000.00 Maximum loan given LTV limit and down payment 7 Maximum loan given income & collateral tests Loan terms: Maximum payment given income & collateral tests Annual interest Rate 4,00% How much house can Ann afford? 10 Periodic interest Rate 0.33% Total Mortgage Costs 11 maximum FE monthly DTI 28.00 12 maximum BE monthly DTI 30.00 13 maximum LTV 95.00% 14 maximum loan/DP 19.00 15 Mortgage Closing Costs $5,000.00 16 Mortgage Buydown Points 1.75 17 TO 19 Term (years) 30 20 Payments per year 12 21 Total Number of Payments 22 Balloon 23 Underwriting FA AMORTIZATION SCHEDULE FA CHARTS PA AMORTIZATION SCHEDULE 360 Activate Windo

Answer & Explanation Solved by verified expert

See Answer