Need help with completing pro forma
[deleted]
[{"id": "e5p8rpg", "text": "GPR is total market rent (gross scheduled rent) divided by number of units.\n\n\nEffective rent per unit is total market rent minus concessions minus lost to lease minus any models or non operating units (I come from multifamily, I don't know what you do) divided by total units. \n\n\nEffective PSF is your effective rent divided by the total amount of \nrentable SQFT, again I come from MF, sometimes commercial space is involved. \n\nEffective increase, Idk what you guys are projecting? A 3% rent growth per year, idk. \n\n\nAnnual debt service is how much your mortgage is, that should be on your T-12.\n\n\nPartnership costs, I'm assuming management fees, should be listed on your t-12. \n\n\nYour pref, I don't know that should be discussed with your partners or equity group.\n\n\nRemaining cash should be your total cash flow. \n\n\nCash on cash return is your cash flow divided by total investment in the property, debt and equity.\n\n\nAnyone feel free to correct me, that's a pretty straight up pro-forma though, and you have all of the information, and honestly you could of googled this shit, but who I am to criticize. ", "replies": [{"id": "e5pb2t2", "text": "I have to agree with U/trash-person. The variables you are trying to define are outside of this spreadsheet. We have no idea how many units you have, which will determine what your effective per unit is, nor the total SF, which will determine the rent psf. The effective increase is whatever your rental rate increase is. \n\nThe rest should all be defined somewhere else in the sheet. The debt service is yearly I assume, which depends on your down payment and cost of capital. \n\nSo you are right to be confused, there is data you are missing that cannot possibly be inferred with what you got going on there. ", "replies": [], "depth": 2}, {"id": "e5pn9on", "text": "Lol if I had to guess, OP has a case study for an interview this week, and they just pulled a random model off the internet.", "replies": [{"id": "e5rcb83", "text": "I mean you aren't wrong lol except for the random model", "replies": [], "depth": 3}], "depth": 2}, {"id": "e5si2mz", "text": "I really appreciate the reply this helps a lot! And I could have asked google/youtube but reddit is really the best for getting questions answered directly and efficiently. Thanks again for your help", "replies": [], "depth": 2}], "depth": 1}]