Qualify by qingyunliuliu

VIEWS: 4 PAGES: 4

									                                636cdb7f-a5c9-49d0-b5fc-e6ea9409253c.xls



            LOAN QUALIFICATION WORKSHEET

Value                      200,000   200,000   200,000    200,000
Loan-to-Value                 80%       80%       80%        80%
Loan Amount                160,000   160,000   160,000    160,000
Interest Rate               7.00%     7.13%     7.25%      7.38%

PAYMENTS                                                  15 year
Loan Payment                 1,064     1,078     1,091      1,472
Taxes                          192       225       225        225
PMI                              0         0         0          0
Insurance/Dues                  40        40        40         40
PITI                         1,296     1,343     1,356      1,737
Bills                          100       100       100        100
PITI + bills                 1,396     1,443     1,456      1,837

         RATIOS                                                      INCOME
                                                                 Salary          3,000
Top Ratio                     23%       24%       24%        31% Bonus             417
                                                                 Other salary    2,100
Bottom                        25%       26%       26%        33% Other             125
                                                                 TOTAL           5,642
                                                                 Annual         67,700

                          RE-FINANCE COST RECAPTURE ANALYSIS
COSTS
Points                          0        0.5      0.75         1
Loan Origination fee            0       800      1200       1600
Garbage Fees                  500       500        500       500
Appraisal                     300       300        300       300
Credit                         50         50        50        50
Business Credit                 0          0         0         0
Tax service                    65         65        65        65
Processing Fee                350       350        350       350
Escrow                        450       450        450       450
Title ins                     558       558        558       558
Sub esc                       100       100        100       100
Recording                      50         50        50        50
Recon                          75         75        75        75
Total                        2498      3298      3698       4098

Current loans              150,000    10,000
Current note rates           0.085     0.115
Current 1st TD interest     12,750    12,750    12,750     12,750
Current 2nd TD interest      1,150     1,150     1,150      1,150
TOTAL                       13,900    13,900    13,900     13,900
New loan interest           11,200    11,400    11,600     11,800
Savings                      2,700     2,500     2,300      2,100
Months to recoup costs          11        16        19         23




                                                 Page 1
636cdb7f-a5c9-49d0-b5fc-e6ea9409253c.xls




                Page 2
636cdb7f-a5c9-49d0-b5fc-e6ea9409253c.xls




                Page 3
636cdb7f-a5c9-49d0-b5fc-e6ea9409253c.xls




                Page 4

								
To top