租金反推售价的算法表格文件下载.xls
《租金反推售价的算法表格文件下载.xls》由会员分享,可在线阅读,更多相关《租金反推售价的算法表格文件下载.xls(3页珍藏版)》请在冰豆网上搜索。
楼层租金(元/.月)递增比例(2年)1F10010%2F6010%3F4010%4F3010%负1F6010%六个月5.85%一年6.31%一至三年6.40%121三至五年6.65%月租金(元/)年租金(元/)N次方五年以上6.80%100120010三、个人住房公积金贷款8五年以下(含五年)4.20%7五年以上4.70%65.652年递增比例10%投资回报率5%6%7%8%9%10%根据租金反推售价年年数数年年递递增增比比例例(QQ)21.110%回收期(年)投资回报率1-Q的N次方1-Q(1-Q的N次方)/(1-Q)205%-159.3742460100%-10.0%1593.742460100%176%-121.2784104278%-10.0%1212.784104278%147%-97.5431782684%-10.0%975.431782684%138%-81.4279871148%-10.0%814.279871148%119%-69.8084751033%-10.0%698.084751033%1010%-61.0510000000%-10.0%610.510000000%月租金(元/)1201008080604040可售价(元/)4590038250306002295015300349282910723285174641164328092234101872814046936423451195431563411726781720105167541340310052670217583146521172287915861可售价(元/)382502910723410195431675414652301147587327023586350264396