Autave DET BUE Data View Formulas Review Home Page Layout Insert Draw 21 Q Detine Name A-O Al fx eTrace Precedents a Trace Dependents Remove Arrows F Insert Autos Recently Financial Logical Text Date & Lookup & Math & More Function Time Used Create from Selection Heference Trio Functions Office Update To keep up to date with security updates fixes, and improvements, choose Check for Updates F2 D A 1 Borrower into 2 come incone month 4 Monthly detail 3 Monty Terance De Parent $249,000.00 Green $20.000.00 represent inputs $2,000.00 Purple text represent 3700.00 Joutputs 550,000.00 Maximum PMT Font Mwimum PMT BEDTI Maximum PMgve both FE & BET mit Maximum lange & Elimits Maximum langen LTV limit and down payment Maximum loven income & collateral tests Maximum payment given income collateral tests How much houten Ann afford? Total Montecosts 34 900 00 $4,500.00 $4,500.00 $1,026.10.08 $1.000.000.00 Loan 4.00 IN 2.00% 36.00% SON 1900 $5,000.00 11 10 Placinterest Rate 11 FENDTI 12 DTI 13 mm LTV 14 mm 13 Morogo 16 Morge Ben Points IT 18 19 Terre 20 Paper year 21 Total Number of Payments 22 Blo 23 26 25 10 30 12 361 20 10 11 34 36 40 41 Underwriting FA AMORTIZATION SCHEDULE FA CHARTS PAMORTIZATION SCHEDULE PA CHARTS + 2 3 4 5 6 Autave DET BUE Data View Formulas Review Home Page Layout Insert Draw 21 Q Detine Name A-O Al fx eTrace Precedents a Trace Dependents Remove Arrows F Insert Autos Recently Financial Logical Text Date & Lookup & Math & More Function Time Used Create from Selection Heference Trio Functions Office Update To keep up to date with security updates fixes, and improvements, choose Check for Updates F2 D A 1 Borrower into 2 come incone month 4 Monthly detail 3 Monty Terance De Parent $249,000.00 Green $20.000.00 represent inputs $2,000.00 Purple text represent 3700.00 Joutputs 550,000.00 Maximum PMT Font Mwimum PMT BEDTI Maximum PMgve both FE & BET mit Maximum lange & Elimits Maximum langen LTV limit and down payment Maximum loven income & collateral tests Maximum payment given income collateral tests How much houten Ann afford? Total Montecosts 34 900 00 $4,500.00 $4,500.00 $1,026.10.08 $1.000.000.00 Loan 4.00 IN 2.00% 36.00% SON 1900 $5,000.00 11 10 Placinterest Rate 11 FENDTI 12 DTI 13 mm LTV 14 mm 13 Morogo 16 Morge Ben Points IT 18 19 Terre 20 Paper year 21 Total Number of Payments 22 Blo 23 26 25 10 30 12 361 20 10 11 34 36 40 41 Underwriting FA AMORTIZATION SCHEDULE FA CHARTS PAMORTIZATION SCHEDULE PA CHARTS + 2 3 4 5 6