r/financialmodelling

A strict DCF of Nike (NKE): Is the Elliott Hill turnaround a Value Trap? My model says intrinsic value is $12.16.
▲ 29 r/financialmodelling+1 crossposts

A strict DCF of Nike (NKE): Is the Elliott Hill turnaround a Value Trap? My model says intrinsic value is $12.16.

With Nike bringing back Elliott Hill as CEO, the stock saw a relief rally and is hovering around $46. But as value investors, we have to separate brand nostalgia from the actual cash flows. I wanted to see if there is any Margin of Safety left, or if the market has already priced in a flawless turnaround.

I ran a strict DCF based on their most recent financial realities. Here is the breakdown of my assumptions:

1. The FCF Baseline & Growth Nike’s Unlevered Free Cash Flow has plummeted to roughly $1.04 Billion over the trailing twelve months due to inventory issues and wholesale channel decay. To be fair to the new CEO, I modeled a solid 6.0% annual FCF growth rate for the next 5 years, assuming he successfully stops the bleeding to On Running and Hoka.

2. The WACC (Discount Rate) I used a strict WACC calculation based on their actual capital structure:

  • Risk-Free Rate: 4.5%
  • Beta: 1.32
  • Debt-to-Capital: 10%
  • Calculated WACC: 10.63%

3. Terminal Value Nike is a mature behemoth in a highly saturated market. I used a Perpetual Growth Rate of 2.5% for the terminal value, matching long-term inflation.

The Math & The Verdict: Discounting my 5-year recovery cash flows ($1.04B growing at 6%) and the terminal value back to present day, I arrive at a base-case intrinsic value of $12.16 per share.

Even if I assume they magically return to their 2021 peak margins tomorrow, it is incredibly difficult to justify the current $46 price tag mathematically without assuming an unrealistic perpetual growth rate.

Am I being way too punitive with my 10.63% discount rate, or is NKE a massive value trap right now? Would love to hear where the bulls think my math is wrong.

u/Aulipe — 17 hours ago

DCF -> LBO case study

Expecting to have a modeling case study as the next part of my interview as a lateral senior analyst. I’m assuming roughly a 2 hour case study with DCF modeling into an LBO. For reference I’m pivoting from big 4 FDD to IB, and do not have real deal modeling experience, only have worked through all of WSP. When modeling LBO scenarios, what is most common practice as a scenario selection metric? What I have been practicing modeling is having 2 approaches to choose from (1 using office price per share using Perpetuity growth model from DCF , and 1 using exit ebitda multiple). The WSP course is quite dated however so wanted to hear if there are more common ways in practice to model different scenarios. (Aside from things like PIK toggle, sensitivity tables etc)

reddit.com
u/Splashyeth — 9 hours ago

Is the Wall Street Prep Student Passport lifetime access?

​

Hey everyone,

I recently got access to the Wall Street Prep Student Passport through my college, and I’m a bit confused about how long it actually lasts.

Is this something we get lifetime access to, or is it only valid during our time as students / for a limited subscription period?

Also, if anyone here has used it:

- Does access get revoked after graduation?

- Is there any way to retain access long-term?

Would really appreciate insights from anyone who’s already gone through this.

Thanks!

reddit.com
u/OperationFull8065 — 23 hours ago

Does the FMVA help CS students?

Cs major planning on taking the FMVA as I heard it helps take you from zero to hero on Excel. Could learn some data analysis tools while also opening up opportunities for finance-related roles. Is that viable ?

reddit.com
u/vfhgvh — 4 days ago

Renewable Portfolio Cashflow Model

I’ve been trying to build a PV, BESS model that allows for analysis and compare between designs and within design phases. Mostly just need cashflow. I’m struggling to find some examples online or an excel doc. I can leverage and adapt to my needs. I’d appreciate any guidance anyone has. Bonus points is a gas generator and SMR project finance model. I’m hoping to be able to model a complete micro grid.

reddit.com
u/KPmac2306 — 4 days ago

Your best use of Ai

Hi everyone

Financial analyst here. I have been using Ai for 7 months now for my work and I don’t think I am using it for its full potential.

If you have any prompts or any tricks you use that could make our work better please tell.

reddit.com
u/Mysterious-Range1187 — 6 days ago

Real Estate Developer Model

Hi! Does anyone have experience working on a financial model for a real estate developer (residential and commercial) company such as this? I am facing some trouble working on the revenue model and could use some help. Thanks!

u/Common_Ad_6025 — 9 days ago

Operating Business DCF for a Real Estate Developer — Where Do I Start?

Task: 
Building an Operating Business DCF for a Real Estate Development and Holding Company

Background:
I have been tasked with valuing a large real estate development and holding group on an operating business basis. We initially completed a NAV across all entities the group owns, but my manager said we need to value the group. The group owns a variety of assets listed below: 

  • Income Producing Properties 
  • Hotels  
  • Land Held for Development 
  • Unsold Units 
  • Development Projects - we have the completed development costs, cost to complete, and debt outstanding for each project

The group is made up of approximately 50 corporations, each holding different properties and asset types. There are no consolidated financial statements across the group.

Questions:

  1. Is the correct approach to build a DCF by aggregating revenue and expenses across all entities and projecting forward as a single consolidated business? Is this the only way to do it properly, or are there alternative approaches?
  2. For assets that generate no current income, such as land held for development and development projects, how do you handle these in an operating business DCF? Do you project the future development cash flows and discount them back, or are these valued separately outside the DCF?

I am relatively new to real estate valuation and would really appreciate any input or guidance from those who have done this before. Happy to provide more detail if helpful.

reddit.com
u/Suspicious-Win-4667 — 9 days ago

As-presented vs Standardized Figures for 3-Statement/DCF Model

Hey guys! I'm new to this, and I'm wondering if best practice for financial statement modeling would be to use the as-presented data from a 10K, or the standardized/normalized results from services like CapIQ, LSEG, or Factset.

I completed WSP's course which draws exclusively from the 10K and makes no mention of these discrepancies.

Now, I'm working on a 3 statement model for KO, but the reclassifications on CapIQ are difficult to reverse-engineer to reconcile them to the 10K. And while it's more comprehensive, I'm ultimately getting bogged down by the granularity of the standardized results.

Consensus estimates on CapIQ are also standardized, so it feels like I have to get this sorted out to be able to match consensus estimates.

I'm a student and have access to these data providers through school, which is both very helpful and very overwhelming. Would appreciate any input!!

reddit.com
u/bibbrecords — 11 days ago

Nike Revenue Build

I spent hours trying to determine the key drivers for each geographical segment but can't do a bottom up approach not enough data, I never did a top down before any advice on how to have a realistic revenue drivers?

reddit.com
u/Neither_Contract3074 — 10 days ago