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

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
通脹率3%
2
加租率5%
3
樓價2000000
4
按揭額(70%)1400000
5
按揭年期30
6
交易成本126100
7
Initial 租金7000
8
Initial 管理費500
9
Initial 差响350
10
11
租金管理費差响尚欠本金按揭利率利息本金每月供款額物業稅投入本金回報率
12
1 7,000 500 350 $1,400,0001% 1,167 3,336 4,503 798 729,436 6.89%
13
2 7,000 500 350 $1,396,6641% 1,164 3,339 4,503 798 732,775 6.86%
14
3 7,000 500 350 $1,393,3251% 1,161 3,342 4,503 798 736,117 6.83%
15
4 7,000 500 350 $1,389,9831% 1,158 3,345 4,503 798 739,462 6.81%
16
5 7,000 500 350 $1,386,6381% 1,156 3,347 4,503 798 742,809 6.78%
17
6 7,000 500 350 $1,383,2911% 1,153 3,350 4,503 798 746,159 6.75%
18
7 7,000 500 350 $1,379,9411% 1,150 3,353 4,503 798 749,512 6.73%
19
8 7,000 500 350 $1,376,5881% 1,147 3,356 4,503 798 752,868 6.70%
20
9 7,000 500 350 $1,373,2321% 1,144 3,359 4,503 798 756,227 6.68%
21
10 7,000 500 350 $1,369,8731% 1,142 3,361 4,503 798 759,588 6.65%
22
11 7,000 500 350 $1,366,5121% 1,139 3,364 4,503 798 762,953 6.63%
23
12 7,000 500 350 $1,363,1471% 1,136 3,367 4,503 798 766,320 6.60%
24
13 7,000 515 350 $1,359,7802% 2,266 2,887 5,153 798 769,206 4.79%
25
14 7,000 515 350 $1,356,8942% 2,261 2,892 5,153 798 772,098 4.78%
26
15 7,000 515 350 $1,354,0022% 2,257 2,896 5,153 798 774,994 4.77%
27
16 7,000 515 350 $1,351,1062% 2,252 2,901 5,153 798 777,895 4.76%
28
17 7,000 515 350 $1,348,2052% 2,247 2,906 5,153 798 780,801 4.75%
29
18 7,000 515 350 $1,345,2992% 2,242 2,911 5,153 798 783,712 4.74%
30
19 7,000 515 350 $1,342,3882% 2,237 2,916 5,153 798 786,628 4.73%
31
20 7,000 515 350 $1,339,4722% 2,232 2,921 5,153 798 789,548 4.72%
32
21 7,000 515 350 $1,336,5522% 2,228 2,925 5,153 798 792,474 4.71%
33
22 7,000 515 350 $1,333,6262% 2,223 2,930 5,153 798 795,404 4.70%
34
23 7,000 515 350 $1,330,6962% 2,218 2,935 5,153 798 798,339 4.69%
35
24 7,000 515 350 $1,327,7612% 2,213 2,940 5,153 798 801,279 4.68%
36
25 7,350 530 368 $1,324,8213% 3,312 2,521 5,833 838 803,800 3.44%
37
26 7,350 530 368 $1,322,3003% 3,306 2,527 5,833 838 806,328 3.44%
38
27 7,350 530 368 $1,319,7723% 3,299 2,534 5,833 838 808,861 3.43%
39
28 7,350 530 368 $1,317,2393% 3,293 2,540 5,833 838 811,401 3.43%
40
29 7,350 530 368 $1,314,6993% 3,287 2,546 5,833 838 813,947 3.43%
41
30 7,350 530 368 $1,312,1533% 3,280 2,553 5,833 838 816,500 3.43%
42
31 7,350 530 368 $1,309,6003% 3,274 2,559 5,833 838 819,059 3.43%
43
32 7,350 530 368 $1,307,0413% 3,268 2,565 5,833 838 821,624 3.43%
44
33 7,350 530 368 $1,304,4763% 3,261 2,572 5,833 838 824,196 3.43%
45
34 7,350 530 368 $1,301,9043% 3,255 2,578 5,833 838 826,774 3.42%
46
35 7,350 530 368 $1,299,3263% 3,248 2,585 5,833 838 829,359 3.42%
47
36 7,350 530 368 $1,296,7413% 3,242 2,591 5,833 838 831,950 3.42%
48
37 7,350 546 368 $1,294,1504% 4,314 2,225 6,539 838 834,175 1.85%
49
38 7,350 546 368 $1,291,9254% 4,306 2,233 6,539 838 836,408 1.85%
50
39 7,350 546 368 $1,289,6924% 4,299 2,240 6,539 838 838,648 1.86%
51
40 7,350 546 368 $1,287,4524% 4,292 2,247 6,539 838 840,895 1.86%
52
41 7,350 546 368 $1,285,2054% 4,284 2,255 6,539 838 843,150 1.87%
53
42 7,350 546 368 $1,282,9504% 4,276 2,263 6,539 838 845,413 1.88%
54
43 7,350 546 368 $1,280,6874% 4,269 2,270 6,539 838 847,683 1.88%
55
44 7,350 546 368 $1,278,4174% 4,261 2,278 6,539 838 849,961 1.89%
56
45 7,350 546 368 $1,276,1394% 4,254 2,285 6,539 838 852,246 1.89%
57
46 7,350 546 368 $1,273,8544% 4,246 2,293 6,539 838 854,539 1.90%
58
47 7,350 546 368 $1,271,5614% 4,239 2,300 6,539 838 856,839 1.90%
59
48 7,350 546 368 $1,269,2614% 4,231 2,308 6,539 838 859,147 1.91%
60
49 7,718 563 386 $1,266,9535% 5,279 1,985 7,264 880 861,132 0.85%
61
50 7,718 563 386 $1,264,9685% 5,271 1,993 7,264 880 863,126 0.86%
62
51 7,718 563 386 $1,262,9745% 5,262 2,002 7,264 880 865,127 0.87%
63
52 7,718 563 386 $1,260,9735% 5,254 2,010 7,264 880 867,137 0.88%
64
53 7,718 563 386 $1,258,9635% 5,246 2,018 7,264 880 869,155 0.89%
65
54 7,718 563 386 $1,256,9455% 5,237 2,027 7,264 880 871,182 0.90%
66
55 7,718 563 386 $1,254,9185% 5,229 2,035 7,264 880 873,217 0.91%
67
56 7,718 563 386 $1,252,8835% 5,220 2,044 7,264 880 875,261 0.92%
68
57 7,718 563 386 $1,250,8395% 5,212 2,052 7,264 880 877,313 0.93%
69
58 7,718 563 386 $1,248,7875% 5,203 2,061 7,264 880 879,374 0.94%
70
59 7,718 563 386 $1,246,7265% 5,195 2,069 7,264 880 881,443 0.95%
71
60 7,718 563 386 $1,244,6575% 5,186 2,078 7,264 880 883,521 0.95%
72
61 7,718 580 386 $1,242,5795% 5,177 2,087 7,264 880 885,608 0.94%
73
62 7,718 580 386 $1,240,4925% 5,169 2,095 7,264 880 887,703 0.95%
74
63 7,718 580 386 $1,238,3975% 5,160 2,104 7,264 880 889,807 0.96%
75
64 7,718 580 386 $1,236,2935% 5,151 2,113 7,264 880 891,920 0.97%
76
65 7,718 580 386 $1,234,1805% 5,142 2,122 7,264 880 894,041 0.98%
77
66 7,718 580 386 $1,232,0595% 5,134 2,130 7,264 880 896,172 0.99%
78
67 7,718 580 386 $1,229,9285% 5,125 2,139 7,264 880 898,311 1.00%
79
68 7,718 580 386 $1,227,7895% 5,116 2,148 7,264 880 900,459 1.01%
80
69 7,718 580 386 $1,225,6415% 5,107 2,157 7,264 880 902,616 1.02%
81
70 7,718 580 386 $1,223,4845% 5,098 2,166 7,264 880 904,783 1.03%
82
71 7,718 580 386 $1,221,3175% 5,089 2,175 7,264 880 906,958 1.04%
83
72 7,718 580 386 $1,219,1425% 5,080 2,184 7,264 880 909,142 1.05%
84
73 8,103 597 405 $1,216,9586% 6,085 1,898 7,983 924 911,040 0.12%
85
74 8,103 597 405 $1,215,0606% 6,075 1,908 7,983 924 912,948 0.13%
86
75 8,103 597 405 $1,213,1526% 6,066 1,917 7,983 924 914,865 0.15%
87
76 8,103 597 405 $1,211,2356% 6,056 1,927 7,983 924 916,792 0.16%
88
77 8,103 597 405 $1,209,3086% 6,047 1,936 7,983 924 918,728 0.17%
89
78 8,103 597 405 $1,207,3726% 6,037 1,946 7,983 924 920,675 0.18%
90
79 8,103 597 405 $1,205,4256% 6,027 1,956 7,983 924 922,630 0.20%
91
80 8,103 597 405 $1,203,4706% 6,017 1,966 7,983 924 924,596 0.21%
92
81 8,103 597 405 $1,201,5046% 6,008 1,975 7,983 924 926,572 0.22%
93
82 8,103 597 405 $1,199,5286% 5,998 1,985 7,983 924 928,557 0.23%
94
83 8,103 597 405 $1,197,5436% 5,988 1,995 7,983 924 930,552 0.24%
95
84 8,103 597 405 $1,195,5486% 5,978 2,005 7,983 924 932,558 0.26%
96
85 8,103 615 405 $1,193,5426% 5,968 2,015 7,983 924 934,573 0.25%
97
86 8,103 615 405 $1,191,5276% 5,958 2,025 7,983 924 936,598 0.26%
98
87 8,103 615 405 $1,189,5026% 5,948 2,035 7,983 924 938,634 0.27%
99
88 8,103 615 405 $1,187,4666% 5,937 2,046 7,983 924 940,679 0.28%
100
89 8,103 615 405 $1,185,4216% 5,927 2,056 7,983 924 942,735 0.30%
Loading...
 
 
 
Sheet1
Sheet2
Sheet3