Thanks for posting. I get very different results for each run, which is not surprising with Monte Carlo. Could you add a standard error for the value differential of the two types of mortgages? It would just be sd(value)/sqrt(#samples).
Yeah, only 100 samples right now since the monte carlo depends on RAND() and that's very expensive for google sheets. I'll add the differential. Thanks for taking a look.