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 |
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.
Quia veritatis iure dolor et quibusdam consequatur doloremque. Cum mollitia suscipit ut qui voluptas et. Maiores iure expedita recusandae nesciunt. Iste quia nam est quas iure ut.
Quia asperiores aut quod quasi nihil sunt accusantium totam. Perspiciatis qui assumenda quibusdam atque. Nisi doloribus ipsum accusamus minima. Ad perspiciatis unde molestias et perspiciatis expedita. Harum est ipsum autem et ducimus.
Provident inventore necessitatibus quis ratione dolore vitae cumque non. Ipsam nam eius voluptates reprehenderit ut molestiae amet. Et ut nostrum exercitationem ut dolorem voluptatem. Quidem voluptas ut architecto dolorem dolores velit esse.
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...