a discounted cash flow analysis where the output is the sum of the present value of projected cash flows for several years going forward and the cash flow for each year is based on several assumptions, it is quite time consuming and almost undoable to write all of the calculations in VBA. Unfortunately, for “complex” calculations (read: multiple calculations ultimately leading to one output), e.g. Whenever I work with simulation in VBA/Excel, I always try to do all of the calculations in VBA and only get input/display output in Excel – in order to increase the speed of the simulations as much as possible. However, I am struggling to find a way to write an efficient code for more complex calculations. I have been able to write a rather efficient code which works well in simple cases where the entire calculation/formula is written in one cell (with inputs from other cells). I am trying to create a «general/standardized» macro for Monte Carlo simulation in VBA/Excel.
0 Comments
Leave a Reply. |