Final Exam / Capstone Project: Analyze a Company End-to-End

Congratulations on reaching the capstone project of our Fundamental Analysis course! This project is designed to help you apply everything you have learned throughout the course to analyze a real company from start to finish. By completing this project, you will develop a practical, repeatable process for evaluating any company and making informed investment decisions. This is the most important step in your journey from learning about investing to actually doing it.

For this project, you will select a publicly traded company and perform a complete fundamental analysis covering business understanding, industry analysis, financial statement analysis, ratio analysis, valuation, and an investment recommendation. Choose a company that you find interesting and that has at least five years of publicly available financial data. If you are based in India, consider starting with a well-known company like Hindustan Unilever, Asian Paints, or HDFC Bank. If you are analyzing US stocks, consider companies like Coca-Cola, Microsoft, or Procter & Gamble.

The project is structured into five steps, each building on the previous one. Complete each step thoroughly before moving to the next. Aim to spend 2-3 hours on each step, for a total of 10-15 hours for the complete project. The output will be an investment memo that you can use as a template for all future stock analysis. This is your opportunity to practice the skills you have learned throughout this course. Review the course foundations if needed in What Is Fundamental Analysis? A Complete Introduction.

The first step is to develop a deep understanding of the business and the industry in which it operates. Start by answering these fundamental questions: What does the company do? Who are its customers? How does it make money? What is its business model — is it asset-light or asset-heavy? Does it have recurring revenue or one-time sales? What is its competitive advantage or economic moat? Use the company's annual report, investor presentations, and website to answer these questions.

Next, analyze the industry using Porter's Five Forces framework. Evaluate the threat of new entrants, bargaining power of suppliers, bargaining power of buyers, threat of substitutes, and the intensity of competitive rivalry. Identify the key success factors in the industry and assess how well the company performs on each one. Research the industry's growth prospects, regulatory environment, and key trends. Compare the company to its top 3-5 competitors on metrics like market share, revenue growth, and profitability.

Finally, assess the company's management quality. Research the background and track record of the CEO and key management personnel. Read the Chairman's letter in the annual report to understand management's vision and strategy. Evaluate their capital allocation decisions — have they made good acquisitions, invested wisely in the business, and returned capital to shareholders appropriately? Check promoter shareholding patterns and any related party transactions. For help with this analysis, see How to Do Industry Analysis Before Picking a Stock and Porter's Five Forces Model Explained for Stock Analysis.

The second step is a thorough analysis of the company's financial statements over the past 5-10 years. Start with the income statement. Analyze revenue growth trends — is growth accelerating, stable, or declining? Break down revenue by segment, geography, or product line if the data is available. Analyze gross margin, operating margin, and net margin trends. Are margins expanding or contracting? What is driving the changes? Check for non-recurring items that distort the true operating performance.

Next, analyze the balance sheet. Evaluate the company's capital structure — how much debt does it have and is the debt level appropriate for the industry? Analyze working capital management — are receivables, inventory, and payables being managed efficiently? Look at the quality of assets — is there a large amount of goodwill or intangible assets that could be impaired? Check for contingent liabilities disclosed in the notes. Review the shareholders' equity section for retained earnings trends, buybacks, and dividend payments.

Finally, analyze the cash flow statement in detail. This is often the most revealing financial statement. Compare net income with cash flow from operations over multiple years — a persistent divergence is a major red flag. Analyze capital expenditure trends and whether the company is investing enough to maintain its competitive position. Evaluate free cash flow generation and the company's use of free cash flow (debt repayment, dividends, buybacks, acquisitions). Check the financing section for changes in debt and equity that signal capital structure changes. Use How to Read a Cash Flow Statement and Why Profit ≠ Cash: Understanding Cash Flow vs Net Income for guidance.

The third step is to calculate and interpret key financial ratios to assess the company's profitability, efficiency, liquidity, solvency, and valuation. For profitability, calculate ROE, ROCE, ROA, gross margin, operating margin, net margin, and free cash flow margin. Compare these ratios with industry peers and track the trends over 5+ years. A high and improving ROE (above 15%) with low debt is a sign of a high-quality business with a competitive advantage.

For efficiency, calculate asset turnover, inventory turnover, receivables turnover (DSO), and payable turnover (DPO). Assess whether the company is using its assets efficiently and compare turnover ratios with industry peers. For liquidity and solvency, calculate current ratio, quick ratio, debt-to-equity, interest coverage, and debt service coverage ratios. Ensure the company has adequate liquidity to weather downturns and does not have excessive debt that could become problematic in a recession.

For growth analysis, calculate revenue CAGR, earnings CAGR, and book value CAGR over 3, 5, and 10-year periods. Use the DuPont analysis to break down ROE into its components (profit margin, asset turnover, and financial leverage) to understand what is driving the company's returns. For DuPont analysis, see Understanding the DuPont Analysis of ROE. For peer comparison techniques, refer to How to Compare Peer Companies in the Same Sector.

The fourth step is to determine the intrinsic value of the company using multiple valuation methods. Start with relative valuation: calculate the current PE, PB, EV/EBITDA, and price-to-sales ratios. Compare these with the company's historical averages and with industry peers. If the stock is trading above its historical average PE, understand why — is it justified by higher growth or margins, or is it simply overvalued? Use the PEG ratio to assess whether the growth rate justifies the PE multiple.

Next, perform a DCF valuation. Project free cash flows for 5-7 years based on your revenue growth, margin, capex, and working capital assumptions. Calculate the appropriate WACC based on the company's cost of equity and cost of debt. Determine the terminal value using both the perpetuity growth method (assume 3-4% terminal growth) and the exit multiple method (use current industry average EV/EBITDA). Discount all cash flows to present value and calculate the intrinsic value per share. Cross-check your DCF assumptions with the company's historical performance and industry outlook.

Finally, perform a sensitivity analysis to understand how changes in key assumptions affect your valuation. Create a table showing intrinsic value across a range of growth rates and discount rates. This will give you a range of possible intrinsic values rather than a single point estimate. Compare your intrinsic value range with the current market price. If the stock is trading at a 20-30% discount to your conservative intrinsic value estimate, it may be undervalued. If it is trading at a premium, it may be overvalued. For valuation guidance, study What Is DCF (Discounted Cash Flow) Valuation? Step-by-Step Guide, Relative Valuation vs Absolute Valuation Explained, and Sensitivity Analysis in DCF Valuation.

The final step is to synthesize all your analysis into a comprehensive investment memo. Your memo should include: (1) Executive summary — a one-paragraph overview of the company and your investment recommendation; (2) Business overview — what the company does, its business model, and competitive advantage; (3) Industry analysis — market size, growth drivers, competitive landscape, and Porter's Five Forces assessment; (4) Financial analysis — key financial metrics, trends, and ratio analysis over 5+ years; (5) Valuation — your intrinsic value range using multiple methods and comparison to current market price.

(6) Investment thesis — 3-5 clear reasons why this is a compelling investment opportunity; (7) Risks and mitigants — the key risks that could cause the investment thesis to fail and what could mitigate these risks; (8) Catalysts — specific events or developments that could unlock value and drive the stock to your target price; (9) Recommendation and price target — your buy/hold/sell recommendation with a 12-18 month price target and expected return; (10) Conditions for review — specific conditions under which you would revisit your thesis, including what would make you buy more, hold, or sell.

Once your investment memo is complete, you have successfully completed the capstone project and the fundamental analysis course! The most important step is to save your memo and revisit it periodically. Track how your analysis compares with the company's actual performance. Learn from your mistakes and refine your process. Investing is a lifelong learning journey, and this capstone project is the beginning, not the end. Congratulations on completing the course. Use your new skills wisely with our Building Your Own Fundamental Analysis Checklist Template and continue learning with How to Keep Learning: Building a Habit of Reading Annual Reports.

Completing this capstone project is a significant achievement that demonstrates your commitment to becoming a serious fundamental investor. The skills you have developed throughout this course will serve you for a lifetime. Remember that investing is a continuous learning process — every company you analyze and every investment you make will teach you something new. We wish you the best in your investing journey. Continue your education with our Best Books on Fundamental Analysis (Beginner to Advanced) and Best Free Tools and Websites for Fundamental Analysis. This content is educational and does not constitute financial advice.