Pro Forma Modeling
Does anyone know where I'd be able to find free guides on learning pro forma modeling in excel? 

Thanks in advance! 
[{"id": "de1p4jo", "text": "The internet. ", "replies": [{"id": "de2fxwn", "text": "I believe you mean the googles specifically? ", "replies": [], "depth": 2}], "depth": 1}, {"id": "de1x9fj", "text": "There are quite a few sites that offer full tutorials with practice models they take you through, but it can be expensive. Let me know if you find anything good that's free. I made sure to keep my files and videos from the classes I took on this at Georgetown, knowing how valuable they were. ", "replies": [], "depth": 1}, {"id": "de1y6it", "text": "I always break down \"modeling\" into two categories:\n\nExcel skills: ability to navigate excel using formulas and formatting techniques\n\nBuilding Pro Formas: creating a tool in excel that appropriately assesses the financial feasibility of an investment opportunity\n\nI'm going to assume you are comfortable in excel. Building a model isn't all that complex (yes, I've done it a lot so maybe I'm bias). You have NOI (rents + reimbursements - expenses) and capital outflows to come to a net cash flow. This net cash flow would be used to calculate an IRR over a given period of time. Yes, it can become a bit more complex when you add debt and/or have a joint venture.\n\nThere are a number of resources available both in books and online. Another cool site to visit is www.wallstreesoasis.com. Check out the real estate forum and browse through there.\n\nAlso happy to discuss over DM.", "replies": [{"id": "de8kj5j", "text": "Where can u learn about formatting? My models are ugly.. ", "replies": [], "depth": 2}], "depth": 1}, {"id": "de2aa31", "text": "AdventuresinCRE.com", "replies": [], "depth": 1}, {"id": "de41spz", "text": "go to loopnet and request some offering packs on properties.  copy and paste the key numbers (income/exp/loan terms) then hide everything else.  \n\nSee if you can recreate the brokers result.  After you do it a few times its pretty easy for basic ones.  As the others mentioned if you are doing jv/preferred debt or some other fancy things it gets a bit more complicated (but not that hard).  Just find as many examples as you can then you recreate them and it will become very easy for you.\n\nThe hardest part in the real world is getting the numbers you use, not modeling them.", "replies": [], "depth": 1}, {"id": "deosan4", "text": "I taught myself pro forma modeling through Foundations of Real Estate Financial Modelling by Staiger, Roger. The book walks you through how to build progressively more complex models from scratch starting with a single house flip, then 5-unit rental , then N-unit rental, then it adds in development scheduling pages and accounting pages. \n\nBe forewarned, I found a few typos/mistakes in the book that will make the model make no sense, but I emailed the publisher and asked for access to the completed models, which will allow you to see what the book meant to say when you notice that it messed up. It will be obvious when the numbers don't make sense.", "replies": [], "depth": 1}]