sensitivity analysis using VBA

Hi Wingfield,

Welcome to the forum

You're example isn't clear to me as the sensitivity shows just 4 columns and are we to assume that the dates will just be the first of each successive year and, I don't understand how your results are arrived at

xladept,

hello.

>> You're example isn't clear to me as the sensitivity shows just 4 columns and are we to assume that the dates will just be the first of each successive year and, I don't understand how your results are arrived at
yeah, it occurs to me that my description doesn't match the spreadsheet. that said, I only have 4 columns in the example rather than 10; but the intent is still the same. the difference in the ss is that I only made 2 results.

>> I don't understand how your results are arrived at
on the two result tabs, I show how the results are arrived at. they're not real meaningful in terms of example. I mainly provide the ss to show what I was trying to do.

so for example, if you put in the actual input location on the "inputs tab" the date 1/1/2011 as input 1, then put in 5% as input 2 - you will then see on the results1 tab 1266. I've also manually put 1266 in the sensitivity tab. same process for the next inputs I want to sensitize on.

>> are we to assume that the dates will just be the first of each successive year
the dates are whatever is in the sensitivity tab.

make sense?? :>)