Next Article in Journal
Dynamic Optimization Model for Estimating In-Situ Production Quantity of PC Members to Minimize Environmental Loads
Next Article in Special Issue
Fuzzy TOPSIS Application to Rank Determinants of Employee Retention in Construction Companies: South Korean Case
Previous Article in Journal
Success Factors of Startups in the EU—A Comparative Study
Previous Article in Special Issue
Quality as Driver for Sustainable Construction—Holistic Quality Model and Assessment
 
 
Font Type:
Arial Georgia Verdana
Font Size:
Aa Aa Aa
Line Spacing:
Column Width:
Background:
Article

Cash-Flow Schedules Optimization within Life Cycle Costing (LCC)

1
Civil Engineering Faculty, Warsaw University of Technology; 00-637 Warsaw, Poland
2
Polish Association of Building Managers, 00-688 Warsaw, Poland
*
Author to whom correspondence should be addressed.
Sustainability 2020, 12(19), 8201; https://0-doi-org.brum.beds.ac.uk/10.3390/su12198201
Submission received: 30 August 2020 / Revised: 18 September 2020 / Accepted: 20 September 2020 / Published: 5 October 2020
(This article belongs to the Special Issue Decision Support System and Sustainable Construction Management)

Abstract

:
Investment and construction plans, architectural and construction decisions, and spatial and technology-related decisions made at the early stages of a project have a significant impact on meeting the investment goals and customer expectations. Decision making is a very time-consuming and complicated process (due to the complexity of construction processes). The whole difficulty comes to specifying the appropriate criteria for assessing the given activities, providing answers to the questions of the decision-making bodies. A set of appropriate criteria and mathematical tools (such as computer algorithms with multi-criteria analysis) can significantly improve and accelerate the decision-making process. This article combines ESORD (an IT tool that allows you to compare different types of solutions based on mathematical calculations) with the Monte Carlo method. The developed approach can help the investor to optimize their cash-flow schedule. The original method enables the client to select a construction project variant characterized by the best economical and sustainable parameters, while taking into account customers’ demands.

1. Introduction

One of the most difficult problems faced by project managers/investors is the selection of the best variant of the implementation of a given investment plan. The struggles related to this issue appear already at the investment planning stage, after the expectations and requirements of the investor/client are defined in the functional and operational program. At individual stages of the project life cycle, the analyzed phenomena are very complex, which results mainly from the specific requirements, the complexity of the issues discussed and the nature of the technological and construction processes and the relationship between them [1]. The choices made have a significant impact on the cash-flow schedule of the investment. By cash-flow schedules authors understand timing of different project incomes and outcomes, sometimes with delays and/or acceleration (sometimes also unfavorable) [2]. From an economic perspective, the problem is especially important during the first stages of a construction project. That is because the sooner the decisions are made, the more impact they will have on the life cycle cost and key performance indices of the project [3].
Cash-flow schedules optimization is balancing the required issues, including capital structure, working capital policies, pricing, vendor costs, projects portfolio, etc., all based on the properly prepared operational workflow [2,3].
Decision making is an integral part of any field of art and science. A decision chain is a set of activities that result in the selection of a specific set of activities. Directly involved in the decision-making process is the decision-maker, who expresses specific preferences, assesses the possibilities, forecasts the results, and selects the final variant of further actions [1]. The analysis of the current investment situation is the first challenge that the assessor has to face. A decision-making situation is a set of all elements independent or dependent on the decision-maker that directly contribute to the final result of the intended actions. In the process of formulating a given problem, factors independent of the decision-maker include a set of the so-called conditions limiting the decision (tested and possible variants), while factors dependent on the evaluator include other criteria for evaluating solutions, which are described by the economic and technical indicators most adequate to the decision-making situation, expressed in individual units [1]. The decision on further actions is difficult not only due to the complexity and marking of possibilities, and the degree of complexity of the task, but also due to the client’s expectations. On the other hand, the preferences of the decision-maker largely depend on the point of view of the expert who generated the given assessment or opinion. The authors of this article, having in mind the above description, argue that the computer implementation of the computational algorithms of selected decision-making methods is an effective tool that improves the decision-making process, while obtaining ordered output data. Authors decided to combine multi-criteria decision-making methods with computer simulations in order to provide the investor with the tool for cash-flow schedule optimization. Such a tool will help the client to select a construction project variant characterized by the best economical and sustainable parameters. The method is described in detail in Section 2.3. The results with a case study are presented in Chapter 3. The method takes into account the stochastic character of predicted sales. This aspect of the solution is especially important in times of uncertainty, such as during the current COVID-19 pandemic, as, for example, it helps investors and clients to keep social distance [4].

2. Materials and Methods

2.1. ESORD IT tool

The ESORD IT tool was developed by the authors’ team for optimization of decision making in construction. The principle of ESORD operation is based on the so-called client-server architecture, enabling mutual communication between the client (e.g., user’s computer) and the server (e.g., database systems). The above solution allows the user to access the system from any place (computer) connected to the internet. Installation of the ESORD program is not necessary and does not require the installation of additional software, because ESORD is a website available at http://esord.pl (after login). The client of the system is a user with a computer with any web browser (for example Mozilla Firefox or Internet Explorer) with enabled support for JavaScript and Flash objects. The server part of the ESORD program is based on the following applications:
  • lighttpd web server (serving as an application server, interface between the user and the entire system),
  • PHP programming language (supporting system logic),
  • Smarty templates (supporting the graphic layer),
  • MySQL database,
  • memcached (a cache system that allows you to write data).
The ESORD program distinguishes (recognizes) two types of users, that is:
  • Type I users, the so-called “searching ones”: this group is interested in finding a suitable variant for them (e.g., a building object, a flat). They communicate (define) their preferences to the program by completing the Residential Building Assessment Survey. Based on the completed questionnaire, the program searches for variants using the implemented algorithms of selected multi-criteria evaluation methods (for example, ELECTRE, ideal point, entropy). In the final stage, the results of the performed calculations are generated. Type I users cannot modify internal program structures.
  • Type II users, the so-called “variants creators” (e.g., investments): this group can be identified as representatives of developers who add investment variants to the program. A variant is added by filling in the form available under the “Add variant” tab. After completing this form, the program asks you to fill in the questionnaire concerning this variant; it is the same questionnaire that is filled in by those who are looking for the solution (searching ones), but it does not define expectations. It describes in detail the condition of a given investment. The group of users with these rights has been defined by the program administrator. See screenshot of ESORD at Figure 1.
The subjective preferences specified by the Type I user are compared with the actual properties of the analyzed variants. The ESORD program presents the variants that best meet user expectations. Based on the results of the multi-criteria assessment, the best variant is generated within the framework of the computational algorithms used by the system. Before the actual mathematical calculations are performed, the variants are pre-searched (filtered) on the basis of user-defined general selection criteria (for example, location—the city). ESORD prompts the Type I user to select the calculation methods to be used in the calculation process (such as AHP or fuzzy logic). The user can view the results for individual variants, achieved by different calculation methods, and can also aggregate final results. The calculation methods implemented in the program take, as input data, the vector of weights of the main criteria and the table of standardized grades. The vector of main criteria weights contains the normalized values of user preference scores with respect to the main criteria.
The ESORD IT tool (Expert System of Developer Solutions Assessment) includes kinds, types and groups of criteria introduced into the general system, which have been defined according to the aspect of choosing a flat (house) variant, referring to the preferences of potential buyers and future users [1]. Figure 2 presents the overall block diagram of algorithms used by ESORD, using the variant ranking methods [5,6].
ESORD’s task is to organize the possible variants, using the entire group of implemented algorithms of assessment methods or using only those indicated by the user (decision-maker). This approach has the advantage that the user receives a visual presentation of the results, a table and a classification of the considered variants (using each of the multi-criteria assessment methods) [5].
In order to organize the pages of the project, multi-criteria assessment methods are used: AHP, ELECTRE, weighted sum, ideal point, and the fuzzy logic method. The ESORD software uses the above algorithms and the detailed results of the surveys in order to prioritize the examined criteria [1]. The computer algorithm calculates the main vector of weights for the examined criteria in order to prioritize their fulfillment. To achieve this type of vector of tested parameters (assessments) for the tested criteria: KL—user assessment Type I for the assessment criterion; KIn—user assessment Type I for the criterion technical infrastructure of the facility; KKo—assessment of a Type I user in the category of facility structure criterion; KF—assessment of Type I user for the rooms’ functionality criterion; KS—user Type I assessment for the criterion of the apartment finishing standard; KB—Type I user security assessment; KC—user assessment Type I in the cleanliness and ecology assessment category of the facility; KO—Type I user assessment for attitude towards the object; KK—user Type I assessment under cost category; WL—main weights vector index value for the facility location criterion. The individual weighting reference points are calculated by the formula in Equation [5]:
W N K = K N K K L + K I n + K K o + K F + K S + K B + K C + K O + K K
where:
  • NK—mark (name) of a considered criterion
For example the value of W i L index in relation to the facility location criterion is calculated using the following formula:
W L = K L K L + K I n + K K o + K F + K S + K B + K C + K O + K K
The system does not include the weights value for detailed criteria while calculating the main weights vector. The received results for the main criteria are presented in Table 1.
In fact, investors’ needs (different investors with different attitudes to the risk and specific expectations) have to be taken under consideration and ESORD allows for it. The impact of weight criteria is described by Mashunin in [7,8]. The ESORD methodology has internally implemented calculation algorithms, selected methods of multi-criteria assessment, including methods of passing and weighted credit (sum and weighted sum), the ideal point method, the ELECTRE method, the fuzzy logic calculation method, and the AHP method. Each criterion is assessed in accordance with the following equation:
k i j N K = O i j I N K 2 O i j I I N K 2
where:
  • k i j N K —the value of the assessment itself for the NK criteria (list of indicators and its sub-criteria on the examples below).
  • O i j I N K —assessment of NK assessment observing the guarded exemptions of the user Type I.
  • O i j I I N K —user assessment of NK Type II.
  • n—N unknown sub-criteria strings under a given NK criterion.
The introduction of the system of increasing the score of the variant under consideration to the power is necessary to enable the choice of differentiation of the score. In order to calculate the considered values, the decision possibilities for the ESORD criteria of the considered evaluation are calculated in accordance with the following purchases:
W w N K = n = 1 r k i j N K n n = 1 r max k i j N K n ;         w = 1 , , 10 ,         n = 1 , 2 , r
where:
  • W w N K —evaluation of the “w” variant according to the “NK” criteria
It is worth mentioning that during the creation of the algorithm system, the basic analysis for the assessment of residential buildings was separated and shaped (Table 2), along with the prioritization of the requirements of future tenants [6].

2.2. Monte Carlo Method

The use of simulation techniques makes it possible to increase the accuracy of the estimates of the effect of various scenarios on the project parameters. The most frequently used simulation is the Monte Carlo method, which enables the numerical simulation of various types of phenomena, in which there are input and output variables, but whose analytical description is complex. The essence of the Monte Carlo technique is the numerical determination of the cumulative distribution function for the value of the output variable using the probability density function assigned to the values of the input variables [9].
In simple terms, the Monte Carlo simulation technique consists of randomly selecting the values of the input variables, subject to the assumed probability distributions, and then calculating the value of the output variable. Repeated iteration of this procedure leads to the mapping of the probability distribution of the output variable. Monte Carlo simulation is an extremely useful and comprehensive form of probability analysis. It is based on the assumption that individual risk-related factors can be described by probability distributions. The name Monte Carlo refers to games based on repeated random attempts, such as roulette or dice [10].
The simulation model in the Monte Carlo method may be presented in the form of a spreadsheet, presenting, for example, an analysis of the duration of activities or a financial model of an investment project. This model is analyzed many times (usually 100 to 100,000 times). In each iteration (simulated process flow), the generated random number is assigned to the project parameters, in accordance with the assumed probability distribution. The results of the analysis are presented in the form of the resulting probability distribution. Using the Monte Carlo simulation technique, for each examined factor a histogram is obtained for various scenarios of materialization of the identified risk factors of the project [11].

2.3. Net Present Value

The most commonly used criteria for assessing the economic efficiency of projects, including construction projects, is net present value (NPV) [3,12,13,14]. NPV can be presented in several different ways and is calculated as the difference between the current value of the flow of inflows i 0 , i 1 , i 2 , , i T and the current value of the expenditure stream e 0 , e 1 , e 2 , , e T or net cash flow (NCFt) for the period from the present moment (t = 0) to the planning horizon (T):
N P V = t = 0 T i t 1 + r t t = 0 T e t 1 + r t = t = 0 T i t e t 1 + r t = t = 0 T N C F t 1 + r t = t = 0 T N C F t δ t
where r is an interest rate, δ is a discount rate, and:
1 ( 1 + r ) t = δ t .
The calculated NPV value can be interpreted, for example, as a surplus of net present revenues over the incurred initial expenditures or the investor’s profit resulting from the implementation of the investment, taking into account changes in the value of money over time. NPV provides premises for making investment decisions. Most often a project is accepted if its NPV > 0 and rejected if NPV < 0. Projects with NPV = 0 are treated as neutral. It is important to mention information asymmetries, which strongly influence the value of NPV [15].

2.4. Original Method

The original method consists of several steps. At first, a basic cash-flow schedule is created for the construction project. It has a form of a spreadsheet with supporting documents. Then several variants of construction projects are tested and compared with the use of the ESORD IT tool to establish their scores. These assessments affect the expected probability with which potential customers are willing to buy/rent a flat or commercial premises in the analyzed facility. The spreadsheet is updated with additional variants, their scores, and time and cost data. Probability distributions are assigned to the sales forecast.
The decision variable in the resulting model is the number (ID) of the selected project variant. The assumptions subject to a probability distribution are rental of the office and residential space (sales). Having developed a computational model, Monte Carlo simulations are performed to determine the probability distribution of cash flows and NPV of the project implementation.
Several approaches can be used to select the final project variant. For example, selecting the project with the highest expected NPV (aggressive investor) or selecting the project that has the greatest chance of obtaining a positive NPV (conservative investor) [16]. In Chapter 3 a case study is presented to show the effectiveness of the method.

3. Results

The investor has a possibility to construct a residential building. Ten different localizations and variants (in accordance with the spatial development plan) are taken into consideration. The considered variants are presented in Table 3. The elaborated data is available in [1]. The calculations were made in an Excel spreadsheet with the use of OptQuest® Engine, OptTek Systems, Inc.
Taking into account the ESORD calculation methodology, the IT system generated the results of selecting specific investment options, subject to balanced demand assessments. The method also allows for portfolio optimization, when an investor would like to get involved in more than one investment [17]. Table 4 provides a visual representation of the evaluation of variants generated by computer algorithms for a specific evaluation methodology.
Final scores obtained by the ESORD software were later used to make predictions of sales. The better the score, the higher probability of customers renting a flat or office space.
On the basis of the collected data, cash-flow schedules were created. Sample NPV calculations are presented in Figure 3. In the presented case, NPV was calculated for the period of 15 years and the final score is presented in the right-lower corner of the figure. The discount rate used for the example calculation was 4%.
ESORD scores were normalized (scale from −1 to 1) and Beta PERT distribution was used to modify predicted likeliness of customers renting premises. Sample distributions are presented in Figure 4.
After completing the spreadsheet and modeling non-deterministic parameters, computational simulations were started. In the considered case, it was decided to optimize the financial schedule by maximizing the expected NPV. For comparison, the likelihood of obtaining a positive NPV was also maximized. The best results are presented in Figure 5 and Figure 6. The forecast data percentiles comparison of the two best variants is presented in Table 5. Statistics of the results are compared in Table 6.
The last step of the procedure assumes the selection of the final project variant. The presented solutions correspond to the choices of the aggressive investor (variant 6) and the conservative investor (variant 8).

4. Discussion

The proposed approach integrates the utility and sustainability assessment tool (ESORD) with cash-flow schedules and the Monte Carlo method. Thanks to the developed approach, investors are able to optimize their decisions obtaining the best results. Importantly, the approach allows users to adjust the approach to the assumptions of the decision-maker, allowing you to make a decision that corresponds to the character of the investor (e.g., aggressive or conservative approach). Due to its stochastic nature, the procedure can be particularly useful in uncertain times, allowing traders to analyze the whole range of possible events. Future research in the discussed field can be related to other important elements of decision making [18]: for example, how to incorporate the investor’s risk acceptance level, more detailed characteristics of investors, etc.

Author Contributions

Conceptualization, M.K.-N. and J.R.; methodology, P.N.; software, M.K.-N., J.Z., P.N. and J.R.; validation, M.K.-N.; formal analysis, P.N.; investigation, M.K.-N., J.Z., P.N. and J.R.; resources, M.K.-N., J.Z., P.N. and J.R.; data curation, M.K.-N., J.Z., P.N. and J.R.; writing—original draft preparation, M.K.-N., J.Z., P.N. and J.R.; writing—review and editing, M.K.-N., J.Z., P.N. and J.R.; visualization, J.R.; supervision, M.K.-N. All authors have read and agreed to the published version of the manuscript.

Funding

This research received no external funding.

Conflicts of Interest

The authors declare no conflict of interest.

References

  1. Książek, M.V.; Nowak, P.; Kivrak, S.; Rosłon, J.; Ustinovichius, L. COMPUTER-AIDED DECISION-MAKING IN CONSTRUCTION PROJECT DEVELOPMENT. J. Civ. Eng. Manag. 2015, 21, 248–259. [Google Scholar] [CrossRef] [Green Version]
  2. Iyer, K.C.; Kumar, R. Impact of Delay and Escalation on Cash Flow and Profitability in a Real Estate Project. Procedia Eng. 2016, 145, 388–395. [Google Scholar] [CrossRef] [Green Version]
  3. Rosłon, J. Optymalizacja Harmonogramu Przedsięwzięcia Budowlanego z Uwzględnieniem Koncepcji Zarządzania Wartością Przedmiotu Inwestycji. Ph.D. Thesis, Warsaw University of Technology, Warsaw, Poland, 2020. [Google Scholar]
  4. Huynh, T.L.D. Does culture matter social distancing under the COVID-19 pandemic? Saf. Sci. 2020, 130, 104872. [Google Scholar] [CrossRef] [PubMed]
  5. Książek, M. Wielokryterialna Ocena Rozwiazan Projektowych Budynków [Multi-Criteria Evaluation of Building Design Solutions]. Ph.D. Thesis, Wydawnictwa Politechniki Warszawskiej, Warsaw, Poland, 2010; p. 241. (In Polish). [Google Scholar]
  6. Książek, M. Ekspercki system oceny rozwiazan deweloperskich–wykorzystanie praktyczne [Expert evaluation system development solutions–use in practice]. In Proceedings of the Theoretical Foundations of Civil Engineering, Polish-Ukrainian Transactions, Krym, Ukraine, 13–17 September 2010; CD. Volume 18. (In Polish). [Google Scholar]
  7. Mashunin, Y.K. Theory and Methods of Vector Optimization; Cambridge Scholars Publishing: London, UK, 2020; Volume 1, p. 183. [Google Scholar]
  8. Mashunin, K.Y.; Mashunin, Y.K. Vector optimization with equivalent and priority criteria. J. Comput. Syst. Sci. Int. 2017, 56, 975–996. [Google Scholar] [CrossRef]
  9. Rosłon, J.; Zawistowski, J. Construction Projects’ Indicators Improvement Using Selected Metaheuristic Algorithms. Procedia Eng. 2016, 153, 595–598. [Google Scholar] [CrossRef] [Green Version]
  10. Zawistowski, J. Application of modified earned value method for assessing the risk and progress of construction projects. In Modern Building Materials, Structures and Techniques. In Proceedings of the International Conference Vilnius Gediminas Technical University, Department of Construction Economics & Property, Vilnius, Lithuania, 19–21 May 2010; Volume 10, p. 557. [Google Scholar]
  11. Anysz, H.; Zawistowski, J. Cost minimization of locating construction machinery park with the use of simulation and optimization algorithms. In Proceedings of the MATEC Web of Conferences; EDP Sciences: Warsaw, Poland, 2018; Volume 196, p. 4088. [Google Scholar]
  12. Rosłon, J.; Kulejewski, J.E. A hybrid approach for solving multi-mode resource-constrained project scheduling problem in construction. Open Eng. 2019, 9, 7–13. [Google Scholar] [CrossRef]
  13. Mari, C. Stochastic NPV Based vs Stochastic LCOE Based Power Portfolio Selection Under Uncertainty. Energies 2020, 13, 3677. [Google Scholar] [CrossRef]
  14. Ye, S.; Tiong, R.L.K. NPV-at-Risk Method in Infrastructure Project Investment Evaluation. J. Constr. Eng. Manag. 2000, 126, 227–233. [Google Scholar] [CrossRef]
  15. Huynh, T.L.D.; Wu, J.; Duong, A.T. Information Asymmetry and firm value: Is Vietnam different? J. Econ. Asymmetries 2020, 21, e147. [Google Scholar] [CrossRef]
  16. Ustinovichius, L.; Zavadskas, E.; Migilinskas, D.; Malewska, A.; Nowak, P.; Minasowicz, A. Verbal analysis of risk elements in construction contracts. In Proceedings of the 3rd International Conference, CDVE 2006, Mallorca, Spain, 17–20 September 2006; Springer: Berlin/Heidelberg, Germany, 2006; pp. 295–302. [Google Scholar]
  17. Nguyen, S.P.; Huynh, T.L.D. Portfolio optimization from a Copulas-GJRGARCH-EVT-CVAR model: Empirical evidence from ASEAN stock indexes. Quant. Financ. Econ. 2019, 3, 562. [Google Scholar] [CrossRef]
  18. Huynh, T.L.D. Replication: Cheating, loss aversion, and moral attitudes in Vietnam. J. Econ. Psychol. 2020, 78, 102277. [Google Scholar] [CrossRef]
Figure 1. Main screen of the ESORD IT tool [own source].
Figure 1. Main screen of the ESORD IT tool [own source].
Sustainability 12 08201 g001
Figure 2. ESORD algorithm—assessment of decision variants.
Figure 2. ESORD algorithm—assessment of decision variants.
Sustainability 12 08201 g002
Figure 3. Sample cash flow and NPV calculations [own source].
Figure 3. Sample cash flow and NPV calculations [own source].
Sustainability 12 08201 g003
Figure 4. Sample distributions modifying predicted sales: (a) Variant 1—highest ESORD score; (b) Variant 9—lowest ESORD score [own source].
Figure 4. Sample distributions modifying predicted sales: (a) Variant 1—highest ESORD score; (b) Variant 9—lowest ESORD score [own source].
Sustainability 12 08201 g004
Figure 5. NPV forecast: maximizing the final value of net present value (NPV)—best variant—6. [own source].
Figure 5. NPV forecast: maximizing the final value of net present value (NPV)—best variant—6. [own source].
Sustainability 12 08201 g005
Figure 6. NPV forecast: maximizing the probability that NPV is greater than or equal to € 0.00—best variant—8.
Figure 6. NPV forecast: maximizing the probability that NPV is greater than or equal to € 0.00—best variant—8.
Sustainability 12 08201 g006
Table 1. The main criteria weights vector.
Table 1. The main criteria weights vector.
CriterionWeightCriterionWeight
Facility location0.143Safety0.143
Technical infrastructure of the facility0.107Ecology and cleanness of the facility0.107
Facility structure0.036Attitude towards the facility0.107
Rooms’ functionality0.143Costs0.107
Apartment’s finishing standard0.107
Table 2. The basic group of criteria used for assessment of residential construction facilities [1].
Table 2. The basic group of criteria used for assessment of residential construction facilities [1].
A. Facility Location B. Technical Infrastructure of the Facility C. Facility Structure D. Rooms’ Functionality
A.1. City infrastructure (transport)
A.1.1. Subway (distance up to 1 km)
A.1.2. City train (distance up to 1 km)
A.1.3. Tramways (distance up to 1 km)
A.1.4. Buses distance up to 1 km)
B.1. Number of lifts in one stairway
B.1.1. Number of floors below 5 (except ground floor and underground) (1 lift)
B.1.2. –//– (2 lifts),
B.1.3. –//– (none)
B.1.4. Number of floors below 5 (except ground floor and underground) (1 lift),
B.1.5. –//– (2 lifts)
C 1. WallD.1. Ergonomics of the rooms
D.1.1. Shape of rooms similar to square—easy to arrange
D.1.2. Niche for a wardrobe in the hall
D.1.3. Niche for a refrigerator in the kitchen
D.1.4. Other facilities (wardrobe, utility room, etc.)
D.1.5. Shape of rooms similar to a rectangle (long and narrow)
C 2. Backbone
C 3. Mixed
A.2. Social infrastructure (service and education facilities)
A.2.1. Shopping and service facilities (food store, fair, market) up to 200 m
A.2.2. Education facilities (school, kindergarten, playground)
up to 200 m
B.2. Car park
B.2.1. By the building,
B.2.2. Guarded car park
B.2.3. Park place inside the facility /multi-level car park,
B.2.4. Other place
D.2. Height of the floors in residential premises
D.2.1. Up to 2.70 m
D.2.2. 2.71–2.90 m
D.2.3. Over 2.90 m
A3. Surrounding
A.3.1. Recreation areas (park, woods, lake, etc.) distance up to 1 km
A.3.2. Highway—distance up to 1 km
A.3.3. Recreation and sports centers—distance up to 1 km
A.3.4. Production plant (e.g., factory) with certain nuisance degree—distance up to 1 km
B.3. IT Telecommunication connections
B.3.1. Cable phone,
B.3.2. Cable TV,
B.3.3. Internet
B.3.4. Others
E. Apartment’s Finishing StandardF. SafetyG. Sustainability of the FacilityH. Attitude towards the FacilityI. Costs
E.1. Internal walls
E.1.1. Plaster + paint
E.1.2. Plaster E 1.3. other solution
E.2. Ceilings
E.2.1. Plaster + paint
E.2.2. Plaster
E.2.3. Other solution
F.1. Staircase
F.1.1. Entry phone
F.1.2. Videophone
F.2. Entry door to the apartment
F.2.1. Ordinary
F.2.2. Anti-burglary
G.1. Frequency of cleaning inside the facility
G.1.1. All working days
G.1.2. Three times a week
G.1.3. Two times a week
G.1.4. Other
H.1. Aesthetics of the facility exteriors
H.1.1. Plaster elevation
H.1.2. Glass elevation
H.1.3. Natural stone elevation
H.1.4. Other solution
I.1. Purchase price and utilization price
I.1.1. Sales price for 1 sq.m. of usable space of the building
I.1.2. The expected costs of utilization of the facility for 1 sq.m. of usable space of the building
I.1.3. Other costs
E.3. Floors
E.3.1. Made of plastics
E.3.2. Made of wood
E.3.3. Made of ceramic materials E.3.4. Made of stone materials
E.3.5. No finishing
F.3. Building security
F.3.1. Receptionist inside the building
F.3.2. Guard at the entrance to the building
F.3.3. 24 h patrols of local security
F.3.4. Closed housing estate
F.3.5. Police precinct (distance—1 km)
G.2. Ecology
G.2.1. Waste selection
G.2.2. Electric energy saving devices in the facility (energy saving bulbs, movement sensors)
G.2.3. Water saving devices in the facility (meters)
G.2.4. Protection against noise
G.2.5. Water processing plant G.2.6. Solar batteries
G.2.7. Other solutions
H.2. Comfortable use of the premises
H.2.1. Feeling of satisfaction and comfort
H.2.2. Feeling of safety
H.2.3. Other impressions
E.4. Window sills
E.4.1. Made of plastics (for example conglomerate)
E.4.2. Made of stone materials (for example marble)
E.4.3. Metal
E.4.4. Wooden
E.4.5. Other
Table 3. Analyzed variants of the investment.
Table 3. Analyzed variants of the investment.
Variants
Name: Variant 1  City: Warsaw
Area: Boremlowska 51
Average living area (m2): 46
Average rent per m2: 49 EUR/month
No. of flats: 190  Cost: 16.5 M EUR
Sample visualizations:
Sustainability 12 08201 i001
Sustainability 12 08201 i002
Name: Variant 2  City: Warsaw
Area: Kłopotowskiego 7
Average living area (m2): 78
Average rent per m2: 46 EUR/month
No. of flats: 150  Cost: 20 M EUR
Sample visualizations:
Sustainability 12 08201 i003
Sustainability 12 08201 i004
Name: Variant 3  City: Warsaw
Area: Grochowska 309
Average living area (m2): 84
Average rent per m2: 39 EUR/month
No. of flats: 680  Cost: 75 M EUR
Sample visualizations:
Sustainability 12 08201 i005
Sustainability 12 08201 i006
Name: Variant 4  City: Warsaw
Area: Bernardyńska 8
Average living area (m2): 56
Average rent per m2: 41 EUR/month
No. of flats: 150  Cost: 9 M EUR
Sample visualizations:
Sustainability 12 08201 i007
Sustainability 12 08201 i008
Name: Variant 5  City: Warsaw
Area: Broniewskiego 68
Average living area (m2): 55
Average rent per m2: 40 EUR/month
No. of flats: 210  Cost: 12.5 M EUR
Sample visualizations:
Sustainability 12 08201 i009
Sustainability 12 08201 i010
Name: Variant 6  City: Warsaw
Area: Radiowa 16
Average living area (m2): 76
Average rent per m2: 37 EUR/month
No. of flats: 450  Cost: 40 M EUR
Sample visualizations:
Sustainability 12 08201 i011
Sustainability 12 08201 i012
Name: Variant 7  City: Warsaw
Area: Polna 7
Average living area (m2): 42
Average rent per m2: 46 EUR/month
No. of flats: 150  Cost: 9 M EUR
Sample visualizations:
Sustainability 12 08201 i013
Sustainability 12 08201 i014
Name: Variant 8  City: Warsaw
Area: Alternatywy 4
Average living area (m2): 69
Average rent per m2: 42 EUR/month
No. of flats: 110  Cost: 9.625 M EUR
Sample visualizations:
Sustainability 12 08201 i015
Sustainability 12 08201 i016
Name: Variant 9  City: Warsaw
Area: Wspólna 41
Average living area (m2): 65
Average rent per m2: 45 EUR/month
No. of flats: 160  Cost: 17.5 M EUR
Sample visualizations:
Sustainability 12 08201 i017
Sustainability 12 08201 i018
Name: Variant 10  City: Warsaw
Area: Zamieniecka 8
Average living area (m2): 82
Average rent per m2: 49 EUR/month
No. of flats: 110  Cost: 12 M EUR
Sample visualizations:
Sustainability 12 08201 i019
Sustainability 12 08201 i020
Table 4. The collective presentation of variant assessments for all methods and final score.
Table 4. The collective presentation of variant assessments for all methods and final score.
VariantWeighted AverageAverageIdeal PointElectreFuzzy LogicAHPFinal Score
10.1140.1150.1230.1720.1200.121518
20.1070.1060.1160.2070.1120.104409
30.0910.0930.0920.00010.0770.09010
40.0970.0970.1050.00010.1040.09571
50.0970.0980.0740.1380.0840.09667
60.1020.1000.0990.0340.0960.102120
70.1050.1040.1150.1030.1180.101286
80.1020.1010.1020.1030.1130.104194
90.0830.0840.0630.00010.0570.0840
100.1030.1030.1100.2410.1210.102320
Table 5. NPV forecast—percentiles comparison.
Table 5. NPV forecast—percentiles comparison.
PercentilesForecast Values—Variant 6Forecast Values—Variant 8
0% € −2,485,290.30 € −263,575.36
10% € −384,060.74 € 637,532.01
20%€ 474,991.99€ 982,691.91
30%€ 1,205,920.74€ 1,266,688.35
40%€ 1,882,102.82€ 1,520,634.29
50%€ 2,514,830.58€ 1,753,883.31
60%€ 3,185,442.91€ 2,017,660.81
70%€ 3,889,059.27€ 2,277,573.71
80%€ 4,766,356.07€ 2,567,897.49
90%€ 5,852,536.29€ 2,968,311.24
100%€ 9,840,775.14€ 4,090,146.43
Table 6. NPV forecast statistics.
Table 6. NPV forecast statistics.
StatisticsForecast Values—Variant 6Forecast Values—Variant 8
Trials10,00010,000
Base case€ 580,141.89€ 1,691,905.78
Mean€ 2,638,797.81€ 1,785,113.04
Median€ 2,514,842.14€ 1,754,597.81
Standard deviation€ 2,341,475.23€ 867,874.75
Variance€ 5,482,506,257,658.74€ 753,206,577,194.92
Skewness0.22990.1155
Kurtosis2.422.35
Coeff. of variability0.88730.4862
Minimum € −2,485,290.30 €−263,575.36
Maximum€ 9,840,775.14€ 4,090,146.43
Range width€ 12,326,065.44€ 4,353,721.79
Mean std. error€ 23,414.75€ 8,678.75

Share and Cite

MDPI and ACS Style

Rosłon, J.; Książek-Nowak, M.; Nowak, P.; Zawistowski, J. Cash-Flow Schedules Optimization within Life Cycle Costing (LCC). Sustainability 2020, 12, 8201. https://0-doi-org.brum.beds.ac.uk/10.3390/su12198201

AMA Style

Rosłon J, Książek-Nowak M, Nowak P, Zawistowski J. Cash-Flow Schedules Optimization within Life Cycle Costing (LCC). Sustainability. 2020; 12(19):8201. https://0-doi-org.brum.beds.ac.uk/10.3390/su12198201

Chicago/Turabian Style

Rosłon, Jerzy, Mariola Książek-Nowak, Paweł Nowak, and Jacek Zawistowski. 2020. "Cash-Flow Schedules Optimization within Life Cycle Costing (LCC)" Sustainability 12, no. 19: 8201. https://0-doi-org.brum.beds.ac.uk/10.3390/su12198201

Note that from the first issue of 2016, this journal uses article numbers instead of page numbers. See further details here.

Article Metrics

Back to TopTop