Recent content by henry_b

it is another variable in the model. Using the current interest rate as the variable in this equation (periods and amounts are not constant in the NPV calc), the result should solve for the future interest rate if the breakeven is equal to zero. I will try the Goal Seek function. Thanks for...

I am comparing 2 net present values at 2 different interest rates. I am trying to find out at using today's interest rate, what the future interest rate will be that will result in a break even of zero. not sure if solver is the right tool or if this is compound problem? Any assistance would...