profitability, liquidity, gearing, efficiency ratios.

I am confused on the numbers to use, but also the values for pre-calculation before calculating the actual ratios.

For example: calculating profitability, I am required to work out other values before being able to use the answers to then allow me to work out the ratio.

Please show a step by step process for all ratios for at least one or two years.

Please show how to logically input this information on excel.