MAXIS_CAT by zhangyun

VIEWS: 15 PAGES: 103

									Maxis Loans                                                                                                                                             5/25/2011 5:21 PM




                                                                                                                                       version 3.0
                                                          May 25, 2011    SERVICEABILITY ASSESSMENT WORKSHEET                       updated Nov 30th,
                                                                                                                                          2010

                     LOAN PAYMENT CALCULATION                                                   APPLICANT 1
                                                                         GROSS INCOME                         COMMITMENTS
              Loan amount                      *                         Base salary                          Personal loan
              Loan term (yrs)                            30.0            Other income                         Other commitments
              Product type         Ratesaver Home Loan                   Other income                         Other loans
              Interest rate option                 Variable              Tax-free income                      Credit card limit
              Interest rate                              8.10%           Rental income
              Payment frequency                    Mth

              Payment amount                                                                                  Does applicant 1 have a HECS debt?
                                                         $0.00                                            * Is applicant 1 married?
              Total payment                              $0.00                                                Dependants applicant 1



                                                                                                APPLICANT 2

                       Total Applicants                                  GROSS INCOME                         COMMITMENTS
                              TAS or NT Loan?                            Base Salary                          Personal Loan
                              FHOG as deposit?                           Other income                         Other loans
                                                                         Other income                         Other commitments
                              ASSESSMENT RESULT                          Tax-free income                      Credit card limit
              Net Adjusted Monthly Income                $0.00           Rental income
              Net Commitments                            $0.00
              Net Expenses                               $0.00                                                Does applicant 2 have a HECS debt?
              Net Disposable Income (NDI)                $0.00                                                Is applicant 2 married?
              Repayments - with 1.5% Buffer              $0.00                                                Dependants applicant 2
              Assessment result
              Maximum Amount
Maxis Loans                                                                       5/25/2011 5:21 PM




                        SPLIT LOAN WORKSHEET

              Total loan amount              $0


                                         Facility 1            Facility 2
                                            30
                    Loan Amount                                    $0

                       Term (yrs)           30.0                  30.0

                    Product Type      Ratesaver Home Loan
                                              1                            Loan
                                                            Ratesaver Home 1

              Interest Rate Option    Variable 1            Variable        1

                      Interest rate         6.54%                 7.29%

              Payment Frequency       F/N     3             F/N

                Payment Amount



                  Total Payment
Maxis Loans                                                                                  5/25/2011 5:21 PM




                                ADDITIONAL APPLICANTS WORKSHEET
                                          APPLICANT 3

              GROSS INCOME                              COMMITMENTS
              Base salary                               Personal loan
              Other income                              Other commitments
                                   #
              Other income                              Other loans
              Tax-free income                           Credit card limit
              Rental income


                                                        Does applicant 3 have a HECS debt?
                                                        Is applicant 3 married?
                                                        Dependants applicant 3

                                          APPLICANT 4

              GROSS INCOME                              COMMITMENTS
              Base Salary                               Personal Loan
              Other income                              Other loans
              Other income                              Other commitments
              Tax-free income                           Credit card limit
              Rental income


                                                        Does applicant 4 have a HECS debt?
                                                        Is applicant 4 married?
                                                        Dependants applicant 4
        ADDITIONAL INFORMATION
                                             Minimum
            Rate        Total interest       Payment
                                              (mth)
Maxis       8.10%            $0                $0.00

Other                        $0                $0.00


                                         0
                                         0   0.0   0
                                         0         $0

                    0
                                            LOAN STATUS CHECK
                                                                                             Loan Amount
       Enter regular payment amount                                                                 Rate
                                                                                                    Term
                 Enter date to check    23-May-18


                      Total payments      Total interest    Total principal      Balance     Interest paid
Year    Year ending
                                              paid              repaid         outstanding      in year
 0       0-Jan-00            $0                 $0                 $0               $0             $0


                Note: This data assumes that the above interest rate remains constant over the full term.
                             $0
                           8.10%
                            30.0


                          Available
                           redraw
                            $0.00


ant over the full term.
Maxis Loans                      5/25/2011 5:21 PM




              ASSESSMENT NOTES
Administration options
Maxis CAT 2 - Update interest rates

    Please select the rates you wish to
    update from the list below


           Maxis Loans Variable rate
                                           OK
           Maxis Loans Fixed rates

           Money Manager                  Cancel
                         GENWORTH Calculator
                                     $ p.a.
Total Net Income
Applicant living costs
NDI
Proposed annual loan payments
Other commitments


Total costs



NDI RATIO:                                    0.00
MAXIMUM LOAN AMOUNT:                  $0
     A                    B                C          D             E                 F              G               H           I          J             K             L         M           N        O      P   Q   R
1                 Income Assessment
2
3                 Code Tables
4                 Income Type                                                   Other Income
                                                     % for                                        % for
5                 Code              Description   Assessment Code               Description    Assessment
6                               1   Full-time            100%               1   Full-time            100%
7                               2   Part-Time            100%               2   Part-Time            100%
8                               3   Self-empl            100%               3   Self-empl            100%
9                               4   Casual               100%               4   Casual               100%
10                                                                          5   Overtime             100%
11                                                                          6   Superannuation       100%
12                                                                          7   Commission           100%
13                                                                          8   Investment             50%
14                Red = Regular Monthly Income                             11   rental                 80%
15                                                                         12   tax free             100%
16
17
18
19                Gross Taxable Income
20
21                App 1
                                                                                              Monthly            Annual AGI
                                                                                    % for     Adjusted            (used in
22                 Income Type        Frequency    Amount        Monthly         Assessment Gross Income         GEMIS calc)
23                      0                 0                 $0                      #N/A            $0.00
24                      0                 0                 $0                      #N/A            $0.00
25                      0                 0                 $0                      #N/A            $0.00
26   tax-free           12                0                 $0          $0.00           100%        $0.00
27                                                                      $0.00                       $0.00                $0.00       Investment loan     freq          amt     mthly amt   adjusted
28                                                                                                                                   Expected rental       0           $0       $0.00       $0.00
29       rental           11               0                $0          $0.00             80%            $0.00           $0.00                             0
                                                                                                                                     Investment loan payments         $0.00     $0.00       $0.00
30                                                                                                                                   Taxable amount                                         $0.00
31                                                                                                                                   Untaxable amount                                       $0.00
32
33                App 2
                                                                                              Monthly
                                                                                    % for     Adjusted
34                 Income Type        Frequency    Amount        Monthly         Assessment Gross Income
35                      0                 0                 $0                      #N/A            $0.00                                                Annual gross rental               % for Assessment
36                      0                 0                 $0                      #N/A            $0.00                                                   App1       $0.00                     0.8
37                      0                 0                 $0                      #N/A            $0.00                                                   App2       $0.00
38   tax-free           12                0                 $0          $0.00           100%        $0.00                                                   App3       $0.00
39                                                                      $0.00                       $0.00                $0.00                              App4       $0.00
40
41       rental           11               0                $0          $0.00             80%            $0.00           $0.00
42
43
44
45                App 3
                                                                                                  Monthly
                                                                                    % for         Adjusted
46                 Income Type        Frequency    Amount        Monthly         Assessment     Gross Income
47                      0                 0                 $0                      #N/A                $0.00
48                      0                 0                 $0                      #N/A                $0.00
49                      0                 0                 $0                      #N/A                $0.00
      A                    B              C              D               E               F             G            H               I               J                 K               L           M          N         O         P        Q   R
50                         12             0                     $0           $0.00           100%          $0.00
51                                                                           $0.00                         $0.00        $0.00
52
53        rental           11              0                    $0           $0.00             80%         $0.00        $0.00
54
55
56
57                 App 4
                                                                                                  Monthly
                                                                                        % for     Adjusted
58                  Income Type        Frequency       Amount         Monthly        Assessment Gross Income
59                       0                 0                    $0                      #N/A            $0.00
60                       0                 0                    $0                      #N/A            $0.00
61                       0                 0                    $0                      #N/A            $0.00
62                       12                0                    $0           $0.00          100%        $0.00
63                                                                           $0.00                      $0.00           $0.00
64
65        rental           11              0                    $0           $0.00             80%         $0.00        $0.00
66
67
68
69
70                 Subtotals
71                 # of applicants 0
72                                                                                     App 1         App 2         App 3          App 4                         # of applicants
73             Adjusted Gross Monthly Income                                               $0.00        $0.00          $0.00         $0.00                             0
74             Adjusted Gross Annual Income                                                $0.00        $0.00          $0.00         $0.00
75        Less Tax payable                                                                 $0.00        $0.00          $0.00         $0.00              $0.00             $0.00           $0.00   $0.00
76             HECS liability                                                              $0.00        $0.00          $0.00         $0.00              $0.00             $0.00           $0.00   $0.00
77             Adjusted Net Annual Income                                                  $0.00        $0.00          $0.00         $0.00
78             Adjusted Net Monthly Income                                                 $0.00        $0.00          $0.00         $0.00
79        Plus Monthly Tax-free Income                                                     $0.00        $0.00          $0.00         $0.00
80             Monthly Rental income                                                       $0.00        $0.00          $0.00         $0.00
81
82
83
84                 Total adjusted net monthly income                                         $0.00         $0.00        $0.00           $0.00
85
86
87
88                 Net Income Conversion
89                                                                                                                                App 1           App 2             App 3           App 4
90                 Adjusted Gross Annual Income                                                                                      $0.00            $0.00            $0.00           $0.00
91
92                 Less Tax                                                                                                                                                                                     GEMIS
93                                       Min.            Max.           Tax                            Tax                      Net Income      Net Income       Net Income       Net Income Net Income Net Income Net IncomeNet Income
94                 Income is :                 $0         $6,000          $0.00         plus          0.00%                             $0               $0               $0               $0        $0         $0        $0        $0
95                 Income is :             $6,001        $37,000          $0.00         plus         15.00%                             $0               $0               $0               $0        $0         $0        $0        $0
96                 Income is :            $37,001        $80,000      $4,650.00         plus         30.00%                             $0               $0               $0               $0        $0         $0        $0        $0
97                 Income is :            $80,001       $180,000     $17,550.00         plus         37.00%                             $0               $0               $0               $0        $0         $0        $0        $0
98                 Income is :           $180,001      No max.       $54,550.00         plus         45.00%                             $0               $0               $0               $0        $0         $0        $0        $0
99                 Medicare :                                                                         1.50%                             $0               $0               $0               $0        $0         $0        $0        $0
100                Total Tax Payable :                                                                                                  $0               $0               $0               $0        $0         $0        $0        $0
101
102                Less HELP (previously HECS)                                                                                    App 1           App 2            App 3            App 4
103                                     Min.            Max.          % rate                                                    Net Income      Net Income       Net Income       Net Income
         A            B               C             D             E       F           G         H            I                J         K              L                 M     N    O          P         Q       R
104             Income is:                 $0       $44,191     0.0%                                               $0              $0       $0               $0
105                                   $44,192       $50,028     4.0%                                               $0              $0       $0               $0
106                                   $50,029       $55,143     4.5%                                               $0              $0       $0               $0
107                                   $55,144       $58,041     5.0%                                               $0              $0       $0               $0
108                                   $58,042       $62,390     5.5%                                               $0              $0       $0               $0
109                                   $62,391       $67,570     6.0%                                               $0              $0       $0               $0
110                                   $67,571       $71,126     6.5%                                               $0              $0       $0               $0
111                                   $71,127       $78,273     7.0%                                               $0              $0       $0               $0
112                                   $78,274       $83,407     7.5%                                               $0              $0       $0               $0
113                                   $83,408       No max.     8.0%                                               $0              $0       $0               $0
114             Total HECS payable:                                                                                $0              $0       $0               $0
115
116
117             Commitments
118
119
120                                                                    Monthly
121       App 1 Personal Loan              0               $0
122             Card Limit                                 $0                 $0.00       Card commitments assessed at
123             Other comm                 0               $0                                        3%
124             Other loans                0               $0                                    of limit
125                                                                           $0.00
126
127       App 2 Personal Loan              0               $0
128             Card Limit                                 $0                 $0.00
129             Other loans                0               $0
130             Other loans                0               $0
131                                                                           $0.00
132
133       App 3 Personal Loan              0               $0
134             Card Limit                                 $0                 $0.00
135             Other loans                0               $0
136             Other loans                0               $0
137                                                                           $0.00
138
139       App 4 Personal Loan              0               $0
140             Card Limit                                 $0                 $0.00
141             Other loans                0               $0
142             Other loans                0               $0
143                                                                           $0.00
144
145             Total Commitments                                             $0.00       GEMIS total            $0.00
146
147
148             Living Expenses
149
150 Loans <300k
151             Dependants No. Dependants $     Living Exp $            Total
152       App 1         0            $0.00          $0.00               $0.00                                                                                                        Living Exp. Code table
153       App 2         0            $0.00                              $0.00             GEMIS Guidelines p.a.             p.m.                 M.E. Guidelines                   Code        ME       GEMIS
154       App 3         0            $0.00         $0.00                $0.00             >300K              $               $                   <300K               p.m.           1        $0.00        $0
155       App 4         0            $0.00                              $0.00             Living Together?                                                                          2      $1,710.00 $1,702
156                                                                                       No               14050         1170.833333             One app           $1,175.00        3           0         $0
157             Total Living Expenses <300k                             $0.00             Yes              20426         1702.166667             Joint app         $1,710.00        4         error      error
158                                                                                                                                                                                 5         error      error
159                                                                                                         p.a.            p.m.                 Dependants       Cost              6      $2,350.00 $2,342
         A             B               C           D       E    F      G        H                  I            J      K   L           M        N   O        P         Q      R
160 Loans >300k                                                            Dependants       Cost                                0       $0.00       7    $1,175.00   $1,171
161             Dependants No. Dependants $   Living Exp       Total                    0                 0     0               1     $418.00       8      $0.00       $0
162       App 1         0            $0.00       $0.00         $0.00                    1              5247   437.25            2     $730.00       9      error      error
163       App 2         0            $0.00                     $0.00                                                            3   $1,000.00       10       0         $0
164       App 3         0            $0.00       $0.00         $0.00                                                            4   $1,270.00       11   $2,885.00   $2,873
165       App 4         0            $0.00                     $0.00                                                            5   $1,540.00       12   $1,710.00   $1,702
166                                                                                                                             6   $1,810.00       13       0         $0
167             Total Living Expenses >300k                    $0.00                                                            7   $2,080.00       14       0         $0
168                                                                                                                             8   $2,350.00       15       0         $0
169                                                                            p.a.                                             9   $2,620.00       16   $3,420.00   $3,404
170             Total Expenses + Commitments <300k             $0.00          $0.00                                            10   $2,890.00
171             Total Expenses + Commitments >300k             $0.00          $0.00
172
173
174             TOTAL NDI
175
176
177             TOTAL NET DISPOSABLE INCOME <300k              $0.00          $0.00
178             TOTAL NET DISPOSABLE INCOME >300k              $0.00          $0.00
179
180
181
     S   T   U   V   W   X   Y   Z   AA   AB   AC   AD   AE       AF
1
2
3
4

5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21


22
23
24                                                            1        1
25
26
27
28
29
30
31
32
33


34
35
36
37
38
39
40
41
42
43
44
45



46
47
48
49
Calculation Tables
                                  SCENARIOS
In Assessment Worksheet
MAXIMUM LOAN AMOUNT <300k
Rate                    9.60%
Term                        30                     INTEREST RATE BUFFER
Repayments               $0.00                            1.50% Buffer Margin
Amount                      $0
                                     term
                                      30
MAXIMUM LOAN AMOUNT >300k
Rate               9.60%
Term                   30                          INTEREST RATE BUFFER
Repayments          $0.00                                 1.50% Buffer Margin
Amount                 $0


Loan 1                                             Loan 1
Rate                     9.60%                              9.6000% Variable with
Term                         30                             0.0000% Fixed Rate
Repayments                $0.00                                9.60% Buffer rate
Amount                       $0

Loan 2                                             Loan 2
Rate                     9.60%                              9.6000% Variable with
Term                         30                             0.0000% Fixed Rate
Repayments                $0.00                                9.60% Buffer rate
Amount                       $0

Repayments Loan 1 & 2                      $0.00




Worksheet Calculations                                                               IF(OR(D55=5,D55=6),D44*D48*(1/D50)

Assessment
Worksheet                         Loan Repayments


                                                       Split 1           Split 2                 Investment
Repayment Frequency                   2                   3                 3                         0
                                  Monthly            Fortnightly       Fortnightly
Loan Amount                          $0                  $0                $0                       $0
No of Repayments                    360                  782               782                       0
Fixed Rate Term                       0                   0                 0                        0
No of Fixed Rate Repayments           0                   0                 0                        0
Starting Interest Rate             8.10%                #N/A              #N/A                    8.10%
Variable Rate                      8.10%                error            8.10%                    8.10%
Number of repayments per year        12             26.07142857       26.07142857                 FALSE
Debt at end of Fixed rate Period   $0.00               $0.00             $0.00                     $0.00
Minimum Loan repayment - Fixed     $0.00               $0.00             $0.00                     $0.00
Minimum Loan repayment - variable  $0.00              #VALUE!            $0.00                    #DIV/0!

Loan type                              1                    1              1




GEMIS


Repayment Frequency                           2                                              Repayment Frequency
                                    Monthly
Loan Amount                                  $0                                              Loan Amount
No of Repayments                            360                                              No of Repayments
Fixed Rate Term                               0                                              Fixed Rate Term
No of Fixed Rate Repayments                   0                                              No of Fixed Rate Repayments
Starting Interest Rate              8.10%    Starting Interest Rate
Variable Rate                       8.10%    Variable Rate
Number of repayments per year           12   Number of repayments per year
Debt at end of Fixed rate Period     $0.00   Debt at end of Fixed rate Period
Minimum Loan repayment - Fixed       $0.00   Minimum Loan repayment - Fixed
Minimum Loan repayment - variable    $0.00   Minimum Loan repayment - variable




Total interest       $0.00                   Total interest
                       Interest Rate Floor Interest Rate Floor
                                     7.40% Interest Rate Floor




                       MAXIMUM LOAN AMOUNT (GEMIS)
                       Rate                    8.88%
                       Term                        30
                       Repayments               $0.00                       $0.00 p.m.
                       Amount                      $0




OR(D55=5,D55=6),D44*D48*(1/D50)




                                                                          Product mix table
                                                                     2                     OK
                                                                     3                    error
                                                                     4                     OK
                                                                     5                    error
                                                                     6                     OK
                                                                     7                    error
                                                                     8                     OK
                                                                     9                    error
                                                                     10                    OK
                                                                     11                   error
                                                                     12                    OK




                       Loan Repayments Competition


     Repayment Frequency                                         2
                                                 Monthly
                                                            $0
                                                           360
                                                             0
     No of Fixed Rate Repayments                             0
Starting Interest Rate              0.00%
                                    0.00%
Number of repayments per year           12
Debt at end of Fixed rate Period     $0.00
Minimum Loan repayment - Fixed       $0.00
Minimum Loan repayment - variable    $0.00




                          $0.00
                  Loan Repayments M.E. 2


Repayment Frequency                                 2              2
                                       Monthly          Monthly
Loan Amount                                        $0             $0
No of Repayments                           #NUM!        #DIV/0!
Fixed Rate Term                                     0              0
No of Fixed Rate Repayments                         0              0
Starting Interest Rate              8.10%    8.10%
Variable Rate                       8.10%    8.10%
Number of repayments per year           12       12
Debt at end of Fixed rate Period     $0.00    $0.00
Minimum Loan repayment - Fixed       $0.00    $0.00
Minimum Loan repayment - variable    $0.00    $0.00




Total interest           #NUM!
Totals (Wk)
              1304
$0.00   $0.00
Interest Rate Tables                                     Drop Down Menus
                                    Code                         4           4                 4        3
                                                         INTERES      LOAN       REPAYMENT PROPERTY
Rate Saver     Variable                     11   0.081    T TYPE      TYPE       FREQUENCY STATUS
               Fixed 1 yr                   12   0.087   Variable Ratesaver Home Loan  Yr      Owner-occupied
               Fixed 3 yr                   13   0.093                                Mth      Investment
                                                         Fixed 1 yr Money Manager Offset Account
               Fixed 5 yr                   14   0.097                                F/N      Combination
                                                         Fixed 3 yr Interest Only Investment Loan
Money Manager Variable                      21   0.084   Fixed 5 yr                   Wk
               Fixed 1 yr                   22   0.087
               Fixed 3 yr                   23   0.093
               Fixed 5 yr                   24   0.097                           Yearly
Maxis Int Only Variable                     31   0.081                           Monthly
               Fixed 1 yr                   32   0.087                           Fortnightly
               Fixed 3 yr                   33   0.093                           Weekly
               Fixed 5 yr                   34   0.097




  Rate entered    Conversion       final rate
   674.00%          0.0674           0.0674                            0.0679




                   Maxis v         TRUE
                   Maxis f         TRUE
                   MM              FALSE




                   Cancel?




                                        $1.00




Interest rate updater via button
         2         3            3     No. OF 4           4          8           8           2
APPLICATION     LIVE  MARITAL       DEPENDANT    EMPLOY      OTHER                    APPL
      TYPE  TOGETHER STATUS             S        MENT        INCOME STATE             TYPE     MARITAL STATUS
Single      Yes      Single         1            Full-time   Full-time    VIC       Purchase Yes, to Applicant 2
Joint       No       Married        2            Part-Time   Part-Time    NSW       Refinance Yes, to other
                     De Facto       3            Self-empl   Self-empl    QLD                 No
                                    4            Casual      Casual       TAS
                                                             Overtime      SA                   Yes, to Applicant 1
                                                                          WA
                                                             Superannuation                     Yes, to other
                                                             Commission ACT                     No
                                                             Investment    NT
                                                                                                Yes, to Applicant 4
                                                                                                Yes, to other
                                                                                                No

                                                                                                Yes, to Applicant 3
                                                                                                Yes, to other
                                                                                                No
               0.0669
 DATE
25-May-11
24-May-12
24-May-13
24-May-14
24-May-15
23-May-16
23-May-17
23-May-18
23-May-19
22-May-20
22-May-21
22-May-22
22-May-23
21-May-24
21-May-25
21-May-26
21-May-27
20-May-28
20-May-29
20-May-30
20-May-31
19-May-32
19-May-33
19-May-34
19-May-35
18-May-36
18-May-37
18-May-38
18-May-39
17-May-40
17-May-41

								
To top