LoanScenarios-Excel_97-2003 by liwenting

VIEWS: 7 PAGES: 11

									Selling Price:
                                   30-Year             30-Year             30-Year               30-Year
  $489,000                           Fixed               Fixed               Fixed                 Fixed
% Down                                    3.50%               5.00%              10.00%               20.00%
Amount Down                          $17,115.00          $24,450.00          $48,900.00           $97,800.00
First Loan Amount                   $471,885.00         $464,550.00         $440,100.00          $391,200.00
Program Rate                             5.000%              5.000%              5.000%               5.000%
Estimated First
                                       $2,533.18           $2,493.80           $2,362.55           $2,100.05
Mortgage Payment
Estimated
                                         $216.28             $212.92             $201.71               $0.00
Monthly PMI
Estimated Monthly
                                         $255.58             $255.58             $255.58             $255.58
Property Taxes
Estimated Monthly
                                         $150.00             $150.00             $150.00             $150.00
Hazard Insurance
Estimated Total
                                      $3,155.04           $3,112.31          $2,969.85             $2,505.63
Monthly Payment
Est. After Tax Pmt
                                      $2,423.63           $2,391.07          $2,282.53             $1,939.95
(30% Tax Bracket)
Rates are subject to change due to unforeseen market conditions and borrower's credit profile.
                               Urmilla Busgith
                               917-806-4482
                               urmillarealtor@aol.com




Have you had your mortgage analysis this year?
Are you receiving the full tax benefits on your mortgage?
Is your mortgage an essential part of your overall financial plan?
Call us today and we will help you find the answer to all this important questions.

Taxes                                        3067
   Selling Price:
    $489,000            30 Yr Fix     30 Yr Fix      30 Yr Fix     30 Yr Fix
% Down                        3.50%         5.00%         10.00%        20.00%
Amount Down              $17,115.00    $24,450.00     $48,900.00    $97,800.00
First Loan Amount       $471,885.00   $464,550.00    $440,100.00   $391,200.00
Program Rate                 5.000%        5.000%         5.000%        5.000%
APR                         5.200%         5.200%        5.200%         5.200%
2nd Loan Amount         #VALUE!       #VALUE!        #VALUE!             $0.00
2nd Program Rate            6.250%         6.250%        6.250%         6.250%
APR                          6.313%        6.313%         6.313%        6.313%
Estimated First
                          $2,533.18      $2,493.80     $2,362.55     $2,100.05
Mortgage Payment
Estimated
                            $216.28       $212.92        $201.71         $0.00
Monthly PMI
Estimated Monthly
                            $255.58       $255.58        $255.58       $255.58
Property Taxes
Estimated Monthly
                            $150.00       $150.00        $150.00       $150.00
Hazard Insurance
Estimated Total
                         $3,155.04      $3,112.31      $2,969.85    $2,505.63
Monthly Payment
Est. After Tax Rebate
                         $2,423.63      $2,391.07     $2,282.53     $1,939.95
(30% Tax Bracket)
Est. Total Pmt
                         $1,223.63      $1,191.07     $1,082.53       $739.95
after rental income
Have you had your mortgage analysis this year?
Are you receiving the full tax benefits on your mortgage?
Is your mortgage an essential part of your overall financial plan?
Call us today and we will help you find the answer to all this important questions.
Taxes                               3067
Rental Income                       1200
                                 123 Main St., Bronx, NY 10467
                                                                                                   Special Comments

                                                                                                   Price                           $ 500,000
                                                                                                  MLS No.                                      34550923
                                                                                                  Price                           $              500,000
                                                                                                  Taxes                           $                4,200
                                                                                                  Bedrooms                                     8
                                                                                                  Bathrooms                                    6
                                                                                                  Style                          Cape
                                                                                                  Garage                         4 Cars
                                                                                                  Foundation                     Basement
                                                                                                  School District                Forest Hills

                                                                                                  Interior/ Additional Features:




Loan Type                                 FHA                            FHA                           FHA                        Conventional
Loan Term                            30 Yrs Fixed                   30 Yrs Fixed                  30 Yrs Fixed                   30 Yrs Fixed
Down Payment (%)                                3.5%                           5.0%                         10.0%                          20.0%
Down Payment ($)                      $      17,500                  $      25,000                 $      50,000                  $     100,000
Base Loan Amount ($)                  $     482,500                  $     475,000                 $     450,000                  $     400,000
Total Loan Amount ($)                 $     488,049                  $     480,463                 $     455,175                  $     400,000
Interest Rate (%)                              4.25%                          4.25%                         4.25%                          4.25%
APR (%)                                        4.89%                          4.89%                         4.89%                          4.89%
Principal & Interest ($)              $        2,401                 $        2,364                $        2,239                 $        1,968
Taxes ($)                             $          350                 $          350                $          350                 $          350
Home Insurance ($)                    $          120                 $          120                $          120                 $          120
PMI                                   $          462                 $          455                $          431                 $          -
Total Pymnt ($)                       $        3,333                 $        3,289                $        3,140                 $        2,438
Pymnt after Tax Rebate                $        2,500                 $        2,467                $        2,355                 $        1,828
Equity Built (3%/year)                $        1,250                 $        1,250                $        1,250                 $        1,250
Final Cash Flow                       $        1,250                 $        1,217                $        1,105                 $          578
Income Requiered                      $      88,888                  $      87,701                 $      83,745                  $      65,007




                             Urmilla Busgith                                                                       Biniamin Eli Weissman
                             Owner/Real Estate Agent                                                               President, NMLS #: 22677
                             C: (917) 806-4482                                                                     C: 718.807.7423
                             P: (718) 794-2327                                                                     P: 718.383.1537
                             F: (718) 794-2323                                                                     F: 718.383.1538



        Rates are subject to change due to unforeseen market conditions and borrower's credit profile. The numbers above are for comparison
            purposes only and accurancy is not guaranteed. The loan comparison does not ensure the availability of, or your eligibility for,
                       any specific product by any particular lender and/or is not a commitment to lend. The APR is estimated.
                        Register Mortgage Broker - NYS Banking Department, All loans arranged through 3rd party providers
Price:        $    500,000
Taxes:        $      4,200
UFPMI:               1.15%
%:                   4.25%
Term:                   360
Insurance:              120
PMI:                 1.15%
Rental Income: $     1,280
                       123 Main St., Bronx, NY 10467
                                                                 Special Comments


                                                                 MLS No.                          34550923
                                                                 Price                  $           425,000
                                                                 Taxes                  $             4,200
                                                                 Bedrooms                         8
                                                                 Bathrooms                        6
                                                                 Style                 Cape
                                                                 Garage                4 Cars
                                                                 Foundation            Basement
                                                                 School District       Forest Hills

                                                                 Interior/ Additional Features:



Loan Type                       FHA                FHA                FHA               Conventional
Loan Term                  30 Yrs Fixed       30 Yrs Fixed       30 Yrs Fixed          30 Yrs Fixed
Down Payment (%)                      3.5%               5.0%              10.0%                 20.0%
Down Payment ($)            $      14,875      $      21,250      $      42,500         $      85,000
Base Loan Amount ($)        $     410,125      $     403,750      $     382,500         $     340,000
Total Loan Amount ($)       $     413,816      $     407,384      $     385,943         $     340,000
Interest Rate (%)                    4.75%              4.75%              4.75%                 4.75%
APR (%)                              5.46%              5.46%              5.46%                 5.46%
Principal & Interest ($)    $        2,159     $        2,125     $        2,013        $        1,774
Taxes ($)                   $          350     $          350     $          350        $          350
Home Insurance ($)          $          120     $          120     $          120        $          120
PMI                         $          393     $          387     $          367        $          -
Total Pymnt ($)             $        3,022     $        2,982     $        2,850        $        2,244
Pymnt after Tax Rebate      $        2,266     $        2,237     $        2,137        $        1,683
Pymnt after Rental          $        1,747     $        1,707     $        1,575        $        1,119
Equity Built (3%/year)      $        1,063     $        1,063     $        1,063        $        1,063
Final Cash Flow             $         (296)    $         (326)    $         (425)       $         (880)
Income Requiered            $      80,579      $      79,521      $      75,995         $      59,829




                    Urmilla Busgith                                          Biniamin Eli Weissman
                    Owner/Real Estate Agent                                  President, NMLS #: 22677
                    C: (917) 806-4482                                        C: 718.807.7423
                    P: (718) 794-2327                                        P: 718.383.1537
                    F: (718) 794-2323                                        F: 718.383.1538
Rates are subject to change due to unforeseen market conditions and borrower's credit profile. The numbers above are for comparison
    purposes only and accurancy is not guaranteed. The loan comparison does not ensure the availability of, or your eligibility for,
               any specific product by any particular lender and/or is not a commitment to lend. The APR is estimated.
                Register Mortgage Broker - NYS Banking Department, All loans arranged through 3rd party providers
Price:        $    425,000
Taxes:        $      4,200
UFPMI:               0.90%
%:                   4.75%
Term:                   360
Insurance:              120
PMI:                 1.15%
Rental Income: $     1,500

								
To top