Property Feasibility and scenarios

Property Feasibility
5 posts / 0 new
Log in or register to post comments.
Last post
2 years ago
#1
marc de vernon A+ 0
ma
Property Feasibility and scenarios

Hi All,

I'm trying to see if there is a way to add scenario analysis to the property feasibility content. I understand the main idea there is to look at how time affects the feasibility, but, I do not see how to add the usual scenarios to the model.

I would be happy to hold the time assumptions separate, and just do sensitivity on costs, and then perhaps another one that shows some time sensitivities. Having a client "play with the development delays" isn't quite good enough.

Any thoughts?

M

2 years ago
James Longden A+ 103

Hi Marc,

The property feasibility content does include sensitivity on cost assumptions by default. These are to the left of the time-based / duration sensitivities. Appreciate these aren't stored scenarios though.

There's no scenario manager module for the property feasibility at the moment. However, I will try and build one out and upload in the next 24hrs.

Cheers. J.

2 years ago
James Longden A+ 103

Hi Marc,

Quick follow-up on this. Attached is an updated property feasibility model, with a couple of new modules in it:

  1. Scenario Manager - this has the core scenarion time series / headings, as per the wider Modano content, only for use with the property feasibility content.
  2. Scenario Cost Assumptions - this is a simple module that you can insert into any property feasibility content and it will link these scenario assumptions out into the summary section (next to the sensitivity assumptions, see image) of any development module, which then impact the cost analysis.

In terms of process, there are a couple of build options:

  1. Insert both of the above two modules mentioned modules into your model and away you go.
  2. Insert only the Scenario Manager module (to get the scenario infrastructure into the model) and then build out custom scenarios as per the following video / section of the wider scenario help: https://www.modano.com/resources/content_libraries/generic_financial_mod...

The second option will allow you to build the scenario assumptions straight into the development module itself - as well as adding debt, tax, scenario assumptions as well.

Let me know how you go. We'll make this official content in due course. Cheers. J.

 

Attachments: 
Modano-Property-Feasibility, Scenario Analysis-GST-INT-M~HF~P-AU-10.10.4.4.xlsb
2 years ago
marc de vernon A+ 0
ma

Thanks so much for responding so quickly. I really appreciate it!

2 years ago
marc de vernon A+ 0
ma

I hate to be a pain, but how would I make one of these for the income portion? I need to also add in the revenue sensitivities. Perhaps I should book with one of your support people?

M