Commercial Real Estate Model Visualized
Hey r/CommercialRealEstate community! You may be aware of some of the financial models developed by the team at Adventures in CRE. Their team recently created a wonderful commercial real-estate model that shows the returns to an LP/GP partnership for a potential hotel investment.

I've visualized their financial model from Excel into an interactive dashboard that allows you to play with assumptions and sensitize the model yourself.

Interactive Model (desktop browser only):  [https://tactyc.io/published/785/commercial-real-estate-model](https://tactyc.io/published/785/commercial-real-estate-model)

Would love to get your feedback if this is helpful!
[{"id": "g197t9y", "text": "Cool stuff.  Id focus lower value.  For 25 mil invested into a project intended to sell at 130 million i'd expect a lot more there and would anticipate someone would just hand make those graphs as needed.  I don't really understand your target audience here.", "replies": [{"id": "g19a9l6", "text": "Thanks for your feedback! You're right the IRR does seem light for what is effectively a 5x return ... really shows the impact of a 10 year holding period! If the holding period were shorter, the IRR jumps up. Is there anything else on here I could add that would make things clearer?\n\nThe target audience for this dashboard was specifically financiers or investors (i.e.LP/GP partnerships or funds ). So this dashboard isn't as focused on the operating metrics (occupancy rates, operating costs etc,). I may build one that also incorporates operating metrics as assumptions someone can flex.", "replies": [{"id": "g19b437", "text": "I think you misunderstand me.  I mean if I wanted a JP to invest 2 million into this project and I sent them this I think they'd laugh at me, I'd spend $500 to have an analyst make something that isn't so generic or make it myself.\n\nIf I were someone investing 50k to buy a 200k small property I might pay 20-30 for this.", "replies": [{"id": "g19boyl", "text": "You're right I might be misunderstanding you. I guess what you're saying is the charts I've shown here are not helpful - in that case, what would would rather show  to a GP that would be helpful? Perhaps I could make those changes.\n\nThe point of the dashboard was also to enable folks to see sensitivity analysis on the key assumptions and Monte Carlo on the model in a simple manner. The charts on the main dashboard are just level 1 and there is wealth of additional analysis on some of the other features that I intended to be helpful.", "replies": [], "depth": 4}, {"id": "g19btfe", "text": "Agree. OP DM and we can talk about selling this service.", "replies": [], "depth": 4}, {"id": "g19buy3", "text": "BTW, the underlying model is also available for download from the dashboard page if you're interested in seeing the full Excel model driving the dashboard.", "replies": [], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "g19dt7v", "text": "I agree the graphs are lame, but was surprised by the Excel model.  It's actually good and usable.", "replies": [{"id": "g19iuft", "text": "The guys at A.CRE are great and their library of models is world class.  I am a 20 year commercial real estate broker and have been doing their Accelerator for fun and to brush up on some modeling skills I am a little rusty on. Never stop learning!", "replies": [{"id": "g19lflk", "text": "Nice.  I just started looking at their website... do they offer a la carte modules or is it all or nothing?  I see the 3 membership packages they offer so I assume the latter is the case.", "replies": [{"id": "g1aa2nf", "text": "Spencer just started the accelerator earlier this year, so I believe it's just all the modules + different levels of support, or none", "replies": [], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "g19omjp", "text": "Dude amazing! They have awesome models that I have used many times and this is the icing on the cake. Would you consider building the apartment value add one out? What is your technical background?", "replies": [{"id": "g19p8os", "text": "Sure thing! I\u2019ll take a look at doing the apartment value one. I\u2019m not a real-estate guy but in fact an ex-M&amp;A investment banker who has learnt how to code :) So I\u2019ve built this platform (tactyc.io) myself that allows anyone to convert their excel models into these interactive dashboards complete with sensitivity and Monte Carlo analysis.\n\nHappy to send along an invite to you for Tactyc so you can play with creating dashboards for your own models! Just DM me.", "replies": [{"id": "g19pa0r", "text": "**I found links in your comment that were not hyperlinked:**\n\n* [tactyc.io](https://tactyc.io)\n\n*I did the honors for you.*\n\n***\n\n^[delete](https://www.reddit.com/message/compose?to=%2Fu%2FLinkifyBot&amp;subject=delete%20g19p8os&amp;message=Click%20the%20send%20button%20to%20delete%20the%20false%20positive.) ^| ^[information](https://np.reddit.com/u/LinkifyBot/comments/gkkf7p) ^| ^&lt;3", "replies": [], "depth": 3}, {"id": "g1b5753", "text": "I would love this. Could you please send me an invite?", "replies": [{"id": "g1ba57w", "text": "Sure, please DM me your email address and I\u2019ll send it along", "replies": [], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "g1a4q8p", "text": "Great idea, but you are missing one important part of the process and that is the story of the property.  What is the current occupancy, market occupancy, rent/rate, what is my upside/downside etc.?", "replies": [], "depth": 1}, {"id": "g7hw693", "text": "Thanks for your information, if you would like to buy commercial property in Hinjewadi, Pune then go with below sites:\n\nhttps://www.realestateindia.com/pune-property/commercial-property-for-sale-in-hinjewadi-pune.htm", "replies": [], "depth": 1}]