Everyday Business Decisions and Real-life Examples.
| Business Decisions | Real Life Examples Using MS-Excel | MS-Excel Functionality (UPPERCASE Lettering) |
|---|---|---|
| New business ventures | I have developed financial models to assess the profitability of new business opportunities. | Cost-volume-profit models using GOAL SEEK, DATA TABLES, and SCENARIOS |
| Long-term planning | I have used forecasting techniques to estimate corporate revenues. | Forecasting techniques in the ANALYSIS TOOLPACK MOVING AVERAGE EXPONENTIAL SMOOTHING |
| Major investments | I have created capital budgeting models for multimillion-dollar land development projects in both domestic and foreign locations. | NPV, IRR |
| Predicting the future | I have developed a predictive model, using linear regression techniques, for an organization's program spending. | ANALYSIS TOOLPACK: REGRESSION |
| Product pricing | I developed a process for pricing the use of airport facilities by using linear programming techniques. | Using SOLVER to optimize product/service pricing |
| Financial reporting | I have created a monthly management reporting system that monitored corporate performance in relation to an organization's budget. | Variance analysis and FORECAST functions were used |
| Equity financing | I have published an essay that deals with the use of equity financing for private airports. | Using PIVOT TABLES to analyze various financial datasets |
| Interpreting financial information | I have prepared analytical reports, based on information obtained from a large data warehouse, using advanced data analysis tools (i.e., Hyperion and Essbase software that interfaced with MS-Excel) | PIVOT TABLES and BI (Business Intelligence) tools were used |
| Performance measurement | I have identified key performance indicators (KPIs) for monthly reporting to senior management. | Creating executive dashboards, using PIVOT TABLES, SLICER and SPARKLINES functions |
| Corporate strategy | I was involved in developing a strategic plan for a subsidiary of a large business. I have also authored essays on corporate strategy. | Employed ANALYSIS TOOLPACK forecasting using MOVING AVERAGE and EXPONENTIAL SMOOTHING techniques |
| Cash management | I have been responsible for managing multi-million-dollar cash portfolios, through purchases of R1 and R2 rated short-term commercial paper. | Created a financial model (using Excel GRAPHICS) to match risk with return on a portfolio of investments |
| Budget management | I have developed and managed multi-million-dollar operating and capital budgets for several organizations. | Amalgamated cost center budgets using the CONSOLIDATION function along with PIVOT TABLES tools |
| Debt financing | I have published an essay dealing with the use of debt financing in relation to residual and compensatory airport pricing models. | Various financial functions: NPV, IRR, PV, FV, RATE along with SOLVER |
| Business Decisions | Real Life Examples Using MS-Excel | MS-Excel Functionality (UPPERCASE Lettering) |
|---|---|---|
| New business ventures | I have developed financial models to assess the profitability of new business opportunities. | Cost-volume-profit models using GOAL SEEK, DATA TABLES, and SCENARIOS |
| Long-term planning | I have used forecasting techniques to estimate corporate revenues. | Forecasting techniques in the ANALYSIS TOOLPACK MOVING AVERAGE EXPONENTIAL SMOOTHING |
| Major investments | I have created capital budgeting models for multimillion-dollar land development projects in both domestic and foreign locations. | NPV, IRR |
| Predicting the future | I have developed a predictive model, using linear regression techniques, for an organization's program spending. | ANALYSIS TOOLPACK: REGRESSION |
| Product pricing | I developed a process for pricing the use of airport facilities by using linear programming techniques. | Using SOLVER to optimize product/service pricing |
| Financial reporting | I have created a monthly management reporting system that monitored corporate performance in relation to an organization's budget. | Variance analysis and FORECAST functions were used |
| Equity financing | I have published an essay that deals with the use of equity financing for private airports. | Using PIVOT TABLES to analyze various financial datasets |
| Interpreting financial information | I have prepared analytical reports, based on information obtained from a large data warehouse, using advanced data analysis tools (i.e., Hyperion and Essbase software that interfaced with MS-Excel) | PIVOT TABLES and BI (Business Intelligence) tools were used |
| Performance measurement | I have identified key performance indicators (KPIs) for monthly reporting to senior management. | Creating executive dashboards, using PIVOT TABLES, SLICER and SPARKLINES functions |
| Corporate strategy | I was involved in developing a strategic plan for a subsidiary of a large business. I have also authored essays on corporate strategy. | Employed ANALYSIS TOOLPACK forecasting using MOVING AVERAGE and EXPONENTIAL SMOOTHING techniques |
| Cash management | I have been responsible for managing multi-million-dollar cash portfolios, through purchases of | Created a financial model (using Excel GRAPHICS) to match risk with return on a portfolio of investments |
| Budget management | I have developed and managed multi-million-dollar operating and capital budgets for several organizations. | Amalgamated cost center budgets using the CONSOLIDATION function along with PIVOT TABLES tools |
| Debt financing | I have published an essay dealing with the use of debt financing in relation to residual and compensatory airport pricing models. | Various financial functions: NPV, IRR, PV, FV, RATE along with SOLVER |
Sharing content requires targeting cookies to be enabled. Please update your cookie preferences to use this feature.