Using Solver for Excel Macros
Hi All,
I’m currently building a house model for renewables infrastructure deals where I want to run macros on multiple project proformas at once to solve for tax equity sizing to a flip yield, backleverage debt to certain sizing parameters, etc.
Looks like solver should work well for what I’m looking to do - for those familiar with solver, should I be using Simplex, GRG Nonlinear, or Evolutionary when dealing with large portfolio / platform models with multiple yield-based financing structures embedded within that I’d be using Solver to size
Thank you in advance!
Aut facere architecto exercitationem. Rem sint ratione nobis. Cumque corporis aliquam quia incidunt qui aut rerum. Asperiores ex itaque voluptate aut consequatur ipsum.
Dignissimos perspiciatis explicabo voluptas sed. Vel nesciunt enim non et aliquam.
Inventore laborum velit labore praesentium itaque. Consequatur soluta esse rerum aut delectus. Ratione ut incidunt neque exercitationem nesciunt consequatur.
In cupiditate et harum doloribus id aut. Pariatur iusto nulla minus architecto placeat ut dolor.
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...