Trending Content - Real Estate Forum
Career Resources
WSO Free Modeling Series - Now Open Through
October 31, 2026
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
High Finance Applications
Guaranteed
Get at least one offer GUARANTEED
- 1:1 support
- 92% success rate
- 2,000+ mentor network
- Unlimited Live bootcamps
- AI for resume + LinkedIn
- Networking automation tools
- HireVue simulation tool
- Full course library
- Private Slack community
- 20hrs of mocks
- + much more...
I'm not an acquisitions guys but I'm going to go out on a limb and say the following:
0 = (purchase price) + CF1/(1+.12)^1 + CF2/(1+.12)^2 + etc.
--> You have the top line so you need to figure your expenses to solve for CFs: know lease type (N, NN, NNN) and then make assumptions for expenses based on industry/local market knowledge. Deduct capex from NOI to get to CFs. --->Insert into equation above and solve for purchase price.
Anyone can correct me if need be.
This is correct. Use Rent Roll, CapEx, and Expense Assumptions to project cash flow for the 5 year holding period. Use =NPV() function in excel to back into "what you would be willing to pay" for the investment.
A newbie question. I was under the impression that the NPV is the summation of cash flows with the deduction of purchase price. It is the profit from a venture, isnt it?If the NPV from a series of cash flows and purchase price with an assumption of a particular discount rate is 15K for example, I thought you can assume that you will be able to make a profit of 15K after paying all debt obligations. Am I wrong? When I read your comment, I thought you meant NPV is what you would be willing to pay.
NPV finds what a series of future cash flows are worth today. It takes into account required rate of return. Think of it this way... What is the maximum amount of cash I'm willing to outlay upfront if I require a 12% return and I believe the project will cash flow at x amount annually? The Net Present Value is the answer to this question.
You make future cash flow growth assumptions and then work your way back. If you payout more than the PV of future cash flows then you wont realize your required rate of return.
can you do this with waterfall splits. Say a sponsor not deal level return, or not a lp investor wants a 12% irr return. same thing? will goal seek work here.
I
backing out purchase price (Originally Posted: 04/19/2010)
Hi all,
I am trying to back-out the purchase price of a public company acquiring a private company. This is all the publically available info I have:
$38.5M equity raise Costs associated with acq. ~$25M Acq. resulting in $150M addition in goodwill and $30M in other intangible assets $500M in net cash paid on CFI (but there are many other small acquisitions)
I ballparked around $250-$400M. However, if I wanted to be more precise, what other info would be useful that can be found on a 10-k?
Thanks a bunch in advance for your comments!
-
If its a public company making a $200-400 million acquisition, its HIGHLY unlikely that the purchase price is undisclosed. Actually, its virtually impossible.
You're probably not looking hard enough.
Id illo dicta assumenda aspernatur libero. Ex enim quaerat nobis ut maiores voluptas et. Exercitationem quos aut praesentium molestiae. Consequuntur maxime quam beatae veniam libero.
Qui aut autem ipsam deleniti ad dolorem. Et vel dolores reiciendis voluptas veniam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...