Fin 320 Module Four Case Study: Exact Answer & Steps

Ever walked into a finance class and felt the room tilt when the professor pulled out a massive case study?
Practically speaking, you’re not alone. Most of us have stared at a spreadsheet, wondered what the numbers actually mean, and then tried to stitch together a story that makes sense for a real‑world firm.

That’s exactly what the FIN 320 Module 4 case study is built for—turning theory into practice, and giving you a sandbox where the numbers, the strategy, and the risk all collide.

Below is the full rundown: what the case is, why it matters, how to tackle it step by step, the pitfalls most students fall into, and the tricks that actually get you a solid grade (and maybe a little confidence boost).

What Is the FIN 320 Module 4 Case Study

In plain English, the Module 4 case is a deep‑dive into corporate valuation and capital budgeting.
Instead of abstract formulas, you get a real company—usually a mid‑size manufacturer or a tech start‑up—complete with historical financials, market data, and a strategic decision to make.

The assignment typically asks you to:

• Forecast cash flows for the next five to ten years.
• Choose an appropriate discount rate (WACC).
• Run a Net Present Value (NPV) and Internal Rate of Return (IRR) analysis.
• Evaluate financing options (debt vs. equity).
• Write a recommendation memo that ties the numbers to a strategic narrative.

Think of it as a mini‑consulting project. You’re the analyst, the board is your client, and the spreadsheet is your courtroom.

The Core Components

• Financial statements – Income statement, balance sheet, cash‑flow statement for the past three years.
• Strategic context – A new product line, an acquisition target, or a plant expansion.
• Assumptions sheet – Growth rates, tax rates, cost of capital, and market risk premium.
• Decision matrix – Usually three scenarios: base case, best case, worst case.

Why It Matters / Why People Care

Because finance isn’t just about crunching numbers; it’s about telling a story that convinces stakeholders to act.

When you nail this case, you prove you can:

1. Bridge theory and practice – All those NPV and CAPM lectures finally have a home.
2. Speak the language of CEOs – Executives don’t want “just the math”; they want the implication of that math.
3. Boost your résumé – Recruiters love seeing “completed FIN 320 Module 4 case study” under the skills section.

On the flip side, ignore it and you’ll end up with a bland spreadsheet that looks impressive but says nothing about risk, strategic fit, or real‑world constraints. In practice, that’s the difference between a hire and a pass.

How It Works (or How to Do It)

Below is the step‑by‑step workflow that consistently earns A‑grades. Feel free to adapt it to your own timeline, but keep the order; skipping a step is the fastest way to get lost.

1. Read the Case Like a Detective

• Skim the executive summary first—what decision is the company facing?
• Highlight every number that looks “sticky”: revenue growth, capital expenditures, debt covenants.
• Write down any jargon you don’t know; a quick Google search will save you hours later.

2. Set Up Your Master Spreadsheet

Create separate tabs for:

Keeping everything linked means a single change (say, a 0.5 % tax tweak) ripples through automatically.

3. Reconcile Historical Data

• Check consistency – Does depreciation in the cash‑flow statement match the accumulated depreciation on the balance sheet?
• Adjust for one‑off items – A lawsuit settlement or a one‑time asset sale can skew trends.
• Calculate ratios – Gross margin, operating margin, ROIC. These become your baseline for future assumptions.

4. Build the Forecast

Start with revenue:

1. Identify the driver (units sold, price per unit, subscription count).
2. Apply the growth rate from the case assumptions, but temper it with industry reports you can quickly pull from free sources (e.g., Statista, IBISWorld summaries).

Then move down the income statement:

• COGS – Usually a stable percentage of revenue, but watch for scaling economies.
• Operating expenses – Separate fixed vs. variable; allocate a modest inflation bump.
• Depreciation & amortization – Use the straight‑line schedule from the historical assets.

For the balance sheet, project:

• Working capital – Apply the historical turnover ratios (e.g., days sales outstanding).
• CapEx – Pull from the strategic context; if the case mentions a new plant, add the stated amount.

Finally, the cash‑flow statement: start with net income, add back non‑cash charges, subtract CapEx, and adjust for changes in working capital.

5. Determine the Discount Rate (WACC)

WACC = (E/V) × Re + (D/V) × Rd × (1‑Tc)

• E/V and D/V – Market value of equity and debt; if market caps aren’t given, use book values as a proxy.
• Re (cost of equity) – CAPM: Re = Rf + β × (MRP). Grab the risk‑free rate from the latest 10‑year Treasury yield, β from a comparable public firm, and the market risk premium from your textbook’s table.
• Rd (cost of debt) – Yield on existing bonds or the company’s borrowing rate in the case.

Don’t forget to adjust the corporate tax rate (Tc) from the assumptions sheet.

If you found this helpful, you might also enjoy who should inspect a crane or words that start with q and end with m.

6. Run the Valuation

• NPV – Discount each year’s free cash flow (FCF) at WACC, sum them, then subtract any initial outlay (e.g., acquisition price).
• IRR – Use Excel’s IRR function on the same cash‑flow series; compare it to WACC.
• Sensitivity analysis – Create a two‑way table varying WACC (±1 %) and revenue growth (±2 %). This shows how fragile the project is and gives you talking points for the memo.

7. Evaluate Financing Options

If the case asks you to choose between debt and equity financing, run two separate WACC calculations:

Show the impact on NPV for each mix—this is where many students lose points by ignoring the financing side entirely.

8. Draft the Recommendation Memo

Structure it like a real board memo:

1. Executive summary – One paragraph: “We recommend proceeding with the expansion because the NPV is $12.3 M under the base case, with a 15 % IRR exceeding the 9 % WACC.”
2. Key assumptions – List the three most material inputs (growth, WACC, CapEx).
3. Analysis – Summarize NPV, IRR, and the sensitivity outcomes.
4. Risks – Highlight the top three (e.g., demand slowdown, cost overruns, interest‑rate spikes).
5. Conclusion & next steps – What the board should sign off on, and any follow‑up data needed.

Keep it tight; board members skim, they don’t read dissertations.

Common Mistakes / What Most People Get Wrong

1. Treating the discount rate as a “one‑size‑fits‑all.”
   Many students plug the textbook’s default WACC and never adjust for the specific capital structure in the case. The result? A distorted NPV that looks too optimistic or too bleak.

2. Ignoring working‑capital changes.
   It’s tempting to skip the day‑to‑day cash‑flow adjustments, but a 5 % increase in inventory can shave millions off free cash flow.

3. Over‑relying on a single scenario.
   A base‑case projection is nice, but the board wants to see best‑ and worst‑case outcomes. Without a sensitivity table, you look lazy.

4. Copy‑pasting textbook formulas without checking units.
   A common slip is mixing percentages with decimals (10 % vs. 0.10). Excel will happily give you a negative NPV that makes no sense.

5. Writing a memo that repeats the spreadsheet.
   The memo should interpret the numbers, not regurgitate them. If you simply list “NPV = $12.3 M,” you’ve missed the chance to explain why that matters.

Practical Tips / What Actually Works

• Start with a rough “back‑of‑the‑envelope” model.
  Sketch the cash‑flow stream on a napkin; it forces you to think about the biggest drivers before you get lost in Excel rows.

• Use named ranges for key inputs.
  When you type “=WACC” instead of “=0.0895,” you avoid accidental overwrites and make the sheet easier to audit.

• Color‑code your sheets.
  Green for inputs, blue for calculations, orange for outputs. It looks professional and helps the grader follow your logic.

• Add a “What‑If” button.
  A tiny macro that toggles between the three scenarios saves you clicking around and impresses the professor. It's one of those things that adds up.

• Cross‑check with a quick DCF calculator online.
  Not to copy, but to verify that your NPV isn’t off by an order of magnitude. If the two numbers diverge, you’ve missed a sign error.

• Practice the story in 60 seconds.
  If you can’t explain the recommendation in a minute, the memo will feel weak. Pretend you’re on a conference call with the CFO.

FAQ

Q: Do I need to use the exact growth rates given in the case?
A: Use them as a baseline, but justify any deviation with external data or logical reasoning. Professors reward thoughtful adjustments.

Q: How many decimal places should I show in the final NPV?
A: Round to the nearest thousand (e.g., $12,300 K). Too many decimals look sloppy; too few hide material differences.

Q: Is it okay to assume a constant tax rate throughout the forecast?
A: Generally yes, unless the case mentions a pending tax reform. If you anticipate a change, model it explicitly and note the impact.

Q: Should I include a terminal value?
A: Absolutely, unless the case explicitly says to stop at year 5. Use a perpetual growth model (g ≈ 2‑3 %) and explain why you chose that rate.

Q: What’s the best way to present the sensitivity table?
A: A two‑axis heat map works well—rows for growth rate, columns for WACC, with cell shading indicating NPV magnitude. It’s visual and quick to read.

That’s the whole playbook.
You’ve got the why, the how, the pitfalls, and the shortcuts that turn a daunting spreadsheet into a compelling story.

Now open Excel, copy the first line of the case onto a sticky note, and start building. The numbers will line up, the memo will flow, and you’ll walk out of FIN 320 feeling like you actually understand corporate finance—not just that you can press “=NPV()”.

Good luck, and may your IRR always beat the WACC.