Warning: is_dir(): open_basedir restriction in effect. File(/var/forums_cache/promotion) is not within the allowed path(s): (/var/www/sites/vforums:/var/www/apsowebly:/var/www/cp/tripwire/local/twpol_apso.txt:/var/www/cp/actions/letsencrypt_authorise.php:/var/log/php_pdf:/var/log/php_mail:/var/www/cms-v4:/tmp:/_tmp/vforums) in /var/www/sites/vforums/v2.4/includes/cache.php on line 45
Warning: is_dir(): open_basedir restriction in effect. File(/var/forums_cache/promotion/skins) is not within the allowed path(s): (/var/www/sites/vforums:/var/www/apsowebly:/var/www/cp/tripwire/local/twpol_apso.txt:/var/www/cp/actions/letsencrypt_authorise.php:/var/log/php_pdf:/var/log/php_mail:/var/www/cms-v4:/tmp:/_tmp/vforums) in /var/www/sites/vforums/v2.4/includes/cache.php on line 45
Warning: fopen(): open_basedir restriction in effect. File(/var/forums_cache/promotion/skins/1.txt.php) is not within the allowed path(s): (/var/www/sites/vforums:/var/www/apsowebly:/var/www/cp/tripwire/local/twpol_apso.txt:/var/www/cp/actions/letsencrypt_authorise.php:/var/log/php_pdf:/var/log/php_mail:/var/www/cms-v4:/tmp:/_tmp/vforums) in /var/www/sites/vforums/v2.4/includes/cache.php on line 51
Warning: fopen(/var/forums_cache/promotion/skins/1.txt.php): failed to open stream: Operation not permitted in /var/www/sites/vforums/v2.4/includes/cache.php on line 51
Real Estate Industry Free Forum Promotion > General :: General Talk :: > Real Estate Industry
Real Estate Industry - Posted By Roberhang (roberhang) on 9th Feb 22 at 9:18am
Hi,
I am beginner in VBA,
I am currently working in the assets management and investment department for a mega project to develop public assets (Museums, Parks, Venues…etc.), and several real estate assets classes (Residential, Retail, Offices, and Hospitality, healthcare, and education).
Currently, we are working on developing a consolidated financial model for all the assets within the park and one of the outcomes of this model is to provide us with the potential lands value per plot (parcel), based on a discounted project cashflow.
One of the key outcomes of this model is to provide us with a prefeasibility and a potential land value (sqm price) that can be used as a threshold before going into a partnership with investors (Jv, SPV, …) so that we can have an estimate of our share (land-in-kind) on any JV.
Since the model needs to be updated frequently, what are the best-VBA-practices that can facilitate and help us in the process of updating the key assumptions (E.g., CAPEX costs per sqm for construction, design, land scaping, infra structure, ...etc.).?
I know this is seems very general, however, I am expecting at this stage to receive ideas and thoughts from those working in the industry and who might had faced such a challenge (updating the model).
This will help me a lot in approaching this challenge and establishing necessary requirements and data bases to activate relevant MACROS moving forward.
What I define as success here is when we reach a point where whenever we open the model and run one macro, all model outcomes are based on most recent assumptions.
Thank you for your time.
Re: Real Estate Industry - Posted By Nicostly (nicostly) on 9th Feb 22 at 6:43pm
My story about becoming a real estate agent is actually a pretty funny one. I've studied law for 4 years and I was convinced that I'm going to be a lawyer. Then, something bad had happened. I didn't pass my bar exam and I was pretty disappointed. I was actually looking for a place to work and I've managed to be hired by a Mortgage Advice Newcastle. After that, I've started to like what I was doing and I was getting better and better at this. Then, my boss has told me about an opportunity related to selling different properties and making deals with new clients and here we are haha