Filetype Excel XLSX | Posted on 16 Aug 2022 | 3 years ago
Authentication
digital resources
205x Filetype XLSX File size 0.15 MB Source: www.thinktank.net.au
Thinktank Commercial Loan - ICR & DSCR Calculator Prepared For: Enter client name
1 enter annual income details 2 enter loan details
Enter data into white shaded cells Floor
BUSINESS INCOME (Company, Trust, Self Employed) PROPOSED LOAN Select Stress
Net Profit Before Tax Type of Loan (Full / Mid / Quick / SMSF) Interest Rate Term (yrs) IO Period
Plus Add Backs Thinktank Loan Amount
Rent Paid OTHER CURRENT LOANS & COMMITMENTS
Interest Paid Select Loan Type Amount/Limit Interest Rate Term Remaining (yrs) Min Payment pm
Depreciation & Amortisation 1
Directors' Salaries/Fees 2
Directors' Super Contributions 3
Other (Detail) 4
Other (Detail) 5
Total Add Backs $0 6
Gross Business Income $0 7
8
PERSONAL & OTHER AVILABLE INCOME 9
Individual/Personal Income - 1 10
Individual/Personal Income - 2 11
Investment Income (May be subject to discount) 12 Credit cards (Total limits) ICR assessed at 20% pa and DSCR at 3.9% per month of limit
Investment Income (May be subject to discount)
Gross Rental Income (Property Being Purchased) * Total of All Loans $0
Gross Rental Income (Other Properties) * Total Interest Payable $0
Other (Detail)
Total Personal & Other Available Income $0 THINKTANK SERVICEABILITY ASSESSMENT RESULT
Total Business, Personal & Other Income $0
* Gross Rental Income is discounted to 80% Interest Cover (ICR) * 0.00
Debt Service Cover (DSCR) ** 0.00
Result of Serviceability Test
* Minimum ICR ≥1.7x for Full Doc & SMSF - 1.9x for Mid Doc - 2.0x for Quick Doc.
Important Note - Please note that this ICR & DSCR calculator is for indicative purposes only and should ** Minimum stressed DSCR >1.1x for all loans.
not be relied upon as constituting approval for the provision of credit. Other factors are taken into account
including available cash surplus for personal living expenses. Indicative Borrowing Capacity
Calculator Updated: 16 April 2021
Calculator Printed: 08/16/2022 @ 15:38:16 Copyright Think Tank Group Pty Ltd
Thinktank SMSF Loan Serviceability Calculator
Date 16-August-2022 3 Impact of Transaction on SMSF Net Assets
SMSF Name Purpose of Loan Purchase Select Purchase or Re-finance
Member 1 Purchase Price 0.00%Yield Property Type
Member 2 Thinktank Loan Amount 0%LVR Loan Interest Rate
Member 3 Equity in Property $0 Loan Term (yrs)
Member 4 Costs to Complete Purchase Interest Only Period
1 Net Assets of SMSF (or assets held in personal Superannuation pre-SMSF) Total SMSF Funds Required $0 Funds required from the SMSF to settle loan
2018 2019 2020
As at Year Ended 30th June Extra/One Off Contributions Insert extra/one off contributions pre-settlement
Cash/Shares Real Property Non-Liquid Total Assets
Current SMSF Assets $0 SMSF Net Assets For Servicing $0 Net income producing assets excluding this property
Loan Amount Interest Rate P&I Term (yrs) Lender
Current Commercial Loans
Current Residential Loans
2 SMSF Profit/(Loss) + Member Contributions + Property Income 4 ICR & DSCR Serviceability Calculation
Member Contributions pa 2018 2019 2020 Income Summary for Serviceability
Member 1 Member Contributions $0 As per most recent year
Member 2 SMSF Profit/(Loss) $0 SMSF net assets excl. property x % Yield + Add-backs
Member 3 Property Income $0 80% of gross rent
Member 4 Less Tax at 15% $0 SMSF Profit + net property income - loan interest x 15%
Total Contributions pa $0 $0 $0 Total Income For Servicing $0
Total of Current Year Contributions (Verifiable) Loan Interest pa $0 Cashflow Surplus $0 pa
SMSF Profit/(Loss) 2018 2019 2020 Interest Only ICR Outcome
Net Profit After Tax (excl. Contributions) ICR (Standard) *
Approx. Investment Return 0.00% 0.00% 0.00% ICR (Stressed)
Deemed Investment Yield pa for Servicing (max 7.5% - min 0%) 3.00% Serviceability Result
Property Lease Income Gross Rent pa 80% for Servicing Principal & Interest DSCR Outcome
Rent per annum Paid to SMSF - Thinktank Loan $0 DSCR (Standard)
Rent per annum Paid to SMSF - Other Lender Loan/s $0 DSCR (Stressed) **
Re-finance or Other SMSF Loans Interest Depreciation/Other Total Add-backs * Unstressed Interest Only ICR calculation must be ³1.70x
Allowable Add-backs (most recent year) $0 ** Stressed Principal & Interest DSCR calculation must be >1.1x
Version 210416 The material in this ICR/DSCR Calculator is intended only for general information and is not advice. It is important that readers seek legal, financial and taxation advice from appropriately qualified and
© Think Tank Group Pty Ltd, 2019 credentialed professionals in relation to their own circumstances or transactions. Think Tank Group Pty Ltd and any related entity will not be liable for any loss or damage arising out of or in
connection with the reliance upon any material in this Serviceability Calculator.
Date Published: 08/16/2022 @ 15:38:16 tt_wale_calculator_210416.xlsx
Thinktank Commercial - Weighted Average Lease Expiry (WALE) Calculator
1 enter property details
Enter data into white shaded cells
PROPERTY DETAILS WALE
Total Lettable Area sqm 0 Area 0.00
Annual Gross Rent Received pa $0 Rent 0.00
TENANCY, INCOME & LEASE DETAILS Remaining Lease
No. Tenant Details Lettable Area % Annual Rent % Term (yrs) Months
1 0.0% 0.0% 0
2 0.0% 0.0% 0
3 0.0% 0.0% 0
4 0.0% 0.0% 0
5 0.0% 0.0% 0
6 0.0% 0.0% 0
7 0.0% 0.0% 0
8 0.0% 0.0% 0
9 0.0% 0.0% 0
10 0.0% 0.0% 0
11 0.0% 0.0% 0
12 0.0% 0.0% 0
13 0.0% 0.0% 0
14 0.0% 0.0% 0
15 0.0% 0.0% 0
0 0% $0 0%
0 $0
Calculator Updated: 16 April 2021
Important Note - Please note that this ICR calculator is for indicative purposes only and
should not be relied upon as constituting approval for the provision of credit. Please provide
Thinktank with all relevant financial information in support of the loan application.
Published on 08/16/2022 at 15:38:16 Copyright (c) Think Tank Group Pty Ltd 2017
Think Tank Commercial Loans - Property Purchase Calculator Prepared For: Enter client name
1 enter loan & up front commission details 2 amount payable upon acceptance of loan offer 3 amount payable at settlement
Enter data into white shaded cells
$ (incl. GST)
Loan Amount Required Think Tank Commitment Fee 0.25% 0 Loan Establishment Fee (incl. GST)
SMSF Loan No (Min $1,000 excl. GST) Introducer Commission 0
No. of Borrowers & Guarantors 1 (incl. GST) Think Tank 0
Property to be Purchased State $ Security Valuation Fee** 0 Less:- Commitment Fee Paid 0
Property Location & Value NSW (may vary according to location & nature of the property) Net Establishment Fee Payable 0
Will GST Apply? (Yes/No) NO 0
Deposit Paid Legal & Title Insurance Costs (incl. GST)
Amount Payable at Settlement 0 Title Insurance Premium *** 0
LVR (Loan to Valuation Ratio) 0.0% Lender Legal Fees (excl. disbursements) ****
No. of Security Properties 1 Settlement Fee (GST free)
Total Legal & Title Insurance Costs 0
For Borrowers Also Selling a Property $
Property Selling Price Stamp Duty & Land Purchase Legal Fees
Will GST Apply? NO 0 Stamp Duty on Land Purchase 0
Selling Agent's Commission 0 Mortgage Stamp Duty on Loan 0
Repay Outstanding Loan Borrower Legal & Lodgement Fees (incl. GST)
Other Payments from Settlement Proceeds Other Charges
Amount Receivable at Settlement 0 Total Stamp Duty & Purchase Legal Fees 0
Establishment Fee & Up Front Commission
Option 1 - 0.95% % (Excluding GST)
Up Front (max 1.0%) 0.60%### 0 (incl. GST) (incl. GST)
Thinktank * 0.35% 0 Amount Payable on Acceptance of Loan $0 µ Amount Payable at Settlement $0 µ
Total Establishment Fee 0.95% 0
Notes BORROWER CASHFLOW SUMMARY
* Think Tank Establishment Fee depends on the Option selected (either 0.15% or 0.35%). If Option 2 is selected, an account fee of $20 pm applies ($10 per split). Property Purchase Price (less Deposit Paid) $0
** Valuation fees are indicative only and may vary depending on the valuer engaged by TT and/or the security location or complexity. Net Sale Proceeds (if applicable) $0
*** Premiums are indicative only, please contact TT on 1300 781 043 for a formal quote. Add $75 for each additional security. Think Tank Loan Funds $0
**** Legal fees are indicative only and do not include disbursements (eg. searches, government duties, lodgement and registration fees, bank and postage fees). Total of Amounts Payable (add Sections 2+3) $0 µ
Disclaimer
The information from this calculator should be used as a guide only. It is not a quote or a pre-approval for a loan. To obtain an approval you must submit a loan Borrower Funds: Surplus / (Funds Required) $0
application to us which we will assess according to our loan approval criteria at the time. The figures and formula used within this calculator may change at any (including GST)
time without notice. Think Tank accepts no responsibility for any losses arising out of the use of or reliance on the conclusions reached by this calculator. Fees Estimated Net GST to be Claimed Back / (Paid) $0
and charges will apply to all loans and will be made available upon application Net Borrower Surplus / (Shortfall) excl. GST $0
Calculator Printed:08/16/2022 @ 15:38:16 Copyright Think Tank Group Pty Ltd
no reviews yet
Please Login to review.
