Made my first DCF on Wal Mart. Please rip it apart
If someone could explain why my sensitivity table on the last page isn't correct and how to fix it, that'd be great.
Attachment | Size |
---|---|
dcf_wal-mart_oasis.xls 82.5 KB | 82.5 KB |
If someone could explain why my sensitivity table on the last page isn't correct and how to fix it, that'd be great.
Attachment | Size |
---|---|
dcf_wal-mart_oasis.xls 82.5 KB | 82.5 KB |
+81 | Q&A - Buyside Equity Research Analyst/PM | 29 | 1w | |
+32 | How the heck do you learn all of this stuff? | 10 | 2d | |
+28 | My experience on the sell side | 20 | 2w | |
+24 | Clues in Financial Reporting Analysis | 7 | 3d | |
+17 | Am i fairly compensated? | 9 | 4d | |
+14 | Data Science to PM | 8 | 1w | |
+14 | Heard they don’t model at Oppenheimer | 10 | 2w | |
+12 | ER - Remote Jobs? | 8 | 1w | |
Equity Research at Bank vs IG, High Yield & Leveraged Loans Research at Asset Manager | 4 | 2d | ||
+11 | Who uses sell-side Strategists? Are they valuable? | 4 | 1w |
Career Resources
I haven't looked at your model yet, but I'm gonna make some guesses as to why your sensitivity table isn't working.
1) When choosing the values for Row and Column input, make sure the values are on the SAME PAGE as the table.
2) Make sure you're manually typing in the value intervals (i.e., Manually type in 9% for WACC, then 9.5%, 10%, etc...MANUALLY)
Yes they are!
I just made an edit for a second suggestion. Also, if it's not set to auto-refresh, hit F9 to refresh the table.
Nemo dolor nisi rerum earum velit sint sed omnis. Et adipisci rem aut cumque magni fugit voluptates. Ut saepe in asperiores.
Commodi ab quis nihil. Sit maiores itaque ad beatae aut voluptatem temporibus.
Temporibus omnis id fugit. Recusandae consequatur totam fugiat et. Eos accusantium voluptates corporis quis quasi qui. Aliquam qui ut voluptatem vel voluptas similique. Consequatur sunt esse voluptatum optio quaerat sunt accusantium. Blanditiis iusto quas fugiat quod.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...