Projects
- Automation of Balance Sheet Ratio calculation
§ Created an Excel template to input accounts and dollar amounts from 10K annual report balance sheet for 2 years.
§ Programmed VBA macros to make adding and removing accounts easier and distinguish current from non-current assets/liabilities.
§ Automated calculation of balance sheet ratios from the template.
§ Created a dashboard to display the balance sheet ratios and graph the ratios for comparison.
§ Analyzed transactions from the ledger for sales and cash receipts to record sales outstanding.
§ Performed aging analysis on sales outstanding.
§ Prepared a cash flow model with revenue and expenses to forecast cash flow for the following year.
§ Created a dashboard to adjust forecasting variables and visualize the impact on cash flow.
- Statistical analysis of Dow Jones Industrial Average (DJIA) and S&P500
§ Compared DJIA and S&P500 closing values for similarities in performance over a period of 10 years from 2012 to 2022.
§ Ran descriptive statistics and simple regression to check for relationship to explain similarities in performance between the two indexes.