Archive for April, 2014

Argus Analyst Tip 10

You might be asked to audit, review and update an existing Argus model versus creating one from scratch. If the author of the model used Market Categories for Market Leasing Assumptions then you are in luck because you can quickly make changes by altering a single variable. For example, if you have three different MLAs that assume $20.00/SF rents, it is much easier to set up a variable called $20.00 Rent and apply that to all three MLAs than it is to enter “20” in each MLA base rent variable. The added advantage is that if you want to change your assumption to $21.00/SF you only have to make one change (to the base rent variable) and you never need to access the MLA tables at all.

Job Hunting Tip #14: Don’t Volunteer Information Unless You Can Substantiate It

Over the past couple of months I have run into two different circumstances whereby the candidate should not have volunteered information: (1) the GPA that they had in school; (2) the salary they were earning. Frequently employers are requiring a transcript from your college (and graduate school if applicable) to not only substantiate the information that was stated on the resume but also to confirm that the discussions that occurred during the interviews are entirely valid. Likewise, if you state that you are making $65,000 per year in salary then you should indeed be making that much. Many employers will ask for a recent pay stub to substantiate this information that you are sharing. The primary reason why employers are checking on these facts has more to do with how truthful the candidates are versus the actual fact-checking of the information.

Unless you are asked specifically for this information, it is best to simply avoid discussing it at all lest you somewhat “inflate” the numbers and the opportunity with the employer disappears.

Excel Tip: Conditional Formatting

Excel’s built-in conditional formatting gets new powers in Excel 2010. Now you can apply one of the pre-built color-coded conditional formatting options to data that includes negative numbers (not only positive numbers, as in Microsoft Office 2007). This can give you quick graphic clues to the way in which profits and losses, for example, fit into a pattern that’s easier to detect graphically than by looking at a column of numbers. You set this up this kind of conditional formatting by clicking Home, Conditional Formatting, Data Bars, and then choosing a color set in the Gradient Fill gallery.