The Accounting Analytics Capstone course is a compulsory capstone course for undergraduate students pursuing a 2nd Major in Accounting Data & Analytics. We showcase their completed projects below.
ISCA Membership Engagement Scoring Model
The team was tasked to develop a model to predict the probability of a member resigning, measure the engagement level of each member and identify the factors that drive member engagement.
Devising a Solution for SGX's Current Revenue Forecast Process.
SGX’s present system requires human intervention to manually sift through various new sources to determine the inputs for their forecast.
The team’s proposed solution—to convert the semi-automated revenue prediction process to a fully automated one—aims to streamline the process and eliminate the human judgement bottleneck. This would enable a standard operating procedure, reduce total man-hours and improve the process accuracy over time.
Developing a Tool to Continuously Monitor and Flag out Non-Compliance in Procurement
To develop a tool that allows continuous monitoring and flagging out of non-compliances to the SGX Procurement Policy, specifically:
1. PO raised after service commencement date
2. Invoice payment in excess of approved PO amount
3. Contracts which are more than $5k but broken into smaller value contracts
Developing a Dashboard to Track Historical Data and Inventory - Hi Beau
Hi-Beau has commissioned the team to design and develop a dashboard, enabling its management to effectively track historical data and inventory to support the forecasting and planning of sales and procurement processes through predictive analytics.
Creating a Data-Driven Pricing Strategy for Lloyd's Inn
Lloyd’s Inn is a 34 room boutique hotel located in the heart of Singapore. The team has been tasked to 1. Develop a forecasting revenue management model to create a data driven pricing strategy and 2. Conduct an analysis to gain insights to re-direct guests towards direct booking and away from Online Travel Agencies.
Fake News Detection & Financial Dashboarding
To produce a text analytics algorithm for EBOS Reputation to determine the truthfulness of the articles found online, and to create an informative financial dashboard for EBOS' clients.
Hong Leong Finance Seeks an Insight into Future Interest Rate
Having an insight into future interest rate can help HLF’s management be prepared for interest movement and undertake contingent activities to mitigate the undesirable effect. The group aims to predict SIBOR rates and to identify macroeconomic
factors related to domestic interest rates.
Hong Leong Finance - Credit Evaluation
Hong Leong Finance, the largest financial company in Singapore, seeks to implement data
analytics to identify the top seven variables to predict if a loan would default.
ASPT Aruki - To Understand its Financial Health Position
Through the use of a CFO dashboard, the company is able to better understand its financial health position and can strive to achieve a favorable cash flow position for its current and future cash flows.
