+ Reply to Thread
Results 1 to 3 of 3

Discounted Cash Flow "What if" analysis (Showing incorrect values)

  1. #1
    Registered User
    Join Date
    08-25-2023
    Location
    India
    MS-Off Ver
    2019
    Posts
    2

    Discounted Cash Flow "What if" analysis (Showing incorrect values)

    i was doing a virtual internship where i needed to produce a dcf model. The value presented in the sheet are correct and producing the desirable result but i cant produce a correct what if analysis model. can someone point the error and help me correct it.
    Attached Files Attached Files
    Last edited by 6StringJazzer; 08-25-2023 at 10:00 AM. Reason: better titles please

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Discounted Cash Flow "What if" analysis (Showing incorrect values)

    What part of this worksheet is the "what if analysis model"? What indicates that there is an error?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    08-25-2023
    Location
    India
    MS-Off Ver
    2019
    Posts
    2
    Quote Originally Posted by 6StringJazzer View Post
    What part of this worksheet is the "what if analysis model"? What indicates that there is an error?
    The last part where there are two tables.

    The correct values are portrayed in the right most end of the table.
    But it should be displayed in 8.5 percent and 12x.

    Don't know what's going wrong.
    Last edited by RohitRaj1990; 08-25-2023 at 10:22 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Match function Issue - Showing incorrect value
    By cjr88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2023, 03:03 PM
  2. [SOLVED] if formula showing as incorrect when it is correct
    By rich1407 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-22-2021, 11:48 AM
  3. Gap Analysis / Incorrect results.
    By Ceetrix in forum Excel General
    Replies: 3
    Last Post: 08-06-2019, 10:24 AM
  4. Basic Formula showing incorrect result
    By jane1613 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-01-2014, 06:50 PM
  5. Showing Incorrect Recent Files
    By mikejody in forum Excel General
    Replies: 4
    Last Post: 02-27-2014, 12:06 AM
  6. Incorrect calculatons in data analysis
    By k4katherine in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-12-2013, 04:11 AM
  7. incorrect total showing up in cell
    By ibabs in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-30-2013, 06:31 PM

Tags for this Thread

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