There's a pretty common theme in this subforum with people asking whether option A, B, or C is the best way to put their money to work. There would be a lot of qualitative and quantitative factors that would go into formulating the best answer for each poster's question, but Excel seems like it would be pretty helpful on the quantitative side.
Is anyone using custom workbooks to answer this question for their own situations? I'm thinking about trying to put together one for mine, though the number of variables seems like it would make accurate estimates quite difficult to arrive by based on things like when PMI drops off mortgage notes, variable interest rates, etc.
An example might be looking at the value of $1 on a timeline at intervals using a set of inputs like a mortgage note, credit card balances, investments with an estimated rate, etc. The goal would be putting in variables for each option on where you could spend $1 PV and seeing what the FV would be out at 1, 5, 10, and 30 years, I guess.
