Showing posts with label Timing. Show all posts
Showing posts with label Timing. Show all posts

Sunday, September 28, 2014

Timing- Analysis Start Date & Years to Report

Ok! We've got our Reporting Start Date of 2/15, what's our Analysis Start Date?  

Always, always I input the Analysis Start Date as starting in January. The year can vary, but we want it to be on the Calendar Year because we almost always get the information for our input into argus off documents that work around the calendar year (e.g. historical operating statements and budgets).  

The Analysis Start Date controls argus' assumptions about input. We have to tell Argus: these operating expenses/miscellaneous revenues/etc. are based on a calendar year. Then Argus does the dirty work so when we say we have a reporting start date of 2/15, it calculates inflation/occupancy/does our dirty work and gives us an output starting 2/1/15 and ending 1/31/2016. 

Depending on the time of year and what the client is willing to give you (budgets are very sacred), that will decide what you're going to work off of. Work off the most up-to-date information they give you. If that's the current year's Year-To-Date (YTD) actual operating statements with the remaining months revised budgeted amounts, great. If it's next year's budget, awesome. This will decide which year you pick for the Analysis Start Date. If you're inputting 2014 numbers, the year will be 2014. if you're inputting the 2015 budget, the year will be 2015. 

Let's say the owner of Sparkle Palace gave us everything they had, which included a 2015 budget. We're going to input the Analysis Start Date as 1/15

The third box- Years to Report or End Date just tells argus how many years of cash flows you want to see. I usually pick 12. You can go up to 40 years of reporting. 

Input 12 in the Years to Report or End Date Box



















Now! Onto Area Measures

Timing- Reporting Start Date

OK great! You've created a new file and are staring at the Timing Tab under Property Description, right?! If not and you're confused, go HERE first!

Otherwise, if you've somehow gotten away from the timing tab, it's easy to find again. In left hand corner, select Property > Timing...

Voila! Back on the timing page. 



















First we're going to talk about Reporting Start Date (the second Box on the screen) 

Now, All this knowledge I'm throwing down... 65% of it comes from my time working in the Capital Markets group of a brokerage firm. Other companies/professionals have different needs/desires/wants from argus. This is just my experience. Property management almost certainly approaches argus different than an aggressive brokerage house coming in and trying to sell a property. 

For brokerage, typically when we are using argus it is because a client has come to us and is considering selling their property. All our assumptions are based on this, and the first assumption we usually make is about timing. Real estate transactions take a long time. It's the nature of the multi-faceted, one-of-a-kind, sometimes headache-inducing beast. 

If we set up a model in September, most likely we're looking at a Year End Close. Hopefully, cross your fingers, before Christmas. The timing of your cash flows should reflect that. Our argus therefore, will have a Reporting Start Date, (if it's September, 2014) of January 2015. 

Why January 2015? Because we're trying to tell Buyers, "Hey look! If you purchase this fabulous property, and own it starting January 1, 2015, look how much money you can make! 

Typically you want to look 3/4/5 months out, but it all depends on what the client wants. Real estate is weird. Each property has different needs. 

Now, a January 2015 timing is fabulous. It feels so good. It's on the calendar year. Seriously, so great. Maybe too simple for us though. Let's say we have a client that is superstitious about closing around the holidays or they want the sale to be in Q1 2015 and they want to close around the end of January. In this tutorial for the Sparkle Palace we'll have a Reporting Start Date of 2/15 (February 2015). This goes in the SECOND BOX. Put it in there! 


NOW! Onto Analysis Start Date.....