Real Estate profit rent graphs

[anjali]

as theres no clear list about buildings and its size i did the same check like before in cap II (just recently switched back from cap plus to cap II and noticed cap lab exists nowdays, therefore i gave it a try due to the german buggy crash-a-lot cap II non patchable version)

started a firm, saved it at start and run only 1 of each building for 5 years each and then load back the save and do it all over with next building. everytime building is priced 10$/sq regardless of type next to the stock exchange in a 80+ real wage city (thats a 25$+ rent usually)
Total size of building estimated = monthly rent received / rent per sq / occupancy
which under normal circumstances should lead to an exact number (exept in cap lab)

this went pretty well in cap II and did only need a few month of gametime to estimate the sizes of the buildings. in cap lab however the sizes seem to fluctuate like hell (40% roughly) never the less it at some point seems to be same building size then in cap II just overhead halfed and bound to real wage in town. Now when i run through the years .... buildings gonna heavily fluctuate (first the total sq ft per building climbing and after the total sq ft going down) and total rent is going down and down and down per month with the occupancy increasing. and the charts freeze at a certain profit and show for the whole year the very same profit

i.e. smallest appartment ranging from total 8.800 sq ft (7.568 sq ft rented at 86% occupancy) up to total 13.200 sq ft (10.824 sq ft rented at 82% occupancy)

or the biggest appartment with 25.000 sq ft which is curiously much cheaper then the medium size 20.000 sq ft appatment and has much lower overhead sure i dont complain its hundreds of millions cheaper to build u whole towns
here the size ranges from 18.310sq up to 26.455 sq ft givven the occupancy and the rent collected for a month.

another issue is the chart graph ... going through my towns all are way off and no way to see what i really get. cba to calculate the rent/occupancy for hundreds of appartments/commercials in a spreadsheet takes several month i guess just to see if i really get this revenue. or if the game screw me up with the little money of the revenue graph

large apartment with 25.000 sq 93.5 occupancy 19.14$/sq
thats 447.432,56$ a month rent
by 42.084$ overhead (yes its in a cheap 52.61 real wage city)
thats a profit of 405.348,56

compared to the revenue graph i am doing only 160.000$ revenue and 120.000$ profit all year long with the occupancy slowely climbing?!?

thats a difference of over 50 million a month throughout all appartments ... its even worse on the commercials

lets see ... biggest commercial (45.000sq ft)
85.15 occupancy by 32.19$/sq
thats 38.317,5sq at 1.233.555,28$ revenue and 142.401$ overhead = 1.091.154,28$ profit a month
revenue graph says 430.000$ (its still climbing up
profit graph says 290.000$ constant for whole year
occupancy is also still climbing

could go on with examples but it really looks like the sq ft decreasing every month hence the occupancy goes up, and revenue goes up due to increase of land value and the profit stays the same because ... some agent rent out for free? havnt given permission to rent out for 0$ ^^

really cant get behind this with logic or spread sheets, even after loads of spend hours.

therefore my main question would be if the revenue/profit chart is just broken/ way off and i receive the real revenue or are the buildings shrinking month by month and after 50 years i gonna have a $100 milion buildings renting out 1 sq ft ?

[anjali]

okay i went through it once again with a enhanced spread sheet and think i found the issue for all this

as long as i charge the 10$ a sq everything is going smooth. revenue shows from stratup throughout 5 years the same as the real receivings.
commercial building 1 is ranging now due to rounding i guess between 26.535 and 26.540 sq ft
one thing i ve noticed where all my previous calculations got this crazy fluctuation was the fact that the previous month rent shows only up in the anual/life time revenue. i.e. you start jan 90
feb 1st the revenue for january is shown 0.00$ for january but the anual revenue shows the january rent. the january rent gonna show up on last month balance sheet in march and the february rent is once again only shown in the anual/life time revenue. this keeps going on through the years and was putting my spreadsheets off. but ...
after the 5 years i hiked the rent from the initial 10$ to market rent of 26$/sq and i keep receiving exactly the same 10$ per sq not a single penny more month by month. checking every 1st of month the all time revenue and reduce the previous month all time revenue to get the rent collected for the current occupation. and it is matching the same revenue per % of occupation regardless the rent /sq ???
the revenue graph n profit graph on the building keeps at 250k / 170k and the rent levels at roundabout 265.000$/month per 100% occupancy, no matter what rent price i ask for it will always be 265.000$ x occupancy. so with other words i could just put on every building a 0.01$ rent per month to get the best overall attractivity and always full buildings but receive still the 180k profit on the building every month. must be a bug.

just went through it because i was wondering why i can barely pay the interest on my 4 billion loans with about 200 appartments banging 18$ - 28$ per sq ft as this is in theory 90-100 million a month profit not mentioning the super commercials with the theoretical $2 million profit /month at 45$ a square but in real i only got about 40 million profit a month by crushing 36 million monthly interest keeps me just raising the loans and let the inflation take care of as i d go broke in crisis if i dont keep loaning and bloating up property value.

while charging 0.01$/sq it took 9 month to get the occupancy from 95% to 100% and the revenue dropped slightly from month to month and leveled now after 12 month at 157.000$ for the whole building thats like 15.700.000 sq ft huge building.

[Parkerrush92]

My question is, is it just the charts displaying wrong numbers, or are the income statements fluctuating too.

[anjali]

as i wrote in 2nd thread, after more testing, the charts are correct but the income itself is way off as you can see on the example below (copied out of spreadsheet) rented sq and total squares on the building calculated on Occupancy & rent received. i ve done this for several years on different buildings. this is actually the 1st commercial out of the commercial building list. the rent is dropping by about 40% when reducing rent to 0.01$ / sq but still thats far off as this is like 17 million sq ft on the commercial to receive this kinda rent. and its the same with any building. nowdays i just set across all buildings 10$/sq and dont bother with community / sport buildings and get same profit then when i used to run the buildings on marketprice +5% which would be 25$ onwards a building and wasting lotsa millions on public buildings. takes a lot of spice out of the game when the real estate isnt working correctly.

date...............occupancy....rent/sq............rented sq.....Rent/month....total squares..........total rent
Jan 90............12.38%.......$10.00..................3,285......$32,847.00..........26,532...........$32,847.00
Feb 90............22.54%.......$10.00..................5,982......$59,821.00..........26,540...........$92,668.00
Mar 90...........31.46%........$10.00..................8,348......$83,482.00..........26,536.........$176,150.00
Apr 90...........38.84%........$10.00.................10,306....$103,062.00..........26,535.........$279,212.00
May 90..........43.91%........$10.00.................11,653....$116,525.00..........26,537.........$395,737.00
Jun 90...........50.33%........$10.00.................13,357....$133,567.00..........26,538.........$529,304.00
Jul 90............55.21%........$10.00.................14,652....$146,524.00..........26,539.........$675,828.00
Aug 90..........60.37%........$10.00.................16,019.....$160,192.00..........26,535.........$836,020.00
Sep 90..........63.28%........$10.00.................16,793.....$167,932.00..........26,538.......$1,003,952.00
Oct 90...........67.97%........$10.00.................18,036....$180,360.00...........26,535......$1,184,312.00
Nov 90..........70.79%........$10.00.................18,787.....$187,867.00..........26,539......$1,372,179.00
Dec 90..........75.48%........$10.00.................20,030.....$200,295.00..........26,536......$1,572,474.00
Jan 91...........77.89%........$10.00.................20,669.....$206,692.00..........26,536......$1,779,166.00
Feb 91...........79.45%........$10.00.................21,084.....$210,837.00..........26,537......$1,990,003.00
Mar 91..........80.26%.........$10.00.................21,299....$212,991.00..........26,538.......$2,202,994.00
Apr 91...........82.74%........$10.00.................21,958.....$219,575.00..........26,538.......$2,422,569.00
May 91..........84.88%........$10.00.................22,526.....$225,259.00..........26,539.......$2,647,828.00
Jun 91...........86.67%........$10.00.................23,000.....$230,000.00..........26,537.......$2,877,828.00
Jul 91............88.38%........$10.00.................23,456.....$234,557.00..........26,539.......$3,112,385.00
Aug 91...........89.44%........$10.00.................23,736.....$237,358.00..........26,538......$3,349,743.00
Sep 91...........91.61%........$10.00.................24,310.....$243,099.00..........26,536......$3,592,842.00
Oct 91...........92.90%........$10.00.................24,652......$246,523.00..........26,536......$3,839,365.00
Nov 91..........92.74%........$10.00..................24,610.....$246,096.00..........26,536......$4,085,461.00
Dec 91..........92.00%........$26.11...................9,376......$244,808.00..........10,191......$4,330,269.00
Jan 92...........93.18%........$26.11...................9,524......$248,675.00..........10,221......$4,578,944.00
Feb 92...........95.03%........$13.18.................18,876.......$248,697.00.........19,864......$4,827,641.00
Mar 92...........95.13%.........$0.01............23,858,800......$238,588.00....25,080,206......$5,066,229.00
Apr 92...........96.35%..........$0.01...........23,160,400......$231,604.00....24,037,779......$5,297,833.00
May 92..........95.52%..........$0.01...........22,003,000.......$220,030.00....23,034,966.....$5,517,863.00
Jun 92...........95.82%..........$0.01...........21,153,000.......$211,530.00....22,075,767.....$5,729,393.00
Jul 92 ............96.91%..........$0.01...........20,612,800.......$206,128.00....21,270,044.....$5,935,521.00
Aug 92...........96.98%..........$0.01 ...........19,664,100.......$196,641.00....20,276,449.....$6,132,162.00
Sep 92...........96.89%..........$0.01 ...........18,828,100.......$188,281.00....19,432,449.....$6,320,443.00
Oct 92............96.96%..........$0.01...........18,056,800......$180,568.00.....18,622,937.....$6,501,011.00
Nov 92..........100.00%..........$0.01..........17,848,200.......$178,482.00.....17,848,200.....$6,679,493.00
Dec 92..........100.00%..........$0.01..........17,105,200.......$171,052.00.....17,105,200.....$6,850,545.00

[Parkerrush92]

What's the solution?

[anjali]

i am not sure how the real estate system is set up, but i would asume that it is supposed to have total sq ft assigned to each building and depends how well you develope the estate the higher is the overall rating, therefore you should be able to get higher rent to cover the expanses. then the public n sports buildings are usefull and you can up the rent as long as you make the estate more valuable.

if the real estate system is programmed to have a cut off point for revenue margin based on real wage in each city, the rent price button needs to be removed, then the public and sports buildings would be neccessary once again else ya not gonna get your buildings to a occupancy rate that ll cover the monthly overhead.

in the 2nd case the rent button is just an easy way to cheat and get your buildings full and the AI buildings empty and with the rent button no need for public/sports buildings nor shopping convinience, as ya just need to pop appartments and commercial side by side to make the land expansive put the rent down and collect the same rent as if you have the best spot in town with all the buildings and all shopping convinience + charging 25$ and more and the AI buildings never get to a proper occupation rate. and no need then also for all the rezoning work as the AI can have the CBD for the farms n factories as the player doesnt need the CBD for commercials.

just went into cap II and did run the same test there. getting a stable 27.779 sq ft for the largest appartment +/- a few sq ft and the rent price button does work properly, if i up the rent by 2 bucks a sq i gonna receive it the next month no matter what who doesnt like it moves out basta. same if i drop it far down, but hence then i run red numbers on the building.

[David]

This bug has been fixed in the latest version 3.0.20 which you may download from: http://www.capitalismlab.com/forum/view ... =37&t=2964

[anjali]

This bug has been fixed in the latest version 3.0.20 which you may download from: http://www.capitalismlab.com/forum/view ... =37&t=2964

sounds great, just too bad that i can't check it as i keep getting same problems on 3.0.20 as i got on 3.0.19 and 3.0.18d that capstart.exe isnt a win32 executable.

[David]

I have updated the patch file v3.0.20 with a new CapStart.exe file.

Please download it again (from the same download link) and give it a try.

[manaziluae]

Really cant get behind this with logic or spread sheets, even after loads of spend hours. Finally I think If the real estate system is programmed to have a cut off point for revenue margin based on real wage in each city, the rent price button needs to be removed, then the public and sports buildings would be necessary once again else ya not gonna get your buildings to a occupancy rate that will cover the monthly overhead.