DEFINING RISK CURVES IN FEASIBILITY ANALYSES OF URBAN REGENERATION PROJECTS WITH MONTE CARLO METHOD
Urban regeneration projects offer numerous community benefits, such as improved housing quality and public spaces, but they also carry risks due to uncertainties in key variables for financial analysis, particularly in Discounted Cash Flow Analysis (DCFA). This research presents a practical tool dev...
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
DEI Tipografia del Genio Civile
2024-11-01
|
| Series: | Valori e Valutazioni |
| Subjects: | |
| Online Access: | https://siev.org/9-36-2024/ |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1832578730329899008 |
|---|---|
| author | Nicholas Fiorentini Diego Mariotti Massimo Rovai |
| author_facet | Nicholas Fiorentini Diego Mariotti Massimo Rovai |
| author_sort | Nicholas Fiorentini |
| collection | DOAJ |
| description | Urban regeneration projects offer numerous community benefits, such as improved housing quality and public spaces, but they also carry risks due to uncertainties in key variables for financial analysis, particularly in Discounted Cash Flow Analysis (DCFA). This research presents a practical tool developed in MS Excel that exploits the Monte Carlo method to quantify the risk of loss of value in these projects. Additionally, innovative Risk Curves are introduced to help investors assess the risks based on specified uncertainties in input variables. Focusing on the urban regeneration of the “Mercato del Carmine” in Lucca (Italy), and following EU project evaluation guidelines, a sensitivity analysis identified critical input variables. The financial sustainability of the project was then assessed using indicators such as Net Present Value (NPV), Internal Rate of Return (IRR), Payback Period (PP), and Productivity Index (PI). The DCFA confirmed the economic viability of the project. Monte Carlo simulations revealed key variables contributing to a significant risk of value loss, with results showing S-shaped Risk Curves. These curves indicate an acceptable tolerance for variations up to 10 percent in inputs related to initial investments, operating costs, and revenues, but show increasing risks with higher variations. This study highlights the value of Monte Carlo simulations in understanding the impact of uncertainty on regeneration project outcomes. The Excel-based tool provides decision-makers with a practical and user-friendly solution for making more informed choices regarding investment risks in urban regeneration projects. |
| format | Article |
| id | doaj-art-818df83aee1844fea7f2a263d58b3e03 |
| institution | Kabale University |
| issn | 2036-2404 |
| language | English |
| publishDate | 2024-11-01 |
| publisher | DEI Tipografia del Genio Civile |
| record_format | Article |
| series | Valori e Valutazioni |
| spelling | doaj-art-818df83aee1844fea7f2a263d58b3e032025-01-30T13:38:36ZengDEI Tipografia del Genio CivileValori e Valutazioni2036-24042024-11-0114917010.48264/VVSIEV-20243609DEFINING RISK CURVES IN FEASIBILITY ANALYSES OF URBAN REGENERATION PROJECTS WITH MONTE CARLO METHODNicholas Fiorentini0Diego Mariotti1Massimo Rovai2Department of Civil and Industrial Engineering (DICI), The University of Pisa, Largo Lucio Lazzarino, 1, 56122, Pisa, ItalyDepartment of Civil and Industrial Engineering (DICI), The University of Pisa, Largo Lucio Lazzarino, 1, 56122, Pisa, ItalyDepartment of Civil and Industrial Engineering (DICI), The University of Pisa, Largo Lucio Lazzarino, 1, 56122, Pisa, ItalyUrban regeneration projects offer numerous community benefits, such as improved housing quality and public spaces, but they also carry risks due to uncertainties in key variables for financial analysis, particularly in Discounted Cash Flow Analysis (DCFA). This research presents a practical tool developed in MS Excel that exploits the Monte Carlo method to quantify the risk of loss of value in these projects. Additionally, innovative Risk Curves are introduced to help investors assess the risks based on specified uncertainties in input variables. Focusing on the urban regeneration of the “Mercato del Carmine” in Lucca (Italy), and following EU project evaluation guidelines, a sensitivity analysis identified critical input variables. The financial sustainability of the project was then assessed using indicators such as Net Present Value (NPV), Internal Rate of Return (IRR), Payback Period (PP), and Productivity Index (PI). The DCFA confirmed the economic viability of the project. Monte Carlo simulations revealed key variables contributing to a significant risk of value loss, with results showing S-shaped Risk Curves. These curves indicate an acceptable tolerance for variations up to 10 percent in inputs related to initial investments, operating costs, and revenues, but show increasing risks with higher variations. This study highlights the value of Monte Carlo simulations in understanding the impact of uncertainty on regeneration project outcomes. The Excel-based tool provides decision-makers with a practical and user-friendly solution for making more informed choices regarding investment risks in urban regeneration projects. https://siev.org/9-36-2024/monte carlo methoddiscounted cash flow analysispublic investmentsrisk analysissensitivity analysisurban regeneration projects |
| spellingShingle | Nicholas Fiorentini Diego Mariotti Massimo Rovai DEFINING RISK CURVES IN FEASIBILITY ANALYSES OF URBAN REGENERATION PROJECTS WITH MONTE CARLO METHOD Valori e Valutazioni monte carlo method discounted cash flow analysis public investments risk analysis sensitivity analysis urban regeneration projects |
| title | DEFINING RISK CURVES IN FEASIBILITY ANALYSES OF URBAN REGENERATION PROJECTS WITH MONTE CARLO METHOD |
| title_full | DEFINING RISK CURVES IN FEASIBILITY ANALYSES OF URBAN REGENERATION PROJECTS WITH MONTE CARLO METHOD |
| title_fullStr | DEFINING RISK CURVES IN FEASIBILITY ANALYSES OF URBAN REGENERATION PROJECTS WITH MONTE CARLO METHOD |
| title_full_unstemmed | DEFINING RISK CURVES IN FEASIBILITY ANALYSES OF URBAN REGENERATION PROJECTS WITH MONTE CARLO METHOD |
| title_short | DEFINING RISK CURVES IN FEASIBILITY ANALYSES OF URBAN REGENERATION PROJECTS WITH MONTE CARLO METHOD |
| title_sort | defining risk curves in feasibility analyses of urban regeneration projects with monte carlo method |
| topic | monte carlo method discounted cash flow analysis public investments risk analysis sensitivity analysis urban regeneration projects |
| url | https://siev.org/9-36-2024/ |
| work_keys_str_mv | AT nicholasfiorentini definingriskcurvesinfeasibilityanalysesofurbanregenerationprojectswithmontecarlomethod AT diegomariotti definingriskcurvesinfeasibilityanalysesofurbanregenerationprojectswithmontecarlomethod AT massimorovai definingriskcurvesinfeasibilityanalysesofurbanregenerationprojectswithmontecarlomethod |