Spreadsheet: 800316d1665593519-if-statements-i-think-excel-test-worksheet
Sheet: Buy Down Options - For Agents

 |  |  |  |  |  |  |  |  |  | Johnson Team Intructions (DO NOT SNIP)
 |  |  |  |  |  |  |  |  |  | *Complete the Yellow Cells below the chart will auto-populate
 |  | Temporary Buy Down Chart |  | Year 1 | Year 2 | Year 3 | Year 4-30 |  |  | Purchase Price |  | 950000 |  | Down Payment %
 |  | Interest Rate |  |  |  |  |  |  |  | Loan Amount |  | 940000
 |  | Principal & Interest Payment |  |  |  |  |  |  |  | Interest Rate |  | 0.07125 | Loan Program |  | Conventional
 |  | Seller Credit Applied As: |  |  |  |  |  |  |  | Permanent Buy Down Interest Rate |  | 0.055 | [NAME] % |  | 0.06
 |  | Temporary Buy Down Savings |  |  |  |  |  |  |  | Terms in Years |  | 30 | [NAME] $
 |  | Monthly |  |  |  |  | Total Savings
 |  | Annual |  |  |  |  |  |  |  |  | Interested Party Contribution Limits (IPC)
 |  |  | Cumulative |  |  |  |  |  |  |  | Occupancy |  | LTV/CLTV | [NAME]
 |  | Discount Point Savings |  |  |  |  |  |  |  |  | Conventional (CONV) Fannie & Freddie |  |  |  | Type | Downpayment from
 |  | Monthly |  |  |  |  | Total Savings |  |  |  | Primary & Secondary |  | >90% | 0.03 | Conventional | 0 | 0.03
 |  | Annual |  |  |  |  |  |  |  |  |  |  | 75.01%-90% | 0.06 | Conventional | 0.1 | 0.06
 |  |  | Cumulative |  |  |  |  |  |  |  |  |  | < 75% | 0.09 | Conventional | 0.25 | 0.09
 |  | Price Reduction Savings |  |  |  |  |  |  |  |  | Investment |  | All LTV/CLTV | 0.02 | FHA |  | 0.06
 |  | Monthly |  |  |  |  | Total Savings |  |  |  | FHA & USDA |  |  |  | USDA |  | 0.06
 |  | Annual |  |  |  |  |  |  |  |  | Not Applicable |  | N/A | 0.06 | VA |  | 0.04
 |  |  | Cumulative |  |  |  |  |  |  |  | VA
 |  |  |  |  |  |  |  |  |  |  | Not Applicable |  | N/A | 0.04
 |  | Purchase Price:
 |  | Loan Amount:
 |  | Comments:
 |  | 1. Interest rate is temporarily reduced by 3% in Year 1, 2% in Year 2, and 1% Year 3
 |  | 2. Up-front cost of the Buy Down is paid by the seller or builder
 |  | 3. Available for [NAME] and Second Home Purchases,
 |  | 4. Fannie Mae, Freddie Mac, FHA, VA
 |  | 5. Johnson Team provides buyer with No Lender Fee Refinance for a lowered rate
 |  | **[NAME] seller credit: Less than 10% down = 3%; Greater than 10% down = 6%
 |  | 2-1 Buydown |  | Year 1 | Year 2 | Year 3-30
 |  | Interest Rate
 |  | Principal & Interest Payment
 |  | Monthly Principal & Interest Savings
 |  | Yearly Principal & Interest Savings
 |  |  |  | Seller-Paid Interest  Due at Closing
 |  | Purchase Price:
 |  | Loan Amount:
 |  | Comments:
 |  | 1. Eligible Products: Fannie Mae, Freddie Mac, FHA, USDA
 |  | 2. Available for [NAME] and Second Homes, Purchase Only, 1-4 Unit Properties
 |  | 3. Interest rate is temporarily reduced by 2% the first 12 months and 1% the second 12 months of the mortgage
 |  | 4. Up-front cost of the buydown is paid by the seller or builder (if new construction)
 |  | 1-1 Buydown |  | Year 1 | Year 2-30
 |  | Interest Rate
 |  | Principal & Interest Payment
 |  | Monthly Principal & Interest Savings
 |  | Yearly Principal & Interest Savings
 |  |  | Seller-Paid Interest  Due at Closing
 |  | Purchase Price:
 |  | Loan Amount:
 |  | Comments:
 |  | 1. Eligible Products: Fannie Mae, Freddie Mac, FHA, USDA
 |  | 2. Available for [NAME] and Second Homes, Purchase Only, 1-4 Unit Properties
 |  | 3. Interest rate is temporarily reduced by 1% the first 12 months
 |  | 4. Up-front cost of the buydown is paid by the seller or builder (if new construction)
 |  | Buyer Benefits:
 |  | ·         Maximizes upfront savings and affordability,
 |  | ·         [NAME] seller credit benefits before refinancing - avoids wasting seller credits on discount points
 |  | Seller Benefits:
 |  | ·         [NAME] credits are more effective in achieving for payment-conscious buyers
 |  | ·         Promote property eligibility for 2-1 Buy Down in listing remarks to increase buyer interest in their listing