急急急求帮助 关于EXCEL

来源:百度知道 编辑:UC知道 时间:2024/05/12 08:08:44
RT 很着急 谢谢大家=.=
王某租个房子至少租15年,经过和中介商讨之后,价钱定在60000每年, 每5年房租涨价3%,但中介要求每3年房子涨价3%,王某每年回报8%.问王某最多会交多少房租一年

这是我自己翻译的 下面是英文版的原题
Question 3. A retail store is currently let on a long lease with 15 years unexpired and with five-yearly rent reviews to open market value. The rent has just been negotiated to market rental value of $60,000 per annum. The owners of the property have approached you and are of the opinion that they would prefer to have three-yearly rent reviews. Pertinent information also provided by the owners is that the anticipated growth in rental value is 3% per annum over the period of the lease and that her required return on investment is 8% per annum. You have advised them that it would not be in the tenant’s interest to agree to more frequent rent reviews and that some form of incentive payment to the tenant would be required to entice the tenant to agree to the change.
 
What is the maximum payment that a prudent owner might pay the tenant?<

一个零售商店租赁了一个长达15合同并且每五年核查该商店的市场价值,房屋的市场价值暂时定在60000元每年,业主更希望房屋的市场价值每三年核算一次,每次增涨3%,并且在租赁期间还要分红到营业额8%,你应当站在业主的一方以支付奖金给房客的方法怂恿房客同意频繁的增加房屋的价值和分红
问业主最多可可以给房客多少奖金
我的理解是房屋拥有者以房子的租赁市场价值作资本投资在商店里,每年得到8%的分红。
感觉缺条件啊,营业额是多少?

按你的理解也是,缺这个条件,你说的王某每年回报8%是多少,什么的8%?

另外这个excel有啥关系?

6000*(1+3%)^15/15