Big Boss
09-28-2021, 12:39 PM
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.
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.