Investment Tutorial: Investment Tutorial: How to read flow of funds tables : Continued

How to Read Flow of Funds Accounts

Selected Sector Tables

We have selected the following sector tables for color-coding on this site, grouped into seven categories or types of 'players':

Individual Investors

F.100 Households and Nonprofit Organizations.

Managers of Nonfinancial Business

F.101 Nonfinancial Business.

F.102 Nonfarm, Nonfinancial Corporate Business

Government Officials

F.105 State and Local Governments

F.106 Federal Government

F.124 Government Sponsored Enterprises

International Players

F.107 Rest of the World

Bankers and Brokers

F.109 Commercial Banking

F.114 Savings Institutions

F.126 Issuers of Asset-Backed Securities

F.129 Securities Brokers and Dealers

Insurance Executives

F.116 Property & Casualty Insurance Companies

F.117 Life Insurance Companies

Fund Managers

F.118 Private Pension Plans

F.119 State and Local Government Employee Retirement Funds

F.120 Federal Government Retirement Funds

F.121 Money Market Mutual Funds

F.122 Mutual Funds

F.123 Closed-End and Exchange-Traded Funds

F.128 Real Estate Investment Trusts (REITs)

These selected sectors present a comprehensive picture of the major players in the U.S. capital market.

Making Flow Tables Easy to Read

As published by the Federal Reserve, flow of funds accounts are difficult to read and can even become mind-numbing when examined for too long at one sitting:

Official flow tables are boring and hard to read

Obscure tables may be acceptable to economists, who thrive on murky concepts and mysterious mathematics, but for pragmatic investors and portfolio managers, time is of the essence.

To make interpretation of national flow of funds accounts easier for capital flow analysts, we have developed a way to color-code the data.

In order to process the color-coding of over ten thousand data points in a timely fashion, soon after the official data is published, we developed macros for Excel spreadsheets that handled the process automatically.

This system is not patented and you may adapt it for your own use. After the first year, we discontinued updating these color-coded tables, since their purpose was primarily as an educational resource. However, you may use the system for commercial purposes, without royalties, if you so wish.

As far as we know, color-coded flow of funds tables had been published only on this site as of September 2005 and the system is in the public domain.

Should you need assistance in automating the color-coding process, please contact us and we will be glad to share our technical know-how.

It is easier to read color-coded tables

On this site, there are thirty flow of funds tables in color-coded format.

These tables are accessed through the 'players' and 'instruments' tabs on the top navigation bar.

[In Lesson 21, you will find a detailed, step-by-step guide to using the flow tables published on this site.]

Color-Coding of Negative Numbers

The subset of thirty flow of fund accounts tables shown on this site contains about ten thousand data points.

Flow of funds data in black and white

The tables in Federal Reserve Release Z.1 are published in black and white, making it hard to distinguish sub-totals from basic data and creating confusion in the interpretation of negative numbers.

To distinguish sources and uses of funds in a sector table, we color the background blue and yellow.

The inset on the right show that even when the row titles are hidden, we can tell that this is a sector table because the background is blue and yellow.

Yellow and blue backgrounds indicate sources and uses of funds in a sector table

We also know that the data against the blue background is a use of funds, while data against a yellow background is a source of funds.

Depending on whether a table refers to an instrument or a sector, and the position of data in the table, negative numbers have four possible meanings:

  1. Sector tables (investment section): A negative number indicates a "source of funds".

  2. Sector tables (liabilities section): A negative number indicates a "use of funds".

  3. Instrument tables (issuers section): A negative number indicates a "buyer of securities".

  4. Instrument tables (purchasers section): A negative number indicates a "seller of securities".

There are also four possibilities for positive data points.

To make it easy to interpret tables, highlighting sources and uses of funds in sector tables and buyers and sellers of securities in instrument tables, we color-code the data as follows:

  1. A blue background indicates a "use of funds" in a sector table.
  2. A yellow background indicates a "source of funds" in a sector table.
  3. A red background indicates a "net sale of securities" in an instrument table.
  4. A green background indicates a "net purchase of securities" in an instrument table.

Whereas sector tables are colored blue and yellow to indicate sources and uses of funds, instrument tables are colored red and green to indicate issuers and purchasers of financial assets.

Red and green backgrounds indicate buyers and sellers in an instrument table.

Because of this coding, we know that the inset on the right is from an instrument table, since the background is red and green.

Sales data is shown in red, while net purchases are shown in green.

Before proceeding, check your progress:

Self-Test

In Capital Flow Analysis, it is necessary to review:
Choice 1The entire contents of Release Z.1.
Choice 2 Only relevant sectors and instruments.
Choice 3 All macro-economic statistics.
Choice 4 Only sub-totals and NIPA data.
Flow tables are color-coded:
Choice 1 as required by law.
Choice 2 for easier reading and interpretation.
Choice 3 by the Federal Reserve Board.
Choice 4 to indicate speculative trading.
A yellow background on a flow table indicates:
Choice 1 A source of funds for a sector.
Choice 2 A sector's use of funds.
Choice 3 Buyers of an instrument.
Choice 4 Sellers of an instrument.

Investment Tutorial: Reading Flow of Funds Accounts learning module : continued >

copyright | privacy | home