Best Gemini prompts for Financial Managers

Using the provided budget data, identify the top 3 departments with the largest variance between actual and projected expenses for Q2. Provide a detailed breakdown of the variance for each department, including the percentage difference and a brief explanation of the potential causes. Assume the data is stored in a Google BigQuery dataset named 'budget_data' and the relevant tables are 'department_expenses' and 'budget_projections'. Use a combination of SQL queries and data visualization to support your analysis.

Develop a predictive model to forecast revenue growth for the next 6 months based on historical sales data. Use a combination of linear regression and exponential smoothing to account for seasonality and trends. Assume the data is stored in a Google Sheets spreadsheet named 'sales_data' and includes columns for date, revenue, and region. Provide a detailed explanation of the model's assumptions and limitations, as well as a visualization of the forecasted revenue growth.

Using the provided portfolio data, optimize the investment allocation to minimize risk and maximize returns. Assume the data includes the expected returns and covariance matrix for a set of 10 assets. Use a combination of mean-variance optimization and Monte Carlo simulations to identify the optimal portfolio allocation. Provide a detailed breakdown of the optimized portfolio, including the weightings for each asset and a visualization of the efficient frontier.

Design a workflow to automate the generation of monthly financial reports using Google Data Studio and Google Sheets. Assume the data is stored in a Google BigQuery dataset named 'financial_data' and includes tables for income statement, balance sheet, and cash flow. Use a combination of SQL queries and data visualization to create a set of dashboards and reports that provide insights into key financial metrics, such as revenue growth, expense ratios, and cash flow margins. Provide a detailed explanation of the workflow and a sample report.