Financial Ratio Analysis (Monthly) Excel Model
Originally published: 29/04/2019 15:45
Last version published: 30/04/2019 13:52
Publication number: ELQ-36046-2
View all versions & Certificate

Financial Ratio Analysis (Monthly) Excel Model

Financial Ratio Analysis tool to compare 5 different companies

This adaptable Financial Ratio Analysis template allows you to compare and analyze the financial ratios for 5 different companies. This is an effective and efficient tool if you are looking to evaluate your company’s strengths and weaknesses in comparison to those of the competition according to a variety of different criteria.

To use this model, just enter the balance data and profit & loss data for each year in order to calculate all the ratios and create a chart for comparison. Once you have input the key data, you will be able to view the worksheet with a summary of all the financial ratios according to different ratio analysis categories (liquidity, activity analysis, profitability & debt management). The template also includes a chart for graphical illustration of the data for a chosen ratio.

If you wish to see how this financial ratio analysis template looks in Microsoft Excel you can download a demo version. The demo version is the same as the real template; however, you will not be able to change anything in the demo version.

If you wish to change something in the template, feel free to contact us to order customization hours at

If you have any questions, or queries, surrounding this tool, you’re able to either start a discussion below or contact us directly via private message via our Eloquens author account! See our channel for additional templates and resources like this one.

Enjoyed this tool? Show your appreciation by leaving a review and a rating.

This Best Practice includes
1 Financial Ratio Analysis excel sheet

Acquire business license for $9.00

Add to cart

Add to bookmarks


0.0 / 5 (0 votes)

please wait...