Hi
I'm trying to add together the cost of acquiring a property and the sum total of the construction costs for x number of periods then multiplying the x% rental yield.
The problem I have is that each new period a new property can be bought so you have to add the cost of construction & price for the property already owned with the cost of the price and construction costs of the new property bought. This is further made problematic because the rental yield changes during the total time that the building is being constructed.
I've uploaded the file to try and make sense of it.
I'm trying to add together the cost of acquiring a property and the sum total of the construction costs for x number of periods then multiplying the x% rental yield.
The problem I have is that each new period a new property can be bought so you have to add the cost of construction & price for the property already owned with the cost of the price and construction costs of the new property bought. This is further made problematic because the rental yield changes during the total time that the building is being constructed.
I've uploaded the file to try and make sense of it.