Completing an operating pro forma(multifamily)
[deleted]
[{"id": "e5solp4", "text": "Looks like you just need to link the appropriate cells and maybe add a calc or two to get the desired results for the highlighted cells. Seems odd, I would ask for clarification as this seems too simple.", "replies": [{"id": "e5t0akg", "text": "Yea I was just told to go through Year 5 actually. Would you know how to do that?", "replies": [{"id": "e5um91e", "text": "Yea, pretty simple. Just use the cash flow forecast assumptions at the bottom to grow the current operating numbers", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "e5svrjm", "text": "What\u2019s the end goal for this pro forma?", "replies": [{"id": "e5sxqhk", "text": "I just know a buyer is going to aquire the properties(y) as he is selling them. Other than that I was just told to complete the pro forma for each, this being one of them", "replies": [], "depth": 2}, {"id": "e5t0b2k", "text": "Just found out I'm supposed to calculate the operating pro forma through year 5..", "replies": [{"id": "e5t2ylo", "text": "I can send you an example Multi UW model I made if that helps you. Also happy to hop on the phone this weekend if not urgent", "replies": [{"id": "e5t4dbs", "text": "Id take you up on the call but I need to submit it by thursday. The UW model would be great though! I can just give you my email ", "replies": [{"id": "e5t64c1", "text": "Sure I can just reddit chat you a download link when I\u2019m home.", "replies": [{"id": "e5t84j1", "text": "Sounds good!", "replies": [], "depth": 6}], "depth": 5}], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "e5tcqtf", "text": "Just a quick glance but your OpEx ratio is approx 43% which is pretty high. Your payroll expense looks to be a major part of that. I would dig through the T-12 and find any non-operating expenses that were lumped in the pro-forma. Your turnover expense is also listed at $766/yr which seems laughable since its been broken out from R&amp;M. \n\n&amp;#x200B;\n\nLike I said, take a careful look at the T-12. Find non-recurring expenses, find amortized capital. Pull the actual tax bill and call the county to find out the millage rate for your tax parcel. Forecast what your new tax expense will be if the property transacts. ", "replies": [{"id": "e5thlw8", "text": "Yea those numbers aren't mine, just given to me. I'm looking at those I'm just trying to calculate it 5 years in advance.", "replies": [], "depth": 2}], "depth": 1}]