FREE Ratio Analysis Template

Copy and paste as many columns of your own data into the grey shaded cells of this template, and then click the "Ratio Analysis" button in the top right hand corner of the worksheet. Follow the prompts to create your own chart visualizing "Ratio Analysis", Growth Rate" and "Market Share" trends in your financial data. Or, you can customize your own financial ratios and feed them into this template. Great for Data Analysis Toolpak users.

View the Time Series Ratio Analysis Dashboard and learn how you can build a web-based, interactive, time series ratio analysis dashboard on your own business ratios in four easy steps.

Notes:

- the 'Ratio Analysis' button in the updated "RatioAnalysisv2.xlsm" version lets you click to select your data and create your formatted ratios line chart

-  the 'Start Over' button in the updated version lets you click to delete your chart and ratios table so you can start from scratch on a new analysis.

You may need to do the following before using any templates:

- Enable or disable macros in Microsoft 365 files
- Unblock macros from downloaded files

You might also try the FREE Simple Box Plot Graph and Summary Message Outlier and Anomaly Detection Template or FREE Outlier and Anomaly Detection Template. Create a scatterplot graph to find outliers and improve forecasts over time with the FREE Weekly Period Scatterplot and Trendlines Analysis Template. Or, automatically detect outliers, create a box & whisker plot graph, and receive a summary conclusion about dataset outliers with one button click using the Outlier Box Plot Graph Analysis Outlier and Anomaly Detection Template. The FREE SAMPLE OUTPUT - TIME SERIES Outlier and Anomaly Detection Template shows how you can detect patterns by finding outliers in data with the TIME SERIES Analysis Outlier Dashboard.