Best Gemini prompts for Financial Specialists, All Other

Analyze the financial statements of XYZ Corporation, a publicly-traded company in the retail industry, and identify areas of improvement in their financial performance. Use a combination of ratio analysis, trend analysis, and industry benchmarking to assess their liquidity, profitability, and solvency. Provide a detailed report that includes recommendations for improvement and a comparison to their main competitors. Assume the company's financial statements are available in a Google Sheets document, and use Google Data Studio to create visualizations and charts to support your analysis.

Develop a comprehensive revenue growth forecast for a new product launch using a combination of historical sales data, market research, and econometric modeling. Use Google BigQuery to analyze large datasets and create a predictive model that takes into account seasonality, trends, and external factors such as economic indicators and competitor activity. Provide a detailed report that includes a breakdown of the forecasting methodology, assumptions, and results, as well as recommendations for pricing and marketing strategies. Assume the historical sales data is available in a Google Cloud Storage bucket, and use Google Dataflow to process and transform the data.

Conduct a comprehensive risk assessment of a potential investment opportunity in a emerging market, including an evaluation of country risk, industry risk, and company-specific risk. Use a combination of quantitative and qualitative methods, including Monte Carlo simulations and scenario analysis, to estimate the potential returns and risks of the investment. Provide a detailed report that includes a risk matrix, sensitivity analysis, and recommendations for risk mitigation strategies. Assume the investment data is available in a Google Sheets document, and use Google Slides to create a presentation that summarizes the findings and recommendations.

Develop a comprehensive financial model for a startup company in the technology industry, including a detailed income statement, balance sheet, and cash flow statement. Use a combination of financial statement analysis, ratio analysis, and industry benchmarking to estimate the company's cost of capital, growth rate, and valuation. Provide a detailed report that includes a breakdown of the financial modeling methodology, assumptions, and results, as well as recommendations for funding and investment strategies. Assume the company's financial statements are available in a Google Sheets document, and use Google Data Studio to create visualizations and charts to support the analysis.