Hi,
I am wanting to perform a goal seek on multiple cells, and want to automate the processing of this goal seek via VBA.
My sheet looks like the below.
I want to understand the minimum offer rate for a series of discounted cashflows on 2,000 rows of data (the Offer Price column has the following formula.
=NPV("Offer_Rate"/12,AL5:DZ5 ("SERIES OF CASHFLOWS")
So, i need to Goal Seek to find the Offer Rate for each series of cashflows, such that the above formula returns a break-even (i.e. the P&L) column is zero.
Is there some VBA code i could use rather having to manually goal seek each row.
Thansk
Dave
I am wanting to perform a goal seek on multiple cells, and want to automate the processing of this goal seek via VBA.
My sheet looks like the below.
Offer Rate | Offer Price | P & L | Contract Cashflows >>>> SUM OF MAR 21 ONWARDS | Mar-21 | Apr-21 | May-21 | Jun-21 | Jul-21 | Aug-21 | Sep-21 | |
3.45% | £10,789.48 | £0.00 | £11,337.40 | £324.22 | £324.22 | £324.22 | £324.22 | £324.22 | £324.22 | £324.22 |
I want to understand the minimum offer rate for a series of discounted cashflows on 2,000 rows of data (the Offer Price column has the following formula.
=NPV("Offer_Rate"/12,AL5:DZ5 ("SERIES OF CASHFLOWS")
So, i need to Goal Seek to find the Offer Rate for each series of cashflows, such that the above formula returns a break-even (i.e. the P&L) column is zero.
Is there some VBA code i could use rather having to manually goal seek each row.
Thansk
Dave