| Peter R.
Belinfante & Co. Pty. Ltd. |
Queries to : |
ITax
Solutions |
13-Feb-01 |
|
| Chartered
Accountants Tel (02) 9319 2504
Email : belinp@idx.com.au |
|
|
| {Step 1} |
|
Enter Your Name Here |
|
|
| SIMPLE
NEGATIVE GEARING MODEL/ILLISTRATIVE EXAMPLE |
REAL ESTATE |
|
|
Sample Data may be
over-written |
Financial Year : |
|
| {Step 2 Enter Financial Year End} |
|
|
30-Jun-01 |
|
|
|
PROPERTY ACQUISITION BUDGET |
|
| Step 3 Enter Property
Purchase Price |
|
500000 |
|
|
|
|
| Step 4 Check Disbursement
Budget |
Stamp Duty estimate |
17990 |
|
NSW Rates |
|
| Enter Legal fees and other
costs |
Enter Legal Fees -conveyance |
600 |
|
|
Disbursements say |
500 |
|
|
Non-Finance Costs |
|
19090 |
|
| Enter Loan Application &
funding costs : |
|
|
|
|
| Enter Application and
Valuation fees |
|
300 |
|
|
| Enter
Loan Duty |
|
200 |
|
|
| Enter Legal fees re Loan
-your solicitor |
|
350 |
|
|
| Enter Legal fees re Loan -
Financial Institution |
|
250 |
|
|
| Total Borrowing Costs |
|
1100 |
|
| On-COST ESTIMATE |
|
20190 |
|
| TOTAL ESTIMATED COST |
|
|
520190 |
|
|
|
|
| Step 5 Enter Up front Cash
Outlay |
|
150000 |
|
|
| Other Funds contributed eg
family |
|
0 |
|
|
| Total Non-Bank Finance |
|
150000 |
|
| 0 |
|
|
|
|
| Total Finance Required Date,
Amount |
|
|
370190 |
|
|
| |
|
|
|
|
FINANCE MIX |
|
|
% Interest Only |
Interest Rate % |
BORROWED |
|
|
| Step 6 Enter % Interest Only
and Rate 1st 12mth |
0.5 |
7.5 |
185095 |
|
| Balance assumed to be
principal and interest |
0.5 |
8.5 |
185095 |
|
|
|
| Principal and Interest Loan
Repayments |
|
| Principal portion |
185095 |
|
| Input Interest Rate &
Term : |
Principal & In Loan |
|
|
|
| Interest
Rate |
8.5 |
As decimal |
|
|
| Term |
25 |
In Years |
|
|
| Loan Repayments |
1490 |
17885 |
|
|
| |
Per Month |
Per Annum |
|
| Estimated Interest first full
year : |
|
| Interest Only Loan |
1157 |
13882 |
|
| Interest (portion of
Principal & Interest Loan) |
1311 |
15733 |
(IST YEAR ONLY) |
|
| Total Estimated Interest |
2468 |
29615 |
|
|
|
|
|
|
PER ANNUM RENTAL BUDGET |
|
| Estimated Property Result : |
Factors |
|
|
|
Input Per Week |
Per Month |
|
| Step 7 Enter Gross Rent |
330 |
1430 |
|
| Estimated Gross Rental |
|
|
|
|
Per Annum |
|
|
| Estimation of property
loss : |
|
17160 |
|
|
| Step 8 Enter Vacancy
allowance % |
5% |
-858 |
|
|
|
|
|
|
| Gross Rental Before Charges |
|
16302 |
|
|
|
| |
|
|
|
|
| Gross Rental Before Charges |
|
16302 |
|
|
|
| |
|
|
|
|
| Step 9 Enter Estimated Per
Annum Expenses |
|
|
|
|
| Advertising |
|
250 |
|
| Enter Management fee % |
7% |
1141 |
|
| Letting fees (assumed 1/52) |
|
314 |
|
| Cleaning |
|
|
|
| Gardening |
|
|
|
| Council Rates |
|
600 |
|
| Water Rates |
|
450 |
|
| Insurance |
|
450 |
|
|
|
|
| Owners Corporation - Strata
Levies |
|
1600 |
|
| Postage, printing ,
stationery, telephone |
|
100 |
|
| Repairs |
|
350 |
|
| Travel to inspect (if
applicable) |
|
|
|
| Sub-total of expenditure
during year |
|
5255 |
|
|
| |
|
|
|
| Add : Deductions to be Calculated |
|
|
|
| Borrowing Expenses (Call for
advice) |
220 |
|
| Building Write offs (call for
advice) |
200 |
|
| Depreciation of fixtures and
fittings (call for advice) |
200 |
|
| Sub-total Notional Deductions |
620 |
|
|
|
|
| Interest Interest Only (from above) |
13882 |
|
|
| Interest P & I (from
above) |
15733 |
|
|
| Sub-total Interest Deductions |
29615 |
|
|
| Total Calculated Expense
Deductions |
|
30235 |
|
|
| ESTIMATED TOTAL EXPENSES |
|
35490 |
|
|
| |
|
|
|
| PROPERTY
LOSS |
|
-19188 |
|
|
| |
|
|
|
|
| Share
claimable by |
Enter 100 or other % below |
|
|
|
| Yourself |
100% |
-19188 |
|
|
| Other joint owner (or tenant
in common) |
0% |
0 |
|
|
|
|
|
|
|
|
|
|
|
| PERSONAL TAX PROJECTIONS |
Enter other personal
information |
|
|
|
|
Projected |
|
| Enter Your Name
Here |
ACTUAL |
ESTIMATED |
TOTAL |
|
|
| SALARY
& WAGES : |
Enter Per Month Amount |
PER ANNUM |
30 JUNE |
|
|
| Enter No. Months : |
1 |
12 |
13 |
|
|
| Salary - gross taxed |
5000 |
60000 |
60000 |
|
| Tax Instalments before or
without TID Variation |
1500 |
18000 |
18000 |
|
|
| |
|
|
|
|
|
| Net wages |
3500 |
42000 |
42000 |
|
| |
|
|
|
| Less Personal Tax Deductions |
Either Enter Per Month
or Per Annum Column |
Total |
|
| Work related deductions |
Per Month |
PER ANNUM |
|
|
| Disability Insurance |
10 |
120 |
120 |
|
|
| Subs & Journals |
25 |
300 |
300 |
|
|
| Depreciation |
50 |
600 |
600 |
|
|
| Car
Expenses |
60 |
720 |
720 |
|
|
| Other |
20 |
240 |
240 |
|
|
| Estimated Work expenses |
165 |
1980 |
1980 |
|
|
| |
|
|
|
|
|
| Estimated Other Personal
Expenses |
|
Enter Totals Only |
|
|
|
| Tax Agents fees |
|
150 |
150 |
|
|
| Depreciation of Equipment |
|
747 |
747 |
|
|
| Other Deductions - Self
Education |
|
0 |
0 |
|
|
| Estimated Other Deductions |
|
897 |
897 |
|
|
|
|
|
|
| TOTAL PERSONAL EXERTION
DEDUCTIONS |
|
|
2877 |
|
|
| |
|
|
|
|
|
| ESTIMATED NET SALARY INCOME |
|
|
57123 |
|
|
| |
|
|
|
|
| PAYG Instalments re Property
Income |
|
Total PAYG Instalment |
|
|
| Enter Total Quarterly PAYG
Instalment x 4 if applicable |
|
2000 |
2000 |
|
| Property Income |
|
Enter Totals Only |
|
|
| Interest Income |
|
3000 |
3000 |
|
|
| Franked Div |
|
|
0 |
|
|
| Imputation Tax Credit |
|
|
0 |
|
|
| Net Rent (per schedule) |
|
Per Above |
-19188 |
|
|
|
|
0 |
|
|
| Total Gross Business &
Property Income |
|
|
-16188 |
|
|
|
|
|
| Less Other Property related deductions : |
|
Enter Totals Only |
|
|
|
| Depreciation F & F |
|
|
0 |
|
|
| Building Write off |
|
|
0 |
|
|
| Subscriptions |
|
50 |
50 |
|
|
| Superannuation (only if
eligble) |
|
0 |
0 |
|
|
| Total Property Related
Expenses |
|
|
50 |
|
|
|
|
|
| TOTAL
NET BUSINESS & PROPERTY INCOME |
|
-16238 |
|
|
|
|
|
|
|
|
|
| Projected Taxable Income |
|
|
40885 |
|
|
| |
|
|
|
|
| Estimated Primary Income Tax
current year |
|
|
8646 |
|
| |
|
|
|
|
|
| Less Franking Credit |
|
|
0 |
|
|
| Sub-total ( cannot be negative) |
|
|
8646 |
|
|
| Add : Medicare Levy excludes
surcharge |
NB 1 % Surcharge may apply |
|
613 |
|
| Less Estimated Tax
Instalments |
1500 |
18000 |
18000 |
|
| Less PAYG Instalments |
|
2000 |
2000 |
|
|
|
|
|
| Estimated Assessment
Payable/-Refundable |
|
|
-10741 |
|
|
| |
|
|
|
|
|
|
Any Tax Savings from
negative gearing should be considered |
|
| Cash Flow Shortfall |
after reviewing the
pre-tax cash flow position. -Can you afford the investment ? |
|
|
|
NET CASH FLOW |
NET |
|
|
Property |
Other Income |
Total |
|
| Net Trading Loss |
Before any taxation savings |
-19188 |
42073 |
22885 |
|
| Add Back notionals |
|
620 |
|
620 |
|
| Add Interest estimate |
|
29615 |
|
29615 |
|
| Deduct Loan Repayments |
|
-31767 |
|
-31767 |
|
|
|
| Estimated Cash Drainage |
For Period |
-20720 |
42073 |
21353 |
|
| Estimated Cash Drainage |
Per Day |
-57 |
115 |
59 |
|
| Estimated Cash Drainage |
Per Month |
-1727 |
3506 |
1779 |
|
| Estimated Cash Drainage |
Per Week |
-398 |
809 |
411 |
|
|
|
|
|
|
|
|
|