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

Bullish Sentiment Sees Biggest 2-Week Decline in Over a Year
posted 3 days ago by Wayne Thorp

Apple Unveils New Apple Watch and Two New iPhones
posted 5 days ago by Jaclyn McClellan

TED Talk: What’s wrong with your pa$$w0rd?
posted 8 days ago by Wayne Thorp

Market Dashboard: One New Bearish Signal This Week
posted 8 days ago by Wayne Thorp

Gadget: Satechi Flexible LED Desk Lamp
posted 9 days ago by Wayne Thorp

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 ➜