I am trying to use Data==>Solver to find out what price we should pay for a property.
We want to achieve a net rental return of 7% (after mortgage interest) on the net capital employed.
The interest rate and size of loan (as a percentage of purchase price) are variables which may change.
We need to calculate what price to offer for the property under several scenarios in order to achieve our expected return.
Solver can't solve it. I can't figure out why. Am I doing something wrong? (See pictures below)
Is there a formula I can use instead.
Spreadsheet is attached.
Bookmarks