I have to analyze financial statements for a company, say Oracle, for the last 5 years including revenue, net profit, employee count and other significant details released in quarterly results? How do I do it?
It depends on the industry, type of company, and your perspective. But generally, I look at three buckets: 1) Profit. 2) Liquidity (Cashflow) 3) Leverage. From a risk perspective, you are looking at whether the company is a going concern. From an investing perspective, you want to determine if the company is valued at the right price - this is much more intensive, requires different metrics than below and requires modeling.
Liquidity: current ratio, cash flow from operations
Leverage: Long-term debt/equity, interest-bearing debt/equity, interest coverage ratio. Note : an operating company should have lower D/E than an investing company. A manufacturing firm would perhaps have 50% assets funded by debt (D/E = 1), while a bank would normally have 80-90% debt to assets (D/E through the roof). Research the industry benchmarks.
SaaS companies and start ups use different metrics and fundamental analysis don’t really work. Check out things like Rule of 40, Efficiency ratio.
Hope this gives you a bit of a start. Remember - Cash is King.