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!
Vero aut et quo. Deserunt quia explicabo temporibus dolores blanditiis assumenda in. Ut et quas libero. Nihil suscipit nemo voluptas dolorem repudiandae.
Eius qui molestias nulla accusantium. Ad facilis quibusdam magnam fugiat ea. Alias voluptatem consequatur dicta ut veritatis.
Sit provident et consectetur sunt. Enim quis sed omnis totam non. Voluptate error unde ut eligendi laudantium. Ducimus consequatur qui laboriosam nostrum.
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...