What is the Tool to Measure Relative Changes in Financial Statements

Dear Friend!

Simple MS Excel is the best tool to measure relative changes in the item heads in financial statements. I use this tool regularly and quite effectively.

You have to physically enter the financial data for many years as columns and data items/ heads as rows. Then you can perform absolute changes and percentage changes quite easily.

After the data is ready, you can use many powerful features of MS Excel like “IF” function, “Conditional Formatting” to highlight results in the most useful and visually powerful forms.

Please see the example Excel Sheet containing NMDC’s operating results for various years, below. By using conditional formatting, the EBT% figures are highlighted in the following ways:

1.     If EBT% is below 50% the cell is filled with light pink and fonts are in dark red.

2.     If EBT% is above 50% but below 75% the cells are highlighted in light green and the font colour is black.

3.     If EBT% is above 75% the cells are highlighted in dark green and the font colour is white.

I hope you will use the MS Excel and also master a few powerful techniques they possess.

Thank you,

With Best Regards

Anand