Skip to main content
Be The Investor
BTI Market NewsInvesting Guides
Back to News

Portfolio Analysis: Allocation, Risk, and Scenarios

Portfolio Analysis: Allocation, Risk, and Scenarios

Turn a holdings list into a practical portfolio review. This guide shows how to reconcile positions, identify overlapping exposures, separate allocation from risk, and write a concise decision memo. An original hypothetical example demonstrates why a modest direct position can represent a larger economic exposure after fund holdings are included.

Portfolio analysis should explain what you own, what can move those holdings together, and which assumptions would make the portfolio unsuitable for its purpose. A useful review ends with a short list of questions and evidence to monitor. A screen full of performance percentages does not complete that job.

This workflow produces a dated diagnostic memo. It can be used with a spreadsheet, brokerage export or research platform. The method does not depend on a particular provider, and the examples below are hypothetical rather than recommendations.

Start with a reconciled portfolio snapshot

Choose one valuation timestamp and one reporting currency. Record each instrument, quantity, price, currency, market value and source. Include cash and liabilities separately. Reconcile the sum to the account statement before interpreting weights. A missing cash balance can make every investment weight look larger than it is.

Loading market context

Keep cost basis separate from current market value. Cost basis answers a historical or tax-related question; current value determines today's allocation. If an instrument lacks a reliable current valuation, label that uncertainty instead of quietly using an old price alongside fresh quotes.

Separate allocation from economic exposure

Allocation describes how capital is distributed. Exposure describes the underlying businesses, markets or conditions influencing that capital. The SEC Investor.gov: Asset Allocation and Diversification connects allocation choices to an investor's horizon and risk tolerance. Those personal constraints belong at the top of the memo, ahead of any chart.

For a look-through review, retain two views: positions as traded and underlying exposures. Do not add the full value of a fund to the full value of all its holdings, which would double-count capital. Instead, allocate the fund's value across its underlying positions when holdings data are available and dated.

Worked example: a hidden company concentration

Assume a hypothetical $100,000 portfolio contains $50,000 in Fund A, $20,000 in Company B and $30,000 in cash. Assume Fund A's published holdings show a 12% weight in Company B at the same reference date. Ignore derivatives, liabilities and transaction costs for this illustration.

ComponentCalculationCompany B exposure
Direct shares$20,000$20,000
Shares inside Fund A$50,000 × 12%$6,000
Combined exposure$20,000 + $6,000$26,000, or 26%

The direct holding is 20% of the portfolio, but the simplified company exposure is 26%. That six-percentage-point difference identifies a research issue; it does not establish that 26% is suitable or unsuitable. FINRA: Concentrate on Concentration Risk explains why overlapping instruments deserve attention. Fund holdings may also have changed since their disclosure date.

Connect each risk question to a measurable observation

A sector label is only a starting point. Two companies in different sectors may depend on the same customer, financing market or capital-spending cycle. Record the shared driver and explain the mechanism. Treat an unverified connection as a hypothesis to investigate.

Review questionEvidence to collectUseful output
What dominates the portfolio?Position and look-through weightsLargest exposures and missing data
What might fall together?Revenue drivers and financing dependenciesShared-driver map
When might cash be needed?Planned withdrawals and settlement constraintsCash requirement schedule
Could a position be difficult to sell?Trading conditions and instrument termsLiquidity questions requiring review
What would invalidate a holding?Company filings and thesis conditionsSpecific monitoring trigger

The SEC Investor.gov: Liquidity or Marketability distinguishes ease of trading from the price shown on a screen. A valuation that appears stable does not by itself demonstrate that a position can be sold readily.

Add a scenario, then write the decision memo

For the example above, assume only Company B's economic exposure declines 30%, while every other underlying exposure is unchanged. The simplified portfolio impact is $26,000 × −30% = −$7,800, or −7.8%. This isolated shock is a sensitivity calculation, not a forecast. It deliberately excludes interactions, fees and changes elsewhere in Fund A.

Use the result to ask whether that exposure is intentional and compatible with the portfolio's purpose. Do not convert the scenario into an automatic trade. Review instrument restrictions, taxes, transaction costs and the underlying investment case before deciding what to change.

Reusable review memo

  • Snapshot: valuation date, reporting currency and reconciled total.
  • Purpose: horizon, withdrawals and constraints supplied by the investor.
  • Evidence: largest direct and look-through exposures.
  • Scenario: explicit shocks, calculated impact and omitted effects.
  • Open question: the most consequential uncertainty.
  • Next review: a dated event or condition that warrants another assessment.

For the foundations behind position-level decisions, read portfolio diversification and position sizing. Use building and tracking an investment thesis to attach evidence and invalidation conditions to each important holding.

Research exercise with SPY

For a real-document exercise, use SPY, the State Street SPDR S&P 500 ETF Trust. From the State Street: SPDR S&P 500 ETF Trust page, record the date of a holdings file and inspect whether an independently held company also appears there. Calculate overlap only after obtaining dated weights. The hypothetical Fund A example above is not a representation of SPY holdings.

Frequently asked questions

Does a larger number of holdings guarantee diversification?

No. The holdings may share underlying companies or economic drivers. Inspect the exposures before drawing a conclusion from the count.

Should every identified risk lead to a sale?

No. The review identifies intentional and unintended exposures. Whether to change them depends on the investor's objectives, constraints and evidence.

How often should the memo be updated?

Choose a documented review cadence and update after material changes in holdings, cash needs or the investment case. This article does not prescribe a universal interval.

Related guides

Prepared with AI assistance for Be The Investor Research. This educational guide includes hypothetical examples, not personalized investment advice. Sources were checked on November 13, 2026. Verify current issuer data and product terms before relying on them. Read our editorial standards.

Continue your SPY research

Frequently asked questions

What is "Portfolio Analysis: Allocation, Risk, and Scenarios" about?

Build a portfolio review with verified holdings, exposure checks, original scenario math and a reusable decision memo that separates evidence from assumptions.

Which stocks and assets does this article cover?

This article relates to SPY.

What is the market context?

Portfolio analysis should explain what you own, what can move those holdings together, and which assumptions would make the portfolio unsuitable for its purpose. A useful review ends with a short list of questions and evidence to monitor. A screen full of performance percentages does not complete that job. This workflow produces a dated diagnostic memo. It can be used with a spreadsheet,…

When was this article published?

It was published on 13 / 11 / 2026 by Be The Investor Research.