Forecasting Analyst

Forecasting Analyst performs the documented duties on this page and it lists 26 real tasks to practice. The focus is on clear, repeatable steps and how tools like Microsoft Excel help. Each one shows where we found it, and comes with an AI prompt you can copy and use straight away.

26evidenced tasks
26ready prompts
8tools of the trade
13-2051.00O*NET-SOC code
361,980hold this job (US, BLS 2025)
$102,740median pay/yr (US)
Open Forecasting 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.

Analysing4

Prepare financial analysis reports

+
Prepare the monthly financial analysis report for Revenue and COGS by product line, include variance to…
Prepare the monthly financial analysis report for Revenue and COGS by product line, include variance to budget, three key drivers, and an executive two-slide summary for Monday morning so CFO can decide reallocation before the board pack is final.
The tools that do the workMicrosoft ExcelMicrosoft PowerPointESCOjob descriptionsWikipedia

Assess the viability of financial actions or entities

+
Assess whether launching the new subscription pricing tier is financially viable: run a five-year pro forma…
Assess whether launching the new subscription pricing tier is financially viable: run a five-year pro forma with sensitivity to churn and ARPU, show NPV, payback, and break-even headcount, and recommend proceed/hold for the product VP by Thursday.
The tools that do the workMicrosoft ExcelESCOO*NETWikipedia

Gather and analyze financial information

+
Gather quarterly financials from sales, operations, and payroll, reconcile to the ledger, produce cleaned…
Gather quarterly financials from sales, operations, and payroll, reconcile to the ledger, produce cleaned input tables and a summary dashboard of margins and cash burn for Friday’s forecast meeting with FP&A and the head of operations.
The tools that do the workMicrosoft Power BIMicrosoft Exceljob descriptionsO*NET

Analyze investment projects

+
Analyze the proposed warehouse expansion project: build a discounted cash flow with capex phasing, operating…
Analyze the proposed warehouse expansion project: build a discounted cash flow with capex phasing, operating uplift, tax and depreciation effects, then produce a risk-weighted IRR and recommendation for the capital committee next Wednesday.
The tools that do the workMicrosoft Exceljob descriptionsWikipedia
Learning1

Develop financial models and forecasts

+
Develop the next quarter forecast and scenario models: translate sales targets into monthly revenue drivers,…
Develop the next quarter forecast and scenario models: translate sales targets into monthly revenue drivers, link to expense ramps and working capital, create scenario toggles for best/worst/case, and deliver an updated forecast file to finance by Tuesday noon.
The tools that do the workMicrosoft Exceljob descriptionsWikipedia
Convincing1

Develop and operate financial analysis tools

+
Build and maintain the financial analysis toolkit: automate standard variance and KPI reports, document…
Build and maintain the financial analysis toolkit: automate standard variance and KPI reports, document calculation logic, create a reusable model library and a one-page user guide so analysts can run monthly close reports without errors.
The tools that do the workAlteryxMicrosoft Exceljob descriptionsO*NET
The daily work20

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

+
Prepare a consolidated financial plan covering cash flow forecasts, capex needs, revenue scenarios, and…
Prepare a consolidated financial plan covering cash flow forecasts, capex needs, revenue scenarios, and investment allocations for the board meeting on Monday, stress-testing three downside cases and flagging funding gaps above $200k.
The tools that do the workMicrosoft ExcelMicrosoft PowerPointESCO

Maintain transparent financial operations for taxation and auditing bodies

+
Assemble a transparent audit pack with reconciled ledgers, tax schedules, supporting invoices, and a one-page…
Assemble a transparent audit pack with reconciled ledgers, tax schedules, supporting invoices, and a one-page variance narrative for the external auditors and tax officer by next Friday, ensuring all entries match the statutory accounts.
The tools that do the workIntuit QuickBooksGoogle DocsESCO

Advise clients or organizations on financial decisions

+
Advise the CFO and head of strategy on whether to reallocate the next quarter's working capital into the new…
Advise the CFO and head of strategy on whether to reallocate the next quarter's working capital into the new product line, showing projected cash flow, break-even timing, and three downside scenarios by Wednesday so the board can vote Thursday.
The tools that do the workMicrosoft ExcelO*NETWikipedia

Collaborate with portfolio managers and analysts

+
Work with Maia in portfolio management and Daniel the equity analyst to reconcile forecast assumptions, merge…
Work with Maia in portfolio management and Daniel the equity analyst to reconcile forecast assumptions, merge their revenue and risk inputs into a single model, and deliver a reconciled forecast with commentary and action items by Friday noon for the portfolio review meeting.
The tools that do the workGoogle DocsMicrosoft Exceljob descriptionsO*NET

Monitor financial markets and asset performance

+
Monitor the fixed income and equity desks overnight for sharp moves, flag any holdings down more than 5…
Monitor the fixed income and equity desks overnight for sharp moves, flag any holdings down more than 5 percent or with volatility spikes, produce a morning brief with attribution and suggested position changes by 7:30 a.m., and notify the head trader immediately if thresholds are breached.
The tools that do the workMicrosoft Power BIjob descriptionsWikipedia

Purchase investments for companies in accordance with company policy.

+
Execute purchases to rebalance the corporate investment portfolio to policy targets, buy the approved…
Execute purchases to rebalance the corporate investment portfolio to policy targets, buy the approved short-duration corporate bonds up to the authorised limit today, record trade details, and confirm compliance with duration and credit limits before settlement.
The tools that do the workMicrosoft ExcelO*NET

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

+
Meet with Priya the CFO and external counsel to map options to restructure the term loan, model cash…
Meet with Priya the CFO and external counsel to map options to restructure the term loan, model cash serviceability for each option, and produce a recommended term and covenant package to present to the lender by Monday morning so refinancing talks can start Tuesday.
The tools that do the workMicrosoft ExcelO*NET

Create client presentations of plan details.

+
Prepare a client-facing presentation summarising the proposed five-year financial plan, include key…
Prepare a client-facing presentation summarising the proposed five-year financial plan, include key assumptions, scenario slides, and a one-page executive recommendation, then send the proof to marketing and the client relationship lead for signoff by Thursday afternoon.
The tools that do the workMicrosoft PowerPointMicrosoft ExcelO*NET

Follow-up on financing records with backers

+
Chase the five backers listed in the financing register for missing transaction receipts and confirmation of…
Chase the five backers listed in the financing register for missing transaction receipts and confirmation of committed tranches, attach the reconciled ledger extract, set a clear next-response deadline of Wednesday, and flag any shortfalls over $50,000 for escalation to Serena in treasury.
The tools that do the workMicrosoft OutlookMicrosoft Exceljob descriptions

Present findings to stakeholders

+
Summarise the quarter‑end forecast, build three downside/upside scenarios with key assumptions, create a…
Summarise the quarter‑end forecast, build three downside/upside scenarios with key assumptions, create a ten‑slide stakeholder deck highlighting cash runway and risks, and circulate to the board and operations leads by Monday for their comments.
The tools that do the workMicrosoft PowerPointMicrosoft Exceljob descriptions

Meet with company management and key players

+
Schedule a one‑hour review with CEO Lina, CFO Marcus, head of sales Javier, and product lead Aisha next…
Schedule a one‑hour review with CEO Lina, CFO Marcus, head of sales Javier, and product lead Aisha next Thursday, circulate the meeting brief with the updated forecast and three decisions we need, and request each attendee send written priorities 48 hours beforehand.
The tools that do the workMicrosoft Outlookjob descriptions

Evaluate the stability of financial investments

+
Run a stability analysis on our five largest investments showing quarterly returns, volatility, and…
Run a stability analysis on our five largest investments showing quarterly returns, volatility, and correlation to the benchmark, highlight any positions with rolling drawdown over 10%, and deliver the findings to Peter in risk by Friday noon.
The tools that do the workMicrosoft ExcelWikipedia

Research market trends and economic data

+
Compile recent GDP, sector PMI, and commodity price series, identify three emerging trends that affect our…
Compile recent GDP, sector PMI, and commodity price series, identify three emerging trends that affect our revenue forecast, quantify their impact on next‑year top line under base and stress cases, and send the research note to marketing and strategy by Wednesday.
The tools that do the workMicrosoft Power BIMicrosoft ExcelWikipedia

Compare financial products and services

+
Compare our current corporate loan, two competing term facilities, and the preferred treasury product on…
Compare our current corporate loan, two competing term facilities, and the preferred treasury product on total cost, covenants, and flexibility over five years, produce a one‑page recommendation with numbers, and deliver to CFO Marcus and legal by Friday close of business.
The tools that do the workMicrosoft ExcelWikipedia

Perform securities valuation or pricing.

+
Value the preferred and common securities for Franklin Capital’s proposed purchase of Acme Utilities using…
Value the preferred and common securities for Franklin Capital’s proposed purchase of Acme Utilities using the latest financials, apply DCF and comparable multiples, produce per-share and portfolio-level prices, and flag any model assumptions that move valuation by over 10%.
The tools that do the workMicrosoft ExcelO*NET

Develop and maintain client relationships.

+
Set up next-quarter check-in with the portfolio contacts at Ridgeway Partners and Cedar Trust, send an agenda…
Set up next-quarter check-in with the portfolio contacts at Ridgeway Partners and Cedar Trust, send an agenda covering performance, rate assumptions, and renewal opportunities, and prepare a one-page briefing showing our forecast, upside cases, and proposed next steps before the call.
The tools that do the workMicrosoft OutlookMicrosoft ExcelO*NET

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

+
Create three clean charts for the Q2 technical report: a monthly revenue trend with moving average, a…
Create three clean charts for the Q2 technical report: a monthly revenue trend with moving average, a sensitivity tornado of rate versus margin, and a weighted-asset allocation pie, formatted for print and legible at 9 point.
The tools that do the workMicrosoft ExcelO*NET

Prepare all materials for transactions or execution of deals.

+
Assemble the transaction packet for the Rhinehold deal: final term sheet, updated forecast model, cap table,…
Assemble the transaction packet for the Rhinehold deal: final term sheet, updated forecast model, cap table, diligence checklist status, and a redlines summary, check every attachment against the checklist, and mark anything missing before legal review.
The tools that do the workMicrosoft ExcelMicrosoft OutlookO*NET

Supervise, train, or mentor junior team members.

+
Run a two-hour training with junior analysts on our forecasting model standards: walk through inputs, common…
Run a two-hour training with junior analysts on our forecasting model standards: walk through inputs, common errors, version control, and a live clean-up exercise using last quarter’s model, then assign follow-up fixes and review due Friday.
The tools that do the workMicrosoft PowerPointMicrosoft ExcelO*NET

Make investment recommendations

+
Draft three ranked investment recommendations for the client portfolio: include target price, horizon,…
Draft three ranked investment recommendations for the client portfolio: include target price, horizon, conviction level, key risks, and portfolio impact, justify each with numbers from our latest forecasts and deliver the memo to Helen in PMO by Wednesday noon.
The tools that do the workMicrosoft ExcelMicrosoft Wordjob descriptions

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