Best ChatGPT prompts for Financial Specialists, All Other

I have a complex financial model with 15 interconnected worksheets, using a combination of Excel formulas, macros, and external data feeds. Identify all potential error propagation paths, including circular references, inconsistent data types, and formula errors, and provide a step-by-step guide to remediate each issue, considering the model's sensitivity to input changes and the potential impact on downstream reports and dashboards.

Create a comprehensive quarterly budget variance report for a large corporation with multiple departments and cost centers, including a detailed analysis of actual vs. budgeted expenses, identification of significant variances, and recommendations for corrective actions, using a dataset with 500 accounts, 200 departments, and 10 cost centers, and assuming a 5% threshold for significant variances.

Design a cash flow forecasting model for a mid-sized business with seasonal fluctuations in revenue and expenses, incorporating historical data from the past 3 years, industry benchmarks, and macroeconomic trends, and providing a 12-month forecast with monthly granularity, including predictions for accounts receivable, accounts payable, and capital expenditures, and an analysis of the potential impact of different economic scenarios on the forecast.

Using a dataset of 10,000 transactions from the past quarter, apply a combination of machine learning algorithms and business rules to identify high-risk transactions that may require compliance review, considering factors such as transaction amount, frequency, and counterparties, as well as regulatory requirements and internal risk policies, and provide a ranked list of the top 100 transactions for review, along with a detailed explanation of the reasoning behind each selection.