26 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.
You usually split time between analysis, meetings, and document prep. Mornings often start by checking markets and asset performance in Excel and Power BI, updating models and spreadsheets with overnight data.
Afternoons go to meetings with portfolio managers, company management, or clients to discuss financial actions, then you build slides in PowerPoint and prepare materials for transactions or deal execution. Expect ad‑hoc tasks like mentoring juniors, following up on financing records, or preparing audit‑ready reports in Word or Google Docs.
Microsoft Excel is the core tool for models, forecasts, charts, and securities valuation. Power BI is used to build dashboards showing asset performance and market monitoring. PowerPoint and Word are used to present findings and prepare transaction materials.
You’ll also use Outlook for client coordination, QuickBooks if you touch company accounting, and sometimes SPSS for statistical analysis. Knowing Excel well (pivot tables, VBA or advanced formulas) plus basic Power BI will cover most day‑to‑day tasks.
AI can speed up data cleaning, draft presentations, and suggest model structures, but never treat its output as final. Use AI to generate first drafts of client presentations or to summarize market news, then verify every number in Excel and Power BI against your sources.
Avoid uploading confidential client documents to public AI services. Keep sensitive financials on company systems, and document assumptions clearly when you use AI so auditors or stakeholders can trace decisions.
Pay varies by region, company size, and your experience. Entry commercial analysts often start near junior analyst wages; mid‑level people with model and client experience earn noticeably more. Firms handling large portfolios or investment deals pay higher.
Key drivers are your ability to build reliable financial models, make actionable investment recommendations, and maintain client relationships. Specific numbers come from local salary surveys, company job posts, and industry reports rather than a single fixed figure.
Practice Excel modelling (discounted cash flow, scenario analysis, pivot tables), learn Power BI for dashboards, and make sample PowerPoint presentations summarizing investment analysis. Build a short portfolio of 2–3 example reports and valuations.
Take basic accounting and corporate finance courses, and practice using QuickBooks if the role touches company finance. Intern or help on real projects so you can point to concrete work (models, client decks, transaction materials) in interviews.
A commercial analyst focuses on company finance, transaction support, client relationships, and operational investment decisions—preparing deal materials, restructuring debt, and monitoring asset performance. You often use Excel, PowerPoint, and Power BI for internal and client deliverables.
An investment analyst leans more toward portfolio construction and market research for securities; a financial analyst can be broader (company budgeting, accounting). In practice the roles overlap, but commercial analysts spend more time on deal execution and client-facing finance.
Advanced Excel skills: building financial models, creating charts, and automating calculations. You’ll use Excel every day for valuation, forecasts, and scenario testing, and for producing charts that go into PowerPoint or Power BI.
Combine that with clear PowerPoint slides and basic Power BI dashboards. These let you present findings to stakeholders and prepare transaction materials that others—portfolio managers, clients, auditors—can act on.