Buy Rent
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
£
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJ
1
Input YELLOW Outputs Blue
2
Example Property Address 1
3
Property Price$319,500.00Stamp Duty
4
Settlement DatetodayActFALSE
5
Stamp Duty StateSAVicFALSE
6
Rent per week$400.00NSWFALSE
7
Months Rented Since Owned48QldFALSE
8
Cash on Cash Return27.05%TasFALSE
9
Real Rent Per Annum$20,384.00WAFALSE
10
Occupancy98SA
11
Famous 500$200,000.00NTFALSE
12
Real Weekly Rent$392.00
13
14
Mortgage
Principle & Interest
Interest Only
15
P&I or IOP&IP&IIO
16
Percentage Deposit5%$1,016.04FALSE
17
Deposit Amount$15,975.00
18
Amount Borrowed$303,525.00
19
Interest Rate3.72%
20
Term in Years15
21
Payments Per Year26
22
Total Payments390
23
Weekly Repayments$234.47
24
Monthly Repayments$1,016.04
25
Annual Loan Repayments$12,192.46
26
Amount paid for the life of the loan
$396,255.01
27
28
Annual Expenses
29
Advertising, for rent etc
30
Council rates$2,000.00
31
Council water rates$500.00
32
Insurance$600.00
33
Maintenance$500.00
34
Property management
35
Body Corporate
36
other
37
other
38
Total Annual Expenses$3,600.00
39
40
Purchase Costs
41
Deposit$15,975.00
42
Solicitor/Conveyancer$1,000.00
43
Stamp Duty
44
Mortgage Application
45
Lenders Mortgage Insurance$319,500
46
Building Inspection Report$0.00
47
Pest Inspection Report
48
Valuation$0.00
49
Renovation & clean up costs
50
Other
51
Total Purchase Costs$16,975.00
52
53
Profit/Loss
54
Total Annual Rent$20,384.00
55
Minus Total Annual Loan$12,192.46
56
Minus Total Annual Expenses$3,600.00
57
Equals Total Profit per Annum$4,591.54
58
Total Profit Ever Since Being Rented
$81,536.00
59
Yield6.38%
60
Cash on Cash Return27.05%
61
Cash flow Positive Weekly$88.30
Loading...
 
 
 
Buy Rent
Sheet1
 
 
Main menu