Buy Rent
Comments
 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$159,950.00Stamp Duty
4
Settlement DatetodayActFALSE
5
Stamp Duty StateqldVicFALSE
6
Rent per week$210.00NSWFALSE
7
Months Rented Since Owned12Qld4023.25
8
Cash on Cash Return-52.23%TasFALSE
9
Real Rent Per Annum$10,701.60WAFALSE
10
Occupancy98SA
11
Famous 500$105,000.00NTFALSE
12
Real Weekly Rent$205.80
13
14
Mortgage
Principle & Interest
Interest Only
15
P&I or IOP&IP&IIO
16
Percentage Deposit0%$810.44FALSE
17
Deposit Amount$0.00
18
Amount Borrowed$159,950.00
19
Interest Rate4.50%
20
Term in Years30
21
Payments Per Year12
22
Total Payments360
23
Weekly Repayments$187.03
24
Monthly Repayments$810.44
25
Annual Loan Repayments$9,725.32
26
Amount paid for the life of the loan
$291,759.54
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$0.00
42
Solicitor/Conveyancer$1,000.00
43
Stamp Duty$4,023.25
44
Mortgage Application
45
Lenders Mortgage Insurance$159,950
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$5,023.25
52
53
Profit/Loss
54
Total Annual Rent$10,701.60
55
Minus Total Annual Loan$9,725.32
56
Minus Total Annual Expenses$3,600.00
57
Equals Total Profit per Annum-$2,623.72
58
Total Profit Ever Since Being Rented
$10,701.60
59
Yield6.69%
60
Cash on Cash Return-52.23%
61
Cash flow Positive Weekly-$50.46
Loading...
 
 
 
Buy Rent
Sheet1