Software for Capital Investment Analysis: A Case Study on Walking Aid for Stroke Patients
Article Sidebar
Main Article Content
บทคัดย่อ
This research presents the development of a software for capital investment analysis, using a case study of a walking aid machine development for stroke patients. The software was created with Visual Basic for Applications (VBA) and Microsoft Access for database management and features a graphical user interface (GUI) for intuitive data input and result display. To support online use and collaboration, the system was also integrated with Microsoft SharePoint for cloud-based data storage and multi-device access. The software processes key financial inputs, including investment costs, annual income, operating expenses, and discount rates. It automatically computes major economic indicators such as NPV, IRR, DPB, and BCR. It also includes a sensitivity analysis function to assess project risk from changes in costs and revenues. Testing with actual project data showed an NPV of 33,822,276.50 THB, an IRR of 65.81%, a payback period of 2.19 years, and a BCR of 1.88, which confirms the project's economic feasibility. The developed software is suitable for use in health-related or technology-based projects requiring accurate and flexible financial analysis in both standalone and networked.
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
References
W. Chantkran, J. Chaisakul, R. Rangsin, M. Mungthin, and B. Sakboonyarat, “Prevalence of and factors associated with stroke in hypertensive patients in Thailand from 2014 to 2018: A nationwide cross-sectional study,” Sci. Rep., vol. 11, no. 1, p. 17614, 2021.
H. Choi, S. Lee, and D. Jeong, “Forensic recovery of SQL server database: Practical approach,” IEEE Access, vol. 9, pp. 14564–14575, 2021.
J. Nie, M. Jiang, A. Botta, Y. Sugahara, and Y. Takeda, “Adaptive ground clearance control for preparation for fall in a wearable assistive device,” in 2024 IEEE 18th International Conference on Advanced Motion Control (AMC), 2024, pp. 1–5.
M. Iloiu and D. Csiminga, “Project risk evaluation methods - sensitivity analysis,” Annals of the University of Petrosani: Economics, vol. 9, pp. 33–38, 2009.
K. Moonpanane, K. Pitchalard, J. Thepsaw, O. Singkhorn, and C. Potjanamart, “Healthcare service utilization of hill tribe children in underserved communities in thailand: Barriers to access,” BMC Health Serv. Res., vol. 22, no. 1, p. 1114, 2022.
National Innovation Agency (NIA), “Know and understand! ‘Medical Innovation’ A tool to turn crisis into life-changing quality of life, NIAnatomy EP.10,” NIA Official Website, Aug. 24, 2022. [Online]. Available: https://www.nia.or.th/quote-NIAnatomy-ep10.
J. Chaki and M. Woźniak, “Deep learning and artificial intelligence in action (2019–2023): A review on brain stroke detection, diagnosis, and intelligent post-stroke rehabilitation management,” IEEE Access, vol. 12, pp. 52161–52181, 2024.
D. Gorton, “A quick guide to the risk-adjusted discount rate,” Investopedia,https://www.investopedia.com/articles/budgeting-savings. [Accessed: 09-Jun-2025].
“Risk Adjusted Discount Rate,”StudySmarter UK. [Online]. Available: https://www.studysmarter.co.uk/explanations/business-studies/corporate-finance/risk-adjusted-discount-rate/. [Accessed: 09-Jun-2025].
P. Yuenyong, N. Plubjang, T. Thongkonghan, S. Pullteap, and K. Kheovichai, “Study of investment feasibility for smart bus stations at silpakorn university,” in 2023 8th International STEM Education Conference (iSTEM-Ed), 2023, pp. 1–5.
(2020). The-Top-10-Causes-of-Death. [Online]. Available: https://www.who.int/news-room/fact-sheets/detail/the-top-10-causes-ofdeath.
M. V. Sokolov, “NPV, IRR, PI, PP, and DPP: a unified view,” arXiv [econ.GN], 2023.
A. Kinicki and B. K. Williams, “Management: A practical introduction”, 6 th ed McGraw-Hill Education, 2012.
S. Pullteap and K. Kheovichai, “Feasibility analysis of investment cost for medical equipment business via E-commerce system,” in 2019 7th International Electrical Engineering Congress (iEECON), 2019, pp. 1–4.
Xiao Qian, Cheng Yuqi, Luo Jiawen, Zhou Shengtong, Zhou Qianzhe, Cao Taoying. Sensitivity analysis of high-speed train wheel vibration under vehicle/track coupling [J]. Journal of Transportation Engineering, 2021, 21 ( 06 ): 160–169.
“Sensitivity analysis for capital budgeting of investment projects,” Superbusinessmanager.com. [Online]. Available: https://www.superbusinessmanager.com/sensitivity-analysis-for-capital-budgeting-of-investment-projects/. [Accessed: 09-Jun-2025].
P. Thaisongkroh and M. Rattanasiriwongwut, “Development of a software management for capital investment decision using Microsoft visual basic programming,” in 2018 International Conference on Engineering, Applied Sciences, and Technology (ICEAST), 2018, pp. 1–4.
R. Liu, “Application of intelligent algorithms in data analysis of financial sharing system,” in 2023 Asia-Europe Conference on Electronics, Data Processing and Informatics (ACEDPI), 2023, pp. 409–413.
GBD 2019 Stroke Collaborators, “Global, regional, and national burden of stroke and its risk factors, 1990-2019: a systematic analysis for the Global Burden of Disease Study 2019,” Lancet Neurol., vol. 20, no. 10, pp. 795–820, 2021.
N. Majstorović, Ž. Širanović, and K. Kavran, “Tools for grading students’ exercises for Microsoft Access applications,” in 2012 Proceedings of the 35th International Convention MIPRO, 2012, pp. 1290–1292.
N. Butsing, J. G. Voss, J. Keandoungchun, N. Thongniran, and M. T. Q. Griffin, “Changes of health-related quality of life within 6 months after stroke by clinical and sociodemographic factors,” Sci. Rep., vol. 15, no. 1, p. 416, 2025.
W. Cao, C. Chen, H. Hu, K. Fang, and X. Wu, “Effect of hip assistance modes on metabolic cost of walking with a soft exoskeleton,” IEEE Trans. Autom. Sci. Eng., vol. 18, no. 2, pp. 426–436, 2021.