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

 
View only
 
 
ABCFGHIKLMNOPQRSTUVWXYZ
1
INPUTSOUTPUTS
2
PURCHASEPURCHASE
3
Purchase Price R 1,200,000
*Percentage
Loan Required
R 1,080,000
4
Bond Amount R 1,080,000 90%Bond R 1,080,000
5
Interest Rate-0.70%
Cash Required
R 181,150
6
Prime Rate10.25%Purchase Balance R 120,000
7
Years30Transfer Costs R 34,565
8
Annual Inflation6.00%Bond Costs R 26,585
9
PROPERTY INFOPROPERTY INFO
10
Type of PropertyAppartment
Loan To Value Ratio (LTV)
0.720
11
Primary Residence
No
Debt Service Coverage Ratio (DSCR)
0.914
12
No. Bed Rooms2
Prop Inflation: Location
7.82%
13
Erf Size146
Prop Inflation: Geographic
6.64%
14
Province
Kwazulu Natal
Prop Inflation: Muncipality
7.82%
15
Municipality Ethekwini
Prop Inflation: Band Value
6.21%
16
CMA Value R 1,500,000 Price per m(2) R 8,219
17
Municiple Value R 1,100,000
Rental per Bed Room
R 5,000
18
MONTHLYMONTHLY
19
Rental Income (1) R 10,000
Profit / Decifit
-R 1,074
20
Rental Income (2) R -
Total Income
R 11,400
21
Rental Income (3) R - Rental(s) R 10,000
22
Bank Charge R - Electricity R 850
23
Levies R 890 Water R 550
24
Rates (Estimate) R 1,063
Total Expenses
R 12,474
25
Rates (actual) R - Loan Repayments R 9,121
26
*Lessor Account
Levies R 890
27
Electricity R 850 Yes Rates R 1,063
28
Water R 550 Yes Electricity R 850
29
Water (BC)NoWater R 550
30
Personal Sub. (min)
R 1,500 Bank Charge R -
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
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
Loading...
 
 
 
Property_Indicies
Sheet2
Prop_Snapshot
Prop_Renovations
Disposable_Input
Bond_Calculator
BondRepayment
AnnualAmort
MonthAmort
Ratios
Rates_Table
Bond_Transfer_Costs
Municiple_Table
Bond_Transfer_Tables
Rates
Data
 
 
Main menu