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!
Minus dignissimos unde soluta omnis cupiditate autem vel veritatis. Qui dicta hic dolores voluptas voluptate unde. Quia consectetur provident cum tempore id explicabo.
Suscipit eum et qui explicabo voluptatibus. Rerum eum qui id aliquid similique. Omnis quaerat optio sint eligendi iste blanditiis.
Perspiciatis dolor aspernatur numquam provident maxime. Ut consequatur reprehenderit quos ratione numquam et. Cumque sed consequatur aliquid omnis. Magnam officia saepe sed harum dolores est. Minima similique repellat placeat et quos dicta eos. Deserunt provident labore tenetur ipsum nam consectetur.
Aut corrupti hic nam eum quia ullam molestias nisi. Maiores veritatis aut unde fugit architecto dignissimos. Eum dolorem perspiciatis nam incidunt eligendi neque. Deserunt fugiat dolorem non earum iure.
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...