Excel Spreadsheet for Fundamental analysis (Ratios)

If you are looking to analyze a stock on the basis of fundamentals using excel and just thinking from where to start off then here is the simple answer to your problem.Here are some handpicked spreadsheets which will make your work more easier and will auto calculate the different ratios.

Ratio Tree – A simple yet comprehensive tree of ratios for most businesses – Strategy Expert

As soon as you change values you will be getting automated calculated ratios such as gross margin,current and quick ratio,f asset turnover and others like Dividend yield etc.

Ratio Calculator (zip) – Calculates a standard set of ratios based on input of financial data.

Ratio Reminder (zip) – Simple worksheet of comparative financials and corresponding ratios

It consists different ratio analysis for short and long term solvency like Debt ratio,Total assets to equity,Total liabilities to total assets,Total liabilities to equity,Interest bearing debt to total assets,Interest bearing debt to equity,Long term debt to long term capital,Return on assets,Return on equity,Gross margin and others

SLG Ratio Master (exe) – Excel workbook for creating 25 key performance ratios.

This is actually a shareware product.In which you have to  enter data from your company’s
financial documents into the appropriate worksheets.  That’s it!.It automatically creates four pre-formatted, printable reports one for each of the ratio categories.

View the Original article