Template

Financial Analyst — Competency Roadmap

Work towards being a financial analyst: reading and interpreting financial statements, building models and forecasts, valuing businesses and turning the analysis into recommendations people can act on.

This roadmap takes you from complete beginner to a well-rounded financial analyst across 11 core and specialist phases. You will master financial accounting, dynamic three-statement modelling, corporate valuation, and corporate finance, before branching into FP&A, equity research, and credit analysis tracks. Finishing this plan leaves you with a portfolio of dynamic financial models, institutional-grade equity and credit reports, and the analytical rigour required for technical finance interviews.

By the end: You will be able to construct dynamic three-statement financial models and multi-scenario DCF valuations from SEC filings, evaluate corporate creditworthiness, and deliver structured investment memos and FP&A variance analyses that drive capital decisions.

Starting levelBeginnerStyleA mix
10h / week11 phases29 tasks~171h total

This is the map — make this roadmap yours

It shows what this journey generally looks like. Tell Kaidoro your version of the goal and it builds the plan around where you are actually starting, what to do first, the hours you really have, and what you have already finished.

1

Financial Accounting & Three-Statement Mechanics

Master the rules of accrual accounting and understand how transactions flow across the Income Statement, Balance Sheet, and Cash Flow Statement.

  • Learn the core accounting equation and accrual principles
    ~5hLearn1 resource

    Financial modelling is impossible without an intuitive grasp of how transactions change balance sheet accounts.

    You'll learn

    • Accrual Accounting — recording revenue when earned and expenses when incurred rather than when cash moves
    • Double-Entry Bookkeeping — system where every transaction affects at least two accounts to maintain balance
    • Matching Principle — accounting rule requiring expenses to be matched with the revenues they helped generate

    Understand how double-entry bookkeeping works and how debits and credits maintain the fundamental equation: Assets = Liabilities + Shareholders' Equity. Compare revenue recognition and matching principles under accrual accounting versus cash accounting.

    Done when: you can correctly categorize 20 standard business transactions into debits, credits, and their net impact on the balance sheet equation.

    How to work through it

    1. Review the definition of assets, liabilities, and equity
    2. Study revenue recognition criteria and the expense matching principle
    3. Work through 20 practice transaction journal entries
  • Deconstruct a real public company 10-K filing
    ~4hPractice1 resource

    Real-world financial reporting contains nuances, non-operating items, and adjustments rarely shown in simplified textbooks.

    You'll learn

    • Form 10-K — comprehensive annual report required by the U.S. SEC
    • Footnote Disclosures — supplementary notes explaining accounting policies and detailed breakdowns
    • Retained Earnings — cumulative net income retained in the business rather than paid out as dividends

    Download an SEC Form 10-K for a mature consumer goods company (e.g., Apple, Nike, or Coca-Cola) via SEC EDGAR. Locate the three primary financial statements and read the footnotes relating to debt, revenue recognition, and depreciation.

    Done when: you have highlighted and cross-referenced where Net Income from the Income Statement flows into Retained Earnings and Operating Cash Flow.

    How to work through it

    1. Navigate to SEC EDGAR and search for a public company 10-K
    2. Identify the Consolidated Statements of Operations, Balance Sheets, and Cash Flows
    3. Read Note 1 (Summary of Significant Accounting Policies) to understand revenue and inventory recognition
  • Build a manual three-statement integration engine
    ~6hBuild

    This exercise cements the exact plumbing linking Net Income, Working Capital changes, CapEx, and Debt balances.

    You'll learn

    • Working Capital — current operating assets minus current operating liabilities
    • CapEx (Capital Expenditures) — funds used by a company to acquire or upgrade physical assets
    • Balance Sheet Check — a boolean or difference formula verifying Assets equal Liabilities plus Equity

    Create a clean spreadsheet linking an Income Statement, Balance Sheet, and Cash Flow Statement across three historical years and two forecast periods. Ensure the balance sheet balances automatically via the cash flow ending balance.

    Done when: the balance sheet check displays zero across all periods and injecting a $100 increase in CapEx correctly flows through Cash Flow, PP&E, and Depreciation.

    How to work through it

    1. Set up historical line items in Excel
    2. Derive the Statement of Cash Flows directly from Income Statement net income and Balance Sheet balance deltas
    3. Link Cash Flow ending cash to the Balance Sheet cash line
    4. Create a dynamic error check cell (=Assets - (Liabilities + Equity))
2

Financial Ratio Analysis & Corporate Performance

Learn to diagnose a business's liquidity, solvency, operating efficiency, and profitability using ratio decomposition and normalized figures.

  • Calculate and interpret profitability and efficiency ratios
    ~5hPractice

    Raw dollar figures do not show operational excellence; ratios standardize metrics across peers of different sizes.

    You'll learn

    • EBITDA — Earnings Before Interest, Taxes, Depreciation, and Amortization
    • ROIC — Return on Invested Capital, measuring efficiency at allocating capital to profitable investments
    • Gross Margin — percentage of revenue exceeding cost of goods sold

    Compute Gross Margin, Operating Margin (EBIT), EBITDA Margin, Return on Assets (ROA), Return on Equity (ROE), and Asset Turnover for two competing companies over a 5-year historical period.

    Done when: you have generated a comparative ratio schedule and written a 1-page summary explaining which company generates superior capital efficiency and why.

    How to work through it

    1. Pull 5 years of historical financials for two direct industry competitors
    2. Build standard formulas for gross, operating, and net margins
    3. Calculate Return on Invested Capital (ROIC) and Return on Equity (ROE)
    4. Identify trends in margins and explain margin expansion or contraction drivers
  • Execute a 3-stage and 5-stage DuPont analysis
    ~4hPractice

    High ROE can mask excessive debt; DuPont analysis reveals the quality and sustainability of equity returns.

    You'll learn

    • DuPont Analysis — framework for breaking down ROE to identify drivers of profitability
    • Equity Multiplier — leverage ratio calculated as Total Assets divided by Total Shareholders' Equity
    • Tax Burden — Net Income divided by Pre-Tax Income (EBT)

    Deconstruct Return on Equity into Operating Efficiency (Net Margin), Asset Turnover (Efficiency), and Financial Leverage (Equity Multiplier). Further expand into the 5-stage model isolating Tax Burden and Interest Burden.

    Done when: you can pinpoint whether an increase in a company's ROE is driven by genuine operating improvements, financial gearing, or tax adjustments.

    How to work through it

    1. Extract Net Income, EBT, EBIT, Revenue, Total Assets, and Total Equity
    2. Calculate the 3 DuPont components and verify their product equals ROE
    3. Calculate the 5 DuPont components to isolate interest and tax effects
  • Produce a financial health and normalization tear sheet
    ~6hBuild

    Analysts must always work with normalized, recurring operational earnings rather than unadjusted GAAP numbers.

    You'll learn

    • Normalized Earnings — earnings adjusted to remove one-off or unusual items
    • Interest Coverage Ratio — EBIT divided by interest expense, measuring ease of servicing interest
    • Net Debt — total gross interest-bearing debt minus cash and cash equivalents

    Normalize reported earnings by stripping out non-recurring items (restructuring charges, litigation settlements, asset impairments) and evaluate liquidity and solvency ratios (Current Ratio, Quick Ratio, Net Debt / EBITDA, Interest Coverage).

    Done when: you produce a 2-page financial health tear sheet with adjusted EBITDA, normalized Free Cash Flow, and a verdict on debt servicing capacity.

    How to work through it

    1. Identify one-off items in the footnotes and MD&A section
    2. Build an Adjusted EBITDA and Adjusted FCF reconciliation bridge
    3. Compute leverage and coverage ratios against historical norms
    4. Format the findings into a clear executive tear sheet
3

Financial Modelling Fundamentals in Excel

Learn professional financial modelling standards, keyboard-first Excel efficiency, and dynamic schedule construction.

  • Master professional financial modelling formatting and shortcuts
    ~4hPractice

    Speed, auditability, and standardization are mandatory for any institutional financial analyst role.

    You'll learn

    • Financial Model Color Coding — visual convention separating inputs, calculations, and cross-sheet links
    • Dynamic Referencing — using XLOOKUP and INDEX/MATCH to eliminate static brittle references

    Adopt standard Wall Street color coding (blue for hardcodes, black for calculations, green for sheet links, red for external links). Learn fundamental keyboard navigation without using the mouse.

    Done when: you can format and build a dynamic 20-row calculation schedule entirely without touching the mouse in under 15 minutes.

    How to work through it

    1. Configure Excel settings for formula auditing and disable automatic error popups
    2. Practice core shortcuts (F2, F4, Ctrl+1, Alt keys, INDEX/MATCH, XLOOKUP)
    3. Apply standardized color-coding and number formatting ($#,##0;($#,##0);"-")
  • Build dynamic supporting schedules (Depreciation, Debt, Working Capital)
    ~7hBuild

    Core statements should never hold complex sub-calculations; they must be fed cleanly by dedicated supporting schedules.

    You'll learn

    • Roll-Forward Schedule — table tracking opening balance, additions, reductions, and closing balance
    • Cash Conversion Cycle — metric expressing time taken to convert investments in inventory back into cash
    • Circular Reference — formula that refers back to its own cell, common in interest expense vs ending cash

    Construct standalone, modular schedules: a PP&E/Depreciation roll-forward schedule with CapEx forecasting; a Working Capital schedule driven by Days Sales Outstanding (DSO), Days Inventory Outstanding (DIO), and Days Payables Outstanding (DPO); and a Debt schedule with a circular-reference-safe interest calculation.

    Done when: all three supporting schedules automatically update output rows based on user input drivers without formula errors.

    How to work through it

    1. Build PP&E roll-forward: Beginning PP&E + CapEx - Depreciation = Ending PP&E
    2. Build Working Capital drivers using 365-day cash conversion cycle formulas
    3. Build Debt amortization schedules with optional debt repayment logic
  • Construct a fully integrated 3-statement dynamic forecast model
    ~8hBuild

    This integrated 3-statement model is the foundational engine behind valuation, credit analysis, and corporate forecasting.

    You'll learn

    • Cash Sweep — mandatory use of excess free cash flow to pay down outstanding debt balances
    • Revolving Credit Facility — flexible bank line of credit drawn when cash drops below a minimum threshold

    Assemble historical data, forecast drivers (revenue growth %, gross margin %, SG&A % of revenue), supporting schedules, and integrated core statements into a complete 5-year operating model.

    Done when: the integrated model dynamically balances across historical and 5-year forecast periods under any driver change.

    How to work through it

    1. Structure dedicated tabs: Cover/Summary, Drivers, Income Statement, Balance Sheet, Cash Flow, Schedules
    2. Link forecast revenue and costs to driver inputs
    3. Connect depreciation, working capital, and debt schedules into core statements
    4. Implement a dynamic cash sweep/revolver mechanism
4

Corporate Finance & Cost of Capital (WACC)

Calculate the theoretical cost of capital for businesses by evaluating capital structure, market risk, and the time value of money.

  • Calculate Cost of Equity using the Capital Asset Pricing Model (CAPM)
    ~4hLearn1 resource

    Cost of equity represents the required rate of return for equity shareholders and forms a core component of discount rates.

    You'll learn

    • CAPM — model describing the relationship between systematic risk and expected return for assets
    • Beta — measure of a stock's volatility in relation to the overall market
    • Equity Risk Premium — excess return that investing in the stock market provides over a risk-free rate

    Estimate a company's Cost of Equity ($K_e$) using the risk-free rate ($R_f$), equity risk premium ($ERP$), and levered beta ($\beta$). Collect raw beta data and understand historical vs implied risk premiums.

    Done when: you can calculate and justify the Cost of Equity for a chosen public firm citing specific source dates for $R_f$ and $ERP$.

    How to work through it

    1. Identify the appropriate 10-year Treasury yield as the risk-free benchmark
    2. Determine the country equity risk premium using published research data
    3. Retrieve or calculate regression beta for the target equity
  • Unlever and relever peer betas to establish pure-play asset risk
    ~5hPractice

    Observed market beta reflects both business risk and financial debt risk; unlevering isolates pure business risk.

    You'll learn

    • Unlevered Beta (Asset Beta) — measure of business risk without the impact of financial leverage
    • Hamada Equation — formula used to separate financial risk from business risk in beta calculations

    Gather a peer group of 4-6 comparable firms, calculate their levered betas, unlever them using their respective debt-to-equity ratios and marginal tax rates to obtain asset betas, calculate the median, and relever to target leverage.

    Done when: you have built an unlevered/relevered beta schedule in Excel with clear formula derivations for Hamada's equation.

    How to work through it

    1. Pull market cap, total debt, cash, and raw betas for 5 comparable peers
    2. Calculate debt-to-equity ratios and apply marginal tax rates
    3. Compute unlevered asset beta for each peer and calculate the peer median
    4. Relever the median beta using the target company's capital structure
  • Calculate Weighted Average Cost of Capital (WACC)
    ~5hBuild

    WACC is the foundational discount rate used to value entire firms in discounted cash flow analyses.

    You'll learn

    • WACC — average rate of return a company expects to pay to all its security holders
    • Synthetic Rating — estimated credit rating based on interest coverage when public bond ratings are unavailable
    • Market Value of Capital — weighting debt and equity by current market values rather than book values

    Determine the effective after-tax cost of debt ($K_d \times (1 - t)$) using yield to maturity (YTM) on existing bonds or credit rating synthetic spreads. Combine with cost of equity weighted by market value weights of debt and equity.

    Done when: you have built a dynamic WACC module that outputs the discount rate and includes sensitivity tables for beta vs equity risk premium.

    How to work through it

    1. Compute market value of equity and market value of debt
    2. Determine pre-tax cost of debt from bond pricing or synthetic credit spread
    3. Apply the marginal tax rate to determine after-tax cost of debt
    4. Calculate WACC formula: $(E/V \times K_e) + (D/V \times K_d \times (1-t))$
5

Business Valuation Methodologies (DCF & Relative Valuation)

Determine intrinsic enterprise and equity value using Discounted Cash Flow (Unlevered FCF) and Comparable Company Multiples.

  • Derive Unlevered Free Cash Flow (FCFF) and terminal value
    ~6hLearn

    Unlevered Free Cash Flow represents cash generated by core operations available to all capital providers regardless of capital structure.

    You'll learn

    • FCFF (Free Cash Flow to Firm) — cash flow available to debt and equity holders after operating expenses and reinvestment
    • Gordon Growth Model — valuation method assuming cash flows grow at a constant stable rate indefinitely
    • Mid-Year Discounting — adjustment accounting for cash flows being received smoothly throughout the year rather than year-end

    Derive Free Cash Flow to Firm: EBIT * (1 - Tax Rate) + D&A - CapEx - Change in NWC. Calculate Terminal Value using both the Gordon Growth (Perpetual Growth) Method and the Exit Multiple (EV/EBITDA) Method.

    Done when: your schedule outputs clean annual UFCF and computes discounted terminal values under both methods.

    How to work through it

    1. Build UFCF bridge directly from EBIT down to Free Cash Flow to Firm
    2. Implement mid-year discounting convention factors
    3. Calculate Gordon Growth terminal value: $[FCFF_n \times (1+g)] / (WACC - g)$
    4. Calculate Exit Multiple terminal value: $EBITDA_n \times Multiple$
  • Build a comprehensive Discounted Cash Flow (DCF) model with enterprise-to-equity bridge
    ~8hBuild

    Bridging Enterprise Value to Equity Value is where many beginners make double-counting errors.

    You'll learn

    • Enterprise Value (EV) — total measure of a company's total value, often viewed as the cost to acquire the entire business
    • Treasury Stock Method — method for calculating diluted share count accounting for in-the-money options and warrants
    • Data Tables — Excel sensitivity tool for testing multiple variable iterations simultaneously

    Discount projected UFCFs and Terminal Value back to present value to find Enterprise Value. Bridge Enterprise Value to Equity Value by subtracting Total Debt, Preferred Equity, and Minority Interest, and adding Cash and Non-Operating Assets. Divide by diluted shares to derive implied price per share.

    Done when: the model produces an implied share price and contains two-way sensitivity tables (WACC vs Perpetual Growth Rate, and WACC vs Exit Multiple).

    How to work through it

    1. Sum present value of explicit forecast period cash flows and present value of terminal value
    2. Apply the enterprise value to equity value bridge (EV - Net Debt = Equity Value)
    3. Calculate treasury stock method diluted shares outstanding
    4. Set up Excel data tables for 2-way sensitivity analysis
  • Build a Comparable Companies (Trading Comps) and Precedent Transactions analysis
    ~7hBuild

    Institutional investors never rely on one valuation method; triangulating between DCF and relative multiples provides realistic valuation bands.

    You'll learn

    • LTM / NTM — Last Twelve Months / Next Twelve Months
    • EV/EBITDA Multiple — enterprise multiple comparing enterprise value to cash operating earnings
    • Football Field Chart — visual representation of valuation ranges generated by different methodologies

    Select 6-8 relevant peers for a target company. Spread historical and forward Enterprise Value multiples (EV/Revenue, EV/EBITDA) and Equity Value multiples (P/E, P/B). Calculate peer min, 25th percentile, median, mean, 75th percentile, and max.

    Done when: you have generated a valuation 'Football Field' chart comparing the implied share price ranges across DCF, Trading Comps, and Precedents.

    How to work through it

    1. Select peer group based on sector, geography, size, and business model
    2. Normalize LTM and NTM financials from public consensus estimates
    3. Calculate implied target equity values using 25th percentile and median peer multiples
    4. Create a floating bar 'Football Field' valuation chart in Excel
6

Advanced Financial Modelling (M&A and LBO Foundations)

Expand modelling capabilities into transaction mechanics, including accretion/dilution merger models and leveraged buyout returns.

  • Build an M&A Accretion / Dilution merger model
    ~7hBuild

    Understanding the earnings and balance sheet impact of acquisitions is essential for both corporate finance and equity research roles.

    You'll learn

    • Accretion/Dilution — whether post-transaction earnings per share increase (accretion) or decrease (dilution)
    • Goodwill — intangible asset recorded when purchase price exceeds fair value of acquired net assets
    • Sources & Uses — table outlining where capital comes from (debt, equity, cash) and how it is spent (equity purchase, fees)

    Model a corporate acquisition evaluating deal financing mix (Cash, Debt, Stock). Combine balance sheets, model purchase price allocation (Goodwill calculation), account for foregone interest on cash, new interest on debt, and synergies.

    Done when: the model outputs pro-forma combined EPS and calculates whether the transaction is accretive or dilutive to the acquirer's EPS in Year 1 and Year 2.

    How to work through it

    1. Calculate purchase price and transaction sources & uses
    2. Determine goodwill: Purchase Price - Fair Value of Net Identifiable Assets
    3. Combine income statements factoring in cost synergies and financing costs
    4. Compute Pro-Forma EPS vs Standalone EPS
  • Build a fundamental Leveraged Buyout (LBO) paper model and full model
    ~8hBuild

    LBO modelling tests maximum cash generation, debt capacity, and return attribution under aggressive capital structures.

    You'll learn

    • IRR (Internal Rate of Return) — annualized rate of return generated by an investment
    • MoIC (Multiple on Invested Capital) — total cash returned divided by total cash invested
    • Debt Waterfall — priority order in which available cash must be used to service various tranches of debt

    Build a 5-year LBO model: establish entry multiple, structure debt tranches (Senior Debt, Subordinated Debt), construct the cash sweep debt paydown schedule, and calculate exit equity value and returns (IRR and MoIC).

    Done when: the model dynamically calculates Sponsor IRR and Cash-on-Cash multiple across exit year and exit multiple sensitivity tables.

    How to work through it

    1. Set up transaction assumptions, leverage multiples, and debt financing terms
    2. Forecast operational cash flow available for debt service
    3. Build waterfall debt repayment schedule and interest expense
    4. Calculate sponsor returns: Internal Rate of Return (IRR) and Multiple on Invested Capital (MoIC)
7

Specialization Track — Corporate FP&A (Financial Planning & Analysis)

Develop internal corporate finance skills: annual operating plans (AOP), rolling forecasts, variance analysis, and unit economics.

  • Build a dynamic Departmental Budget & Annual Operating Plan (AOP)
    ~6hBuild

    FP&A analysts spend substantial time building bottom-up expense and headcount models to support business unit leaders.

    You'll learn

    • Annual Operating Plan (AOP) — formal corporate operational budget set before each fiscal year
    • Bottom-Up Forecasting — estimating company-wide metrics by starting with granular operational units and adding them together
    • Benefits Loading Factor — percentage added to base salary to cover taxes, health insurance, and retirement

    Create a bottom-up budget model projecting department-level headcount expenses, payroll taxes, operational expenditure, and travel & entertainment costs, aggregated into a master corporate summary.

    Done when: modifying headcount hiring start dates dynamically recalculates monthly department expenses and total company cash outflow.

    How to work through it

    1. Build headcount roster schedule driven by hire date, salary, bonus %, and benefits loading
    2. Build operating expense schedule driven by fixed costs and variable revenue drivers
    3. Consolidate department tabs into an executive master P&L budget
  • Perform Price-Volume-Mix (PVM) and Budget vs Actuals (BvA) variance analysis
    ~5hPractice

    Management needs to know whether missed revenue targets were caused by pricing pressure, unit volume declines, or shifting product mix.

    You'll learn

    • Price-Volume-Mix (PVM) Analysis — mathematical decomposition explaining revenue changes caused by price shifts, sales volume, or product selection
    • Variance Analysis — quantitative investigation of the difference between actual results and planned targets
    • Waterfall Chart — visual tool showing how an initial value is affected by intermediate positive or negative values

    Analyze the variance between monthly actual financial results and budgeted targets. Decompose gross revenue and margin deviations into Price variance, Volume variance, and Product Mix variance.

    Done when: you have generated a waterfall variance chart showing the exact bridge from Budgeted Gross Margin to Actual Gross Margin.

    How to work through it

    1. Calculate dollar variance ($) and percentage variance (%) for all revenue and expense lines
    2. Apply Price-Volume-Mix formulas to unit sales data
    3. Build an Excel Waterfall bridge chart visualizing the variance breakdown
    4. Draft a 1-page commentary explaining major root causes
  • Model SaaS / Subscription Unit Economics and Cohort Retention
    ~6hBuild

    Modern corporate FP&A roles heavily require specialized domain metrics such as recurring revenue and cohort analysis.

    You'll learn

    • LTV/CAC Ratio — ratio comparing the lifetime value of a customer to the cost of acquiring them
    • Net Revenue Retention (NRR) — percentage of recurring revenue retained from existing customers over a given time period
    • Cohort Analysis — tracking behavioral metrics of a specific group of customers who signed up in the same time frame

    Construct an operational unit economics model for a subscription business calculating Customer Acquisition Cost (CAC), Lifetime Value (LTV), LTV/CAC ratio, Monthly Recurring Revenue (MRR) expansion, and Net Revenue Retention (NRR).

    Done when: you produce a cohort retention matrix and a dashboard of SaaS metrics indicating payback period in months.

    How to work through it

    1. Build a monthly customer cohort retention schedule (triangular matrix)
    2. Model MRR components: New, Expansion, Contraction, Churn
    3. Compute CAC, LTV, CAC Payback Period, and NRR formulas
8

Specialization Track — Equity Research & Asset Management

Develop public markets investment research skills: industry analysis, thesis generation, earnings preview/review, and institutional report writing.

  • Perform an industry competitive structure analysis (Porter's Five Forces & Moats)
    ~5hLearn

    Financial forecasts are meaningless without deep qualitative conviction regarding the industry's economic structure.

    You'll learn

    • Economic Moat — distinct competitive advantage that allows a company to maintain superior profitability over long horizons
    • Porter's Five Forces — framework for analyzing industry competition and profitability potential
    • Pricing Power — ability of a firm to raise prices without reducing customer demand

    Analyze an industry sector (e.g., Semiconductors or Enterprise Software). Evaluate supplier power, buyer power, threat of substitutes, barriers to entry, and competitive rivalry. Identify the economic moat sources for the dominant market leaders.

    Done when: you produce a structured 3-page industry research note detailing pricing power, capital intensity, and secular growth drivers.

    How to work through it

    1. Define industry boundaries and value chain participants
    2. Evaluate pricing power and supplier concentration
    3. Identify economic moats: network effects, switching costs, scale advantages, or intangible assets
    4. Synthesize total addressable market (TAM) growth trajectory
  • Author an institutional-grade Equity Initiation of Coverage Report
    ~10hBuild

    The initiation report is the quintessential flagship deliverable for buy-side and sell-side equity analysts.

    You'll learn

    • Variant Perception — analytical view that differs materially from consensus expectations
    • Initiation of Coverage — comprehensive first report issued by an analyst on a specific stock setting ratings and target price
    • Consensus Estimates — average financial estimates published by all sell-side analysts covering a stock

    Select a mid-cap public company. Build a complete dynamic financial model, formulate a differentiated variant perception (thesis), establish a 12-month target price using blended DCF/Comps, and write a professional 8-page initiation report.

    Done when: your report includes an executive investment thesis, key variant perception, risk factors, financial forecast summary table, and valuation methodology.

    How to work through it

    1. Develop 2-3 core thesis points differentiating your view from market consensus
    2. Build full 3-statement forecast model and valuation bridge
    3. Structure the report: Executive Summary, Investment Thesis, Industry Drivers, Financial Analysis, Valuation, Risks
    4. Review formatting to ensure institutional layout quality
9

Specialization Track — Credit Analysis & Fixed Income

Evaluate default risk, debt covenants, recovery rates, and downside debt capacity for leveraged and investment-grade borrowers.

  • Evaluate debt structures, bond indentures, and negative covenants
    ~6hLearn

    Credit analysts focus primarily on downside protection, asset security, and legal enforceability of repayment.

    You'll learn

    • Bond Indenture — legal contract between bond issuer and bondholders detailing terms and restrictions
    • Maintenance Covenant — requirement to maintain specific financial ratios (e.g., Leverage < 4.0x) tested quarterly
    • Lien Priority — legal claim priority over pledged assets in the event of default or bankruptcy

    Review a bond indenture or credit agreement on SEC EDGAR. Map out debt capital structure priority (Senior Secured, Senior Unsecured, Subordinated, Mezzanine) and evaluate covenant protections (Debt incurrence tests, restricted payments, change of control).

    Done when: you produce a capital structure priority diagram showing lien status, maturity schedule, and covenant cushion for a chosen issuer.

    How to work through it

    1. Retrieve an issuer's bond prospectus (424B2 filing) or Credit Agreement (Exhibit 10 to 10-K)
    2. Identify affirmative, negative, and financial maintenance covenants
    3. Chart the debt maturity profile across the next 7 years
    4. Calculate covenant headroom based on current trailing EBITDA
  • Perform a downside stress test and Liquidity / Recovery analysis
    ~7hBuild

    A credit analyst's primary job is verifying how a company survives its worst conceivable operating environment.

    You'll learn

    • Recovery Rate — percentage of principal and accrued interest recovered following a borrower default
    • Liquidity Runway — amount of time a company can continue operating before running out of cash during deficits
    • Liquidation Waterfall — legal order of distribution of asset proceeds to creditors during bankruptcy

    Build a severe downside recession scenario on a company's forecast model (25% revenue drop, 300 bps margin contraction). Calculate burn rate, runway under available liquidity, and perform an enterprise value liquidation waterfall to estimate recovery rates for each debt tranche.

    Done when: you write a 2-page Credit Committee Memo concluding with a formal recommendation (Approve/Reject loan, or Overweight/Underweight bond) with expected recovery percentages.

    How to work through it

    1. Inject stress drivers: volume compression, margin squeeze, working capital drain
    2. Track monthly liquidity (Cash + Available Revolver Capacity)
    3. Estimate liquidation/distressed enterprise value under 5x trough EBITDA
    4. Waterfall enterprise value through the capital structure to compute recovery %
10

Financial Data Tools & Analytics (SQL & Python)

Supercharge analytical productivity by querying financial databases, scraping data, and automating repetitive analysis tasks.

  • Query corporate financial datasets using SQL
    ~5hPractice1 resource

    Modern FP&A and quantitative analyst roles frequently query data warehouses (Snowflake, BigQuery) directly rather than waiting for CSV extracts.

    You'll learn

    • SQL Window Functions — calculations across a set of table rows that are related to the current row
    • Common Table Expressions (CTE) — temporary named result set defined within a SELECT, INSERT, UPDATE, or DELETE statement

    Write SQL queries to filter, aggregate, and join transactional financial datasets. Calculate monthly customer cohort revenue, rolling average margins, and sales rep commission payouts using window functions and CTEs.

    Done when: you write a single query using Common Table Expressions (CTEs) and window functions (OVER (PARTITION BY ... ORDER BY ...)) that extracts rolling 3-month average revenue per customer from raw transaction tables.

    How to work through it

    1. Set up SQLite or PostgreSQL with a sample retail transaction database
    2. Write basic aggregation queries (SUM, AVG, GROUP BY, HAVING)
    3. Implement multi-table INNER and LEFT JOINs across customers, orders, and products
    4. Write advanced analytical window functions and CTEs
  • Automate financial data pulling and charting in Python
    ~6hBuild

    Automating routine data aggregation in Python saves dozens of manual hours when monitoring broad market universes.

    You'll learn

    • pandas — Python library providing high-performance data structures and analysis tools
    • Sharpe Ratio — measure of risk-adjusted return calculated as excess return divided by standard deviation
    • DataFrames — two-dimensional, size-mutable, tabular data structure in pandas

    Use Python with pandas and yfinance to pull historical market prices and financial metrics for an index of 50 companies. Automate calculation of cumulative returns, volatility, correlation matrices, and export a formatted summary chart.

    Done when: your script runs from command line, downloads data for 10 tickers, and saves a generated correlation heatmap and cumulative performance graph.

    How to work through it

    1. Install pandas, matplotlib, seaborn, and yfinance in a virtual environment
    2. Write a script to fetch 5 years of daily adjusted closing prices
    3. Calculate daily log returns, rolling volatility, and annualized Sharpe ratios
    4. Generate and save formatted seaborn correlation heatmaps and return charts
11

Portfolio Assembly, Technical Drills & Interview Readiness

Package your models, research notes, and analyses into a verifiable GitHub/web portfolio, and master technical finance interview drills.

  • Assemble a public GitHub / PDF financial analyst portfolio
    ~6hBuild

    A demonstrable portfolio of institutional-grade work provides undeniable proof of competence beyond resume buzzwords.

    You'll learn

    • Portfolio Presentation — structuring technical artifacts for review by hiring managers and investment committees
    • Model Sanitization — auditing spreadsheets for circular errors, broken links, and inconsistent hardcodes

    Curate your best deliverables: 1 integrated dynamic 3-statement model with DCF valuation, 1 Equity Research Initiation Report or Credit Memo, 1 FP&A Variance Dashboard, and 1 SQL/Python automation script. Write clean README documentation explaining assumptions and methodology for each item.

    Done when: you have a published repository with all files organized, properly formatted, and downloadable with clear executive summaries.

    How to work through it

    1. Review all models to guarantee no #REF! or #VALUE! formula errors exist
    2. Ensure standardized formatting and professional aesthetic across all spreadsheets and PDFs
    3. Write README.md files detailing investment thesis, methodology, and key takeaways for each asset
    4. Host files on GitHub or a clean personal portfolio landing page
  • Drill core technical interview questions and 3-statement linking tests
    ~6hPractice

    Financial analyst technical rounds test instantaneous mental fluency in accounting plumbing and valuation theory under pressure.

    You'll learn

    • Technical Accounting Drills — standard rapid-fire questions testing real-time three-statement mental mapping
    • Modelling Timed Test — standard hiring assessment requiring candidate to build a 3-statement model in 60-90 minutes

    Practice answering classic technical interview questions aloud without hesitation (e.g., 'Walk me through a $10 increase in depreciation across all three statements', 'How does a $50 debt-financed asset purchase affect the statements?', 'Why would EBITDA be higher than CFO?').

    Done when: you can solve and articulate 15 standard accounting transaction questions and explain valuation trade-offs in timed mock sessions without referencing notes.

    How to work through it

    1. Write down answers to the top 20 three-statement accounting interview mechanics questions
    2. Practice walking through the DCF formula and WACC adjustments verbally
    3. Perform 3 timed, 60-minute mock financial modelling tests from scratch
  • Execute a live 10-minute stock pitch or corporate presentation
    ~4hApply

    Analysts must be able to defend their findings persuasively and answer challenging follow-up questions from executives or portfolio managers.

    You'll learn

    • Stock Pitch Structure — standard format for pitching an actionable long/short recommendation to an investment committee
    • Catalyst — specific corporate event or data release expected to cause the market to reprice a security

    Deliver a concise 10-minute investment recommendation pitch or business performance review presentation to a peer, mentor, or recorded video. Cover the company overview, investment thesis, financial catalysts, valuation target, and key downside risks, followed by a Q&A defense.

    Done when: you have completed a recorded 10-minute presentation and reviewed the recording to eliminate filler words and refine clarity of delivery.

    How to work through it

    1. Prepare a 5-slide pitch deck (Overview, Thesis, Catalysts, Valuation, Risks)
    2. Time yourself delivering the pitch in under 10 minutes
    3. Anticipate 5 hostile counter-arguments and draft concise rebuttal answers
    4. Record your presentation and review for pacing, clarity, and analytical conviction

How the plan fits together

11 phases in 6 stages. Anything on the same row can be worked on at the same time.

An arrow points from a phase to the work it unlocks: before starting any phase, every phase with an arrow into it has to be finished first.

STARTSTAGE 2STAGE 3STAGE 4STAGE 5STAGE 61Financial Accounting &Three-Statement Mechanics3 tasks · ~15h2Financial Ratio Analysis &Corporate Performance3 tasks · ~15h3Financial ModellingFundamentals in Excel3 tasks · ~19h4Corporate Finance & Costof Capital (WACC)3 tasks · ~14h5Business ValuationMethodologies (DCF &Relative Valuation)3 tasks · ~21h6Advanced FinancialModelling (M&A and LBOFoundations)2 tasks · ~15h7Specialization Track —Corporate FP&A (FinancialPlanning & Analysis)3 tasks · ~17h8Specialization Track —Equity Research & AssetManagement2 tasks · ~15h9Specialization Track —Credit Analysis & FixedIncome2 tasks · ~13h10Financial Data Tools &Analytics (SQL & Python)2 tasks · ~11h11Portfolio Assembly,Technical Drills &Interview Readiness3 tasks · ~16h
Solid arrow
Must be finished before the phase it points to
Dashed arrow
Same rule, but the prerequisite sits more than one stage back

Resources

22 in this plan's library, beyond the links on individual tasks.

Learning & Reference

Foundational textbooks, SEC filing repositories, and valuation databases.

  • Applied Corporate Finance & Cost of Capital Resources

    Provides foundational lectures, slide decks, and real-world case studies for estimating cost of equity, debt spreads, and WACC.

    pages.stern.nyu.edu · NYU Stern School of Business (Professor Aswath Damodaran) · Online Repository & Lecture Archive · Free

  • Best Practices for Equity Research Analysts: Essentials for Buy-Side and Sell-Side Analysts

    Guides public equity analysts through finding catalysts, conducting channel checks, creating earnings preview models, and writing investment memos.

    mhprofessional.com · McGraw-Hill · Book · ~$50–$75

  • Damodaran Online Valuation and Data Repository

    Provides regularly updated global data benchmarks for industry betas, country risk premiums, cost of capital, and valuation multiples.

    pages.stern.nyu.edu · Professor Aswath Damodaran (NYU Stern) · Data Repository · Free

  • Damodaran Online: Corporate Finance & Valuation Resources

    The premier academic and practitioner hub for industry beta estimates, equity risk premiums, synthetic rating spreads, and complete DCF lecture series.

    pages.stern.nyu.edu · Aswath Damodaran (NYU Stern) · Course Archive & Data Library · Free · Intermediate to Advanced

  • Financial Modeling

    Bridges corporate finance theory with hands-on Excel mechanics to build dynamic schedules, circular interest loops, and robust financial models.

    mitpress.mit.edu · The MIT Press · Book · ~$85–$115

  • Financial Planning & Analysis and Performance Management

    Offers practical guidance on building annual operating plans, rolling forecasts, price-volume-mix variance analysis, and executive-ready KPI dashboards.

    wiley.com · John Wiley & Sons · Book · ~$60–$90

  • Financial Statement Analysis and Security Valuation

    Use this comprehensive reference to master DuPont ratio decomposition, quality-of-earnings adjustments, and financial statement normalization.

    mheducation.com · McGraw-Hill Higher Education · Book · ~$70–$250

  • Fundamentals of Corporate Credit Analysis

    Explains credit rating methodologies, cash-flow adequacy ratios, debt covenant structuring, and recovery analysis in distressed scenarios.

    mhprofessional.com · McGraw-Hill · Book · ~$65–$90

  • Introduction to Financial Accounting

    Teaches fundamental accrual accounting mechanics and how business activities systematically flow across the three primary financial statements.

    coursera.org · University of Pennsylvania (Wharton) via Coursera · Course · Free to audit (paid certificate optional, or included via Coursera Plus subscription)

  • Investment Banking: Valuation, LBOs, M&A, and IPOs

    Teaches transaction modeling mechanics, purchase price allocation, accretion/dilution EPS merger analysis, and multi-tier LBO debt paydown schedules.

    wiley.com · John Wiley & Sons · Book · ~$80–$110

  • Mergers & Inquisitions (M&I) / Breaking Into Wall Street Interview Preparation Materials

    Prepares candidates with rapid-fire technical interview questions, three-statement accounting drills, and modeling case study structures.

    mergersandinquisitions.com · Mergers & Inquisitions / BIWS · Interview Preparation Platform · Free articles and guides; paid dedicated training courses

  • Python for Data Analysis: Data Wrangling with Pandas, NumPy, and Jupyter

    Written by the creator of pandas, this is the essential hands-on text for ingesting, manipulating, and analyzing structured time-series financial data.

    wesmckinney.com · Wes McKinney (O'Reilly Media) · Open-Access Book · Free online version available · Beginner to Intermediate

  • Python for Finance: Mastering Data-Driven Finance

    Teaches analysts how to apply Python and SQL to handle time-series financial datasets, interact with APIs, and automate workflows.

    oreilly.com · O'Reilly Media · Book · ~$55–$70

  • SEC EDGAR Search and Database

    Use this primary source registry to retrieve original 10-K, 10-Q, 8-K, and S-1 filings for public corporate research.

    sec.gov · U.S. Securities and Exchange Commission · Database & Public Registry · Free

  • Valuation: Measuring and Managing the Value of Companies

    The standard practitioner guide for unlevered DCF modeling, ROIC forecasting, and applying enterprise and equity valuation multiples.

    John Wiley & Sons · Book · ~$65–$95

Certifications & Credentials

Industry recognized certifications and candidate study programs.

  • Certified Corporate FP&A Professional (FPAC)

    Targets enterprise-level corporate planning, rolling forecasts, annual operating budgets, and variance management across business units.

    Association for Financial Professionals (AFP) · Professional Certification · Exam and preparation fees apply · Intermediate to Advanced

  • Chartered Financial Analyst (CFA) Program

    The primary institutional credential covering comprehensive financial analysis, portfolio management, equity valuation, and ethics.

    cfainstitute.org · CFA Institute · Professional Certification Program · ~$940–$1,390 per exam level

  • Financial Modeling & Valuation Analyst (FMVA)

    A skills-based program certifying practical competency in three-statement modeling, DCF valuation, and executive presentation design.

    corporatefinanceinstitute.com · Corporate Finance Institute (CFI) · Professional Certification Program · $497–$847 annual subscription

  • Financial Modeling & Valuation Analyst (FMVA) Program

    A rigorous curriculum specifically tailored for hands-on three-statement, DCF, and scenario modeling standards in corporate finance and FP&A roles.

    Corporate Finance Institute (CFI) · Professional Certification · Subscription pricing (~$497/year) · Intermediate

Communities & Discussion

Professional forums and analyst networking groups.

  • r/FinancialCareers Community

    An active peer community useful for resume reviews, role trajectory guidance, and practical advice on transitioning between financial analyst specializations.

    reddit.com · Reddit · Online Forum · Free · All Levels

  • Wall Street Oasis (WSO)

    Join to discuss industry compensation trends, interview experiences, career pathways, and real-time financial modeling challenges.

    wallstreetoasis.com · Wall Street Oasis · Online Forum & Community · Free forum access (paid optional prep materials)

  • Wall Street Oasis (WSO) Community Forums

    The largest practitioner forum for discussing technical interview questions, recruiting timelines, modeling case studies, and compensation benchmarks.

    wallstreetoasis.com · Wall Street Oasis · Online Community · Free to read and participate · All Levels