Guest Post – Difference in Underwriting From a Buyers and Sellers Perspective

by Joe Stampone on January 10, 2010

By: Jon, with input from the team at www.argusvaluation.com

In our first guest post, we explained The Role of the Real Estate Financial Analyst.  In today’s post we’re going to get a bit more specific and explain how someone who receives an Argus projection on the buy-side should approach auditing the assumptions in the projection.

Even though it is common knowledge that sell side analysts underwrite their models with assumptions to enhance net operating income (NOI), many buy side analysts miss out on common subtleties which can lead to a more accurate view of NOI over a 10-year period.

In this post, the 5 main topics discussed will be:

  1. Management Fees
  2. Structural Reserve
  3. Reimbursement (are tenants really triple-net?)
  4. General Vacancy Rate / Credit & Collection Loss and exclusions
  5. Market Leasing Assumptions

1.  Management fees are impacted by several issues:

  • They get projected at rates of anywhere from 1%-5%
  • They also are sometimes a percentage of base rent and other times a percentage of effective gross revenue
  • And if you weren’t confused enough yet, they also get listed as reimbursable or non-reimbursable expenses.

The trick with management fees on the buy-side is to take things with a grain of salt.  Obviously during your firm’s ownership of the property, the expense will be different depending on if you manage it in-house or hire a third-party management company.  Typically an industry standard amount to use is 4% of effective gross revenue, and place it within the Non-Reimbursable Expenses category.

Often times Argus files you will receive will show that management fees are being recovered by tenants, and we caution you to verify this with tenant leases during due diligence because often times this isn’t actually the case.

2.  Structural reserve is a pretty simple issue.  Typically it is categorized as a Capital Expenditure, although sometimes your principal may ask you to move it under Non-Reimbursable expenses so that it is above the line (i.e., decreases NOI to reduce pricing, and not just cash flow).  Typically you’ll find the expense in the $0.10 per square foot range for a property, although you’ll want to increase this amount to $0.15-$0.20 per square foot depending on the age and condition of a property.

3.  The issue we bring up regarding tenant reimbursement is more general in nature.  Especially in retail properties, one must be careful to consider that the Argus projection is accurately taking into account tenant reimbursements and not overestimating the amount of expenses recovered.  Often, sell-side analysts will prepare an Argus projection and assume all tenants reimburse full pass-throughs, however in reality this is rarely the case.  Many tenants often have restrictions on certain expenses, others such as anchors often pay small fixed amounts, while sometimes even retail tenants may be on gross leases.

By running a property report and comparing the overall reimbursement revenue versus the operating expenses one can get a good sense of the percent of overall reimbursement and see if it makes sense relative to the property type and tenancy.

4.  General Vacancy Rate and Credit & Collection Loss is a way to project a market vacancy factor and reduce the potential gross revenue derived from your projections in Argus.  This amount differs depending on the market, and can be anywhere from 5% to 20%.  One must be diligent in their market research to find averages for the marketplace in comparable properties, as underwriting with too low a rate will lead you to pay too high a price given the income at the property.

Something else to consider is to check over any tenant groups excluded from the vacancy factor.  Large anchor tenants and other national credit tenants often can safely be excluded from this revenue deduction as they are typically not going to suddenly leave the property.  However, the case could be made to include even a national grocer like Kroger if there is little time left on the initial lease term.  The important point here is to review all exclusions listed and make sure that you are confident in them remaining at the property.

5.  Market Leasing Assumptions (MLA’s) are typically what drive most of the revenue growth in an Argus projection.  This is because this is where market rents come into play as leases expire.  All MLA’s need to be thoroughly scrubbed to ensure conservative market rents are projected, along with all of the other rollover assumptions such as vacancy before the space is re-leased, anticipated abatements, and tenant improvement expenses.  By carefully reviewing tenant MLA’s and ensuring that no tenant jumps in rent from for instance an $8.00 per square foot gross rent to $15.00 per square foot triple-net rent without a reason which the seller can confidently backup, you protect yourself and help to ensure you aren’t met with major surprises during the life of an investment.

These five items are helpful to review each time you receive an Argus model for a property, and by carefully auditing the work given to you, you will hopefully be aware of the true returns potential for a property.

The main software we discussed today was Argus Valuation DCF.  It is integral to an analyst’s daily responsibilities, and one must be comfortable with it to ensure that all projections for a property are handled properly.  If you’re not familiar with Argus, visit www.argusvaluation.com or email us at argusvaluation@gmail.com to learn more about the training courses we offer.  Also, if you have any general questions about this post please feel free to email us.  Good luck in your real estate career.

Similar Posts:

Post to Twitter Tweet This Post

{ 2 comments }

Joe Stampone January 11, 2010 at 11:29 am

I want to thank Jon and everyone over at Argus Valuation for this guest post. All models need to be examined thoroughly and assumptions need to be verified. In football, like real estate models, I've never seen a play that didn't work in the playbook. However, once of the field, not every play works and even the ones that do work, they usually didn't go as planned.

Joe Stampone January 11, 2010 at 5:29 pm

I want to thank Jon and everyone over at Argus Valuation for this guest post. All models need to be examined thoroughly and assumptions need to be verified. In football, like real estate models, I've never seen a play that didn't work in the playbook. However, once of the field, not every play works and even the ones that do work, they usually didn't go as planned.

Comments on this entry are closed.

blog comments powered by Disqus
susanna carlo valentino lyrics download gcc chautauqua abstract free ragdoll creating programs alinco dj x10 reviews antologia della letteratura italiana wealthtekk.com bacardi mixes 1994 georgie boy pursuit p30 can unknown run for city council john f kennedy mem high school balboa 4000 pack 80 s club mixes 2008 impreza sti pics alvy reels hannah montanna lip synch deserts at 30 degrees 2005 pt cruiser convertable manual bid slayer 2009 resolution survey myspace blue pitbull breeder battery experts trimm road ottawa divinity recipie canda gold loon evening gazette middlesbrough 1959 pennies stampin around cartridges reversible synchronous motor diagram d0gs heartbeat accuspray paint guns ddm dominator video ernesto chong 99 ford contour gl problems classroom aides and unemployment benefits alabama lyrics american pride 101 north kansas ave olathe ks dancing fathers and daughters explaining hitler gait rite system bushrod doggett ann stripling descendants brevard county florida newspapers clifford varner african pygmy hedgehog breeders 12 month rn to bsn program conan doyle john dickson carr frazer and frazer falling gavin rossdale audrey sampson paula sandlin constance vines correct punctuation for a sentence resturaunts near sacramento 2007 lowe 194 tahiti gfk kites 1995 automatic toyota tercel repair handbook 100 juice products apa billiards ie 7 trusted sites effects of prednisone 2007 buell xb9r test avocat claude girouard 4 shop casters kaehlers whitefish bay esoteric white magick canada bimini top clips dermatologist komal chopra andrew frederick jorgenson california commercial gutter basic geometry test translation rotation reflection pacleanways.org alopecia treatments british sas desert rats wateroutfitters.com 1067 highway 80 pooler georgia bedouin shrine circus 2007 calendar lousywriter.com grohe warrenty adonis in winnipeg 55 gallon drum roller dfw airport departure gates bloc autonome d clairage de scurit limp bizkit bass tab rearranged alternative fuels of south carolina inc instruction template for 8086 microprocessor cannery lasvegas 12 volt lcd televisions american leaders of world war 2 3 month old boy picture fafsa fillers corduroy slacks lumix camera digital top pricegrabber com bio about anthony horowitz 4th of july events pittsburg ks ball lickers and nut suckers compare ionic air purifiers bank of montreals bruce mckenzie h s intergrated company apple safari browser user manual blue 4 leaf clover crock ancient tribal views on photographly knock off fake lv cline genealogy in new jersey 1815 apa ethical principles involving human subjects andrew dyson chesterfield roman a clef algo crane bumper children self esteem sports buy ru 486 online average airport delays detroit michigan 2x4 connectors 1932 ford sedan arrowheadhospital.com alive or dead deanna durbin fishing passaic river in totowa parkrecord.com alchohol water separation christian inspirational sayings 3d cardboard cinema standups catholic church in millard ne maj biagini isavo.org christina lan caoile nguyen jules and mimi 12v adapter for lg 8350 swell personal training defenders of wildlife magazine dark field microscopy of mitochondria 4 pillars destiny aberystwyth cliff railway wiki cobalt iii cyanide formula dyco 20 20 seam seal clark floor scrubber parts predictive techniques in astrology can employer cut your commision rate animal population pie graphs irradiation sterilization company eldon benjamin ausherman catnaper power recliners business entity search indiana 1st stark portland or 1900 s administrative assistant certificate 1951 the lords supper picture thelearningboxpreschool.com car mufflers at walmart average cost of replacing asphalt driveway boston fd radio asia geography quizzes fun map games caro syrup pecan pie recipe earths age class 2 safety vests century importers elimination of fire sirens brazil sao paulo picture 2 guys catering abusive officer caught on tape poems of springtime angela and steve ferro leftover crack tab 1999 ford contour starting problems guy screwing a dog pictures bacardi gold rum joseph and mildred mcfarland indiana connecticut defenders mural quadrant dog alopecia everydayedisons.com cigarettes and non smokers becoming a hells angel boat yard cradle uk boys life waterproofing 20 minutes chicken roast cut pepper antenna rotor bearing 10 amp power supply 10000 step program walking vettenet.org proven home based forgotten realms timeline emulator project 64 super smash bros 1994 ap macroeconomics exam airwick.com bible scripture for memorials famous trumpets 1973 ford f250 crew cab parts dog the bounty hunters nationality health thelma uk cliniclegal.org john oxley queensland library atm cell architecture ppt 2008 mph school rankings free motorola pebble ringtones helen von mott videos les setters 2002-2004 suv angelas city phillipines ppryor.com can warfrin stop periods beach inspired bathroom design accommodation auckland lists vintagebang.com mrs bush nerves pinched post free games notes on treble clef alaskan malamute australian shepherd fulfillment renton boartlongyear.com facts on margert kimble gage weaverpopcorn.com hospital denver todd conklin asheville npr banzai buffet churchill alternative school benny benassi mix playlist andy warhol dracula bc equipment hourly rates for excavators bill shoemaker rockport texas sg1 area 52 fonts warp rampancy.net mother teresa newsweek magazine carnation milk peanut butter fudge bacterial biosynthesis of indole-3-acetic acid american automobile association pedestrian safety 6600 cellular nokia phone pengar och v nskap beasley spay and rueter chaning a toilet flap funny and useless information credentials funeral director caryoralsurgery.com balboa 54108 analog input velocity control circle flap handbag elkhorn kids camp idaho country suiets in summerville sc can women wear speedo jammers chicagoland firework displays lhmhonda.com mayflower ar public schools enron business ethics guitar unplugged tonneaucoversworld.com lexington hearld news paper tracksidetrains.com atelier perfume oil a import ncia da m sica american traditions hardwood 00 gauge signal controll amex points 4120 ec alarm air conditioner splitter dna heat induced separation bankshot billiards game beachbabez.com generations batra ravi birch carrol and cole ge lexan 9034 crotalaria toxin do it again smash mouth catalinaferries.com american veterans center tenth annual conference bungee chair for adults aacn approved ceus strangepages.net 33 frank 2007 2008 txt crossbow arcade game chocolat vitale buy raspberry plants crystal report bitmap link unavailable eva basco suarez loyola plans lanai studio rentals ansell moisture absorbing technology prepx.com barbara lowe dallas access add only one record form toplesslolitas.com causes of macular degeneration abita springs krewe of push mow medplususa.com calculate oil reserves stratigraphic geometric factor 1st to die by james patterson gotta get it food tv 1992 mitsubishi mighty max clutch problems 11825 via lucerna circle kentucky groundwater data repository dejection an ode colerige customizing color and size dogpile site submissions calgovcouncil.org amy burke hammond la dell d600 li ion battery 2009 rose parade dvd award winning female bluegrass vocalist vincent candle lit supper history christmas pies fitnessforoneandall.com faced insulation ho chi minh apartment rent clingmans dome seen from fontana lake macy day parade horton ksh memory scripting advantage camo shower stall curtain 1940 czech violin beaumont artwork lithograph alarm cellular backup beyond the beyond wired blogs download online quake herpes prednisone alaska eye care center anchorage ak bees and cell phone signals chromosome thirteen alternatively weighed indexes nonnudepic.net american sign language tutor tasteoftx.com australians voting overseas cheats for pokemon crystal for gbc contact denzel washington dpfwiw.com 1940 ford deluxe 2 dr sedan area code for latham n y barry manilow feelings nursing consideration in leopolds maneuver at what age does iq stabilize gemma arterton oil d51s p2.4 16647 kl us nobullcollection.com julian trevor brown cocker spaniel names double curve scoliosis 12 circuit court vs supreme court apple raspberry picking in albany county obituary archives thelma cooper 1996 colonel lee lorain claybusters harvester 50 cal short sabots 1000 watts amplifier schematic diagram