templates available in excel 97 (excel 8) and higher versions
TRANSCRIPT
![Page 1: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/1.jpg)
Templates available in Excel 97 (Excel 8) and higher versions:
All of the Excel templates in Research Insight can be customized to fit your own particular needs.
Company Fundamental Analysis TemplatesBalance Sheet Annual and Quarter BAL_ANL.XLSBusiness Segment Report BUS_SEG.XLSCash Flow Annual and Quarter CF_ANL.XLSIncome Statement Annual and Quarter INC_ANL.XLS
Backtest Building ToolsBacktest Builder Monthly Model Report MNTBLDR.XLSBacktest Builder Quarterly Model Report QTRBLDR.XLS
Backtest Model TemplatesDetailed Backtest with Summary - Monthly SUMMMNTH.XLSDetailed Backtest with Summary - Quarterly SUMMQTR.XLSQuick Backtest - Monthly BASICMNT.XLSQuick Backtest - Quarterly BASICQTR.XLS
Comparison TemplatesComparable Analysis COMPS.XLSComparables Model - Detail Report COMPVALR.XLSComparables Model - High Level COMPSTMT.XLSGroup Aggregate & Average AGGCALCA.XLSIndex Ratio Comparisons INDXRAT.XLS
Debt Analysis TemplatesCompany Annual Debt Structure Overview DEBTVIEW.XLSCompany Quarterly Debt Structure Overview DEBTVW_Q.XLSDetailed Credit Score CORPSCOR.XLSQuick Credit Score CREDIT.XLSZ-Score Calculator ZSCORE.XLS
Detailed Fundamental TemplatesAnalyze Report ANALYZE.XLSFull B/S, I/S, C/F, Ratio CO_FULL.XLS
Insider and InstitutionalDecile Analysis of Institutional Trading IODEC.XLSInsider Trading Details IT.XLSInstitutional Flow Analysis IOFLOW.XLS
Excel Templates
211
![Page 2: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/2.jpg)
Standard & Poor’s Research Insight Report & Chart Library
Market Charting and Performance SummaryIndustry Charting INDCHART.XLSMarket Charting CHARTING.XLSMarket Performance Summary PERFORM.XLS
Multiple RegressionMultiple Regression Analysis REGRESS.XLS
Portfolio Analysis TemplatesChart Top 10 Companies TOP10.XLSPortfolio Allocation PORTALLO.XLSPortfolio Weight Comparison PORTWGHT.XLS
Snapshot Company OverviewCompany Snapshot SNAPSHOT.XLSQuick Overview QUICK.XLS
Transfer PricingBusiness Description with Financial Overview MULTDETL.XLSBusiness Description Company Overview MULTDESC.XLSOverview with Business Description DESC.XLS
Valuation/Estimates TemplatesDetailed Comparison of Fundamental & Valuations COMPRANK.XLSDividend Discount Model CSVDDM.XLSDupont Analysis DUPONT.XLSDupont Analysis - Quarterly DUPONTQ.XLSEvaluation Model EVALUATR.XLSFIRST CALL with Trends FCRPT.XLSI/B/E/S with Trends IBESRPT.XLSLast 12 MM Comparable Ranking LTMCOMP.XLSScoring Report SCORBLDR.XLSValuation Model VALUATN.XLS
212
![Page 3: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/3.jpg)
Opening and Running Spreadsheet Templates
In this section we provide some examples of spreadsheet templates created using Research Insight. These examplesdemonstrate the power and versatility of creating and running Research Insight reports in Excel. Each of thesetemplates offers a wide range of information compiled into one spreadsheet which can be accessed by simplyentering the company ticker or set. To open a template in Excel:
1. From the S&P menu, select Open Template.
3. Excel will open Research Insight and you will see the spreadsheet template you have selected. Each of the templates defaults to a pre-loaded company or set the first time you use it.
Excel Templates
213
2. You will see the File Open dialog box. Select the template you want to use and click Finish.
4. To change the company displayed in thetemplate, click the (Run) button. You willsee the Run Assistant Window. Enter thecompany ticker or set for which you want to runthe spreadsheet in the Companies field, andclick OK. If you are not sure of a ticker symbol,click the ((Look Up) button to search thecompanies in the North America database.
![Page 4: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/4.jpg)
Balance Sheet Annual and Quarterly (BAL_ANL.XLS)
DescriptionThis template is an annual and quarterly trend analysis of key balance sheet items for a company. Charts display keyitems such as Current Assets, Working Capital and Debt. The following example shows the annual trend analysis.
Standard & Poor’s Research Insight Report & Chart Library
214
![Page 5: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/5.jpg)
215
Spreadsheets - Company Fundamental Analysis
![Page 6: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/6.jpg)
Business Segment Report (BUS_SEG.XLS)
DescriptionAnalyze a company’s business segment data over time. Includes a breakdown of segment revenues, operating profit,depreciation, capital expenditures and margins. The following example shows the first section of the template.
Standard & Poor’s Research Insight Report & Chart Library
216
![Page 7: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/7.jpg)
Excel Templates - Company Fundamental Analysis
217
![Page 8: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/8.jpg)
Cash Flow Annual and Quarterly (CF_ANL.XLS)
DescriptionAnnual and Quarterly trend analysis of key cash flow statement items for a company. Charts display key items suchas Net Income, Capital Expenditures and Depreciation. The following example shows the annual trend analysis.
Standard & Poor’s Research Insight Report & Chart Library
218
![Page 9: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/9.jpg)
219
Excel Templates - Company Fundamental Analysis
![Page 10: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/10.jpg)
Income Statement Annual and Quarterly (INC_ANL.XLS)
DescriptionAnnual and quarterly trend analysis of key income statement items for a company. Charts display key items such asNet Income, Gross Profit and EBIT.
Standard & Poor’s Research Insight Report & Chart Library
220
![Page 11: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/11.jpg)
221
Excel Templates - Company Fundamental Analysis
![Page 12: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/12.jpg)
Backtest Builder Monthly Model Report (MNTBLDR.XLS)
DescriptionUse the Backtest wizard to build a customized monthly backtest environment for your own screen, time frame,number of periods and rebalancing periods.
Standard & Poor’s Research Insight Report & Chart Library
222
Use the wizard toenter criteria foryour monthlybacktesting model.
View a summary of the results for each periodyou specified in your model.
To bring up the Backtest Wizard, click the CCrreeaattee RReeppoorrttbutton in the template.
![Page 13: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/13.jpg)
223
Excel Templates - Backtest Building Tools
The Backtest Builder creates a set of companies that fits yourcriteria for each period you specified.
![Page 14: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/14.jpg)
Backtest Builder Quarterly Model Report (QTRBLDR.XLS)
DescriptionUse the Backtest wizard to build a customized quarterly backtest environment for your own screen, time frame,number of periods and rebalancing periods.
Standard & Poor’s Research Insight Report & Chart Library
224
Use the wizard toenter criteria foryour quarterlybacktesting model.
View a summary of the results for each periodyou specified in your model.
![Page 15: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/15.jpg)
225
Excel Templates - Backtest Building Tools
The Backtest Builder creates a set of companies that fits yourcriteria for each period you specified.
![Page 16: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/16.jpg)
Detailed Backtest with Summary - Monthly (SUMMMNTH.XLS)
DescriptionThis template backtests an investment theory or model for 20 monthly user-defined time periods. Includes adetailed results summary. This example shows the Research Insight screen used in the model and one of the 20resulting sets (on the following page).
Standard & Poor’s Research Insight Report & Chart Library
226
![Page 17: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/17.jpg)
Excel Templates - Backtest Model Templates
227
![Page 18: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/18.jpg)
Detailed Backtest with Summary - Quarterly (SUMMQTR.XLS)
DescriptionThis template backtests an investment theory or model for 20 quarterly user-defined time periods. Includes adetailed results summary. This example shows the Research Insight screen used in the model and one of the 20resulting sets (on the following page).
Standard & Poor’s Research Insight Report & Chart Library
228
![Page 19: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/19.jpg)
229
Excel Templates - Backtest Model Templates
![Page 20: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/20.jpg)
Quick Backtest - Monthly (BASICMNT.XLS)
DescriptionTest an investment theory back in time. Runs for six annual periods using monthly time references. This exampleshows the Research Insight screen used in the model and one of the six resulting sets (on the following page).
Standard & Poor’s Research Insight Report & Chart Library
230
![Page 21: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/21.jpg)
231
Excel Templates - Backtest Model Templates
![Page 22: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/22.jpg)
Quick Backtest - Quarterly (BASICQTR.XLS)
DescriptionTest an investment theory back in time. Runs for six annual periods using quarterly time references. This exampleshows the Research Insight screen used in the model and one of the six resulting sets (on the following page).
Standard & Poor’s Research Insight Report & Chart Library
232
![Page 23: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/23.jpg)
233
Excel Templates - Backtest Model Templates
![Page 24: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/24.jpg)
Comparable Analysis (COMPS.XLS)
DescriptionTwelve years of historic balance sheet and income statement with recent quarterly data. Charts include ROE,Price/Earnings, Price/Book, Price and Shares Traded. Various ways to select comparables and display data - Mean-High-Low-Median-Mean(excluding extreme points). This example highlights selected sheets from the template.
Standard & Poor’s Research Insight Report & Chart Library
234
![Page 25: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/25.jpg)
235
Excel Templates - Comparison Templates
![Page 26: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/26.jpg)
Comparables Model - Detail Report (COMPVALR.XLS)
DescriptionCompares up to 20 companies LTM income statement, balance sheet, and ratio analysis - LTM Margins, Earningsand Returns, Selected Multiples (Market Value, Enterprise Value, Price/Sales, Price/Book, Price/Cash Flow,Dividend Yields, P/E and Price/Operating Earnings. This example highlights selected sheets from the template.
Standard & Poor’s Research Insight Report & Chart Library
236
![Page 27: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/27.jpg)
237
Excel Templates - Comparison Templates
![Page 28: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/28.jpg)
Comparables Model - High Level (COMPSTMT.XLS)
DescriptionCompares up to 20 companies LTM and 4 year annual data. Income statement data and percent of Sales, BalanceSheet and Cash Flow data, ratio analysis, year-over-year percent changes, comparable averages. This examplehighlights selected sheets from the template.
Standard & Poor’s Research Insight Report & Chart Library
238
![Page 29: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/29.jpg)
239
Excel Templates - Comparison Templates
![Page 30: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/30.jpg)
Group Aggregate & Average (AGGCALCA.XLS)
DescriptionShows where a company stands compared to the companies in its SIC, Industry Sector and S&P Major Index,based on 8 fundamental factors. Determines the relative importance of a company to its industry. For example,determines if a company is the primary source of revenue in its industry. Tracks changes over 5 years.
Standard & Poor’s Research Insight Report & Chart Library
240
GROUP AGGREGATE & AVERAGE CALCULATORAnnual Data
![Page 31: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/31.jpg)
241
Excel Templates - Comparison Templates
AGGREGATE CALCULATORUtilizing a Weighted Average Market Value over the set
![Page 32: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/32.jpg)
Index Ratio Comparison (INDXRAT.XLS)
DescriptionCompares a company to the weighted average of its industry. Evalutes market statistics, returns, valuations, growthrates, balance sheet, profitability, financial strength, effectiveness and efficiency of a company versus its SIC, sectoror major index.
Standard & Poor’s Research Insight Report & Chart Library
242
![Page 33: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/33.jpg)
243
Excel Templates - Comparison Templates
![Page 34: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/34.jpg)
Company Annual Debt Structure Overview (DEBTVIEW.XLS)
DescriptionReview the debt structure in detail on an annual basis for a company for items such as both Senior and SubordinateConvertible Debt, Notes, Debentures, and Capital Leases. Officer Names and Titles are also provided. Thisexample highlights selected sheets from the template.
Standard & Poor’s Research Insight Report & Chart Library
244
![Page 35: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/35.jpg)
245
Excel Templates - Debt Analysis Templates
![Page 36: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/36.jpg)
Company Quarterly Debt Structure Overview (DEBTVW_Q.XLS)
DescriptionReview the debt structure in detail for a company on a quarterly basis for items such as Senior and SubordinateConvertible Debt, Notes, Debentures, and Capital Leases. Includes Officer Names and Titles. This examplehighlights selected sheets from the template.
Standard & Poor’s Research Insight Report & Chart Library
246
![Page 37: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/37.jpg)
247
Excel Templates - Debt Analysis Templates
![Page 38: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/38.jpg)
Detailed Credit Score (CORPSCOR.XLS)
DescriptionCalculates an implied corporate credit score using criteria from the S&P Ratings Group. Company’s ratios arecompared against the latest three-year medians found in the S&P Corporate Ratings Criteria.
Standard & Poor’s Research Insight Report & Chart Library
248
![Page 39: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/39.jpg)
249
Excel Templates - Debt Analysis Templates
![Page 40: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/40.jpg)
Quick Credit Score (CREDIT.XLS)
DescriptionCalculates an implied corporate credit score using criteria from the S&P Ratings Group. Company’s ratios arecompared against the latest three-year medians found in the S&P Corporate Ratings Criteria.
Standard & Poor’s Research Insight Report & Chart Library
250
![Page 41: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/41.jpg)
Z-Score Calculator (ZSCORE.XLS)
DescriptionView the health of a company with the Z-Score Calculator which predicts the risk of bankruptcy using Return onTotal Assets, Sales to Total Assets, Equity to Debt, Working Capital to Total Assets, and Retained Earnings toTotal Assets. Compare your target company to an industry as well.
251
Excel Templates - Debt Analysis Templates
![Page 42: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/42.jpg)
Analyze Report (ANALYZE.XLS)
DescriptionAnnual and quarterly trend analysis of Growth and Per-Share Growth items, Earnings Power, Stock Performance,Valuation, Liquidity, Income Statement, Balance Sheet, Common Size, Source of Earnings and Asset T/O Analysis.This example highlights selected sheets from the template.
Standard & Poor’s Research Insight Report & Chart Library
252
![Page 43: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/43.jpg)
253
Excel Templates - Detailed Fundamental Templates
![Page 44: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/44.jpg)
Full B/S, I/S, C/F, Ratio (CO_FULL.XLS)
DescriptionAnnual and quarterly trend analysis of key balance sheet items for a company. Charts display key items such asCurrent Assets, Working Capital and Debt.
Standard & Poor’s Research Insight Report & Chart Library
254
![Page 45: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/45.jpg)
255
Excel Templates - Detailed Fundamental Templates
![Page 46: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/46.jpg)
Decile Analysis of Institutional Trading (IODEC.XLS)
DescriptionDecile Analysis of Institutional Trading allows you recalculate the template using a variable of your choice.
Standard & Poor’s Research Insight Report & Chart Library
256
![Page 47: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/47.jpg)
Insider Trading Details (IT.XLS)
DescriptionProvides summary and detailed Insider Trading data. Features include: Price vs. Insider Trading activity graph.Click on graph to view details.
257
Excel Templates - Insider and Institutional
![Page 48: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/48.jpg)
Institutional Flow Analysis (IOFLOW.XLS)
DescriptionTrack the flow of Institutional money through economic sectors and drill down on an industry and theconstitutents of that industry.
Standard & Poor’s Research Insight Report & Chart Library
258
![Page 49: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/49.jpg)
Industry Charting (INDCHART.XLS)
DescriptionCharts several industry peers side-by-side for several market performance and valuation measures.
259
Excel Templates - Market Charting and Performance Summary
![Page 50: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/50.jpg)
Market Charting (CHARTING.XLS)
DescriptionChart a company’s performance, fundamentals, volume and valuation measures over time.
Standard & Poor’s Research Insight Report & Chart Library
260
![Page 51: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/51.jpg)
261
Excel Templates - Market Charting and Performance Summary
![Page 52: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/52.jpg)
Market Performance Summary (PERFORM.XLS)
DescriptionFind the top and bottom performers for various return periods for the S&P 500, MidCap, Small Cap, and for theRussell Constituents, Industry and Economic Sector performance is also presented.
Standard & Poor’s Research Insight Report & Chart Library
262
![Page 53: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/53.jpg)
Multiple Regression Analysis (REGRESS.XLS)
DescriptionAnalyze the components of return for a company to determine the best return predictive model using multipleregression analysis.
263
Excel Templates - Multiple Regression
![Page 54: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/54.jpg)
Chart Top 10 Companies (TOP10.XLS)
DescriptionCharts key financial ratios and growth rates for the Top 10 peer companies. Enter a ticker and choose the peergroup to evaluate: S&P Index, Economic Sector, Industry Sector or SIC code.
Standard & Poor’s Research Insight Report & Chart Library
264
![Page 55: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/55.jpg)
265
Excel Templates - Portfolio Analysis Templates
![Page 56: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/56.jpg)
Portfolio Allocation (PORTALLO.XLS)
DescriptionProvides portfolio characteristics and sector allocation for your portfolio. Portfolio holdings can be imported intothe template via a .csv file.
Standard & Poor’s Research Insight Report & Chart Library
266
![Page 57: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/57.jpg)
267
Excel Templates - Portfolio Analysis Templates
![Page 58: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/58.jpg)
Portfolio Weight Comparison (PORTWGHT.XLS)DescriptionCompare portfolio weighting to S&P Major Indexes (500,400,600 or Super). Determine if portfolio is over/underweighted in an industry. Sector statistics include: Market Value, Total Return, Dividend Yield, ROE,Price/Earnings, Beta, Price/Sales and Price/Cash Flow. Find constituents of each index or portfolio and drill downby economic or industry sector. This example highlights selected sheets from the template.
Standard & Poor’s Research Insight Report & Chart Library
268
![Page 59: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/59.jpg)
269
Excel Templates - Portfolio Analysis Templates
![Page 60: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/60.jpg)
Company Snapshot (SNAPSHOT.XLS)
DescriptionPresents a snapshot of a company’s key market and fundamental financial data.
Standard & Poor’s Research Insight Report & Chart Library
270
![Page 61: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/61.jpg)
271
Excel Templates - Snapshot Company Overview
![Page 62: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/62.jpg)
Quick Overview (QUICK.XLS)
DescriptionGives a quick look at the market (high-low-close-volume). Presents key fundamental data including balance sheet,income statement and earnings per share.
Standard & Poor’s Research Insight Report & Chart Library
272
![Page 63: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/63.jpg)
Business Description with Financial Overview (MULTDETL.XLS)
DescriptionMultiple company business descriptions are available with company financial overviews.
273
Excel Templates - Transfer Pricing
![Page 64: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/64.jpg)
Business Description Company Overview (MULTDESC.XLS)
DescriptionFinancial Overview of a company with a detailed business description. This report runs for imported businessdescriptions.
Standard & Poor’s Research Insight Report & Chart Library
274
![Page 65: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/65.jpg)
Notes
275
Excel Templates - Transfer Pricing
![Page 66: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/66.jpg)
Overview with Business Description (BUSDESC.XLS)
DescriptionDisplays valuation, business description, top 5 sector peers by sales, key income statement and balance sheet items,earnings per share, dividends, ratios, growth rates and business segments for a company.
Standard & Poor’s Research Insight Report & Chart Library
276
![Page 67: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/67.jpg)
277
Excel Templates - Transfer Pricing
![Page 68: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/68.jpg)
Detailed Comparison of Fundamental & Valuations (COMPRANK.XLS)
DescriptionCompare target company to 10 peer companies side by side. Mean and median provided for a quick evaluation.year-end ratios, historic size and growth, DuPont Analysis, rankings for growth and valuations, charts and summaryinformation. This example shows selected sheets from the template on pages 278-281.
Standard & Poor’s Research Insight Report & Chart Library
278
![Page 69: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/69.jpg)
279
Excel Templates - Valuation Templates
![Page 70: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/70.jpg)
Standard & Poor’s Research Insight Report & Chart Library
280
![Page 71: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/71.jpg)
281
Excel Templates - Valuation Templates
![Page 72: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/72.jpg)
Dividend Discount Model (CSVDDM.XLS)
DescriptionTwo-stage dividend discount model. Presents the value of a common stock issue based on the expected future cash flows.
Standard & Poor’s Research Insight Report & Chart Library
282
![Page 73: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/73.jpg)
DuPont Analysis (DUPONT.XLS)
DescriptionProvides breakdown of the key DuPont Analysis ratios that comprise the ROE: Pretax Margin, Asset Turnover andLeverage, then applies the Tax Rate for After-Tax ROE. Charts provide trend analysis for each measure.
283
Excel Templates - Valuation Templates
![Page 74: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/74.jpg)
DuPont Analysis - Quarterly (DUPONTQ.XLS)
DescriptionDetailed trend analysis based on the DuPont analysis method.
Standard & Poor’s Research Insight Report & Chart Library
284
![Page 75: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/75.jpg)
Notes
285
Excel Templates - Valuation Templates
![Page 76: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/76.jpg)
Evaluation Model (EVALUATR.XLS)
DescriptionCompany evaluation tool with Price, P/E, Growth Rates, EPS, Dividend Momentum and FIRST CALL data.Company overview with Business and Geographic segment information. Estimates require FIRST CALLsubscription.This example shows selected sheets from the template on pages 286-289.
Standard & Poor’s Research Insight Report & Chart Library
286
![Page 77: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/77.jpg)
287
Excel Templates - Valuation Templates
![Page 78: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/78.jpg)
Standard & Poor’s Research Insight Report & Chart Library
288
![Page 79: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/79.jpg)
289
Excel Templates - Valuation Templates
![Page 80: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/80.jpg)
FIRST CALL with Trends (FCRPT.XLS)
DescriptionCompany evaluation tool with Price, P/E, Growth Rates, EPS, Dividend Momentum and FIRST CALL data.Company overview with Business and Geographic segment information. Estimates require FIRST CALLsubscription.
Standard & Poor’s Research Insight Report & Chart Library
290
![Page 81: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/81.jpg)
291
Excel Templates - Valuation Templates
![Page 82: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/82.jpg)
I/B/E/S with Trends (IBESRPT.XLS)
DescriptionActual EPS and I/B/E/S EPS, growth comparisons, consensus trends.
Standard & Poor’s Research Insight Report & Chart Library
292
![Page 83: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/83.jpg)
Notes
293
Excel Templates - Valuation Templates
![Page 84: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/84.jpg)
Last 12 MM Comparable Ranking (LTMCOMP.XLS)
DescriptionCompare a target company to 10 peer companies side by side. Mean and median provided for quick evaluation.LTM balance sheet, income statement, cash flow, margin and market valuation analysis, ratios, historic size and growth, DuPont Analysis, ranking and charts, summary information.
Standard & Poor’s Research Insight Report & Chart Library
294
![Page 85: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/85.jpg)
295
Excel Templates - Valuation Templates
![Page 86: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/86.jpg)
Scoring Report (SCORBLDR.XLS)
DescriptionCompare a target company to 10 peer companies side by side. Mean and median provided for quick evaluation.LTM balance sheet, income statement, cash flow, margin and market valuation analysis, ratios, historic size and growth, DuPont Analysis, ranking and charts, summary information.
Standard & Poor’s Research Insight Report & Chart Library
296
![Page 87: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/87.jpg)
297
Excel Templates - Valuation Templates
![Page 88: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/88.jpg)
Valuation Model (VALUATN.XLS)
DescriptionPrice predictor with detailed valuation analysis.
Standard & Poor’s Research Insight Report & Chart Library
298
![Page 89: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/89.jpg)
299
Excel Templates - Valuation Templates
![Page 90: Templates available in Excel 97 (Excel 8) and higher versions](https://reader031.vdocuments.us/reader031/viewer/2022021305/62073a1449d709492c2f3af5/html5/thumbnails/90.jpg)
Notes
Standard & Poor’s Research Insight Report & Chart Library
300