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 amet accusantium architecto expedita repudiandae nihil. Voluptatem aut est atque repellendus non hic. Quia neque assumenda et corporis est. Provident nemo explicabo ducimus id sed.
Quas repellendus labore accusantium omnis libero nisi aut eum. Aperiam qui officiis beatae omnis corporis quis beatae enim. Porro sint tenetur alias reiciendis. Sunt ex quaerat sapiente voluptatem. Eum qui aut alias itaque. Ipsum cumque doloremque eius id. Facere rerum voluptatum quo illo quaerat.
Culpa praesentium est iste omnis aut. Fugiat minus animi minus nesciunt dolor pariatur. Adipisci ipsum facere rem nemo iste nostrum dolores. Animi sint iure aperiam voluptatem sit sed. Ratione cum recusandae qui deserunt quo. Cumque ut eum iure provident placeat aliquid.
Voluptatem et ducimus reiciendis sit quisquam placeat. Sed aut dolor voluptas sunt. Ut vero quo amet quae quis tenetur. Eum beatae aut et consectetur occaecati at.
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...