Risk-assessment V1.0: A new interactive software to develop risk assessment using MATLAB®
This article presents the use of an interactive computer tool developed in MATLAB® called RISKASSESSMENT v1.0, to perform market risk analysis of commercial products, through the development of cash flow, sensitivity analysis, and SpiderPlot graphics, which allow the identification of the economic-f...
- Autores:
-
Cardenas Escorcia, Yulineth del Carmen
Valencia Ochoa, Guillermo Eliecer
Cardenas, Javier
- Tipo de recurso:
- Article of journal
- Fecha de publicación:
- 2018
- Institución:
- Corporación Universidad de la Costa
- Repositorio:
- REDICUC - Repositorio CUC
- Idioma:
- eng
- OAI Identifier:
- oai:repositorio.cuc.edu.co:11323/1758
- Acceso en línea:
- http://hdl.handle.net/11323/1758
https://repositorio.cuc.edu.co/
- Palabra clave:
- Risk assessment
interactive software
MATLAB®
sensitivity analysis
cash flow
spider graphs
- Rights
- openAccess
- License
- Atribución – No comercial – Compartir igual
| id |
RCUC2_ef84003d3732ebc94b5bbf6e138810a5 |
|---|---|
| oai_identifier_str |
oai:repositorio.cuc.edu.co:11323/1758 |
| network_acronym_str |
RCUC2 |
| network_name_str |
REDICUC - Repositorio CUC |
| repository_id_str |
|
| dc.title.eng.fl_str_mv |
Risk-assessment V1.0: A new interactive software to develop risk assessment using MATLAB® |
| title |
Risk-assessment V1.0: A new interactive software to develop risk assessment using MATLAB® |
| spellingShingle |
Risk-assessment V1.0: A new interactive software to develop risk assessment using MATLAB® Risk assessment interactive software MATLAB® sensitivity analysis cash flow spider graphs |
| title_short |
Risk-assessment V1.0: A new interactive software to develop risk assessment using MATLAB® |
| title_full |
Risk-assessment V1.0: A new interactive software to develop risk assessment using MATLAB® |
| title_fullStr |
Risk-assessment V1.0: A new interactive software to develop risk assessment using MATLAB® |
| title_full_unstemmed |
Risk-assessment V1.0: A new interactive software to develop risk assessment using MATLAB® |
| title_sort |
Risk-assessment V1.0: A new interactive software to develop risk assessment using MATLAB® |
| dc.creator.fl_str_mv |
Cardenas Escorcia, Yulineth del Carmen Valencia Ochoa, Guillermo Eliecer Cardenas, Javier |
| dc.contributor.author.spa.fl_str_mv |
Cardenas Escorcia, Yulineth del Carmen Valencia Ochoa, Guillermo Eliecer Cardenas, Javier |
| dc.subject.eng.fl_str_mv |
Risk assessment interactive software MATLAB® sensitivity analysis cash flow spider graphs |
| topic |
Risk assessment interactive software MATLAB® sensitivity analysis cash flow spider graphs |
| description |
This article presents the use of an interactive computer tool developed in MATLAB® called RISKASSESSMENT v1.0, to perform market risk analysis of commercial products, through the development of cash flow, sensitivity analysis, and SpiderPlot graphics, which allow the identification of the economic-financial equilibrium point of a company. The tool facilitates the reduction of the uncertainty produced in the return on investment due to changes in the economic environment of the sector in which the company operates, through statistical techniques and tools that involve parameters such as the annual effective rate in the Colombian national currency, net present value, internal rate of return, period of recovery of capital, through a sensitivity analysis. To validate the effectiveness of using software in the development of risk analysis, a case study was conducted for an alcohol beverage sales business, where, based on the portfolio containing the product quantity, unit variable cost, sales price, percentage of sales growth and annual sales volume, in addition to detailed information on the initial investment, the cash flow with a 5-year horizon, the net present value, the internal rate of return, the period of capital recovery and the average accounting profitability are calculated. The tool also performs sensitivity analysis and SpiderPlot for each of the products. Finally, the program presented allows to calculate the annual cash flows in a fast and didactic way, which normally requires time and specialized training in a traditional exercise. |
| publishDate |
2018 |
| dc.date.accessioned.none.fl_str_mv |
2018-11-23T19:26:55Z |
| dc.date.available.none.fl_str_mv |
2018-11-23T19:26:55Z |
| dc.date.issued.none.fl_str_mv |
2018 |
| dc.type.spa.fl_str_mv |
Artículo de revista |
| dc.type.coar.fl_str_mv |
http://purl.org/coar/resource_type/c_2df8fbb1 |
| dc.type.coar.spa.fl_str_mv |
http://purl.org/coar/resource_type/c_6501 |
| dc.type.content.spa.fl_str_mv |
Text |
| dc.type.driver.spa.fl_str_mv |
info:eu-repo/semantics/article |
| dc.type.redcol.spa.fl_str_mv |
http://purl.org/redcol/resource_type/ART |
| dc.type.version.spa.fl_str_mv |
info:eu-repo/semantics/acceptedVersion |
| format |
http://purl.org/coar/resource_type/c_6501 |
| status_str |
acceptedVersion |
| dc.identifier.issn.spa.fl_str_mv |
2283-9216 |
| dc.identifier.uri.spa.fl_str_mv |
http://hdl.handle.net/11323/1758 |
| dc.identifier.instname.spa.fl_str_mv |
Corporación Universidad de la Costa |
| dc.identifier.reponame.spa.fl_str_mv |
REDICUC - Repositorio CUC |
| dc.identifier.repourl.spa.fl_str_mv |
https://repositorio.cuc.edu.co/ |
| identifier_str_mv |
2283-9216 Corporación Universidad de la Costa REDICUC - Repositorio CUC |
| url |
http://hdl.handle.net/11323/1758 https://repositorio.cuc.edu.co/ |
| dc.language.iso.none.fl_str_mv |
eng |
| language |
eng |
| dc.relation.references.spa.fl_str_mv |
Barrozo F, Valencia G, C. Y. (2017) ‘An Economic Evaluation of Renewable and Conventional Electricity Generation Systems in a Shopping Center Using HOMER Pro®’, Contemporary Engineering Sciences, 10, pp. 1287–1295. DOI: 10.12988/ces.2017.710149. 161 Dugarte, E. (2015) ‘Diseño de una metodología automatizada para la evaluación financiera de proyectos de inversión en activos fijos bajo condiciones de riesgo e incertidumbre’, PhD Proposal, 1, p. 292. DOI: 10.1017/CBO9781107415324.004. Fontaine, M. (2016) ‘Project Risk Management’, in Enterprise Risk Management, pp. 47–58. DOI: 10.1016/B978-0-12-800633-7.00004-3 García Ruiz, F. A. (2009) ‘Caracterizacion y Análisis de Modelos de Evaluacion Económica de Proyectos de Inversion bajo Incertidumbre’, Revista Ingeniería Industrial - Universidad del Bío-Bío, 8(1), pp. 35–50. ISSN: 0717-9103. Koltsaklis, N.E., Dagoumas, A.S., Kopanos, G.M., Pistikopoulos, E.N., Georgiadis, M. C. (2013) ‘A mathematical programming approach to the optimal long-term national energy planning’, Chemical Engineering Transactions, 35, pp. 625–630. DOI: 10.3303/CET1335104. Newman, D. G. (2004) Engineering Economic Analysis. 9th edn. ISBN: 978-0199339273 Paquin, J. P., Gauthier, C. and Morin, P. P. (2016) ‘The downside risk of project portfolios: The impact of capital investment projects and the value of project efficiency and project risk management programmes’, International Journal of Project Management. Elsevier Ltd and Association for Project Management and the International Project Management Association, 34(8), pp. 1460–1470. DOI: 10.1016/j.ijproman.2016.07.009. Valencia, Guillermo E et al. 2017. “Energy Saving in Industrial Process Based on the Equivalent Production Method to Calculate Energy Performance Indicators.” 57: 709–14. DOI: 10.3303/CET1757119. Valera A., Soriano A., M. V. (2014) ‘Low-Cost Platforms for Realization of Mechatronics and Robotics Practical Works’, Revista Iberoamericana de Automática e Informática Industrial RIAI, 11, pp. 363–376. DOI: 10.1016/j.riai.2014.09.002. |
| dc.rights.spa.fl_str_mv |
Atribución – No comercial – Compartir igual |
| dc.rights.accessrights.spa.fl_str_mv |
info:eu-repo/semantics/openAccess |
| dc.rights.coar.spa.fl_str_mv |
http://purl.org/coar/access_right/c_abf2 |
| rights_invalid_str_mv |
Atribución – No comercial – Compartir igual http://purl.org/coar/access_right/c_abf2 |
| eu_rights_str_mv |
openAccess |
| dc.publisher.spa.fl_str_mv |
Chemical Engineering Transactions |
| institution |
Corporación Universidad de la Costa |
| bitstream.url.fl_str_mv |
https://repositorio.cuc.edu.co/bitstream/11323/1758/1/Risk-assessment%20V1.0%20A%20new%20interactive%20software%20to%20develop%20risk%20assessment%20using%20MATLAB.pdf https://repositorio.cuc.edu.co/bitstream/11323/1758/2/license.txt https://repositorio.cuc.edu.co/bitstream/11323/1758/4/Risk-assessment%20V1.0%20A%20new%20interactive%20software%20to%20develop%20risk%20assessment%20using%20MATLAB.pdf.jpg https://repositorio.cuc.edu.co/bitstream/11323/1758/5/Risk-assessment%20V1.0%20A%20new%20interactive%20software%20to%20develop%20risk%20assessment%20using%20MATLAB.pdf.txt |
| bitstream.checksum.fl_str_mv |
3e37f85549218a947e5704eedcee1ee0 8a4605be74aa9ea9d79846c1fba20a33 522e90fb5135c5f4d844ff64f9a70b53 ef712c47d0f6922fa7237731d107ae55 |
| bitstream.checksumAlgorithm.fl_str_mv |
MD5 MD5 MD5 MD5 |
| repository.name.fl_str_mv |
Repositorio Universidad de La Costa |
| repository.mail.fl_str_mv |
bdigital@metabiblioteca.com |
| _version_ |
1808400032404078592 |
| spelling |
Cardenas Escorcia, Yulineth del Carmen03fd6a99d8c63fdc544119cb52765c40Valencia Ochoa, Guillermo Eliecerf48e278e72fed2f5937be19a6c38767eCardenas, Javierdba1a0451f3ba94b99b3e7dc52ad0ed32018-11-23T19:26:55Z2018-11-23T19:26:55Z20182283-9216http://hdl.handle.net/11323/1758Corporación Universidad de la CostaREDICUC - Repositorio CUChttps://repositorio.cuc.edu.co/This article presents the use of an interactive computer tool developed in MATLAB® called RISKASSESSMENT v1.0, to perform market risk analysis of commercial products, through the development of cash flow, sensitivity analysis, and SpiderPlot graphics, which allow the identification of the economic-financial equilibrium point of a company. The tool facilitates the reduction of the uncertainty produced in the return on investment due to changes in the economic environment of the sector in which the company operates, through statistical techniques and tools that involve parameters such as the annual effective rate in the Colombian national currency, net present value, internal rate of return, period of recovery of capital, through a sensitivity analysis. To validate the effectiveness of using software in the development of risk analysis, a case study was conducted for an alcohol beverage sales business, where, based on the portfolio containing the product quantity, unit variable cost, sales price, percentage of sales growth and annual sales volume, in addition to detailed information on the initial investment, the cash flow with a 5-year horizon, the net present value, the internal rate of return, the period of capital recovery and the average accounting profitability are calculated. The tool also performs sensitivity analysis and SpiderPlot for each of the products. Finally, the program presented allows to calculate the annual cash flows in a fast and didactic way, which normally requires time and specialized training in a traditional exercise.engChemical Engineering TransactionsAtribución – No comercial – Compartir igualinfo:eu-repo/semantics/openAccesshttp://purl.org/coar/access_right/c_abf2Risk assessmentinteractive softwareMATLAB®sensitivity analysiscash flowspider graphsRisk-assessment V1.0: A new interactive software to develop risk assessment using MATLAB®Artículo de revistahttp://purl.org/coar/resource_type/c_6501http://purl.org/coar/resource_type/c_2df8fbb1Textinfo:eu-repo/semantics/articlehttp://purl.org/redcol/resource_type/ARTinfo:eu-repo/semantics/acceptedVersionBarrozo F, Valencia G, C. Y. (2017) ‘An Economic Evaluation of Renewable and Conventional Electricity Generation Systems in a Shopping Center Using HOMER Pro®’, Contemporary Engineering Sciences, 10, pp. 1287–1295. DOI: 10.12988/ces.2017.710149. 161 Dugarte, E. (2015) ‘Diseño de una metodología automatizada para la evaluación financiera de proyectos de inversión en activos fijos bajo condiciones de riesgo e incertidumbre’, PhD Proposal, 1, p. 292. DOI: 10.1017/CBO9781107415324.004. Fontaine, M. (2016) ‘Project Risk Management’, in Enterprise Risk Management, pp. 47–58. DOI: 10.1016/B978-0-12-800633-7.00004-3 García Ruiz, F. A. (2009) ‘Caracterizacion y Análisis de Modelos de Evaluacion Económica de Proyectos de Inversion bajo Incertidumbre’, Revista Ingeniería Industrial - Universidad del Bío-Bío, 8(1), pp. 35–50. ISSN: 0717-9103. Koltsaklis, N.E., Dagoumas, A.S., Kopanos, G.M., Pistikopoulos, E.N., Georgiadis, M. C. (2013) ‘A mathematical programming approach to the optimal long-term national energy planning’, Chemical Engineering Transactions, 35, pp. 625–630. DOI: 10.3303/CET1335104. Newman, D. G. (2004) Engineering Economic Analysis. 9th edn. ISBN: 978-0199339273 Paquin, J. P., Gauthier, C. and Morin, P. P. (2016) ‘The downside risk of project portfolios: The impact of capital investment projects and the value of project efficiency and project risk management programmes’, International Journal of Project Management. Elsevier Ltd and Association for Project Management and the International Project Management Association, 34(8), pp. 1460–1470. DOI: 10.1016/j.ijproman.2016.07.009. Valencia, Guillermo E et al. 2017. “Energy Saving in Industrial Process Based on the Equivalent Production Method to Calculate Energy Performance Indicators.” 57: 709–14. DOI: 10.3303/CET1757119. Valera A., Soriano A., M. V. (2014) ‘Low-Cost Platforms for Realization of Mechatronics and Robotics Practical Works’, Revista Iberoamericana de Automática e Informática Industrial RIAI, 11, pp. 363–376. DOI: 10.1016/j.riai.2014.09.002.ORIGINALRisk-assessment V1.0 A new interactive software to develop risk assessment using MATLAB.pdfRisk-assessment V1.0 A new interactive software to develop risk assessment using MATLAB.pdfapplication/pdf760272https://repositorio.cuc.edu.co/bitstream/11323/1758/1/Risk-assessment%20V1.0%20A%20new%20interactive%20software%20to%20develop%20risk%20assessment%20using%20MATLAB.pdf3e37f85549218a947e5704eedcee1ee0MD51open accessLICENSElicense.txtlicense.txttext/plain; charset=utf-81748https://repositorio.cuc.edu.co/bitstream/11323/1758/2/license.txt8a4605be74aa9ea9d79846c1fba20a33MD52open accessTHUMBNAILRisk-assessment V1.0 A new interactive software to develop risk assessment using MATLAB.pdf.jpgRisk-assessment V1.0 A new interactive software to develop risk assessment using MATLAB.pdf.jpgimage/jpeg72921https://repositorio.cuc.edu.co/bitstream/11323/1758/4/Risk-assessment%20V1.0%20A%20new%20interactive%20software%20to%20develop%20risk%20assessment%20using%20MATLAB.pdf.jpg522e90fb5135c5f4d844ff64f9a70b53MD54open accessTEXTRisk-assessment V1.0 A new interactive software to develop risk assessment using MATLAB.pdf.txtRisk-assessment V1.0 A new interactive software to develop risk assessment using MATLAB.pdf.txttext/plain17135https://repositorio.cuc.edu.co/bitstream/11323/1758/5/Risk-assessment%20V1.0%20A%20new%20interactive%20software%20to%20develop%20risk%20assessment%20using%20MATLAB.pdf.txtef712c47d0f6922fa7237731d107ae55MD55open access11323/1758oai:repositorio.cuc.edu.co:11323/17582023-12-14 11:45:12.501open accessRepositorio Universidad de La Costabdigital@metabiblioteca.comTk9URTogUExBQ0UgWU9VUiBPV04gTElDRU5TRSBIRVJFClRoaXMgc2FtcGxlIGxpY2Vuc2UgaXMgcHJvdmlkZWQgZm9yIGluZm9ybWF0aW9uYWwgcHVycG9zZXMgb25seS4KCk5PTi1FWENMVVNJVkUgRElTVFJJQlVUSU9OIExJQ0VOU0UKCkJ5IHNpZ25pbmcgYW5kIHN1Ym1pdHRpbmcgdGhpcyBsaWNlbnNlLCB5b3UgKHRoZSBhdXRob3Iocykgb3IgY29weXJpZ2h0Cm93bmVyKSBncmFudHMgdG8gRFNwYWNlIFVuaXZlcnNpdHkgKERTVSkgdGhlIG5vbi1leGNsdXNpdmUgcmlnaHQgdG8gcmVwcm9kdWNlLAp0cmFuc2xhdGUgKGFzIGRlZmluZWQgYmVsb3cpLCBhbmQvb3IgZGlzdHJpYnV0ZSB5b3VyIHN1Ym1pc3Npb24gKGluY2x1ZGluZwp0aGUgYWJzdHJhY3QpIHdvcmxkd2lkZSBpbiBwcmludCBhbmQgZWxlY3Ryb25pYyBmb3JtYXQgYW5kIGluIGFueSBtZWRpdW0sCmluY2x1ZGluZyBidXQgbm90IGxpbWl0ZWQgdG8gYXVkaW8gb3IgdmlkZW8uCgpZb3UgYWdyZWUgdGhhdCBEU1UgbWF5LCB3aXRob3V0IGNoYW5naW5nIHRoZSBjb250ZW50LCB0cmFuc2xhdGUgdGhlCnN1Ym1pc3Npb24gdG8gYW55IG1lZGl1bSBvciBmb3JtYXQgZm9yIHRoZSBwdXJwb3NlIG9mIHByZXNlcnZhdGlvbi4KCllvdSBhbHNvIGFncmVlIHRoYXQgRFNVIG1heSBrZWVwIG1vcmUgdGhhbiBvbmUgY29weSBvZiB0aGlzIHN1Ym1pc3Npb24gZm9yCnB1cnBvc2VzIG9mIHNlY3VyaXR5LCBiYWNrLXVwIGFuZCBwcmVzZXJ2YXRpb24uCgpZb3UgcmVwcmVzZW50IHRoYXQgdGhlIHN1Ym1pc3Npb24gaXMgeW91ciBvcmlnaW5hbCB3b3JrLCBhbmQgdGhhdCB5b3UgaGF2ZQp0aGUgcmlnaHQgdG8gZ3JhbnQgdGhlIHJpZ2h0cyBjb250YWluZWQgaW4gdGhpcyBsaWNlbnNlLiBZb3UgYWxzbyByZXByZXNlbnQKdGhhdCB5b3VyIHN1Ym1pc3Npb24gZG9lcyBub3QsIHRvIHRoZSBiZXN0IG9mIHlvdXIga25vd2xlZGdlLCBpbmZyaW5nZSB1cG9uCmFueW9uZSdzIGNvcHlyaWdodC4KCklmIHRoZSBzdWJtaXNzaW9uIGNvbnRhaW5zIG1hdGVyaWFsIGZvciB3aGljaCB5b3UgZG8gbm90IGhvbGQgY29weXJpZ2h0LAp5b3UgcmVwcmVzZW50IHRoYXQgeW91IGhhdmUgb2J0YWluZWQgdGhlIHVucmVzdHJpY3RlZCBwZXJtaXNzaW9uIG9mIHRoZQpjb3B5cmlnaHQgb3duZXIgdG8gZ3JhbnQgRFNVIHRoZSByaWdodHMgcmVxdWlyZWQgYnkgdGhpcyBsaWNlbnNlLCBhbmQgdGhhdApzdWNoIHRoaXJkLXBhcnR5IG93bmVkIG1hdGVyaWFsIGlzIGNsZWFybHkgaWRlbnRpZmllZCBhbmQgYWNrbm93bGVkZ2VkCndpdGhpbiB0aGUgdGV4dCBvciBjb250ZW50IG9mIHRoZSBzdWJtaXNzaW9uLgoKSUYgVEhFIFNVQk1JU1NJT04gSVMgQkFTRUQgVVBPTiBXT1JLIFRIQVQgSEFTIEJFRU4gU1BPTlNPUkVEIE9SIFNVUFBPUlRFRApCWSBBTiBBR0VOQ1kgT1IgT1JHQU5JWkFUSU9OIE9USEVSIFRIQU4gRFNVLCBZT1UgUkVQUkVTRU5UIFRIQVQgWU9VIEhBVkUKRlVMRklMTEVEIEFOWSBSSUdIVCBPRiBSRVZJRVcgT1IgT1RIRVIgT0JMSUdBVElPTlMgUkVRVUlSRUQgQlkgU1VDSApDT05UUkFDVCBPUiBBR1JFRU1FTlQuCgpEU1Ugd2lsbCBjbGVhcmx5IGlkZW50aWZ5IHlvdXIgbmFtZShzKSBhcyB0aGUgYXV0aG9yKHMpIG9yIG93bmVyKHMpIG9mIHRoZQpzdWJtaXNzaW9uLCBhbmQgd2lsbCBub3QgbWFrZSBhbnkgYWx0ZXJhdGlvbiwgb3RoZXIgdGhhbiBhcyBhbGxvd2VkIGJ5IHRoaXMKbGljZW5zZSwgdG8geW91ciBzdWJtaXNzaW9uLgo= |