@Darnell Simon
Thank you so much! I appreciate it.
You are correct, if there's no change in NOI for Year 1. (NOI = net operating income aka profit)
You'll notice in your calculations that there was a "trick." If you only look at purchase price and exclude any other expenses (cap ex, closing, etc) and you're not increasing revenue or NOI in Year 1, then your cap rate and Cash on Cash will be the same.
The cash on cash fluctuates from the cap rate in Year 1 due to added expenditures on top of purchase price (Cap ex, closing costs, etc) and changes in NOI for Year 1. Without those, the math calculation is the same.
Take a look at the attached jpg:
The IRR is a simple formula in Excel.
Start with a negative number (negative cash outflows)
Then combine all the cashflows that come in.
Apply the IRR formula.
Now that you have the IRR you can start to assess lots of things:
1) How does this compare to other investments?
2) Does the pricing seem right?
3) Will this satisfy investors?
When you're doing this for real, of course, you'll have to add in many other factors:
* Cap Ex, Due Diligence, Closing Costs, etc
* Financing if any is available
* This gives you the projected deal-level IRR - which is great if all the capital is yours or if everyone involved is getting a proportionate share of the deal based on their investment. But if you're working with silent partners in a syndication, then the cashflows will be further divided between what you get for your work and what the investors get.
It took me a while to grasp the IRR calculation.
If you want to dive a little deeper check out:
"Time Value of Money"
"Present Value"
"Future Value"
And the book that helped me understand the basics of real estate investing finance: What every real estate investor should know about cashflow and 36 other key financial measures
Let me know if it helps!