Analyze credit data and financial statements to determine the degree of risk involved in extending credit or lending money.
AI finds trends and writes the spreadsheet formulas.
📊 Real AI use (Anthropic Economic Index, Apr 2026 to May 2026): AI completed the task directly in 61% of those conversations; the rest were back-and-forth with the person.
Show prompt & steps
Paste a spreadsheet or table and ask AI to find trends, outliers and totals, or to write the formula you need. It's like having an analyst on call.
Ready-to-use prompt
I work as a credit analyst. Part of my job is to analyze credit data and financial statements to determine the degree of risk involved in extending credit or lending money. Context: We use Oracle Business Intelligence Enterprise Edition and SAS; the work draws on economics and accounting, mathematics and law and government. Question: [price reasonableness, cost trends, profitability] Data: [paste proposals, reports, history] Analyze, compare to benchmarks and give a recommendation. Show formulas. Show your working step by step and give spreadsheet formulas so I can reproduce the numbers.
10-minute exercise: Business data analysis
AI makes arithmetic mistakes. Recompute anything that matters with a spreadsheet formula.
Double-check every number. AI can make arithmetic and rounding mistakes.
Importance 4.9/5 · core task · O*NET work activity: Analyze business or financial data.. Also involves: Assess risks to business operations..