Students evaluate two U.S. companies from different stock exchanges to assess free cash flow trends and then analyze three industry competitors using key financial statements and ratios in the provided Excel template.
Overview For your first assignment, you will research how to evaluate stocks as an investment option and complete a company analysis using the provided template. Students often begin with reliable public sources because accurate data forms the foundation for sound investment decisions. You will start by selecting two companies to determine how free cash flow impacts their growth potential. Then you will select three competitors in the same industry to perform a company analysis. The point of this assignment is to practice finding and analyzing company financial information.
Instructions Step 1: Gather the financial information. Use one or more of the following sources: Yahoo Finance (Preferred Method): https://finance.yahoo.com. Search for your company. Select the Financials tab to view the Income Statement, Balance Sheet, and Cash Flow Statement. Many students appreciate Yahoo Finance for its clean layout and direct links to annual reports. Morningstar: https://www.morningstar.com/stocks. SEC Filings (10-K, 10-Q, and other reports): https://www.sec.gov/edgar/search. Company Investor Relations Website: Find financial reports under the Investor Relations section of the company’s website. D&B Hoovers (Industry Research): https://www.dnb.com.
Step 2: Complete the company analysis in the Company and Stock Analysis [EXCEL] template. Note: Select the correct tab (Week 3 – Company Analysis) at the bottom of the Excel document. Accurate entry here helps you see patterns across statements more clearly. Determine the free cash flow for the last two most recent years for the two companies. Select one company on each of the two different domestic (U.S.) stock exchanges to review. Free cash flow is defined as cash flow from operations minus capital expenditures. Positive free cash flow often signals that management has resources available after maintaining operations, which can support strategic choices without heavy borrowing.
Explain how a company’s free cash flow affects its growth potential. Include the inferences you can draw from a company’s free cash flow. Companies generating steady free cash flow tend to fund expansions, research, or shareholder returns more sustainably than peers reliant on external capital. Complete the Company Analysis section, including the Industry and the names of the three companies.
Complete the Income Statement section for each company’s Total Revenue, Gross Profit, Net Income, and/or EBITDA. Net Income is a generally accepted accounting principle (GAAP). The Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) is not GAAP, because it usually presents more favorable numbers. These figures allow direct year-over-year comparisons that reveal operational efficiency trends.
Complete the Balance Sheet section for each company’s Total Assets, Total Liabilities, and Total Stockholders’ Equity.
Calculate the following three ratios for each company and enter the results in the template (the formulas to calculate the ratios are provided in the template). Debt-to-Equity Ratio. Gross Margin. Operating Margin. Please list the figures used for the calculation of each ratio.
Calculate the following ratios for each company using the 10k annual report and enter the results in the template (the formulas to calculate the ratios are provided in the template). Profitability ratios. Efficiency ratios. Leverage ratios. Liquidity ratios.
Discuss three takeaways or an analysis of what you have learned about each company based on their financial data. Include at least one paragraph for each company in the Template.
This course requires the use of Strayer Writing Standards (SWS). The library is your home for SWS assistance, including citations and formatting. Please refer to the Library site for all support. Check with your professor for any additional instructions.
The specific course learning outcome associated with this assignment is as follows: Review concepts related to corporate finance, investment strategies, risk assessment, corporate valuation, and financial management.
Sample Company Analysis Excerpt
Investors frequently examine free cash flow because it shows cash available after essential spending on operations and assets. For instance, consistent positive free cash flow enables a firm to pursue acquisitions or innovation while limiting debt reliance. In one recent analysis of consumer goods companies, higher free cash flow correlated with stronger reinvestment capacity and steadier earnings growth.
Apple Inc. (NASDAQ) demonstrated robust free cash flow in recent years, supporting share repurchases and product development without straining liquidity. The company’s balance sheet reflected growing total assets alongside controlled liabilities, which kept the debt-to-equity ratio moderate. Gross margin remained elevated due to premium pricing and supply chain efficiencies, while operating margin highlighted effective cost management.
Three key takeaways emerge from the data. First, strong free cash flow generation appears to buffer against economic slowdowns. Second, profitability ratios stayed competitive compared with sector averages. Third, liquidity ratios indicated solid short-term solvency that could support future expansion plans.
According to Investopedia, “Consistent positive FCF signals financial flexibility, allowing a company to repay debt, pay dividends, or reinvest in growth.”
Additional observations include efficiency ratios that suggested effective asset utilization in generating revenue. Leverage ratios remained within prudent levels for the industry, reducing financial risk. Overall, the financial profile pointed toward sustainable operations capable of weathering market shifts.
Firms with negative or volatile free cash flow may face constraints when funding growth initiatives, sometimes leading to higher borrowing costs or delayed projects.
Free Cash Flow and Growth Potential
Positive free cash flow provides internal funding that reduces dependence on capital markets. Companies can allocate these resources toward research and development, market expansion, or returning value to shareholders through dividends and buybacks. In contrast, limited free cash flow may force reliance on debt or equity issuance, which can dilute ownership or increase interest expenses.
Empirical studies show that firms generating higher free cash flow margins often achieve more consistent long-term growth with lower risk profiles. Managers who deploy free cash flow effectively tend to enhance shareholder value over time.
- Firms should track trends in free cash flow alongside capital expenditure plans to forecast sustainable growth rates.
- Negative free cash flow during heavy investment phases can still indicate healthy expansion when future cash flows are projected to rise.
- Comparing free cash flow yield across peers helps identify undervalued opportunities with solid fundamentals.
Ratio Analysis Insights
Debt-to-equity, gross margin, and operating margin offer quick snapshots of financial structure and profitability. When calculated from 10-K data, these metrics gain reliability because they reflect audited figures. Profitability, efficiency, leverage, and liquidity ratios together paint a fuller picture of operational health and risk exposure.
Students benefit from listing source figures next to each ratio so instructors can verify calculations easily. Trends across multiple years often reveal more than single-period snapshots.
References
Pratama, A. (2023). Equity valuation using free cash flow to equity on IDX30 index for 2022 to 2026 period projection. International Journal of Social and Management Studies, 6(3), 119-127. https://www.ijsmsjournal.org/2023/volume-6%20issue-3/ijsms-v6i3p119.pdf
Saeed, S. (2020). Impact of free cash flow on the financial performance of banks in Pakistan. Semantic Scholar. https://pdfs.semanticscholar.org/ec9c/d38a7ea1aeb9abb80bc68bfefea40324e6cd.pdf
Tengulov, A. (2025). Valuation and long-term growth expectations. Journal of Financial and Quantitative Analysis. https://www.cambridge.org/core/journals/journal-of-financial-and-quantitative-analysis/article/valuation-and-longterm-growth-expectations/677A63FF27B758BBE12BD6C008B0A97C
Week 4 Assignment – Competitor Valuation and Risk Assessment In Week 4, build on your company analysis by performing a discounted cash flow valuation for one of the firms studied previously and assessing key investment risks. Compare your intrinsic value estimate with current market price, then discuss how industry-specific risks (such as supply chain disruptions or regulatory changes) could affect future free cash flow projections. Submit a 2- to 3-page memo that includes sensitivity analysis on growth and discount rate assumptions, plus updated ratio comparisons with the three competitors. Use the same Excel template to extend your work and cite sources per SWS guidelines. This assignment reinforces corporate valuation techniques and prepares you for portfolio decision-making.