Stock Market Calculations You Actually Need to Know
Most people blow past the basic formulas in their finance class and move on. The ones who don't end up wasting hours recalculating on practice sheets because they missed something obvious. Activity Sheet 3 Stock Market Calculations covers the ground most courses skim, but it does so in a way that mirrors what you'd actually see on a trading desk. The difference between getting the right answer and the wrong one usually comes down to understanding when a formula applies and when it doesn't. Let's start with what you're actually solving for. The main categories on that sheet are: Total Return: (Ending Value - Beginning Value + Dividends) / Beginning Value. That's it. Simple arithmetic. The trap people fall into is using the average price over the period instead of the actual beginning market value. If you bought 100 shares at $50 and the price ended at $58 with a $1 per share dividend, your return is ($5800 - $5000 + $100) / $5000 = 18%. Writing it out on paper like that makes it harder to mess up.
Dividend Yield: Annual Dividend Per Share / Current Share Price. When someone asks you this on a test, they often give you quarterly payments and expect you to multiply by four. It's almost never explicitly stated. Watch for it. Price-Earnings Ratio: Current Share Price / Earnings Per Share. People forget that EPS is typically reported as an annual figure based on trailing twelve months, not a quarterly number. Using the quarterly EPS without annualizing it will give you a P/E that's roughly four times too low. Market Capitalization: Share Price × Total Outstanding Shares. Don't confuse outstanding shares with authorized shares. Outstanding is what actually exists and trades. Authorized is just the legal ceiling on how many could exist.
How I Almost Got Burned on a Worked Example
There was one exercise in the third set where the problem stated a company had paid dividends of $0.75 per share in Q1 and Q2, and then jumped to asking for the annual yield based on a current price of $42. The natural instinct was to add Q1 and Q2 and run with $1.50 annualized. That's wrong. Dividends don't annualize linearly. The correct move was to take the $1.50 as a midpoint indicator, check whether the company had a history of consistent payments, and use the most recent annual dividend disclosed in the problem's data table. In this case it was $2.88 per year, which gave a yield of about 6.86%, not the 3.57% you'd get from doubling the partial data. I've seen that mistake repeat in every cohort that goes through this material. The activity sheet itself doesn't flag it explicitly, which is part of why it's useful. Taxes and fees are ignored by default. Every calculation on that sheet assumes a frictionless environment. Your actual return will be lower. Don't let that confusion creep in and make you second-guess the math. The formula doesn't account for commission, bid-ask spreads, or capital gains tax. It's designed to measure nominal performance. Weighted averages matter more than simple averages. When calculating the return of a portfolio across multiple positions, a simple average of individual returns is almost never correct unless each position is exactly the same dollar amount. You need to weight each return by its proportion of total portfolio value. I once graded through a batch where half the students used simple averages on a portfolio with positions ranging from $500 to $15,000. The difference was sometimes 4 percentage points. That's a meaningful gap.
Get the Full Details
Turnover calculations require care with cost basis. If you buy 200 shares, sell 100, then buy 150 more at different prices, your cost basis for the remaining 250 shares depends on which method you're using: FIFO, LIFO, or average cost. The activity sheet usually assumes FIFO unless stated otherwise. If it doesn't state it, ask. Using the wrong method changes your gain or loss calculations entirely.
Practical Workflow for Getting Through the Sheet Efficient
Set up a small grid before you start solving anything. Columns for ticker, shares held, purchase price, current price, dividend per share, and computed values. Fill in every known variable first. Then calculate one metric at a time across all positions before moving to the next. This keeps you from mixing up which numbers belong to which stock. I keep the grid in a spreadsheet now instead of paper because copy-pasting prevents arithmetic errors, but the logic is the same. When the sheet asks for a benchmark comparison, use the relevant index return for the exact same time period. Comparing a stock's 6-month return to the S&P 500's yearly return is apples and oranges and shows up on every exam. Make sure the periods match. If you hit a section that asks for beta or alpha, remember that beta measures volatility relative to a market benchmark, and alpha measures excess return beyond what beta would predict. The CAPM formula is Rf + beta × (Rm - Rf). The risk-free rate is usually given or implied. Don't plug in a corporate bond yield unless the problem specifies it. Use Treasury yields.
What the Sheet Doesn't Cover Well
It treats stock prices as static numbers. In reality, intraday prices move, and if your activity involves a specific event like an earnings announcement or a stock split, the mechanics change. A two-for-one split halves the share price and doubles the share count. Your total value stays the same. Several students on the last pass treated a split as a price drop and assumed they'd lost money. It's not a loss. It's a mechanical adjustment. The sheet also doesn't address short selling. If you're short a stock, your maximum gain is theoretically bounded (price can only go to zero) but your downside is unlimited. The return formula flips sign. You profit when the price drops. Keep that straight when the problem mentions borrowing shares or margin requirements.
Where to Get the Full Activity Sheet
You can find Activity Sheet 3 Stock Market Calculations through your course portal or the textbook companion site. Some instructors host it on their department pages. If you're working independently, look for versions paired with the CFA Institute pre-module materials or the Investopedia practice sets, which tend to align closely with the standard curriculum this sheet follows. Work through it once with the formulas open, then do it again without notes. The second pass is where you actually lock it in. The calculations aren't hard, but the conditions attached to each one matter more than the arithmetic itself.
