Using Excel to dissect financial knowledge.
1. Pick any publicly traded assembly that you would love. You conciliate be accumulating three years of estimate quibbles in Excel, and creating common-size declarations for each of those years. (If you would love to accept past knowledge about common-size declarations, appear at http://www.netmba.com/finance/statements/common-size/.) You should besides cause a compute of graphs illustrating the estimate quibble knowledge. You may accomplish assembly knowledge either from the SEC (Edgar) or from the assembly's website.
2. Use the selfselfsame assembly as the former training. Note that you conciliate be accumulating three years of allowance declarations as well-behaved-behaved as preparing common-size declarations, farsighted the subjoined financial declaration ratios and preparing a compute of graphs illustrating those ratios and any other knowledge you move is expressive.
The ratios to be speedy are:
Debt to equity ratio
Gross improvement ratio
Return on assets
Return on equity
Inventory ratios, if alienate