Flexmls Help

Calculation Reports

Click Calculation Reports under Daily Functions to access an amortization calculator and a closing cost estimator. Hover over a report name to view its description at the right. Click View Sample for a report to display an example of its output. Click on a report link to open the page where you can enter information into the calculator and generate the report.

DF_Calculators.png

Payment/Amortization Calculator

Click Amortization Schedule on the Calculation Reports page to open the Payment/Amortization Calculator. Use this calculator to determine the breakdown of principal and interest in mortgage payments.

DF_Amortization.png

Enter the principal loan balance, the annual interest rate, the number of payments per year, and the loan term. Then enter the date of the first payment. The payment amount will be automatically calculated and displayed in the Calculated Payment field.

If needed, you can enter a balloon payment amount for a specific payment number to determine how it will affect the total number of payments needed to repay the principal amount.

Before printing, select the information to display on the report. You can print annual totals only, a payment report only, or the entire schedule with all payments. You can also enter a title for the report.

Click View Report to view the report on-screen, and then use your browser's print function to print the report. Click Print Report to go directly to the print page.

Closing Cost Estimator

Click Closing Cost Estimator on the Calculation Reports page to calculate closing costs and/or net proceeds for a sale. Input charges and expenses for the buyer and/or the seller at closing.

DF_Closing_Cost_Estimator1.png

Click New to start a new closing cost estimator (CCE) or highlight an existing CCE and click Load to view it. To use a saved CCE as a template for a new CCE, load the saved CCE, type in a new name, and check the Save as new checkbox.

Select to display the buyer's summary, seller's summary, or both on the report. Enter the names and property address for the report, if necessary. Enter the contract and closing dates and the contract price for the property.

The Summary section contains the most commonly entered transaction information. You can add line items by clicking on the Add Line Item link for a category. The total paid by the buyer and reduction amount due to the seller are displayed at the bottom of the section, along with the Cash at Settlement totals.

Settlement charges are calculated in the last section of the report. Commissions, fees, insurance, and any reserves deposited with the lender are entered in this section. The total charges for each party appear at the bottom of the section. These charges are then automatically entered as line items in the Cash at Settlement section.

DF_Closing_Cost_Estimator.png

When you are finished entering information, you can save, print, or e-mail the CCE by using the buttons at the top of the screen. You can print a full version of the report, with or without page breaks, or you can print a condensed version. Signature blocks for buying and selling parties are displayed on the last page of the report.

If you print or e-mail before you save, the system will automatically save your entries.