收租回报率.xlsx

通脹率3%加租率5%樓價HK$2,000,000.00按揭額(70%)HK$1,400,000.00按揭年期30交易成本126100Initial 租金7000Initial 管理費500Initial 差响350租金管理費差响尚欠本金按揭利率利息17,000500350$1,400,0001%1,16727,000500350$1,396,6641%1,16437,000500350$1,393,3251%1,16147,000500350$1,389,9831%1,15857,000500350$1,386,6381%1,15667,000500350$1,383,2911%1,15377000500350$1,379,9411%1,15087,000500350$1,376,5881%1,14797,000500350$1,373,2321%1,144107,000500350$1,369,8731%1,142117,000500350$1,366,5121%1,139127,000500350$1,363,1471%1,136137,000515350$1,359,7802%2,266147,000515350$1,356,8942%2,261157,000515350$1,354,0022%2,257167,000515350$1,351,1062%2,252177,000515350$1,348,2052%2,247187,000515350$1,345,2992%2,242197,000515350$1,342,3882%2,237207,000515350$1,339,4722%2,232217,000515350$1,336,5522%2,228227,000515350$1,333,6262%2,223237,000515350$1,330,6962%2,218247,000515350$1,327,7612%2,213257,350530368$1,324,8213%3,312267,350530368$1,322,3003%3,306277,350530368$1,319,7723%3,299287,350530368$1,317,2393%3,293297,350530368$1,314,6993%3,287307,350530368$1,312,1533%3,280317,350530368$1,309,6003%3,274327,350530368$1,307,0413%3,268337,350530368$1,304,4763%3,261347,350530368$1,301,9043%3,255357,350530368$1,299,3263%3,248367,350530368$1,296,7413%3,242377,350546368$1,294,1504%4,314387,350546368$1,291,9254%4,306397,350546368$1,289,6924%4,299407,350546368$1,287,4524%4,292417,350546368$1,285,2054%4,284427,350546368$1,282,9504%4,276437,350546368$1,280,6874%4,269447,350546368$1,278,4174%4,261457,350546368$1,276,1394%4,254467,350546368$1,273,8544%4,246477,350546368$1,271,5614%4,239487,350546368$1,269,2614%4,231497,718563386$1,266,9535%5,279507,718563386$1,264,9685%5,271517,718563386$1,262,9745%5,262527,718563386$1,260,9735%5,254537,718563386$1,258,9635%5,246547,718563386$1,256,9455%5,237557,718563386$1,254,9185%5,229567,718563386$1,252,8835%5,220577,718563386$1,250,8395%5,212587,718563386$1,248,7875%5,203597,718563386$1,246,7265%5,195607,718563386$1,244,6575%5,186617,718580386$1,242,5795%5,177627,718580386$1,240,4925%5,169637,718580386$1,238,3975%5,160647,718580386$1,236,2935%5,151657,718580386$1,234,1805%5,142667,718580386$1,232,0595%5,134677,718580386$1,229,9285%5,125687,718580386$1,227,7895%5,116697,718580386$1,225,6415%5,107707,718580386$1,223,4845%5,098717,718580386$1,221,3175%5,089727,718580386$1,219,1425%5,080738,103597405$1,216,9586%6,085748,103597405$1,215,0606%6,075758,103597405$1,213,1526%6,066768,103597405$1,211,2356%6,056778,103597405$1,209,3086%6,047788,103597405$1,207,3726%6,037798,103597405$1,205,4256%6,027808,103597405$1,203,4706%6,017818,103597405$1,201,5046%6,008828,103597405$1,199,5286%5,998838,103597405$1,197,5436%5,988848,103597405$1,195,5486%5,978858,103615405$1,193,5426%5,968868,103615405$1,191,5276%5,958878,103615405$1,189,5026%5,948888,103615405$1,187,4666%5,937898,103615405$1,185,4216%5,927908,103615405$1,183,3656%5,917918,103615405$1,181,2996%5,906928,103615405$1,179,2226%5,896938,103615405$1,177,1356%5,886948,103615405$1,175,0386%5,875958,103615405$1,172,9306%5,865968,103615405$1,170,8126%5,854978,509633425$1,168,6836%5,843988,509633425$1,166,5436%5,833998,509633425$1,164,3936%5,8221008,509633425$1,162,2326%5,8111018,509633425$1,160,0606%5,8001028,509633425$1,157,8776%5,7891038,509633425$1,155,6846%5,7781048,509633425$1,153,4796%5,7671058,509633425$1,151,2646%5,7561068,509633425$1,149,0376%5,7451078,509633425$1,146,7996%5,7341088,509633425$1,144,5506%5,7231098,509652425$1,142,2906%5,7111108,509652425$1,140,0186%5,7001118,509652425$1,137,7356%5,6891128,509652425$1,135,4416%5,6771138,509652425$1,133,1356%5,6661148,509652425$1,130,8186%5,6541158,509652425$1,128,4896%5,6421168,509652425$1,126,1486%5,6311178,509652425$1,123,7966%5,6191188,509652425$1,121,4326%5,6071198,509652425$1,119,0566%5,5951208,509652425$1,116,6696%5,5831218,934672447$1,114,2696%5,5711228,934672447$1,111,8576%5,5591238,934672447$1,109,4346%5,5471248,934672447$1,106,9986%5,5351258,934672447$1,104,5506%5,5231268,934672447$1,102,0896%5,5101278,934672447$1,099,6176%5,4981288,934672447$1,097,1326%5,4861298,934672447$1,094,6356%5,4731308,934672447$1,092,1256%5,4611318,934672447$1,089,6026%5,4481328,934672447$1,087,0676%5,4351338,934692447$1,084,5206%5,4231348,934692447$1,081,9596%5,4101358,934692447$1,079,3866%5,3971368,934692447$1,076,8006%5,3841378,934692447$1,074,2016%5,3711388,934692447$1,071,5896%5,3581398,934692447$1,068,9646%5,3451408,934692447$1,066,3266%5,3321418,934692447$1,063,6756%5,3181428,934692447$1,061,0106%5,3051438,934692447$1,058,3326%5,2921448,934692447$1,055,6416%5,2781459,381713469$1,0529366%5,2651469,381713469$1,050,2176%5,2511479,381713469$1,047,4866%5,2371489,381713469$1,044,7406%5,2241499,381713469$1,041,9816%5,2101509,381713469$1,039,2086%5,1961519,381713469$1,036,4216%5,1821529,381713469$1,033,6206%5,1681539,381713469$1,030,8056%5,1541549,381713469$1,027,9766%5,1401559,381713469$1,025,1336%5,1261569,381713469$1,022,2756%5,1111579,381734469$1,019,4046%5,0971589,381734469$1,016,5186%5,0831599,381734469$1,013,6176%5,0681609,381734469$1,010,7026%5,0541619,381734469$1,007,7736%5,0391629,381734469$1,004,8296%5,0241639,381734469$1,001,8706%5,0091649,381734469$998,8966%4,9941659,381734469$995,9086%4,9801669,381734469$992,9046%4,9651679,381734469$989,8866%4,9491689,381734469$986,8526%4,9341699,850756492$983,8046%4,9191709,850756492$980,7406%4,9041719,850756492$977,6606%4,8881729,850756492$974,5666%4,8731739,850756492$971,4556%4,8571749,850756492$968,3306%4,8421759,850756492$965,1886%4,8261769,850756492$962,0316%4,8101779,850756492$958,8586%4,7941789,850756492$955,6706%4,7781799,850756492$952,4656%4,7621809,850756492$949,2446%4,7461819,850779492$946,0086%4,7301829,850779492$942,7556%4,7141839,850779492$939,4856%4,6971849,850779492$936,2006%4,6811859,850779492$932,8986%4,6641869,850779492$929,5796%4,6481879,850779492$926,2446%4,6311889,850779492$922,8926%4,6141899,850779492$919,5246%4,5981909,850779492$916,1396%4,5811919,850779492$912,7366%4,5641929,850779492$909,3176%4,54719310,342802517$905,8816%4,52919410,342802517$902,4276%4,51219510,342802517$898,9566%4,49519610,342802517$895,4686%4,47719710,342802517$891,9626%4,46019810,342802517$888,4396%4,44219910,342802517$884,8986%4,42420010,342802517$881,3406%4,40720110,342802517$877,7636%4,38920210,342802517$874,1696%4,37120310,342802517$870,5576%4,35320410,342802517$866,9276%4,33520510,342826517$863,2786%4,31620610,342826517$859,6126%4,29820710,342826517$855,9276%4,28020810,342826517$852,2246%4,26120910,342826517$848,5026%4,24321010,342826517$844,7616%4,22421110,342826517$841,0026%4,20521210,342826517$837,2246%4,18621310,342826517$833,4276%4,16721410,342826517$829,6116%4,14821510,342826517$825,7766%4,12921610,342826517$821,9226%4,11021710,859851543$818,0496%4,09021810,859851543$814,1566%4,07121910,859851543$810,2446%4,05122010,859851543$806,3126%4,03222110,859851543$802,3616%4,01222210,859851543$798,3896%3,99222310,859851543$794,3986%3,97222410,859851543$790,3876%3,95222510,859851543$786,3566%3,93222610,859851543$782,3056%3,91222710,859851543$778,2346%3,89122810,859851543$774,1426%3,87122910,859877543$770,0296%3,85023010,859877543$765,8976%3,82923110,859877543$761,7436%3,80923210,859877543$757,5696%3,78823310,859877543$753,3746%3,76723410,859877543$749,1586%3,74623510,859877543$744,9206%3,72523610,859877543$740,6626%3,70323710,859877543$736,3826%3,68223810,859877543$732,0816%3,66023910,859877543$727,7596%3,63924010,859877543$723,4146%3,61724111,402903570$719,0486%3,59524211,402903570$714,6616%3,57324311,402903570$710,2516%3,55124411,402903570$705,8196%3,52924511,402903570$701,3656%3,50724611,402903570$696,8896%3,48424711,402903570$692,3916%3,46224811,402903570$687,8706%3,43924911,402903570$683,3266%3,41725011,402903570$678,7596%3,39425111,402903570$674,1706%3,37125211,402903570$669,5586%3,34825311,402930570$664,9236%3,32525411,402930570$660,2656%3,30125511,402930570$655,5836%3,27825611,402930570$650,8786%3,25425711,402930570$646,1496%3,23125811,402930570$641,3976%3,20725911,402930570$636,6216%3,18326011,402930570$631,8216%3,15926111,402930570$626,9976%3,13526211,402930570$622,1496%3,11126311,402930570$617,2776%3,08626411,402930570$612,3806%3,06226511,972958599$607,4596%3,03726611,972958599$602,5136%3,01326711,972958599$597,5436%2,98826811,972958599$592,5486%2,96326911,972958599$587,5276%2,93827011,972958599$582,4826%2,91227111,972958599$577,4116%2,88727211,972958599$572,3166%2,86227311,972958599$567,1946%2,83627411,972958599$562,0476%2,81027511,972958599$556,8746%2,78427611,972958599$551,6766%2,75827711,972987599$546,4516%2,73227811,972987599$541,2006%2,70627911,972987599$535,9236%2,68028011,972987599$530,6206%2,65328111,972987599$525,2906%2,62628211,972987599$519,9346%2,60028311,972987599$514,5506%2,57328411,972987599$509,1406%2,54628511,972987599$503,7036%2,51928611,972987599$498,2386%2,49128711,972987599$492,7466%2,46428811,972987599$487,2276%2,43628912,5711,016629$481,6806%2,40829012,5711,016629$476,1066%2,38129112,5711,016629$470,5036%2,35329212,5711,016629$464,8736%2,32429312,5711,016629$459,2146%2,29629412,5711,016629$453,5276%2,26829512,5711,016629$447,8126%2,23929612,5711,016629$442,0686%2,21029712,5711,016629$436,2956%2,18129812,5711,016629$430,4946%2,15229912,5711,016629$424,6636%2,12330012,5711,016629$418,8036%2,09430112,5711,047629$412,9146%2,06530212,5711,047629$406,9966%2,03530312,5711,047629$401,0486%2,00530412,5711,047629$395,0706%1,97530512,5711,047629$389,0636%1,94530612,5711,047629$383,0256%1,91530712,5711,047629$376,9576%1,88530812,5711,047629$370,8596%1,85430912,5711,047629$364,7306%1,82431012,5711,047629$358,5716%1,79331112,5711,047629$352,3816%1,76231212,5711,047629$346,1596%1,73131313,2001,078660$339,9076%1,70031413,2001078660$333,6246%1,66831513,2001,078660$327,3096%1,63731613,2001,078660$320,9626%1,60531713,2001,078660$314,5846%1,57331813,2001,078660$308,1746%1,54131913,2001,078660$301,7326%1,50932013,2001,078660$295,2586%1,47632113,2001,078660$288,7516%1,44432213,2001,078660$282,2126%1,41132313,2001,078660$275,6406%1,37832413,2001,078660$269,0356%1,34532513,2001,111660$262,3976%1,31232613,2001,111660$255,7266%1,27932713,2001,111660$249,0226%1,24532813,2001,111660$242,2846%1,21132913,2001,111660$235,5126%1,17833013,2001,111660$228,7076%1,14433113,2001,111660$221,8676%1,10933213,2001,111660$214,9946%1,07533313,2001,111660$208,0866%1,04033413,2001,111660$201,1436%1,00633513,2001,111660$194,1666%97133613,2001,111660$187,1546%93633713,8601,144693$180,1066%90133813,8601,144693$173,0246%86533913,8601,144693$165,9066%83034013,8601,144693$158,7536%79434113,8601,144693$151,5636%75834213,8601,144693$144,3386%72234313,8601,144693$137,0776%68534413,8601,144693$129,7796%64934513,8601,144693$122,4456%61234613,8601,144693$115,0746%57534713,8601,144693$107,6676%53834813,8601,144693$100,2226%50134913,8601,178693$92,7406%46435013,8601,178693$85,2216%42635113,8601,178693$77,6646%38835213,8601,178693$70,0696%35035313,8601,178693$62,4376%31235413,8601,178693$54,7666%27435513,8601,178693$47,0576%23535613,8601,178693$39,3096%19735713,8601,178693$31,5236%15835813,8601,178693$23,6976%11835913,8601,178693$15,8336%7936013,8601,178693$7,9296%403,625,199285,452181,2601,337,761本金每月供款額物業稅投入本金回報率3,3364,503798729,4366.893,3394,503798732,7756.86%3,3424,503798736,1176.83%3,3454,503798739,4626.81%3,3474,503798742,8096.78%3,3504,503798746,1596.75%3,3534,503798749,5126.73%3,3564,503798752,8686.70%3,3594,503798756,2276.68%3,3614,503798759,5886.65%3,3644,503798762,9536.63%3,3674,503798766,3206.60%2,8875,153798769,2064.792,8925,153798772,0984.78%2,8965,153798774,9944.77%2,9015,153798777,8954.76%2,9065,153798780,8014.75%2,9115,153798783,7124.74%2,9165,153798786,6284.73%2,9215,153798789,5484.72%2,9255,153798792,4744.71%2,9305,153798795,4044.70%2,9355,153798798,3394.69%2,9405,153798801,2794.68%2,5215,833838803,8003.442,5275,833838806,3283.44%2,5345,833838808,8613.43%2,5405,833838811,4013.43%2,5465,833838813,9473.43%2,5535,833838816,5003.43%2,5595,833838819,0593.43%2,5655,833838821,6243.43%2,5725,833838824,1963.43%2,5785,833838826,7743.42%2,5855,833838829,3593.42%2,5915,833838831,9503.42%2,2256,539838834,1751.852,2336,539838836,4081.85%2,2406,539838838,6481.86%2,2476,539838840,8951.86%2,2556,539838843,1501.87%2,2636,539838845,4131.88%2,2706,539838847,6831.88%2,2786,539838849,9611.89%2,2856,539838852,2461.89%2,2936,539838854,5391.90%2,3006,539838856,8391.90%2,3086,539838859,1471.91%1,9857,264880861,1320.851,9937,264880863,1260.86%2,0027,264880865,1270.87%2,0107,264880867,1370.88%2,0187,264880869,1550.89%2,0277,264880871,1820.90%2,0357,264880873,2170.91%2,0447,264880875,2610.92%2,0527,264880877,3130.93%2,0617,264880879,3740.94%2,0697,264880881,4430.95%2,0787,264880883,5210.95%2,0877,264880885,6080.942,0957,264880887,7030.95%2,1047,264880889,8070.96%2,1137,264880891,9200.97%2,1227,264880894,0410.98%2,1307,264880896,1720.99%2,1397,264880898,3111.00%2,1487,264880900,4591.01%2,1577,264880902,6161.02%2,1667,264880904,7831.03%2,1757,264880906,9581.04%2,1847,264880909,1421.05%1,8987,983924911,0400.121,9087,983924912,9480.13%1,9177,983924914,8650.15%1,9277,983924916,7920.16%1,9367,983924918,7280.17%1,9467,983924920,6750.18%1,9567,983924922,6300.20%1,9667,983924924,5960.21%1,9757,983924926,5720.22%1,9857,983924928,5570.23%1,9957,983924930,5520.24%2,0057,983924932,5580.26%2,0157,983924934,5730.252,0257,983924936,5980.26%2,0357,983924938,6340.27%2,0467,983924940,6790.28%2,0567,983924942,7350.30%2,0667,983924944,8010.31%2,0777,983924946,8780.32%2,0877,983924948,9650.33%2,0977,983924951,0620.35%2,1087,983924953,1700.36%2,1187,983924955,2880.37%2,1297,983924957,4170.38%2,1407,983970959,5570.802,1507,983970961,7070.81%2,1617,983970963,8680.82%2,1727,983970966,0400.83%2,1837,983970968,2230.84%2,1947,983970970,4160.85%2,2057,983970972,6210.87%2,2167,983970974,8360.88%2,2277,983970977,0630.89%2,2387,983970979,3010.90%2,2497,983970981,5500.91%2,2607,983970983,8100.92%2,2727,983970986,0820.912,2837,983970988,3650.92%2,2947,983970990,6590.94%2,3067,983970992,9650.95%2,3177,983970995,2820.96%2,3297,983970997,6110.97%2,3417,983970999,9520.98%2,3527,9839701,002,3040.99%2,3647,9839701,004,6681.01%2,3767,9839701,007,0441.02%2,3887,9839701,009,4311.03%2,4007,9839701,061,8310.99%2,4127,9831,0181,064,2431.38%2,4247,9831,0181,066,6661.39%2,4367,9831,0181,069,1021.40%2,4487,9831,0181,071,5501.41%2,4607,9831,0181,074,0111.42%2,4737,9831,0181,076,4831.43%2,4857,9831,0181,078,9681.44%2,4977,9831,0181,081,4651.45%2,5107,9831,0181,083,9751.47%2,5227,9831,0181,086,4981.48%2,5357,9831,0181,089,0331.49%2,5487,9831,0181,091,5801.50%2,5607,9831,0181,094,1411.49%2,5737,9831,0181,096,7141.50%2,5867,9831,0181,099,3001.51%2,5997,9831,0181,101,8991.52%2,6127,9831,0181,104,5111.53%2,6257,9831,0181,107,1361.54%2,6387,9831,0181,109,7741.55%2,6517,9831,0181,112,4251.56%2,6657,9831,0181,115,0901.57%2,6787,9831,0181,117,7681.58%2,6917,9831,0181,120,4591.59%2,7057,9831,0181,123,1641.60%2,7187,9831,0691,125,8831.99%2,7327,9831,0691,128,6142.00%2,7467,9831,0691,131,3602.01%2,7597,9831,0691,134,1192.02%2,7737,9831,0691,136,8922.03%2,7877,9831,0691,139,6792.04%2,8017,9831,0691,142,4802.05%2,8157,9831,069