Home > Excel Business Solutions > Business Finance > Financial Analysis > Financial Ratio Evaluation Share

Financial Ratio Evaluation

Excel financial ratio evaluation for financial analysis


Excel Financial Ratio Evaluation

Rate this solution:
(4/5 from 2 votes)
Financial Ratio Evaluation screenshot
Financial Ratio Evaluation for Excel calculates over two dozen key financial ratios at the touch of a button, and generates presentation quality comparison graphs at the same time. Financial Ratio Evaluation for Excel helps you make your most informed investment and operating decisions using the same ratios that experts rely on to evaluate companies. Plus, it helps you learn how to use these ratios by explaining exactly what each means. Find out what to watch for in each ratio and learn how to discern ratio fact from fiction.

Completely button and menu-driven, Financial Ratio Evaluation for Excel puts all the data you need to enter on a single sheet. Just enter the actual data and goals, and the program does the rest. You'll create over 40 sheets of graphs and reports - all in minutes. If you're planning to invest in a company or project, or if you just want to learn more about ratios, this program is ideal.

Key Features of Financial Ratio Evaluation for Excel include:
  • Compare ratios with personal goals or with industry averages.
  • Regularly analyze the numbers and make sure the company stays healthy.
  • Presentation quality graphs can be printed easily from anywhere in the program.
  • The Clear Data button makes creating another version simple. Just clear data, enter new data, and save.
  • Easy installation lets you just jump right in and get started.
  • Detailed on-line help is always just a click away to give you tips on the easiest way to complete a task.
  • Support is provided by the actual author of the product. You get the author's name, telephone, and support hours at the click of a button.

Over 25 key financial ratios with graphs include:
  • Debt to Equity
  • Assets to Equity
  • Debt Ratio
  • Times Interest Earned
  • Days Sales Outstanding
  • Inventory Turnover
  • Days Sales in Inventory
  • Asset Turnover
  • Working Capital Turnover
  • Equity Turnover
  • Return on Sales
  • Return on Total Assets
  • Return on Equity
  • Operating Return
  • Gross Margin
  • Operating Income per Share
  • Earnings per Share
  • Market Price per Share
  • Book Value per Share
  • Composition of Assets (over 4 years)
  • Composition of Liabilities and Equity (over 4 years)
  • Disposition of Sales Dollars (over 4 years)
  • Net Working Capital
  • Working Capital to Assets
  • Current Ratio
  • Quick Ratio
  • Dividend Payout Ratio

For whom: Ideal for small business owners, investment analysts, financial consultants, business students/faculty, MBAs, CPAs , etc.

What it does: Asks for vital financial data and generates reports on key ratios. Financial ratios indicate the health and direction of a company. Ratio analysis is a highly reliable technique followed by thousands of financial analysts to judge a company's performance.

Designed by: CPAs and MBAs with dozens of years of business and financial consulting experience. Design is based on expert financial models followed by thousands of successful business and financial consultants.

Get It

(Pricing is available on the next page)
(Updated on 2016-05-01)

Related Excel Solutions for Financial Ratio Evaluation

Financial CalculationsFinancial Analysis  Financial Ratio CalculationsFinancial Analysis  Cash Flow ValuationBusiness Valuation  Animated ChartsPresentation and Reporting  DuPont AnalysisFinancial Analysis  Financial Ratio TemplatesFinancial Accounting  Business Plan for InvestorsBusiness Planning  Financial Business Plan TemplateFinancial Analysis  Financial Investment ToolsTechnical Analysis

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum or proposed as a project to the Excel freelance community.