Valuation Spreadsheets . . . care to share yours, fellow CREdditors?
This would seem like a tool that someone has already made available . . . but I haven't found it. Not online and not on Google Drive tempaltes. Without access to Argus, the closest I've found is someone giving away a spreadsheet full of macros. :-\

Fellow CREdditors, would you share the spreadsheet(s) that you use to value commercial real estate?
[{"id": "c893ah0", "text": "You don't necessarily need a spreadsheet to value a piece of commercial property. What income do you expect (less vacancy), and how credit worthy are the potential tenants?", "replies": [{"id": "c893s7u", "text": "Thank you for responding, but all of the samples I see include many other factors and metrics: finance costs, initial improvements, vacancy, \ntaxes, utilities, maintenance, management, insurance, and then Cap rate, DCR, Payback Period, Break-Even Ratio, etc.\n\nWhether these are necessary or not, do you have a spreadsheet to model [how you would value a vacant mixed use row house](http://www.reddit.com/r/RealEstate/comments/1780a4/how_would_you_value_contiguous_vacant_mixed_use/)?", "replies": [], "depth": 2}], "depth": 1}, {"id": "c898jjs", "text": "You definitely need a spreadsheet, especially for retail investments and strip centers.  With changes in price per sq. ft., rental rates, in the years 5-10, in order to understand cash on cash returns, equity, and vacancy rates, less management and expenses you need some complex spreadsheets or argus software to input.  I have my assistant put these together using a combination of excel and argus.  ", "replies": [{"id": "c89fqnh", "text": "Care to share a sample spreadsheet?   :-D\n\npretty please", "replies": [], "depth": 2}], "depth": 1}, {"id": "c8senkg", "text": "I think you are going to have to build one up. Some of us have access to discounted cash flow spreadsheets, but I am pretty sure that unless you own the firm giving it away would not be kosher.\n\nTo create a simple one you want to account for all of the factors that will impact your cash flow during the holding period. Off the top of my head: vacancy, ongoing expenses, inflation rate, miscellaneous expenses in the future {new roof in 6 years or new paint job in 2 years}, debt service.\n\nThen you have to account for the sale amount at the end of the holding period. The easiest way would be to assume a sales cap rate and apply it to the NOI of that period. Do not forget that it will cost you some money to sell the property in the form of broker fees.\n\nIf you followed the steps, you got the future cash flows so the last step is to come up with an appropriate discount rate and take those cash flows to the present.\n\nYou can use the spreadsheet in the link below as a base to build yours. It is a debt service coverage spreadsheet, but it has a lot of the stuff that you are going to need to build the DCF one.\n\nhttp://www.loanuniverse.com/sensitivity.php\n", "replies": [], "depth": 1}, {"id": "c9ov91k", "text": "Cash flow based valuation is important, but you need to realize its just that... Cash flows. Take each tenants expected cash flow and take out any expenses you need to and cap it out.", "replies": [{"id": "c9ov9e3", "text": "Then take out capital requirements and leasing costs both rolling and new.", "replies": [], "depth": 2}], "depth": 1}]