Unlock Efficiency with Excel Pro Forma Template for Supervision

Excel pro forma template for Supervision

welcome this is performa stabilized spreadsheet seek actual operating data video tutorial number one my name is Jeffrey Smith in this tutorial I want to show a new feature on the proforma operating data worksheet on this worksheet I've added a column of data for actual operating data and and a button seek actual now these fields in yellow are input fields and they are initialized to the calculated values these values are calculated ing to the performer stabilized worksheet ing to the specified return on equity and the cash flow on your Equity after Debt Service now I notice that sometimes you are not looking for a property with a particular cap rate instead you are looking at an actual property with actual operating data and therefore let's demonstrate this scenario let's suppose that you're looking at a property and the actual operating data is let's say 172,000 the vacancy and credit loss is actually a negative 22,000 the other income from laundry and storage and maybe cable TV let's say that's actually 9,500 and the actual operating expense let's say that's 80,000 and let's say the price that you want to pay is roughly 750,000 that calculates a cap rate of 10.60% this does not match the performance stabilized sheet which calculated a 12% cap rate and a maximum allowable offer of 72331 so let's see what we do have to have in order to match these numbers let's do a seek actual sometimes the seeking does not work in this case it seems to have worked it has calculated the ratios copied them over to the calculated cells and over in the profor a stabilized worksheet it has adjusted the gross return on Equity rate and the gross return on Equity cash flow to achieve that cap rate and that purchase price and the net operating income this has been perform a stabilized spreadsheet seek actual operating data video tutorial number one my name is Jeffrey Smith and thank you for your support