Fin 320 Final Project Milestone Two

Mastering FIN 320 Final Project Milestone Two: A Deep Dive into Analytical Execution

Successfully navigating the first phase of your FIN 320 final project—likely involving topic selection, thesis development, and initial data gathering—is a significant achievement. Milestone Two represents the critical transition from planning to execution, where theoretical finance knowledge meets practical, hands-on analysis. This stage is where you transform your chosen company or case study into a living laboratory, applying core concepts like financial statement analysis, ratio valuation, and industry benchmarking to build a compelling, evidence-based argument. Mastering this milestone is not just about completing a requirement; it’s about developing the analytical rigor that defines a competent financial thinker.

What Exactly is FIN 320 Milestone Two?

While specific requirements can vary by institution and professor, Milestone Two in a typical undergraduate corporate finance course universally focuses on the core analytical engine of your project. Having established your research question (e.g., "Is Company X undervalued?" or "How effective was Company Y's recent capital restructuring?"), you now must provide the quantitative backbone to answer it. This involves a systematic dissection of financial data to uncover trends, strengths, weaknesses, and comparative performance.

The primary deliverables for this milestone usually include:

• A comprehensive horizontal and vertical analysis of the last 3-5 years of income statements and balance sheets.
• The calculation and interpretation of a full suite of key financial ratios across liquidity, solvency, profitability, and efficiency categories.
• A comparative industry analysis, placing your subject firm’s ratios against industry averages or a direct competitor.
• A preliminary trend assessment that identifies emerging patterns or red flags in the data.
• An initial narrative synthesis that connects the numbers to your overarching thesis, highlighting what the data so far suggests.

This phase is the bridge between descriptive research and analytical insight. It answers the "what" with the "so what."

The Step-by-Step Execution Framework

Approach this milestone with a structured, methodical process to ensure completeness and analytical depth.

Step 1: Secure and Clean Your Financial Data

Before any analysis, you must have reliable, formatted data. Retrieve the last three to five years of annual 10-K reports (for U.S. public companies) from the SEC’s EDGAR database or your institution’s financial databases like Bloomberg, Capital IQ, or Morningstar. Extract the core statements: Income Statement, Balance Sheet, and Statement of Cash Flows.

• Critical Action: Create a clean, consistent Excel or Google Sheets workbook. Standardize units (thousands vs. millions), ensure all figures are in the same currency, and create separate, clearly labeled tabs for each statement and for your ratio calculations. Data integrity is non-negotiable; garbage in, garbage out.

Step 2: Perform Horizontal and Vertical Analysis

This is your first layer of analysis, providing context and structure.

• Horizontal Analysis (Trend Analysis): For each line item on the Income Statement and Balance Sheet, calculate the year-over-year (YoY) percentage change. Formula: (Current Year Amount - Prior Year Amount) / Prior Year Amount. This reveals growth rates, contraction, or stability in revenue, costs, assets, and liabilities. A 20% spike in accounts receivable alongside only 5% revenue growth could signal collection issues.
• Vertical Analysis (Common-Size Analysis): Express every line item as a percentage of a base figure. For the Income Statement, use Total Revenue as 100%. For the Balance Sheet, use Total Assets as 100%. This normalizes the statements, allowing for easy comparison across periods and, crucially, against other companies of different sizes. You can instantly see if Cost of Goods Sold (COGS) is consuming 60% of revenue this year versus 55% last year, or if long-term debt comprises 40% of total assets.

Step 3: Calculate and Interpret the Financial Ratios

This is the heart of Milestone Two. Calculate ratios in four core categories, comparing them over time and against benchmarks.

1. Liquidity Ratios: Can the company meet short-term obligations? Key ratios: Current Ratio, Quick Ratio. Look for declining trends.
2. Solvency (Leverage) Ratios: What is the long-term financial risk? Key ratios: Debt-to-Equity, Debt-to-Assets, Times Interest Earned. A rising debt-to-equity ratio warrants investigation into why.
3. Profitability Ratios: How efficiently is the company generating profit? Key ratios: Gross Profit Margin, Operating Margin, Net Profit Margin, Return on Assets (ROA), Return on Equity (ROE). ROE is paramount; use the DuPont analysis (ROE = Profit Margin x Asset Turnover x Equity Multiplier) to decompose its drivers.
4. Efficiency (Activity) Ratios: How well does the company manage its assets? Key ratios: Inventory Turnover, Accounts Receivable Turnover, Total Asset Turnover. Slowing turnover can indicate operational inefficiency.

Interpretation is key: Don’t just state the ratio. Say, "The current ratio fell from 1.8 to 1.2 over three years, indicating deteriorating short-term liquidity, potentially due to a 40% increase in accounts payable." Always link the ratio movement to a plausible business reason.

Step 4: Conduct the Industry Comparative Analysis

A ratio in isolation is meaningless. A 15% ROE might be terrible for a tech firm but excellent for a utility. You must benchmark.

• Identify 2-3 primary competitors and obtain their latest financial data.
• Calculate the same ratios for these competitors.
• Use industry averages from sources like Damodaran’s datasets, RMA Annual Statement Studies, or your textbook. Compare your firm’s ratios to both the direct competitors and the broader industry average.
• Ask: Is our subject firm leading, lagging, or matching the pack in profitability? Is it more or less leveraged than its peers? This comparative view is what transforms internal analysis into strategic insight.

Step 5: Synthesize and Connect to Your Thesis

Now, weave the quantitative story. Create a summary table of your key ratio findings (trends and comparisons). In a narrative section, answer:

• What are the **two or three

most critical financial strengths and weaknesses** revealed by the analysis?

• How do these strengths/weaknesses support or challenge your initial thesis about the company’s future prospects?
• Are there any red flags (e.g., rapidly increasing leverage, declining margins, deteriorating liquidity) that could derail your thesis?
• What strategic implications arise from the financial profile? For instance, a highly leveraged firm in a cyclical industry might be vulnerable to downturns, while a company with strong margins and low debt might be well-positioned for growth.

This synthesis is where you demonstrate critical thinking—linking the numbers to a coherent strategic narrative. If your thesis was that the company is a strong buy, your analysis should show robust profitability, improving efficiency, and a solid capital structure relative to peers. If the numbers tell a different story, your thesis must evolve accordingly.

Step 6: Prepare for Valuation (Milestone Three)

The financial analysis you’ve completed now provides the foundation for valuation. The trends in revenue, margins, and capital structure will inform your assumptions about future cash flows. The industry comparison will help you assess whether your growth and margin assumptions are realistic. Think of Milestone Two as building the case for what the company is worth—Milestone Three is where you assign a dollar value.

Conclusion

Milestone Two is not a mechanical exercise in ratio calculation—it is the rigorous financial due diligence that validates (or invalidates) your investment thesis. By systematically analyzing three years of financial statements, calculating and interpreting key ratios, benchmarking against competitors and industry averages, and synthesizing these insights into a strategic assessment, you transform raw data into actionable intelligence. The effort you invest here will directly determine the credibility and defensibility of your final valuation and recommendation. Treat it as the indispensable bridge between understanding a company’s story and determining its true worth.