I need a more powerful pro forma template that includes both rentals and condo sales in a ground up development.
Like the title says, I need pro forma help. My templates I have are simply not versatile enough. I'm working on a land assembly with multiple owners, each one wants to do different things with their land, such as get an annuity, sell out right, buy a site condo at the end, or put their land in as equity. Combine that with partners that want to have both surface parking and underground parking, as well as rentals they hold onto and condos they build and sell. All together, I don't even know where to start to find a template that includes all of this stuff. Any ideas?
[{"id": "izjy6ev", "text": "\"Pro forma\" can mean anything in CRE. Are we talking excel grids? Narrative report templates? You really have to be specific about what exactly you want and what you want it to do.\n\nThat being said you really shouldn't be \"finding\" a pro forma. You should be creating your own and then it becomes your template for the next similar job. There are way too many variables in this business to just grab a random template out of the ether. \n\nIf you don't have the skills to do this you need to learn them or hire someone who does.", "replies": [{"id": "izl71uv", "text": "&gt; That being said you really shouldn't be \"finding\" a pro forma. You should be creating your own and then it becomes your template for the next similar job. There are way too many variables in this business to just grab a random template out of the ether.\n\nTruth.  OP needs to stick build it.  For an Excel template, that means figuring out what the math needs to be then putting it all together.  It takes time, but the real treasure is the ~~friends we made~~ skills we built along the way.", "replies": [], "depth": 2}], "depth": 1}, {"id": "izk3a6a", "text": "I can make one for you if you pay me. I've worked with this structure before.", "replies": [], "depth": 1}, {"id": "izld48d", "text": "https://mfxventures.com/\n\nThese guys are my go to for pro forna development and normalization. They are really affordable and will even work to standardize it with your LPs.", "replies": [{"id": "izo5a6t", "text": "I read their site. Apart from them doing the underwriting, a question I have is do they provide consulting and numbers for the market? And how expensive are they?", "replies": [{"id": "izp8nf6", "text": "I've used them all over the US, and I know they are doing some international work in Europe.\n\nPricing depends on the complexity of what you need, but it's usually between 75-150 an hour.\n\nJust reach out and ask for a quote. They are pretty responsive.", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "izllwyl", "text": "You should 100% be building this out for yourself. Sure, you can get someone to make one for you.. but you won\u2019t understand how every variable stresses the rest of them. If you understand your investment model well enough, and have some basic excel skills, you should be able to make a decently thorough pro forma model there.", "replies": [], "depth": 1}, {"id": "izmsost", "text": "You need a discounted cash flow with a bulk sale and absorption analysis that accounts for fee simple and leased fee income. This is going to need to be custom built.", "replies": [], "depth": 1}, {"id": "izn9q5n", "text": "[Top Shelf Models](https://www.tsmfinancialmodels.com)\n\nThese are the go-to models if you want something off the shelf.  They can customize if needed", "replies": [{"id": "izo50wc", "text": "To what scope have you used them and what was the cost if you don\u2019t mind sharing.", "replies": [{"id": "izs9ymk", "text": "$2,100 for this multifamily development model.  All of the customizations I wanted were included in the 1 hour that comes with the purchase", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "izob8tv", "text": "Try this? https://getpoindexter.com/", "replies": [], "depth": 1}, {"id": "iztmcwl", "text": "I work at a development shop and can build this onto your current model or build a new one for $$$, DM me if interested.", "replies": [], "depth": 1}]