Best Gemini prompts for Chief Executives

Analyze the EBITDA margin of our company over the past 5 years, including a detailed breakdown of the key drivers of margin expansion or contraction, such as changes in revenue, cost of goods sold, and operating expenses. Identify the most significant factors contributing to any fluctuations and provide recommendations for improving EBITDA margin going forward. Assume a revenue growth rate of 10% per annum and a fixed asset turnover ratio of 2.5. Provide a concise report, including charts, tables, and a written summary, and ensure that all calculations are performed using GAAP accounting standards.

Using data from our company's BI dashboard, analyze the market share trends of our top 3 products over the past 3 years, including a comparison to our main competitors. Identify any significant changes or anomalies in the data and provide insights into the potential causes of these trends, such as changes in customer preferences, competitor activity, or external market factors. Provide a written report, including visualizations and statistical analysis, and ensure that all data is properly normalized and adjusted for seasonality.

Develop a comprehensive resource allocation plan for our company's upcoming fiscal year, including a detailed breakdown of projected resource utilization by department and function. Use data from our ERP system to analyze historical resource allocation trends and identify areas where resources can be optimized or reallocated to improve efficiency and reduce waste. Provide a written report, including a resource allocation matrix and a summary of the key recommendations, and ensure that all calculations are performed using a zero-based budgeting approach.

Conduct a thorough analysis of a potential M&A target company, including a review of their financial statements, operational performance, and market position. Use data from our financial modeling software to analyze the potential synergies and risks associated with the acquisition, including the impact on our company's EBITDA margin, market share, and burn rate. Provide a concise report, including a written summary, financial projections, and a recommendation on whether to pursue the acquisition, and ensure that all analysis is performed using a discounted cash flow valuation approach.