I need to find out the NPV of a given set of criteria and then perform a loop to determine if the benefits come in at 15% less, 10% less 5% less 5% greater, 10% greater, 15% greater.
Any help with loops for a beginner? Thanks!
I need to find out the NPV of a given set of criteria and then perform a loop to determine if the benefits come in at 15% less, 10% less 5% less 5% greater, 10% greater, 15% greater.
Any help with loops for a beginner? Thanks!
Could you provide more details. What inputs for calculating NPV? How do you want results displayed, etc. would all help.
Absolutely! Thanks for your help. I've attached a spreadsheet that hopefully explains.
You don't really need to use VBA to accomplish this task. You can just multiply the cash flows at each level and copy the formula. See attached. Let me know if that's not what you were looking for.
You're right...this is simpler and I like it .
Follow-up question. Can you do the same with the inputs that make up the cash flows. For example: sales are one reason for the cash flow. Can I do a sensitivity analysis on if sales goes down 15,10, 5% etc... and see what the NPV impact is?
Where do sales feed into the cash flow? I don't see anything on the sheet that has that.
You're correct, there's not a space for inputs...I was just asking a hypothetical question. For example, I have two benefit variables (sales and cost savings). Is there a way to show the same -15%, 10% etc.. for each benefit? So the question would be what would the total NPV be if sales goes down by 15% but cost savings increases by 10%?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks