What are some tools for calculating cash-flow projections for leasing?
I am looking for a software that calculates net effective rent and produces different cash flow scenarios/projections based on TI, Operating expenses, annual increments, discount rate,  lease term and type, months free rent etc.

or an excel sheet with formulas? I am looking to better understand how it's all calculated.
[{"id": "g75o5gj", "text": "Without going full blown Argus Enterprise you can definitely model all of those in excel. Check the library of files on \u201cAdventures in CRE\u201d (google)", "replies": [{"id": "g768xhd", "text": "I\u2019m a big fan of their stuff. I post to the legal form section for free legal documents", "replies": [], "depth": 2}], "depth": 1}, {"id": "g75v95m", "text": "There are excel downloads available, costar lease analysis, and I think there is a tool for it in appfolio but don't quote me on the last one.", "replies": [], "depth": 1}, {"id": "g75wd0h", "text": "Procalc is widely used.", "replies": [], "depth": 1}, {"id": "g75x2ij", "text": "I generally just use excel to model income / reimbursement / expenses / cap rate. Simple lease analyses are not too complicated for excel.", "replies": [], "depth": 1}, {"id": "g762yxg", "text": "If you want to understand how it's all calculated, then you need to learn to build your own models in Excell.", "replies": [], "depth": 1}, {"id": "g7649gy", "text": "It looks like you are looking to underwrite a property, then contract leases, and then add speculative leases or make adjustments to existing.  I'm a big fan of starting with a CCIM spreadsheet and manual. You may find someone who would be willing to share this for you to take a look and decide to pursue the coursework and designation. I haven't heard of Procalc, IMO you'll want to understand the basics before considering ARGUS. The spreadsheets mentioned seem decent if they come with training and help guides.", "replies": [], "depth": 1}, {"id": "g77j1r5", "text": "I was just reading the nic senior housing report and there was a section on development that had lease up info. After 12 month average project was 65% occupied. After 18, it was 90%. There has to be something like that for your property type. \n\nIf youre at 70% occupancy, and the market is at 90%, the itll take a year to get 65% of the way to 90. In other words 83%. Then another 6 months to get to 88% full \n\nThinking outside the box here\n\nExcel + google + youtube will be your best friend", "replies": [], "depth": 1}, {"id": "gf3x1x3", "text": "Argus and pre-built Excel models are fine (I personally use Argus), but if you want to understand how it's calculated, it might be best to learn to built an Excel model from scratch. The most complex part of models are market leasing assumptions (MLAs), but modeling them on Excel will certainly help you. Make a rent schedule to model your rent roll w/ any rent escalations and abatements, add debt schedules, equity waterfalls, etc. and tie it all together on a coherent pro forma.\n\nOnce you understand all of this, you'll look at Argus and see it as an overpriced software version of an Excel template.", "replies": [], "depth": 1}]