Results 1 to 5 of 5

Free Cash Flow and Present Value of Future Cash Flow Questions

Threaded View

  1. #1
    Registered User
    Join Date
    02-28-2015
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    52

    Free Cash Flow and Present Value of Future Cash Flow Questions

    Hello. I have another question on my readings from the Dhandho Investor by Pabrai. He analyzed Bed Bath and Beyond's stock. My only question is how he got the number 523 for Free Cash Flow

    Information (For 2005)
    Quoted Stock Price = $36 per share
    Market Cap = $10,700,000,000

    Capital Expenditures = $191,000,000
    Depreciation = $99,000,000
    Net Free Cash Flow = $413,000,000

    Revenue Growth = 15% to 20%
    Net Income Growth= 25% to 30%

    Growth for Free Cash Flow = 30% for first 3 years, then 15% a year for three years, 10% a year thereafter

    Excess Cash = $850,000,000
    ---------------------------------

    Please see the excel doc for the chart



    Best regards,

    James
    Attached Files Attached Files
    Last edited by jim0000; 07-23-2017 at 09:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Present Value of Discounted Cash Flow Question
    By jim0000 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-23-2017, 04:12 PM
  2. Present Value of Discounted Cash Flow Question
    By jim0000 in forum Excel General
    Replies: 1
    Last Post: 07-23-2017, 01:17 AM
  3. Present Value fo Cash Flow Calculation Macro
    By forexcellence13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2013, 08:40 PM
  4. Cash Flow Present Value Calculation
    By forexcellence13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2013, 06:43 AM
  5. Replies: 0
    Last Post: 06-28-2011, 08:17 AM
  6. [SOLVED] Cash Flow
    By matthewmcgirr@earthlink.net in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2005, 02:05 PM
  7. [SOLVED] Cash Flow Set-Up
    By Gary T in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-13-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1