Generate Reports & Use Calculators

Edited

This guide provides step-by-step instructions on how to generate reports and use calculators within Scarlett. It covers various reports including applications summary, lender transactions, commissions, renewal tracking, and firm statistics. It also provides calculators for scenarios such as mortgage payments, maximum mortgage, mortgage analyzer, payment analyzer, mortgage isolator, prepayment analyzer, and income required. Viewing this guide will help users navigate the website and utilize the different tools effectively.


Video Walkthrough


Step-by-Step Guide

Reports

1) Click here to access all reports

Applications Summary Report

2) Click here to access "Applications Summary Report"

3) Here you can access the agent you want to select

4) Here you can select from a PDF or CSV format

5) Here you can select your Deal Source

6) Here you can scroll or search for a lender

7) Click here for Application Status

8) Click here for Application Type

9) Click here for Referral Source

10) Click here to pick the Date Type

11) Click here to Group By: (Application Status, Lender, Mortgage Position, Referral Source, Agent)

12) Here you can choose the Date Range

13) As well, you can add additional sorting filters that may fit

14) Here you can Run the Report, Set Default Settings, or Reset to Default

Lender Transactions Report

15) Click here to get to the Lender Transaction Report

16) Here you can select from Agent, Format, Deal Source, Lender, Application Status, Date Type, From and To Range, Group by Status, and the additional sortation features. As well, you can Run Report, Set Default Settings, and Reset to Default.

Commissions Report

17) Click here to get to Commissions Report

18) Commissions Report has all of the available search filters as Lender Transactions Report, as well a Fee Type and Deduction Type.

Renewal Tracking Report

19) Click here to get to Renewal Tracking Report

20) All of the features in this report should look familiar to the previous features

Firm Statistics Report

21) Click here to get to the Firm Statistics Report

22) These features should be familiar as well

Calculators

23) Click here to view the wide range of calculators available in Scarlett

Scenario Builder

24) Click here to view the Scenario Builder

25) Here you can build and save basic mortgage scenarios

Amortization Schedule

26) Click here to view the Amortization Schedule

27) Here you can produce and print amortization tables based on the mortgage data you input

Maximum Mortgage

28) Click here to get to the Maximum Mortgage page

29) In Maximum Mortgage, you can calculate the qualifying mortgage amounts based on income

Mortgage Analyzer

30) Click here to get to the Mortgage Analyzer

31) Here you can calculate the mortgage payments and generate an amortization schedule based on your input

Payment Analyzer

32) Click here to get to Payment Analyzer

33) Payment Analyzer does a quick and simple calculation of mortgage payments based on basic information such as amount, interest rate, amortization, and then generates a payment comparison based on frequency

Mortgage Isolator

34) Click here to access the Mortgage Isolator

35) Here you can isolate variables and reverse engineer your mortgage based on the inputs

Prepayment Analyzer

36) Click here to get to the Prepayment Analyzer

37) Here you can demonstrate the value of making lump sum or accelerated payments

Income Required

38) Click here to get to the income required page

39) This calculator shows income requirements based on mortgage amounts