top of page

EXCEL

 

Below are examples of a few projects where I developed and utilized Excel Financial models:

  • Entergy – IT, Corporate and Supply Chain Budget, Forecast & FP&A reporting

  • Levi’s Strauss & Co.– SAP Project Financial Reporting and Optimization

  • PepsiCo – Sales Finance Plan, Forecast & FP&A Reporting

  • Pacific Gas & Electric – Professional Services FP&A Reporting

  • Walmart eCommerce – Gross Profit Reconciliation and FP&A Balance Sheet & Income Statement

​

Sample Projects
Click on Icon for VBA Code
Excel_VBA.PNG

SAMPLE 1: Calculate Stock Performance Utilizing VBA coding  

The analysis outlines 2017 and 2018 Stock Performance to help individuals pick stocks with high volume and performance. The program outlines 12 Stock Stickers that were chosen to track in 2017 and 2018. The program can easily be modified to including thousand of stock tickers that needed to be tracked given the values are already assigned in the tickers array ahead to time. The program is designed such that it will go through the worksheet only once and display all values

​

​

Click on View Raw on GitHub website
NBA Points Scored - Simple Regression -

SAMPLE 2: Perform Statistical Analysis utilizing Excel

NBA Regression Analysis 

The analysis is to determine whether "Points Scored" (PTS) by NBA player ( y - dependent variable) can be predicted by using "Minutes Played" (x- independent variable).  The model utilizes simple regression test to review R Square, P Value, Intercept and X Coefficients.

SAMPLE 3: Sales Plannning, Forecasting & FP&A reporting Model

Coming Soon

LinkedIn Recommendation
 
​“Vick is a committed professional with extensive knowledge in Accounting, Supply Chain and Logistics. His expertise in model building (ie Scorecards) helped deliver exposure and results to the Supply Chain team. I enjoyed working with Vick as he was a great communicator with a positive attitude.”
 

Edesa David, Sr. Financial Analyst at Orchard Supply Hardware

​
​“Vick has tremendous analytical skill. His expertise with business analysis and knowledge resulted in several key improvements in operational efficiency and improved savings. His commitment to improvement and pursue continuous professional improvement has been key in his success. We work together on Developing of Supply Chain Scorecard for company and other projects. It was pleasure to working with him. He will be great asset for company and team”
​
Viren Patel , Supply Chain Specialist at Orchard Supply Hardware

  Proudly created by Vick Anand

bottom of page