Comparison Rate Calculator by ajizai

VIEWS: 11 PAGES: 177

									                    INTERSTAR Comparison Rate Calculator

                    Comparison Rate Calculator & Schedule                                              Products & Setup



1. Comparison rate calculator
Calculate the comparison rate for a given loan amount.
  Loan Amount $ $270,000.00                                          Product:   FullDoc Variable Home Loan


Comparison rate:      #NAME?        p.a                       Borrower rate: #NAME?


      WARNING: This Comparison Rate applies only to the example or examples given. Different amounts and
      terms will result in different Comparison Rates. Costs such as redraw fees or early repayment fees, and
      costs savings such as fee waivers, are not included in the Comparison Rate, but may influence the cost of
      the loan.

2. Comparison Rate schedule (based on legislation amounts)
Select products to be included in your comparison rate schedule, then click Print
       Product 1:   FullDoc Variable Home Loan                     Product 2:   FullDoc Variable with cheque book

       Product 3:   Reduced Rate Loan (12 months)                  Product 4:   Reduced rate loan (6 months) with cheque book

       Product 5:   Sub Prime Standard variable rate loan          Product 6:   Sub Prime loan with credit & debit card/cheque book

                                                                     Print



      Comparison Rate Schedule

                                                                                ABC Mortgage Corporation Pty Ltd
                                                                                ABN : 123456789
                                                                                Level 31, 367 Comparison Street
                                                                                Melbourne, Victoria, 3000
                                                                                Phone : (03) 9612 1111
      Issue Date:                   19-December-2011



      Secured Loan Product:         FullDoc Variable Home Loan                  Repayment Frequency: Monthly

      Credit Provider:              Perpetual Trustees Victoria Limited


      Amount                        Term          Comparison Rate Annual Percentage Rate
      $30,000.00                    5 years          #NAME?                         #NAME?
      $50,000.00                    7 years          #NAME?                         #NAME?
      $70,000.00                    25 years         #NAME?                         #NAME?
      $100,000.00                   25 years         #NAME?                         #NAME?
      $130,000.00                   25 years         #NAME?                         #NAME?
      $150,000.00                   25 years         #NAME?                         #NAME?
      $200,000.00                   25 years         #NAME?                         #NAME?
      $225,000.00                   25 years         #NAME?                         #NAME?
$250,000.00                25 years        #NAME?                             #NAME?
$275,000.00                30 years        #NAME?                             #NAME?
$300,000.00                30 years        #NAME?                             #NAME?




Secured Loan Product:      FullDoc Variable with cheque book          Repayment Frequency: Monthly

Credit Provider:           Perpetual Trustees Victoria Limited


Amount                     Term       Comparison Rate Annual Percentage Rate
$30,000.00                 5 years       #NAME?                         #NAME?
$50,000.00                 7 years       #NAME?                         #NAME?
$70,000.00                 25 years      #NAME?                         #NAME?
$100,000.00                25 years      #NAME?                         #NAME?
$130,000.00                25 years      #NAME?                         #NAME?
$150,000.00                25 years      #NAME?                         #NAME?
$200,000.00                25 years      #NAME?                         #NAME?
$225,000.00                25 years      #NAME?                         #NAME?
$250,000.00                25 years      #NAME?                         #NAME?
$275,000.00                30 years      #NAME?                         #NAME?
$300,000.00                30 years      #NAME?                         #NAME?


WARNING: This Comparison Rate applies only to the example or examples given. Different amounts and
terms will result in different Comparison Rates. Costs such as redraw fees or early repayment fees, and
costs savings such as fee waivers, are not included in the Comparison Rate, but may influence the cost of
the loan.



Comparison Rate Schedule

                                                                      ABC Mortgage Corporation Pty Ltd
                                                                      ABN : 123456789
                                                                      Level 31, 367 Comparison Street
                                                                      Melbourne, Victoria, 3000
                                                                      Phone : (03) 9612 1111
Issue Date:                19-December-2011



Secured Loan Product:      Reduced Rate Loan (12 months)              Repayment Frequency: Monthly

Credit Provider:           Perpetual Trustees Victoria Limited


Amount                     Term       Comparison Rate Annual Percentage Rate
$30,000.00                 5 years       #NAME?                         #NAME?
$50,000.00                 7 years       #NAME?                         #NAME?
$70,000.00                 25 years      #NAME?                         #NAME?
$100,000.00                25 years      #NAME?                         #NAME?
$130,000.00                25 years      #NAME?                         #NAME?
$150,000.00                25 years      #NAME?                         #NAME?
$200,000.00                25 years      #NAME?                         #NAME?
$225,000.00                25 years      #NAME?                         #NAME?
$250,000.00                25 years      #NAME?                         #NAME?
$275,000.00                30 years        #NAME?                             #NAME?
$300,000.00                30 years        #NAME?                             #NAME?




Secured Loan Product:      Reduced rate loan (6 months) with          Repayment Frequency: Monthly
                           cheque book
Credit Provider:           Perpetual Trustees Victoria Limited


Amount                     Term       Comparison Rate Annual Percentage Rate
$30,000.00                 5 years       #NAME?                         #NAME?
$50,000.00                 7 years       #NAME?                         #NAME?
$70,000.00                 25 years      #NAME?                         #NAME?
$100,000.00                25 years      #NAME?                         #NAME?
$130,000.00                25 years      #NAME?                         #NAME?
$150,000.00                25 years      #NAME?                         #NAME?
$200,000.00                25 years      #NAME?                         #NAME?
$225,000.00                25 years      #NAME?                         #NAME?
$250,000.00                25 years      #NAME?                         #NAME?
$275,000.00                30 years      #NAME?                         #NAME?
$300,000.00                30 years      #NAME?                         #NAME?


WARNING: This Comparison Rate applies only to the example or examples given. Different amounts and
terms will result in different Comparison Rates. Costs such as redraw fees or early repayment fees, and
costs savings such as fee waivers, are not included in the Comparison Rate, but may influence the cost of
the loan.



Comparison Rate Schedule

                                                                      ABC Mortgage Corporation Pty Ltd
                                                                      ABN : 123456789
                                                                      Level 31, 367 Comparison Street
                                                                      Melbourne, Victoria, 3000
                                                                      Phone : (03) 9612 1111
Issue Date:                19-December-2011



Secured Loan Product:      Sub Prime Standard variable rate loan      Repayment Frequency: Monthly

Credit Provider:           ABC BANK


Amount                     Term       Comparison Rate Annual Percentage Rate
$30,000.00                 5 years       #NAME?                         #NAME?
$50,000.00                 7 years       #NAME?                         #NAME?
$70,000.00                 25 years      #NAME?                         #NAME?
$100,000.00                25 years      #NAME?                         #NAME?
$130,000.00                25 years      #NAME?                         #NAME?
$150,000.00                25 years      #NAME?                         #NAME?
$200,000.00                25 years      #NAME?                         #NAME?
$225,000.00                25 years      #NAME?                         #NAME?
$250,000.00                25 years      #NAME?                         #NAME?
$275,000.00                30 years      #NAME?                         #NAME?
$300,000.00                30 years        #NAME?                             #NAME?




Secured Loan Product:      Sub Prime loan with credit & debit         Repayment Frequency: Monthly
                           card/cheque book
Credit Provider:           XYZ Bank


Amount                     Term       Comparison Rate Annual Percentage Rate
$30,000.00                 5 years       #NAME?                         #NAME?
$50,000.00                 7 years       #NAME?                         #NAME?
$70,000.00                 25 years      #NAME?                         #NAME?
$100,000.00                25 years      #NAME?                         #NAME?
$130,000.00                25 years      #NAME?                         #NAME?
$150,000.00                25 years      #NAME?                         #NAME?
$200,000.00                25 years      #NAME?                         #NAME?
$225,000.00                25 years      #NAME?                         #NAME?
$250,000.00                25 years      #NAME?                         #NAME?
$275,000.00                30 years      #NAME?                         #NAME?
$300,000.00                30 years      #NAME?                         #NAME?


WARNING: This Comparison Rate applies only to the example or examples given. Different amounts and
terms will result in different Comparison Rates. Costs such as redraw fees or early repayment fees, and
costs savings such as fee waivers, are not included in the Comparison Rate, but may influence the cost of
the loan.
       10.14
       67.44
        6.43
8.73   11.29   8.43   2.86
        4.14
       99.44
        2.56
                 v 1.1

r




book

) with cheque book

debit card/cheque book
                                Maybe just show the schedule?




                                                     Week
                                                                Fortnight
                                                                Year




           How will we show different initial and ongoing rates?
Term1      Term1RateTerm2        Term2RateUpfront        Ongoing Frequency Closing
        30       6.5           0            0        935         0       1       295

CRDisplay                Term1
                ScheduleTerm   Term2
            1    #NAME? #NAME?          0
            1    #NAME? #NAME?          0
            1    #NAME? #NAME?          0
            1    #NAME? #NAME?          0
            1    #NAME? #NAME?          0
            1    #NAME? #NAME?          0
            1    #NAME? #NAME?          0
            1    #NAME? #NAME?          0
            1 #NAME?     #NAME?             0
            1 #NAME?     #NAME?             0
            1 #NAME?     #NAME?             0




Term1           Term1RateTerm2       Term2RateUpfront   Ongoing Frequency Closing
        30           6.65        0          0       935        0        1       295

CRDisplay                Term1
                ScheduleTerm   Term2
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0




Term1           Term1RateTerm2    Term2RateUpfront   Ongoing Frequency Closing
            1        5.7       29      6.5         0        0        1       295

CRDisplay                Term1
                ScheduleTerm         Term2
 #NAME?          #NAME?          1    #NAME?
 #NAME?          #NAME?          1    #NAME?
 #NAME?          #NAME?          1    #NAME?
 #NAME?          #NAME?          1    #NAME?
 #NAME?          #NAME?          1    #NAME?
 #NAME?          #NAME?          1    #NAME?
 #NAME?          #NAME?          1    #NAME?
 #NAME?          #NAME?          1    #NAME?
 #NAME?          #NAME?          1    #NAME?
 #NAME?         #NAME?            1 #NAME?
 #NAME?         #NAME?            1 #NAME?




Term1           Term1RateTerm2     Term2RateUpfront   Ongoing Frequency Closing
        0.5          5.05     29.5      6.65        0        0        1       295

CRDisplay                Term1
                ScheduleTerm           Term2
 #NAME?          #NAME?          0.5    #NAME?
 #NAME?          #NAME?          0.5    #NAME?
 #NAME?          #NAME?          0.5    #NAME?
 #NAME?          #NAME?          0.5    #NAME?
 #NAME?          #NAME?          0.5    #NAME?
 #NAME?          #NAME?          0.5    #NAME?
 #NAME?          #NAME?          0.5    #NAME?
 #NAME?          #NAME?          0.5    #NAME?
 #NAME?          #NAME?          0.5    #NAME?
 #NAME?          #NAME?          0.5    #NAME?
 #NAME?          #NAME?          0.5    #NAME?




Term1           Term1RateTerm2         Term2RateUpfront   Ongoing Frequency Closing
        20           8.5          0           0       800       120       3       195

CRDisplay                Term1
                ScheduleTerm   Term2
            1    #NAME? #NAME?                0
            1    #NAME? #NAME?                0
            1    #NAME? #NAME?                0
            1    #NAME? #NAME?                0
            1    #NAME? #NAME?                0
            1    #NAME? #NAME?                0
            1    #NAME? #NAME?                0
            1    #NAME? #NAME?                0
            1    #NAME? #NAME?                0
            1    #NAME? #NAME?                0
            1 #NAME?     #NAME?             0




Term1           Term1RateTerm2       Term2RateUpfront   Ongoing Frequency Closing
        20           8.5         0          0       600        30       1       300

CRDisplay                Term1
                ScheduleTerm   Term2
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
            1    #NAME? #NAME?              0
                           Interstar Comparison Rate Calculator


                                                Product & Originator Setup

1. Product Setup:
Product 1
            Lender Product: Premium
            Credit Provider: Perpetual Trustees Victoria Limited

     Originator description: FullDoc Variable Home Loan
                Initial Term:        30 years                 Borrower rate (initial):    6.5
             Ongoing Term:            0 years            Borrower rate (ongoing):          0
             Upfront Fees $           0
                 Valuation $        250                                Legal Costs $     685
             Ongoing fees $           0     per     Monthly

       Lenders admin fees $         295

Product 2
            Lender Product: Premium Deluxe
            Credit Provider: Perpetual Trustees Victoria Limited


     Originator description: FullDoc Variable with cheque book
                Initial Term:        30 years                 Borrower rate (initial):   6.65
             Ongoing Term:            0 years            Borrower rate (ongoing):
             Upfront Fees $           0
                 Valuation $        250                                Legal Costs $     685
             Ongoing fees $           0     per    Monthly
       Lenders admin fees $         295

Product 3
            Lender Product: Premium LowStart
            Credit Provider: Perpetual Trustees Victoria Limited

     Originator description: Reduced Rate Loan (12 months)
                Initial Term:         1 years                 Borrower rate (initial):    5.7
             Ongoing Term:           29 years            Borrower rate (ongoing):         6.5
             Upfront Fees $           0
                 Valuation $          0                                Legal Costs $       0
             Ongoing fees $           0     per     Monthly
       Lenders admin fees $         295
Product 4
            Lender Product: Premium Deluxe LowStart
             Credit Provider: Perpetual Trustees Victoria Limited

     Originator description: Reduced rate loan (6 months) with cheque book
                 Initial Term:         0.5 years                   Borrower rate (initial):    5.05
              Ongoing Term:           29.5 years             Borrower rate (ongoing):          6.65
              Upfront Fees $             0
                  Valuation $            0                                  Legal Costs $         0
              Ongoing fees $             0     per       Monthly
       Lenders admin fees $           295

Product 5
            Lender Product: Other funder product
             Credit Provider: ABC BANK

     Originator description: Sub Prime Standard variable rate loan
                 Initial Term:          20 years                   Borrower rate (initial):     8.5
              Ongoing Term:              0 years             Borrower rate (ongoing):             0
              Upfront Fees $             0
                  Valuation $         400                                   Legal Costs $       400
              Ongoing fees $          120      per       Half Yearly
       Lenders admin fees $           195

Product 6
            Lender Product: Other funder product
             Credit Provider: XYZ Bank

     Originator description: Sub Prime loan with credit & debit card/cheque book
                 Initial Term:          20 years                   Borrower rate (initial):     8.5
              Ongoing Term:              0 years             Borrower rate (ongoing):             0
              Upfront Fees $             0
                  Valuation $         300                                   Legal Costs $       300
              Ongoing fees $            30     per       Monthly
       Lenders admin fees $           300

2. Originator Details:
            Originator name: ABC Mortgage Corporation Pty Ltd
             Street Address: Level 31, 367 Comparison Street
     Suburb/State/Postcode: Melbourne, Victoria, 3000
                         ABN: 123456789                Telephone: (03) 9612 1111



     To the maximum extent permitted by law, Interstar will not be liable in any way (including for negligence) for any loss,
     damage, cost or expense suffered or incurred by the users of this Comparison Rate Calculator, or in connection with
information offered or supplied through this Comparison Rate Calculator.
                                                    8.43       1.57              8.43
                                                    8.43       4.71              8.43
                                                    8.43      20.14                 3
                                                   15.57       8.43              6.43




                                        Prod1     Prod2    Prod3      Prod4   Prod5
    <Select product>                      1         2        3          4             5
1   FullDoc Variable Home Loan
2   FullDoc Variable with cheque book
3   Reduced Rate Loan (12 months)
4   Reduced rate loan (6 months) with cheque book
5   Sub Prime Standard variable rate loan
6   Sub Prime loan with credit & debit card/cheque book

    Product names
        1                        0
        2                        0
        3                        0
        4                        0
Annual % rates
      Initial                     Ongoing     Concatenated - multi year
    1                      6.5            0   6.5%p.a for 30 year(s) then 0 %p.a
    2                     6.65            0   6.65%p.a for 30 year(s) then 0 %p.a
    3                      5.7          6.5   5.7%p.a for 1 year(s) then 6.5 %p.a
    4                     5.05         6.65   5.05%p.a for 0.5 year(s) then 6.65 %p.a
    5                      8.5            0
    6

Terms Initial                     Ongoing
    1                       30            0
    2                       30            0
    3                         1         29
    4                       0.5        29.5

Display borrower rate
    1 6.5%p.a for 30 year(s) then 0 %p.a
    2 6.65%p.a for 30 year(s) then 0 %p.a
    3 5.7%p.a for 1 year(s) then 6.5 %p.a
    4 5.05%p.a for 0.5 year(s) then 6.65 %p.a


      Term1
Product                           Term2       Term1RateTerm2Rate Upfront Fee              Ongoing Fee
    1                       30            0         6.5          0                  935           0
    2                       30            0        6.65          0                  935           0
    3                         1         29          5.7        6.5                    0           0
    4                       0.5        29.5        5.05       6.65                    0           0
    5                       20            0         8.5          0                  800         120
    6                       20            0         8.5          0                  600          30


      CreditProvider
Product                         CreditProvider
    1 Perpetual Trustees Victoria Limited
    2 Perpetual Trustees Victoria Limited
    3 Perpetual Trustees Victoria Limited
    4 Perpetual Trustees Victoria Limited
    5 ABC BANK
    6 XYZ Bank
                                         v 1.1

Rate Calculator


                  Calculator/ Schedule
ator Setup




             %
             %




             %
             %




             %
             %
                       %
                       %




                       %
                       %




                       %
                       %




ny way (including for negligence) for any loss,
parison Rate Calculator, or in connection with
   102




Prod6       Selected product
        6            1
Concatenated - no initial
0%p.a
0%p.a
6.5%p.a
6.65%p.a




          Closing Fee
                    APR
Ongoing Fee Frequency
        1       295 ###
        1       295 ###
        1       295 ###
        1       295 ###
        3       195 ###
        1       300 ###
Ongoing Fee Frequency Droplist

Monthly

Quarterly
Half Yearly
Yearly


Ongoing Fee Frequency
Prod1         Prod2       Prod3       Prod4       Prod5       Prod6
          1           1           1           1           3           1
1
                Interstar Comparison Rate Calculator

                                                    Help                     Products & Setup         Calculator/ Schedule



Products & Setup Help
The Interstar Comparison Rate Calculator has been designed to help you calculate Comparison Rates and Comparison
Rate Schedules for your Interstar loan products

Before using the calculator you need to setup your loan products in the Products and Setup page.
The first four products are the Interstar Premium, Premium Deluxe, Premium StarStart and the Premium Deluxe
StarStart. The last two can be used for other funder products if you so choose.

Product Setup
For each product (you can enter up to six per schedule) the following steps are required:
       1) Enter the retail name of your loan product in the box labeled "Originator Description" - e.g. "Everyday
          Professional Package".
       2) Enter the initial loan term if applicable (e.g. 6 months for a honeymoon period)
       3) Enter the Initial borrower rate if applicable (e.g. 4.5% for 6 months)
       4) Enter the ongoing loan term. This will be the entire term of the loan if there is no initial term.
       5) Enter the ongoing borrower rate. (e.g. 7% for life of the loan).
       6) Enter the Upfront costs (inc application, brokerage etc.)
       7) Enter any applicable Valuation Costs (ISA suggests $250 for standard transactions)
       8) Enter any applicable Legal Costs (ISA suggests $685 being $434.30 plus $250 discharge costs)
       9) Enter any other ongoing costs and select there frequency from the drop down menu

Once you have completed all six products enter your company details

Originator Details setup:
       1) Enter the originator company name e.g. ABC Mortgages Pty Ltd
       2) Enter the street address
       3) Enter the ABN number of your company

Once completed, return to the calculator page


Using the Calculator / Producing Schedules

From the Calculator page, you can either display a Comparison rate based upon an specified loan amount or display
the schedule of 6 products in accordance with legislation

Using the Calculator for any loan amount
                 1) Enter the Loan Amount in the space provided
                 2) Select a product from the drop down list. Please note that the product you select references the
                    information that you have setup in the product setup page.
                 3) Once you have done steps 1) and 2) the Comparison Rate will be displayed

The comparison rate uses the information that you have entered as part of the product setup page. Please note that
the product page must be setup correctly in order to display the correct Comparison Rate and if you have not entered all
of the applicable information, this can cause the rate to come out incorrectly. The Rate is determined by legislative
formula as set out in the applicable legislation introduced as at 1 July 2003.

Displaying the Product Schedule and Printing

The Schedule allows you to comply with legislation and will permit up 6 products to be printed. In order to print the
Comparison Rate schedule, the following steps need to be followed:
                   1) Select each product from the drop down menu's provided.
                   2) Press the button labeled Print (which is located underneath the product selection).

The print function will use your computers default printer to print out the Comparison Rate Schedule with required
legislative amounts.

The comparison rate uses the information that you have entered as part of the product setup page. Please note that
the product page must be setup correctly in order to display the correct Comparison Rate and if you have not entered all
of the applicable information, this can cause the rate to come out incorrectly. The Rate is determined by legislative
formula as set out in the applicable legislation introduced as at 1 July 2003.

Personalising the Calculator

The heading (Interstar Comparison Rate Calculator) on all 3 sheets is editable. You are able to personalise it to your
needs. Simply double-click on any part of the heading to begin editing it.
ator

     Calculator/ Schedule




n Rates and Comparison



Premium Deluxe




 - e.g. "Everyday




oan amount or display




u select references the



age. Please note that
f you have not entered all
 mined by legislative




In order to print the
edule with required


age. Please note that
f you have not entered all
 mined by legislative




o personalise it to your

								
To top