Financial Ratio Calculations

Excel financial ratio calculations for financial analysis

Submit Excel Solution
Submit Solution [Guide]

Recently Added:
Product Mix Optimization
SEO Keyword Analysis
Tools Add-ins
Data Tools
Directory Contents Lister
More Resources:
Excel Help Forum

Follow Business Spreadsheets On:
Find Excel Solutions:
Suggested text load results and icon loads solution.
Browse Main Categories: Business Finance | Financial Markets | Operations Management | Excel Productivity

Financial Ratio Calculations

Rate this solution:
(2.5/5 from 2 votes)
Buy Now
Financial Ratio Calculations screenshot
Pin It
 Financial Ratio Calculations for Excel provide calculations for 2 period and 5 period analysis. Financial Ratio Calculations calculates over forty financial ratios from two and five period balance sheet figures, income statements and cash flows.

Financial ratios include: profit ratios, return on total assets, return on equity, return on invested capital, working capital, working capital days, asset ratios, inventory, payables and receivables ratios, acid test, quick ratio, debt ratios, solvency ratios and cash flow ratios.

All ratio formulas are given.

Financial Ratio Calculations also provides additional efficiency and shareholder return ratios: Operating Cycle & DuPont Ratios. Operating Ratios are a measure of management's ability to turn the cash cycle from inputs to money in the bank.

Core Financial Ratios – Dupont Ratios – Operating Efficiency Ratios now computed and summarized in a separate table. DuPont Ratios are a short cut to examining core ratios which make up the return on equity. These are considered the most important ratios as they compute shareholders return.

Financial Ratio Calculations for Excel supplies ready made balance sheet and income templates for quick entry of results or forecasts for 2 periods.

Buy Now
Price: USD 99.95

Related Excel Solutions:Financial Analysis Templates-Financial Analysis  Financial Ratio Evaluation-Financial Analysis  Income Statement-Financial Accounting  Balance Sheet-Financial Accounting  Financial Formula Calculations-Financial Analysis  Macroeconomic Model-Forecasting and Prediction  DuPont Analysis-Financial Analysis  Financial Ratio Templates-Financial Accounting

Share your thoughts with other users: Create your own review

Popular Searches

Upgrade Excel with always the latest Office apps
Get Office 365

  © 2014 Business Spreadsheets. All Rights Reserved. Legal | About Us