Excel VBA Investment Forecast Model
Budget: $50 – $0 USD
We have an existing Excel Tool (programmed in VBA) that lets us perform long-term investment analysis. The core function is to forecast both asset values and related income / expense streams for horizons longer than five years.
We currently have several streams built out but we need a good VBA programmer who understand some amount of finance (Assets/Liabilities, Income/Expenses, etc) to build out additional functionality
The model should:
• Offer a clean input section where I can enter assumptions—growth rates, cash-flow timing, discount factors, tax parameters, and one-off events—without touching any formulas.
• Run a VBA-driven calculation engine that pushes those inputs through the sheets, producing a yearly projection of market value, dividends, interest, capital gains, and expenses.
• Present results in easy-to-read summary tables and charts (NPV, IRR, payback, cumulative cash flow, and sensitivity toggles).
Please code with clear comments, keep worksheets logically organized, and include a short user guide inside the file so I can tweak assumptions or expand the logic later. Once finished, I should be able to open the workbook, change a few numbers, press a single “Run Forecast” button, and instantly view updated long-term projections.
We currently have several streams built out but we need a good VBA programmer who understand some amount of finance (Assets/Liabilities, Income/Expenses, etc) to build out additional functionality
The model should:
• Offer a clean input section where I can enter assumptions—growth rates, cash-flow timing, discount factors, tax parameters, and one-off events—without touching any formulas.
• Run a VBA-driven calculation engine that pushes those inputs through the sheets, producing a yearly projection of market value, dividends, interest, capital gains, and expenses.
• Present results in easy-to-read summary tables and charts (NPV, IRR, payback, cumulative cash flow, and sensitivity toggles).
Please code with clear comments, keep worksheets logically organized, and include a short user guide inside the file so I can tweak assumptions or expand the logic later. Once finished, I should be able to open the workbook, change a few numbers, press a single “Run Forecast” button, and instantly view updated long-term projections.