I am a realtor and I am trying to create an excel sheet for comparing multiple offer scenarios.
Here are the offers
Offer 1
$200,000
Maximum offer of $225,000
Escalation intervals of $500
Offer 2
$205,000
Maximum offer of $210,000
Escalation intervals of $100
buyer asking for $4500.00 in closing cost
Basically the offer of this is now $200,500
Offer 3
$200,000
Maximum offer of $211,000
Escalation intervals of $1,000
Basically I am looking for a formula that can show escalated offers in a cell for easy comparison as to which one is the winner. So if we did it manually we would know that offer 1 would win because they can go up to $225,000 but the final price would only be $211,500 because of the $500 escalation interval of offer 1 and only needing to exceed offer 3's maximum offer by $500.
Hopefully this is possible with a formula as it would really take all the work out of manually piecing it together. I have attached a screen shot of my spreadsheet for reference. The green line is where I want the formula to automatically show the offer with escalations in play. The offers do not need to exceed the maximum offer in all cases.
Here are the offers
Offer 1
$200,000
Maximum offer of $225,000
Escalation intervals of $500
Offer 2
$205,000
Maximum offer of $210,000
Escalation intervals of $100
buyer asking for $4500.00 in closing cost
Basically the offer of this is now $200,500
Offer 3
$200,000
Maximum offer of $211,000
Escalation intervals of $1,000
Basically I am looking for a formula that can show escalated offers in a cell for easy comparison as to which one is the winner. So if we did it manually we would know that offer 1 would win because they can go up to $225,000 but the final price would only be $211,500 because of the $500 escalation interval of offer 1 and only needing to exceed offer 3's maximum offer by $500.
Hopefully this is possible with a formula as it would really take all the work out of manually piecing it together. I have attached a screen shot of my spreadsheet for reference. The green line is where I want the formula to automatically show the offer with escalations in play. The offers do not need to exceed the maximum offer in all cases.