Commercial Analyst

Commercial Analyst follows protocols and provides hands-on help, illustrated by 26 standard tasks you can try. These show the rhythm of a shift, typical tools like Microsoft Excel, and what success looks like. Each one shows where we found it, and comes with an AI prompt you can copy and use straight away.

26evidenced tasks
26ready prompts
9tools of the trade
13-2051.00O*NET-SOC code
361,980hold this job (US, BLS 2025)
$102,740median pay/yr (US)
Open Commercial Analyst in the interactive atlas →

What it pays

Government survey numbers — not estimates, not ads.

In India, Professionals earn about ₹38,298 a month on average — around ₹4.6 lakh a year (government PLFS survey via ILOSTAT, occupation-family figure).
Think you get this job?Six quick questions on how it really works — with a hint and the reason behind every answer.
Test yourself →

The work, task by task

These are the real jobs-to-be-done, not a wish list. Each task shows where we found it, and the prompt underneath is written for that exact task.

Keeping the record1

Prepare financial analysis reports

+
Compile last four quarters of revenue and cost lines for Product Group A, run margin, breakeven and cashflow…
Compile last four quarters of revenue and cost lines for Product Group A, run margin, breakeven and cashflow scenarios, highlight three risks to growth, and deliver a two-page analysis with charts to the sales director Monday morning.
The tools that do the workMicrosoft ExcelMicrosoft PowerPointESCOjob descriptionsWikipedia
Analysing5

Assess the viability of financial actions or entities

+
Evaluate acquisition target ZeroPoint by reviewing last three years' statements, calculate EBITDA multiples…
Evaluate acquisition target ZeroPoint by reviewing last three years' statements, calculate EBITDA multiples and sensitivity to revenue decline, state whether the deal meets our 15 percent return hurdle, and send recommendation with supporting model to the CFO by Wednesday.
The tools that do the workMicrosoft ExcelMicrosoft WordESCOO*NETWikipedia

Gather and analyze financial information

+
Pull balance sheet and P&L entries for the last 12 months for Retail Division, reconcile discrepancies,…
Pull balance sheet and P&L entries for the last 12 months for Retail Division, reconcile discrepancies, compute key ratios and trend lines, and prepare a reconciled spreadsheet and one-page findings note for the finance controller by Tuesday close.
The tools that do the workMicrosoft Exceljob descriptionsO*NET

Analyze investment projects

+
Model the three-year projected cashflows for the new plant build, include NPV, IRR and payback under base,…
Model the three-year projected cashflows for the new plant build, include NPV, IRR and payback under base, optimistic and pessimistic scenarios, and submit the investment report with the supporting workbook to the investment committee on Thursday.
The tools that do the workMicrosoft Exceljob descriptionsWikipedia

Develop financial models and forecasts

+
Build a three-way financial forecast for FY27 through FY29 that links the income statement, balance sheet and…
Build a three-way financial forecast for FY27 through FY29 that links the income statement, balance sheet and cash flow, use last three years' actuals and current sales plan, flag cash shortfalls and sensitivity to a 10% sales drop.
The tools that do the workMicrosoft Exceljob descriptionsWikipedia

Develop and operate financial analysis tools

+
Develop a reusable analysis workbook that automates monthly variance, rolling forecasts and KPI dashboards,…
Develop a reusable analysis workbook that automates monthly variance, rolling forecasts and KPI dashboards, include documentation for inputs and a test dataset so analysts can update without breaking formulas.
The tools that do the workMicrosoft Exceljob descriptionsO*NET
The daily work20

Advise clients or organizations on financial decisions

+
Draft a clear advisory note for PetroChem's CFO recommending whether to accelerate capex, defer dividends, or…
Draft a clear advisory note for PetroChem's CFO recommending whether to accelerate capex, defer dividends, or raise a short-term revolver based on the attached Q1 cashflow, three-year forecast, and covenant schedule; include risks and a recommended next step by Tuesday.
The tools that do the workMicrosoft ExcelMicrosoft OutlookO*NETWikipedia

Collaborate with portfolio managers and analysts

+
Set up a one-hour workshop with the equity and fixed income portfolio managers plus two sector analysts to…
Set up a one-hour workshop with the equity and fixed income portfolio managers plus two sector analysts to review the new client mandate, circulate the mandate summary and our draft allocation proposal, and capture decisions on rebalancing and execution windows for next quarter.
The tools that do the workMicrosoft OutlookGoogle Docsjob descriptionsO*NET

Monitor financial markets and asset performance

+
Produce a daily market brief for the investment committee showing performance of our top ten holdings,…
Produce a daily market brief for the investment committee showing performance of our top ten holdings, benchmark moves, FX impacts and any holdings exceeding 5% intraday move, with one-paragraph implications and trade ideas by 8:00 a.m. tomorrow.
The tools that do the workMicrosoft Power BIMicrosoft Exceljob descriptionsWikipedia

Purchase investments for companies in accordance with company policy.

+
Prepare and execute the purchase of $5 million of high-grade corporate bonds for Horizon Ltd within our…
Prepare and execute the purchase of $5 million of high-grade corporate bonds for Horizon Ltd within our approved counterparty limits, attach the trade ticket, compliance waiver and updated cash position, and confirm settlement instructions with treasury today.
The tools that do the workMicrosoft ExcelMicrosoft OutlookO*NET

Confer with clients to restructure debt, refinance debt, or raise new debt.

+
Run a client meeting pack proposing three restructuring options for Greengrow Holdings: extend maturities,…
Run a client meeting pack proposing three restructuring options for Greengrow Holdings: extend maturities, push covenant holiday, or raise a subordinated facility; include modelled debt service for each, estimated fees, and our recommendation for discussion at Friday's client call.
The tools that do the workIBM SPSS StatisticsMicrosoft ExcelO*NET

Create client presentations of plan details.

+
Build a 12-slide client presentation that explains the recommended financial plan: executive summary,…
Build a 12-slide client presentation that explains the recommended financial plan: executive summary, five-year projections, sensitivity to sales down 15%, required actions and next steps, and deliver a print-ready PDF for the Thursday board meeting.
The tools that do the workMicrosoft PowerPointMicrosoft ExcelO*NET

Handle all the matters in reference to the finance and investments of a company

+
Prepare a consolidated financial plan and update the cash flow, P&L and balance sheet forecasts for the board…
Prepare a consolidated financial plan and update the cash flow, P&L and balance sheet forecasts for the board meeting next Wednesday, flagging investment risks, proposed hedges, and three growth scenarios with supporting assumptions and figures.
The tools that do the workMicrosoft ExcelMicrosoft PowerPointESCO

Maintain transparent financial operations for taxation and auditing bodies

+
Compile and reconcile the ledgers, produce a clear audit pack with trial balance, tax schedules and…
Compile and reconcile the ledgers, produce a clear audit pack with trial balance, tax schedules and supporting transaction evidence for the fiscal year closing on June 30, then notify the tax team and external auditors with the pack attached.
The tools that do the workIntuit QuickBooksMicrosoft ExcelESCO

Perform securities valuation or pricing.

+
Value the corporate bond portfolio at quarter end using the latest cashflows and market yields, price each…
Value the corporate bond portfolio at quarter end using the latest cashflows and market yields, price each security to yield and spread, flag any below-market collars, and produce a one-page memo explaining assumptions by close Friday.
The tools that do the workMicrosoft ExcelO*NET

Develop and maintain client relationships.

+
Reach out to Priya at Eastside Capital and Mark the procurement director to schedule a quarterly review,…
Reach out to Priya at Eastside Capital and Mark the procurement director to schedule a quarterly review, propose the updated fee schedule and risk limits, and confirm their appetite before Tuesday so we can fold changes into the renewal.
The tools that do the workMicrosoft OutlookO*NET

Draw charts and graphs, using computer spreadsheets, to illustrate technical reports.

+
Create clear charts that show revenue runoff, margin by product and three-year CAGR, label axes and data…
Create clear charts that show revenue runoff, margin by product and three-year CAGR, label axes and data sources, embed the visuals in the technical report and export a printable figure set for tomorrow's meeting.
The tools that do the workMicrosoft ExcelMicrosoft PowerPointO*NET

Prepare all materials for transactions or execution of deals.

+
Assemble the transaction pack for the Hudson sale: title report, valuation model, cap table, key contracts…
Assemble the transaction pack for the Hudson sale: title report, valuation model, cap table, key contracts and a one-page execution checklist, verify signatures and readiness, and upload final bundle to legal by Wednesday noon.
The tools that do the workMicrosoft OfficeMicrosoft OutlookO*NET

Supervise, train, or mentor junior team members.

+
Run a two-hour training with Leo and Ana on our valuation model: walk through inputs, error checks, scenario…
Run a two-hour training with Leo and Ana on our valuation model: walk through inputs, error checks, scenario runs and documentation standards, give them an exercise and feedback, and add outcomes to the team's playbook.
The tools that do the workMicrosoft PowerPointMicrosoft ExcelO*NET

Make investment recommendations

+
Prepare three ranked investment recommendations for the capital committee: thesis, expected return, downside…
Prepare three ranked investment recommendations for the capital committee: thesis, expected return, downside sensitivity and required covenants, include stress test results and a one-slide summary for Thursday's approval meeting.
The tools that do the workMicrosoft ExcelMicrosoft PowerPointjob descriptions

Follow-up on financing records with backers

+
Chase the three backers who missed the March filings, attach the reconciliation packet and the signed term…
Chase the three backers who missed the March filings, attach the reconciliation packet and the signed term sheets, ask for the outstanding bank statements and wire confirmations, and request their confirmations by next Thursday so we can close the quarter.
The tools that do the workMicrosoft OutlookMicrosoft Exceljob descriptions

Present findings to stakeholders

+
Put together a 12-slide briefing that explains next quarter revenue scenarios, key assumptions, and required…
Put together a 12-slide briefing that explains next quarter revenue scenarios, key assumptions, and required decisions, include the sensitivity table and ask for a 30-minute slot on Friday afternoon with finance, commercial leads and the CEO.
The tools that do the workMicrosoft PowerPointMicrosoft Exceljob descriptions

Meet with company management and key players

+
Schedule a 60-minute strategy meeting next Tuesday with the CFO, head of sales and operations, circulate the…
Schedule a 60-minute strategy meeting next Tuesday with the CFO, head of sales and operations, circulate the latest cash flow and forecast two days before, and flag three decision points we need their commitment on.
The tools that do the workMicrosoft OutlookMicrosoft Exceljob descriptions

Evaluate the stability of financial investments

+
Run a stress test on the portfolio to show five-year returns under base, downside and severe scenarios,…
Run a stress test on the portfolio to show five-year returns under base, downside and severe scenarios, highlight liquidity risks and covenant breach probabilities, and deliver the results with recommendations by Monday.
The tools that do the workMicrosoft ExcelIBM SPSS StatisticsWikipedia

Research market trends and economic data

+
Compile the past 18 months of sector data, GDP and interest rate movements, extract the top three trend…
Compile the past 18 months of sector data, GDP and interest rate movements, extract the top three trend drivers and a two-page implications note for our pricing and pipeline, finish by Wednesday for the commercial review.
The tools that do the workMicrosoft ExcelGoogle DocsWikipedia

Compare financial products and services

+
Create a comparison matrix of the five competing lending products, score them on cost, covenants, flexibility…
Create a comparison matrix of the five competing lending products, score them on cost, covenants, flexibility and execution time, recommend the preferred option and identify negotiation levers, circulate to procurement and the CFO by Friday.
The tools that do the workMicrosoft ExcelMicrosoft PowerPointWikipedia

Says who?

These are the pages we read to build this. Open any of them and check us.

Activities this job lives in

The human activities behind the tasks — each with its honest AI ceiling.

The logs, files & records this job keeps

Shared with other careers — the same record means something different in each.

Related careers

Same family of work — each with its own tasks and prompts.

The LLOS Work Atlas is the world's largest evidenced task library — a map of human work, with a ready prompt behind every task. 1,774 careers · every task named by the sources that witnessed it — O*NET, ESCO, real job descriptions, Wikipedia — and the deepest tasks by several at once. And it is honest about limits: where AI cannot help, the map says so.

The rest of the map

Same library, five ways in.

Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.
Built on public evidence: O*NET®, ESCO, Wikipedia, U.S. Bureau of Labor Statistics, ILOSTAT. All sources & licenses