Date of Publication
9-2020
Document Type
Master's Thesis
Degree Name
Master of Science in Computational Finance
Subject Categories
Finance and Financial Management
College
Ramon V. Del Rosario College of Business
Department/Unit
Financial Management
Thesis Adviser
Ildemarc Bautista
Defense Panel Chair
Edwin Valleroso
Defense Panel Member
Ricarte Pinlac
Roberto Roll Ramos
Abstract/Summary
Quantitative analysis is required in business decisions such as investment and portfolio management, business volume and cost forecasting, financial analysis, or in informal analyses where one simply seeks to determine any relationship such as dependences among variables.
While statistical programs are available, these normally involve complex functions and selections that can intimidate users who do not have formal statistical or math backgrounds but work in the field of Finance. Further, while some of these functions are readily available in MS Excel, they are not strategically placed together to give easy access to the user, as Excel is for a wide array of users instead of a specific type of user in mind.
The Project aims to give users (e.g. students, practitioners) an intuitive and simple tool that can aid in business decisions in the aforementioned fields (among others that are possible) by providing the most commonly used functions in these fields and providing easy to read results to facilitate interpretation.
Abstract Format
html
Language
English
Format
Electronic
Keywords
Investment analysis—Computer programs
Upload Full Text
wf_yes
Recommended Citation
Ventura, R. M. (2020). A VBA statistical toolkit for investment analysis (with applications in forecasting and business decision making). Retrieved from https://animorepository.dlsu.edu.ph/etd_masteral/6217
Embargo Period
8-10-2022