You can go to the SEC EDGAR website and search for 10-K filings for large pharma companies -- Roche, Novartis, Pfizer, Merck etc. they summarize their financials including r&d spend. Most big pharma companies spend $5-12B / year on r&d and it can take 10 years to get approval