Tabulate ratios
Ratios from different periods may
be combined using the "Tabulate ratios" function. You can select
SPREDGARized worksheets from the active workbook. Alternatively,
SPREDGAR will search all open workbooks for potential worksheets to
include.
Here is a portion of the resulting worksheet for
Intel.
Note: The
“price” ratios are computed on a rolling basis quarter by quarter. Thus the
first three quarters are listed as “N/A” (not available), because it takes four
quarters of data to compute each price ratio.
Gordon
Gerwig, founder of Spredgar Software, has a B.S. in Electrical Engineering and Computer Science from the University of
California at Berkeley and an M.B.A. in Finance from the University of
California at Davis.
Gordon Gerwig and Spredgar
Software have been written up in
Online
Investing for Dummies,
Online Investing
Hacks, and
in the
Innovator, the U.C. Davis Graduate School of
Management's alumni magazine. Gordon
is an individual investor and a member of the American Association of Individual Investors
(AAII).
He is a CERTIFIED FINANCIAL
PLANNER, a
Licensed International
Financial Analyst (LIFA) , and
is an associate member of the
CFA Institute. He has worked in
financial services as a advisor for Morgan Stanley and American Express. He has
experience in small business lending, valuation and consulting.
Spredgar Software's
mission is to
provide
unbiased financial investment data through Excel
add-in software for the
private investor, the professional analyst, and the academic.
