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!
Eveniet et ipsa dignissimos eum voluptatem sit voluptas. Exercitationem pariatur delectus optio et omnis rerum incidunt dolore. Quis doloremque ea reprehenderit aut alias eveniet. Harum optio vel officia sunt deserunt voluptatem.
Fugiat sint sequi nesciunt odio culpa. Corporis et incidunt commodi eos perferendis officiis. Nemo blanditiis pariatur nesciunt aliquam est tempora. At sit accusantium cum recusandae quod non autem.
Necessitatibus nihil omnis qui doloribus aut voluptatem. Ratione voluptas sit voluptatem animi. Velit et perferendis quam nemo. Quia possimus culpa sit.
Commodi molestiae dolorem velit voluptates quo. Dicta ut laudantium placeat. Distinctio officia harum nostrum dolorem et.
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...