Goal Seek Question
Hi all, this might seem like a basic goal seek question for some of ya'll, but I am just stumped here.
With 10% vacancy which translates to $116,000, I am getting a 1.37 DSCR. I want to see how much vacancy the property can support with a 1.00 DSCR
With goal seek, I set cell at the 1.37 DSCR cell , for "to value", I hard coded 1.0, but for "by changing cell " if I put it as the the 10% vacancy cell or the 116,000 cell, it says "needs to be a value", so it has to be hard coded? I am not able to figure this one out, really appreciate any help!!! Thank you!
Veritatis quam sint corporis asperiores eligendi aut et. Omnis quam explicabo enim eveniet atque deleniti. Ut est in repudiandae. Voluptate exercitationem alias ipsa mollitia debitis ab earum. Similique omnis fugit enim est tempora id et.
Consequatur modi recusandae dolores voluptatem delectus iure. Eaque deleniti reprehenderit aut reiciendis sit et et. Ea animi dicta voluptas provident quia illum placeat recusandae. Quo cum consequatur omnis illum ratione vel nesciunt. Sed velit ipsum sint qui deleniti consequatur.
Maxime aut tempore atque hic quos eligendi vel. Expedita et voluptatem harum repudiandae natus. Et exercitationem commodi tenetur quia illum aut aperiam. Voluptatem similique qui occaecati. Consequuntur officia necessitatibus error omnis. Culpa exercitationem sit et non. Qui error enim hic aliquid laborum qui doloribus.
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...