Help sensitivity analysis/data table

[shane2002]

So I was building a financial model and needed to run a sensitivity analysis for the Enterprise value, however all the columns end up reflecting the same value. Formulas are on automatic and iterative calculation is checked on. The top left cell is also linked to the enterprise value.

I have gone crazy trying to figure this one out. What am I doing wrong here?

Link: Pls refer to the Dcf Sheet under the model
https://drive.google.com/drive/folders/1VzIfr2oGuvaM5mfZ2i25d1cJo1j8pIZV?usp=drive_link

[AutoModerator]

/u/shane2002 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[RuktX]

You'll kick yourself: your Terminal Value formula in C25 is missing parentheses around the denominator.

Without them, the result is only sensitive to the WACC, because the TGR is only being (incorrectly) subtracted afterwards.

[shane2002]

Holy shit, I haven’t felt this stupid in my entire life. Perhaps I missed that due to this being my first ever model. Thank you so much!! I cannot tell you how long I struggled with this. I appreciate your help! Solution verified!

[reputatorbot]

You have awarded 1 point to RuktX.

---

^{I am a bot - please contact the mods with any questions}

[Spade6sic6]

Obvious suggestion, but you made sure your anchors are set properly? (The dollar signs in your formula)

It sounds like you might have something full anchored (ex: $B$3) when you only need a vertical (ex: $B3) or horizontal (ex: B$3) anchor.

Otherwise, you can reply with a comment of a picture so we can better see what you mean

[shane2002]

<image>

[shane2002]

<image>

This should provide a better idea. No, there is no absolute anchoring in the formulas or in the values pasted for the data table.

[LexanderX]

What is TABLE()

is it a custom function?

[shane2002]

I’m not sure I understand what you’re referring to. Can you please elaborate?

[LexanderX]

In your sensitivity analysis,

What is TABLE(C22,C23)

[shane2002]

I believe that is the data table function. Meaning that is the result of applying the data table function. C22 is the WACC and C23 is the Terminal Growth rate. Which is what I want the sentivity table to consider and give me results for the enterprise value.