Evaluate how effectively a company turns its asset base, shareholders’ equity, and employed capital into earnings with a structured monthly return-ratio worksheet.
This Excel workbook is designed for founders, finance managers, analysts, and investors who need a consistent view of return on assets (ROA), return on equity (ROE), and return on capital employed (ROCE). Enter the company’s monthly net income, total assets, total shareholders’ equity, and debt liabilities, then review the calculated ratios in a table and trend chart.
Assess asset efficiency
Use ROA to examine how much net income the business generates relative to the assets recorded for each month.
Review equity returns
Track ROE to understand the relationship between monthly earnings and the shareholders’ equity supporting the business.
Follow capital performance
Monitor ROCE alongside ROA and ROE to see whether return measures are strengthening, weakening, or remaining stable over the year.
What does the return-ratio analysis help you evaluate?
The workbook brings the underlying financial figures and three related return measures into one monthly view. This makes it easier to interpret performance in context instead of reviewing a single percentage without its earnings, asset, equity, or debt base.
Measure return on assets. Compare net income with total assets to review how productively the company’s asset base is being used.
Measure return on equity. Relate earnings to total shareholders’ equity and observe how the return to the equity base changes by month.
Monitor return on capital employed. Review ROCE as an additional perspective on the return generated from the capital supporting operations.
Compare monthly movement. Read January-through-December values side by side to identify changes, plateaus, and unusual shifts in the three ratios.
Connect ratios to their drivers. Keep net income, assets, equity, and debt liabilities visible above the calculated outputs so changes can be traced back to the reported figures.
What is inside the workbook?
The worksheet combines a monthly financial-input table, calculated return-ratio rows, and a chart covering the same twelve periods. The layout separates the figures supplied by the user from the resulting percentages, allowing the source values and outputs to be reviewed together.
Monthly financial figures
Enter net income, total assets, total shareholders’ equity, and debt liabilities for each month from January through December.
Calculated return ratios
Review monthly ROA, ROE, and ROCE percentages directly below the financial figures used for the analysis.
Return-ratio trend chart
Compare all three measures on one line chart to see how their direction and relative levels change across the year.
The workbook view places twelve months of net income, assets, shareholders’ equity, and debt liabilities above calculated ROA, ROE, and ROCE rows, with a chart showing each ratio’s monthly path.
Review inputs, outputs, and trends in one view
The monthly table supports a practical review process: first confirm the underlying financial figures, then read the calculated return percentages, and finally use the chart to spot movements that deserve a closer look. Because the three ratios are plotted together, users can distinguish a broad change in earnings efficiency from a movement that affects only one capital base.
How do you use the template?
Enter the company details and figures
Add the company name, then complete the monthly rows for net income, total assets, total shareholders’ equity, and debt liabilities.
Review the calculated ratios
Read the ROA, ROE, and ROCE percentages for each month and check them against the financial figures shown immediately above.
Interpret the annual pattern
Use the chart and month-to-month table to identify improving returns, declining efficiency, or periods that require further financial analysis.
Who is this template for?
This workbook is suited to business owners reviewing capital efficiency, finance managers preparing periodic performance analysis, analysts organizing return metrics, and investors examining how earnings relate to the resources committed to a company. It is most useful when reliable monthly financial figures are already available and the goal is to calculate and visualize return ratios in a consistent format. The template focuses specifically on ROA, ROE, and ROCE rather than providing a complete set of financial statements or a full valuation model.
