A:

Once investors know the approximate due dates and yields of their holdings, they can do a few simple calculations in a spreadsheet or other program to calculate thier income. Here is a breakdown of the due dates for some common fixed-income sources:

  • Bonds & CDs - Government, corporate, and municipal bonds tend to pay their interest semiannually, but exactly which months will depend on the individual issue. Information about specific bond coupons can be obtained from account statements or from a broker or advisor directly. The same semiannual schedule also applies to certificates of deposit (CDs) from a bank or other institution.

  • Money Market & Mutual Funds - Many fixed-income mutual funds and exchange-traded funds will pay their income monthly. The exact amount distributed each month will vary based on market conditions, but a current yield figure can be found online or through a broker and used to calculate a pro-rated amount that will be sent to your account each month.

  • Stocks - Common stocks that pay dividends typically distribute this income once per quarter, or four times per year. Yield figures for stocks can also be found through many media outlets or through a financial advisor. Companies generally try to increase their dividends over time, but most do so slowly, and so investors should assume a relatively constant yield over short time frames. Preferred stocks may pay their dividends quarterly or monthly, but the dividend rate is typically locked in at issuance.

A hypothetical portfolio could look like this on an income estimation spreadsheet:

Portfolio A
- Market Value Annual Yield Annual Income (est.) Payment Schedule
Bond Mutual Fund $60,000 3.50% $2,100 Monthly dividend
CD at local Bank $50,000 4.50% $2,250 June, December
Money Market Fund $20,000 2.75% $550 Monthly dividend
Stock ABC $15,000 2% $300 Mar, June, Sept, Dec
Stock XYZ $45,000 3% $1,350 Feb, May, Aug, Nov
- - - - -
Totals: $190,000 - $6,550 -

From here, you can go one step further and set up a view that shows your investment cash flows by month:

Income by Month
- Bond Fund CD Money Market Stock ABC Stock XYZ Total Income
November $175 - $46 - $338 $559
December $175 $1,125 $46 $75 - $1,421

This information can then be input into your overall budgeting plans. If there is a shortfall in the desired level of income, the investor could take steps such as seeking higher-yielding investments (which may come with higher risks) or reducing expenses.

To learn more on creating a dynamic fixed-income portfolio, see The Basics Of The Bond Ladder and Creating The Modern Fixed-Income Portfolio.

RELATED FAQS

  1. How can I create a yield curve in Excel?

    Find out more about the yield curve, what the yield curve is and how to create the yield curve for U.S. Treasury bonds using ...
  2. What are the different formations of yield curves?

    Find out more about the yield curve and yield curve formations, what yield curves measure and the three main types of yield ...
  3. How does quantifying fixed overhead volume variance show whether a company is profitable ...

    Find out why some fundamental analysts look at fixed overhead volume variance as an indicator of company profitability or ...
  4. What is price variance in cost accounting?

    Understand what price variance is in relation to cost accounting. Learn the most common way price variance arises and how ...
RELATED TERMS
  1. Accelerated Return Note (ARN)

    A short- to medium-term debt instrument that offers a potentially ...
  2. Next Generation Fixed Income (NGFI) Manager

    A Next Generation Fixed Income (NGFI) manager is a fixed income ...
  3. Next Generation Fixed Income (NGFI)

    Next generation fixed income is an innovative approach to investing ...
  4. Class 3-6 Bonds

    Several classes of noninvestment grade bonds held by an insurance ...
  5. Return On Equity - ROE

    The amount of net income returned as a percentage of shareholders ...
  6. Impact investing

You May Also Like

Related Articles
  1. Stock Analysis

    Google Stock: A Tale of Two Share Classes

  2. Mutual Funds & ETFs

    How To Short The U.S. Bond Market

  3. Mutual Funds & ETFs

    The EMAG Emerging Mkts Bond ETF: Worth ...

  4. Mutual Funds & ETFs

    5 Dividend ETFs with Growth Potential

  5. Investing

    Feeling Risk-Averse? Consider These ...

Trading Center