Hi all,
I have just put together a quick feasibility model enabling you to find out the profitability of a development.
My question to all you excel experts out there is; does anyone know of a way to enable the cashflow spreadsheet (2nd tab) to represent the development and construction timeline? For example; if the project was to take 24 months from go to whoa, are we able to make the size of the spreadsheet, together with the colour coded "phases" such as design/construction/settlement etc to show the actual imputs? I use the total cap interest on this spread sheet to arrive at the value that appears on the "feasibility" sheet.
Hope my question isn't too confusing
BTW, any other comments or suggestions are very welcome.
Boods
I have just put together a quick feasibility model enabling you to find out the profitability of a development.
My question to all you excel experts out there is; does anyone know of a way to enable the cashflow spreadsheet (2nd tab) to represent the development and construction timeline? For example; if the project was to take 24 months from go to whoa, are we able to make the size of the spreadsheet, together with the colour coded "phases" such as design/construction/settlement etc to show the actual imputs? I use the total cap interest on this spread sheet to arrive at the value that appears on the "feasibility" sheet.
Hope my question isn't too confusing
BTW, any other comments or suggestions are very welcome.
Boods