PhDs' In account & Finance with extensive programming capabilities in spreadsheets (excel/google sheet), VBA, R, Python, PowerBI.
DCF, investment strategy backtest, sensitivity analysis, Monte Carlo simulation.
Experience in commercial valuation benchmarking,
forecasting at the portfolio level, market sizing, variance analysis projects.
Supported clients on strategy & decision projects, sensitivity analysis on key parameters such as discount rates, working capital, etc.
Hands-on experience in Data Analysis using Excel, SPSS using various techniques such as regression, conjoint analysis, factor analysis, cluster analysis, sensitivity analysis, multiple goals seek, etc. To identify customers/product requirements and ensure that all the KPI are fully analyzed and their contributions and risks are appropriately outlined. Reports in powerpoint, PDF reports or excel dashboard.
Excel Dashboard, Reporting
Expertise in Excel/VBA. 3+ years of experience in creating Excel dashboards & templates, providing a stunning representation of business data. Accomplished in data mining/analysis/reporting/predicting/ improving values.
Services provided in descriptive, predictive and prescriptive analytics areas include constant monitoring of data, trends, KPIs, applying filters on data, visualizing data through varied graphs, generation of insights, predicting future trends using regression modeling, optimization using Linear Programming.
Financial Models Forecasting
Develop 3-10 years financial model that will include revenue projections, income statements, cash flow statements, and a balance sheet. The financial models involve projecting three financial statements. The revenue forecast is based on industry-specific drivers, which are prepared using the industry expertise of our Colleagues. The expenses are decided considering various industry-specific cost components and assumptions are made using bench-marks.
The model can be for a new venture, new product line or to forecast the health of your core business. The model can help you make decisions on how you want to move forward and plan for the future. Would you like to see how an increase in sales would affect your bottom line? Would you like to know the effect of a raw material price increase or a lower overhead will affect you going forward?
Financial Statement Projections
Develop 3-10 years financial model that will include revenue projections, income statements, cash flow statements, and balance sheets. The financial models involve projecting three financial statements. The revenue forecast is based on industry-specific drivers, which are prepared using the industry expertise of our Colleagues.
Reviews For This Service