{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calculator","Definitions","Instructions","BackEnd"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[8,1,9,7],[36,1,43,7]]}
[]
[]
[]
[]
[]
[null,"SMSF Refinance Prime Serviceability Calculator",null,null,null,null,"Date:",{"$f":"NOW()","v":"2024-04-11T09:52:46.650"}]
[null,null,null,null,null,null,"User:","Jean Toh"]
[{"$f":"MAX(A9:A31)","v":1},"Applicant Name(s):"]
[{"$f":"IF(B9=\"\",1,0)","v":1},null,null,null,null,null,null,null,{"$f":"IF(B9=\"\",\"**\",\"\")","v":"**"}]
[]
[]
[null,"Loan Details:"]
[{"$f":"IF(H13=\"\",1,0)","v":1},"Security Type",null,null,null,null,null,null,{"$f":"IF(H13=\"\",\"**\",\"\")","v":"**"},{"$f":"OR(H13=\"\",H14=\"\",H15=\"\",H18=\"\",H20=\"\",H23=\"\",H30=\"\")","v":true}]
[{"$f":"IF(H14=\"\",1,0)","v":1},"Enter Loan Amount",null,null,null,null,null,null,{"$f":"IF(H14=\"\",\"**\",\"\")","v":"**"}]
[{"$f":"IF(H15=\"\",1,0)","v":1},"Security Value",null,null,null,null,null,null,{"$f":"IF(H15=\"\",\"**\",\"\")","v":"**"}]
[null,"Loan LVR",null,null,null,null,null,{"$f":"IF(ISERROR(H14/H15),0,H14/H15)","v":0}]
[null,"Repayment Type",null,null,null,null,null,{"$f":"IF(H18=0,\"\",IF(H18>H19,\"Principal & Interest\",\"Interest Only\"))","v":""}]
[{"$f":"IF(H18=\"\",1,0)","v":1},"Loan Term",null,null,null,null,null,null,{"$f":"IF(H18=\"\",\"**\",\"\")","v":"**"}]
[null,"Interest Only Term"]
[{"$f":"IF(H20=\"\",1,0)","v":1},"Interest Rate",null,null,null,null,null,null,{"$f":"IF(H20=\"\",\"**\",\"\")","v":"**"}]
[]
[null,"Current Loan:"]
[{"$f":"IF(H23=\"\",1,0)","v":1},"Monthly Loan Repayment/s",null,null,null,null,{"$f":"IF(H23=\"\",\"**\",\"\")","v":"**"}]
[null,"Annual Loan Repayment/s",null,null,null,null,null,{"$f":"IF(ISERROR(H23*12),0,H23*12+(H23*12)*20%)","v":0}]
[]
[null,"New Loan:"]
[null,"Monthly Loan Repayment/s",null,null,null,null,null,{"$f":"IF(H17=\"Principal & Interest\",-PMT(H20/12,(H18-H19)*12,H14,0,0)+15,IF(H17=\"Interest Only\",(H14*H20)/12+15,0))","v":0}]
[null,"Annual Loan Repayment/s",null,null,null,null,null,{"$f":"IF(ISERROR(H27*12),0,H27*12)","v":0}]
[]
[{"$f":"IF(H30=\"\",1,0)","v":1},"Monthly Gross Rental Income",null,null,null,null,null,null,{"$f":"IF(H30=\"\",\"**\",\"\")","v":"**"}]
[null,"Annual Gross Rental Income",null,null,null,null,null,{"$f":"IF(ISERROR(H30*12),0,H30*12)","v":0}]
[null,"**  ---  Denotes mandadory fields"]
[]
[null,"Result - Must Exceed 1.00",null,null,null,null,null,0]
[null,"Express Refinance NSI",null,null,null,null,null,{"$f":"H30-H27","v":0}]

{"sheet":"Definitions","index":1,"n_rows":48,"n_cols":2,"rows_kept":48,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Definitions"]
["Definitions"]
[]
["Household Numer","The household group that an individual applicant is attached to."]
[]
["Status","Individual applicants household status (single or couple)"]
[]
["Dependents","Number of children or other dependents of an individual applicant. Dependents includes adult children over 18 if they rely on parents to cover living costs. Dependents also includes dependent children or other parties over 18 such as children with disabilities."]
[]
["Gross Taxable Income","Yearly cash component of salary before tax. (Taxable income).  To be entered by you."]
[]
["Non-Taxable Income","Non taxable income of the applicant.  This is generally pension or governement benefit income that is not taxable."]
[]
["Annual Rental Income","Annual Rental Income received from investment properties (include income from property being purchased if a tenancy agreement is held and can be provided).  The calculator will use 80% of the amount entered adjusted for the relevant tax rate."]
[]
["Monthly Interest Expense (for gearing prurposes only)","The interest expense for investment property where a tax deduction is able to be claimed. This amount is to be allocated to the relevant applicant. The interest expense must not include any principal amount that forms part of the loan payment."]
[]
["Net Monthly Income","Monthly cash component of salary after tax.  Automatically calculated."]
[]
["Company Net Profit Before Tax","Yearly cash component of salary after expenses before tax. (Taxable income).  "]
[]
["Company addbacks","Non-taxable addbacks for the company such as depreciation and interest payments on loans included in servicing assessment."]
[]
["Living Allowance","Refer to application form for details of each category.  Full details must be entered for each household group."]
[]
["Credit Card (Limit not Debt)","We need to take the full credit card limit into account when calculating serviceability.  We will use 3.8% of the total limit, regardless of the debt outstanding."]
[]
["Existing Commitments","Existing debt commitments of the applicant. Full available loan limits must be entered as well as payments based on the full limit."]
[]
["Sensitivity","An annual percentage rate applied to the total balances of outstanding loans as a precaution against any future interest rate increases.  Currently 2.0%p.a. with 5.3% floor assessment rate."]
[]
["Loan Term","Loan term of loan application in years."]
[]
["Interest Only Term","Interest only term applicable to the applied loan"]
[]
["New Loan Amount","Loan amount as per the application"]
[]
["Interest rate","Applicable interest rate for the product"]
[]
["New Monthly Loan Repayments","This is the monthly loan repayment of the proposed loan.  It is a principal and interest repayment.  For interest only repayment calculations please refer to us."]
[]
["Result - Net Surplus","This is the remaining amount of the borrowers available monthly income after living expenses, existing commitments and the proposed commitment are deducted.  This amount must be positive to succesfully pass the Serviceability Calculator.  Please refer your scenario to usif the loan does not pass the Serviceability Calculator."]
[]
["SMSF Contributions","Annual superannuation contributuons for the applicant."]
[]
["Annual Management Fee","Annual management fee applicible for the SMSF. This includes accountants fees, auditor fees, compliance expenses etc. Costs incurred in the generation of income are excluded from this amount as this is incorporated into the return on SMSF Assets."]
[]
["SMSF Assets","This is the amount of the Self Managed Super Fund's Assets excluding the security for the loan.  This is only applicable to SMSF loans.  (We assume an investment return of 3.9% per annum taxed at the current Tax Rate for Superannuation income).  "]

{"sheet":"Instructions","index":2,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[22,1,22,4],[23,0,24,4],[0,0,0,4],[1,0,3,4],[5,0,8,4],[15,1,15,4],[17,1,18,4],[20,1,21,4]]}
["Mortgage Mart SMSF Refinance Prime Instructions"]
["Welcome to our Mortgage Mart SMSF Refinance Calculator.  The Calculator has been developed utilising  current guidelines and attempts to provide Mortgage Mart Refinance Borrowing Capacity."]
[]
[]
[]
["The calculator is available only for Corporate Trustee facilites and requires the rental return on an individual security coverage ratio over the particular asset.  Should your clients return a result greater than 1.00%, the proposal may proceed."]
[]
[]
[]
[]
["Introduction"]
["Serviceability Calculator"]
[]
["How to use the Calculator"]
[]
["Step 1","Enter the Borrowers name in the box provided, the date should pre-fill to todays date for you."]
[]
["Step 2","Enter the proposed loan amount, interest rate and loan term.   Please note, the product offers is only available for Interest Only facilities."]
[]
[]
["Step 3","Enter the rental income available for the property as evidenced by 12 months rental history from either Rental Statements and/or Rental Credits to Bank Statements no older than 60 days from approval."]

{"sheet":"BackEnd","index":3,"n_rows":107,"n_cols":17,"rows_kept":107,"cut":false,"hidden":true,"merged":[]}
["Security Type","Repayment Type",null,"Security Type","Min Loan Amount","Max Loan Amount","LVR",null,"Data Test"]
["Residential","Principal & Interest",null,"Residential",150000,1500000,0.7,null,{"$f":"OR(Calculator!H13=\"\",Calculator!H14=\"\",Calculator!H15=\"\")","v":true}]
["Commercial","Interest Only",null,"Commercial",150000,2000000,0.7]
[]
[]
[null,"Current User:","Jean Toh",null,null,null,null,null,null,null,null,null,null,null,null,"Allowed Users To Edit",{"$f":"IF(ISERROR(VLOOKUP(C6,P7:P50,1,0)),\"Not Found!\",VLOOKUP(C6,P7:P50,1,0))","v":"Not Found!"}]
[null,"---- You may enter policies after this row up to maximum designated line. Make sure to enter on Column B only.  This will be hidden once you leave the sheet. ---"]
[1,"Refinance Policy (with minimum 2 years clean repayment history)"]
[{"$f":"A8+1","v":2}]
[{"$f":"A9+1","v":3},"\nAnnual rental exceeds annual loan repayment to validate serviceability"]
[4,"     - Max LVR 70%"]
[5,"     - 100% of rental income can be used for servicing purposes (evidenced by 12 months rental history from either rental statements and/or rental credits to bank statements)"]
[6,"     - 2 years clean repayment history (evidenced by loan statements. Interenet transactions statement must be supported by formal Bank statements)"]
[7,"     - New loan repayment must be less than the current repayment.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kailun (Ivan) Huang"]
[8,"     - Other income cannot be used to support for this method. "]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[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]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"A73+1","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]