Solving for Purchase price given IRR

Apologies in advance if I'm not supposed to share outside links. Are you trying to calculate a going-in residual land value? If not, I think I know what you're trying to do and this link might help, with using a simple solver function

No I’m trying to calculate the value drop of buildings based on increased interest rates really.

For this exercise, I want to show what purchase price we would want for x IRR

=NPV(Desired IRR, cash flow stream)

Goal seek would work but NPV might be more automated if that's what you were looking for. Just link the rate in the NPV formula to your IRR cell.

OP here - thank you all for the responses, I really appreciate it. I guess the thing I am grappling with is the equity inflow & outflow. This really isn't possible is it since I'm looking for a negative outflow of X which is also the purchase price.

This should be pretty simple. The IRR is the same thing as the discount rate.

If the investment is unlevered (no debt), then you would discount all of the projected cash flows to time zero using your IRR input and sum them together, which would give you a present value. If you want this number to appear negative, you would simply add a hyphen in front of the sum formula “-sum()”. Note that you would then need to add back acquisition closing costs to get to your purchase price. Unlevered discount rates (unlevered IRRs) are the customary method of valuing any asset.

If the investment is levered (includes debt) and you want to use a levered IRR input (not recommended), then you need to discount the net cash flow to equity after debt service and sum the cash flows. This will give you equity value, so you would need to add back the loan proceeds, loan closing costs, and acquisition closing costs to get to the purchase price.

Read Investopedia’s article titles “How to Calculate a Discount Rate in Excel” if this is not making sense to you, or Google how to discount cash flows. You can use the NPV formula from Excel, but I think it’s cleaner/better to use real math:

Present Value = Future Value / ((1 + discount rate)^(year))

Not to be rude or anything but isn't this literally the first thing you learn in finance?

I have a macro that uses goal seek to adjust Px to a YoC. IRR would be the same. Here's the code that I assigned to a button (with named ranges):

------------------

Sub GoalSeek()

Dim intSeek As Integer

Range("YieldOnCost").GoalSeek Goal:=Range("SeekTarget"), changingCell:=Range("PurchasePrice")

MsgBox ("Purchase Price updated successfully")

End Sub

------------------

YieldOnCost = the result cell with your formula for YoC (can be IRR)

SeekTarget = an input cell with what I want to goal seek YoC to

PurchasePrice = the input that I'm changing

Might not be the approach you are looking for, but it worked well for me. Feel free to reach out if you have any questions about it. 

You XNPV the cash flows and you back into the equity check. This plus debt raised equals total sources. Sources equal uses. Total Uses less fees and min cash equals purchase price (EV).