Mortgage Comparison Calculator
Close Window
Go Back
Print this page

Purpose
Calculator Locations

Defaults & Assumptions
    ARM Loans
    Second Mortgage
    Interest Rate Projections

Reports
Trio Users

Purpose

The purpose of the Mortgage Comparison Calculator is to allow you to compare up to three mortgage scenarios, including borrower qualification ratios.


Calculator Locations

The Mortgage Comparison Calculator can be reached from eMagic’s Main Menu, Loan Manager and a Direct Connect (DC) Main Menu:

Main Menu:


Loan Manager:


DC Main Menu:

This calculator does not transfer data to/from a Loan/Lead. (A different version of this calculator does transfer data to/from a Loan/Lead.)

top

Defaults & Assumptions

The value entered in the Rate field is used to calculate the initial principal and interest payment.

If the loan has an interest only period, a fully-amortized P&I payment that is based upon the selected Product’s amortization term, is used in the qualifying ratios.

MGIC MI guidelines are incorporated in the calculator. When a loan scenario does not comply with an MGIC guideline, a Microsoft Internet Explorer Alert (!) message will appear only once. You can close the alert message and continue using the calculator. Thereafter, loan scenarios which fall outside MGIC guidelines will contain an MI value of “Unavailable,” and the calculator will display the message, “One or more scenarios cannot be calculated.”

The MI calculations in this calculator are not to be relied on for qualifying a borrower for MI or as a final MI quote.

See MGIC's Rate Finder calculator for MI quotes.

  1. ARM Loans

    Qualifying ratios are calculated using a P&I payment based upon the rate entered in the Qualifying Rate field, if any.

    All loans have an amortization term of 360 months.

    All adjustments are made to the rate.

  2. Second Mortgage

    Total Interest Paid and Total Amount paid will include the second mortgage only if Calculate Monthly Payment is selected in the Subordinate Financing form.

    Amortization schedules for second mortgages can be displayed only if you select Calculate Monthly Payment in the Subordinate Financing form.

    A HELOC is assumed to have interest only payments throughout the term of the loan.

    Fixed-rate second loans are fully amortized (no balloon loans).

  3. Interest Rate Projection Details

    Interest rate projections apply to ARM loans. Use different interest rate projections to provide different amortization scenarios for different rate increases. For example, create a best-case (Remain flat), mid-case (Rise gradually) and worst-case (Rise sharply) scenario.

    1. First Mortgages

      Remain Flat: The start rate (interest rate) will remain flat the same throughout the life of the loan.

      Rise gradually: The start rate (interest rate) will increase by 1% in the month after the initial adjustment period ends. Thereafter, it will increase by 0.75% per subsequent adjustment period until the maximum rate is reached.

      Rise sharply: The start rate (interest rate) will increase by 2% in the month after the initial adjustment period ends. Thereafter, it will increase by 2% per subsequent adjustment period until the maximum rate is reached.

    2. 2nd Mortgages

      Remain flat: The start rate (interest rate) will remain the same throughout the life of the loan.

      Rise gradually: The rate during the first year after the end of the fixed period will be equal to the start rate plus a 0.5% per year increase for every year since loan start. The rate will increase by 0.5% after the next 12 months and increase again by 0.5% in another 12 months. The rate will then maintain this level for the remaining loan term.

      Rise sharply: The rate during the first year after the end of the fixed period will be equal to the start rate plus a 1% per year increase for every year since loan start. The rate will increase by 1% after the next 12 months and increase again by 1% in another 12 months. The rate will then maintain this level for the remaining loan term.

Reports


Up to eight lines of text can be displayed in the calculator’s Notes field. These notes appear in the PDF report and can be used to share important information about the calculator results.

Reports are in PDF format. Use the icons on the PDF tool bar to save, print or email the report.

When an amortization schedule is produced by the calculator, it will appear in the saved PDF report.

  1. E-Mail Report Instructions

    Desktop E-Mail Clients

    Follow these instructions if you use an e-mail program such as Outlook, Outlook Express, Lotus Notes, etc.

    Look for the "E-mail" icon on the PDF toolbar. (If you do not see the e-mail icon, right-click the PDF tool bar, select More Tools..., E-mail, OK.)

    Select the E-mail icon. A new e-mail message should open in your e-mail program with the PDF file attached. Change the subject line and complete the message as desired.

    Send the PDF file as an attachment.

    Web-Based E-Mail

    Follow these instructions if you use a web-based e-mail service such as Gmail, Yahoo, Hotmail, etc.

    Select the “Save" icon on the PDF toolbar. Save the PDF file to your computer’s Desktop. (If you do not see the Save icon, right-click the PDF tool bar, select More Tools..., Save a Copy, OK.)

    Open your E-mail program, start a new message, and attach the PDF. Complete the e-mail as desired.

Trio Users

The PDF report can be saved to your PC and then uploaded to your Trio folder.

top