As I am starting to build my investment portfolio (mainly focusing on turnkey type investments) I was wondering what template other people use to calculate their estimated returns i.e. what template do you use to create your own pro forma?
@Chris A. I Think a lot of these responses will vary based upon the area. I've got a standard that I created for homes in my area that I would love to share.
@Kenneth Mooney Just sent a PM! I use a standard template that allows me to change variables such as tax, insurance, vacancy, maintenance, PM, price of house, down payment, etc. and basically it will calculate my pay down on the loan, cash on cash returns each month, total money out of pocket at close of deal, IRR, and annual gross and net cashflow. Would be great to compare with others!
Hi is it possible to share the pro forma template with me?
@Chris A. Can you send this to me as well please?￼
@Chris A. would you mind sharing with me as well? Thanks in advance!
For simple investments the BP calculators are good.
Would you be able to share the template with me please?
There are a lot of good ones out there. I'm about 40 hours into building my own detailed spreadsheet. It depends how complex of analysis you want to do. The more detailed the better, in my opinion.
Are any of you using good pro formas that also include construction+land acquisition and related loans? I'm working to develop a new small coliving rental project. I have used the BP calculator and want something more flexible.
@Jeffrey Tufenkian The one I am building is geared more towards multifamily syndication. But if you want a copy once its completed, shoot me your email and I can send it over.
I don't think there is a specific XLS, but you need to think in terms of where NOI is at today and what you need to do to grow it.
That includes understanding rehab/repairs, increasing rent and reducing expenses.