CI’s Financial Ratio Analysis Spreadsheet

July 19, 2014

For most investors, examining a company’s financial statements front to back is not only time-consuming, but overwhelming. Financial ratios seek to minimize this tedious task by allowing investors to work through financial statement figures in an organized fashion and draw conclusions based on how certain figures relate to one another.

Stock investors are primarily looking for future growth in cash flow and earnings. Fundamental investors examine variables that might significantly impact a firm’s financial structure, sales, earnings production and dividend policy. By looking through a company’s financial ratios, investors can piece together an estimate about the company’s overall “health” to determine if it is an investment worth undertaking. CI offers a financial ratio analysis spreadsheet that aids in collecting the needed data and calculating the ratios. Five basic financial ratio categories are addressed in this spreadsheet: liquidity, efficiency, leverage, coverage and profitability. Note that the spreadsheet will not work correctly for evaluating financial companies.

The spreadsheet was created in Excel 2013 (Office 365). If you do not have this version of Excel, the spreadsheet may not open correctly. Support for Office 2003 has ended and we recommend users of Office 2003 update their software. Another option is to install an Office Compatibility Pack, which will allow you to open 2013, 2010 and 2007 Office System documents in Office 2003, Office XP, or Office 2000.

Read More »

Contact CI       Computerized Investing

CI Market Dashboard

We have put together a collection of market indicators and track them to help you gauge the direction of the market.

CI Analysis Worksheets

Interactive analysis templates covering DuPont analysis (return on equity), valuing stocks the Warren Buffett way, and more to come.

CI Blog Feed

No Changes in CI Market Dashboard, Stays at All-Time Bearish Level
posted 2 days ago by Wayne Thorp

New iPhone 6, Without the Wait
posted 6 days ago by Wayne Thorp

Bearish Sentiment Hits 7-Week High
posted 6 days ago by Wayne Thorp

Market Dashboard Most Bearish Since Inception
posted 6 days ago by Wayne Thorp

TipRanks Launches Website
posted 12 days ago by Jaclyn McClellan

Recent Articles

First Quarter 2014

Calculating Mohanram’s G-Score Using SI Pro and Microsoft Excel

Quantifying a strategy focused on separating the winners from the losers in high price-to-book-value stocks.

Fourth Quarter 2013

Excel 2013/Office 365 Home Premium

A look at the fundamental changes that have taken place with Office 2013 and some new features offered in Excel 2013.

Third Quarter 2013

The Ulcer Index of the AAII Stock Screens

Calculating the downside risk of the stock screening methodologies tracked at

Second Quarter 2013

Bond Duration & Convexity

Part three of our series on bond calculations takes maturity into account when measuring price sensitivity.

Click here for entire collection of Spreadsheet Corner articles ➜