Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to change values to formula in VBA to carry out goal seek?
I have written VBA to project cashflows at year end for the next 10 years.
The complete formula is: Cashflow at year end (t) = (cashflow at year start(t-1) + money coming in at year start * (1- discount rate(t)))*(1+ interest rate) I have breaken down to the following columns: Cashflow at year start, Money in at year start, Discounted money in, Interest, and Cashflow at year end. Now I set my expected Cashflow at year end, how to change my VBA code to carry out GoalSeek in order to find how much money should come in each year given other info unchanged? Many many thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal seek formula | Excel Discussion (Misc queries) | |||
Goal Seek Algebra Formula | Excel Worksheet Functions | |||
Goal Seek | Excel Discussion (Misc queries) | |||
How can I put Goal Seek into a cell formula? | Excel Worksheet Functions | |||
Null values in charts and how to override the goal seek functionality | Charts and Charting in Excel |