Real Analysis, LLC Real Estate Financial Modeling

1
Real Analysis, LLCReal Estate Financial Modeling
Analysis1128 Cherrytown Road Westminster, MD
21158 410.840.0172 www.real-analysis.com
2
Real Analysis, LLCReal Estate Financial Modeling
Analysis

• Commercial retail and office buildings
• Malls strip shopping centers
• New development
• Residential

3
Real Analysis, LLCReal Estate Financial Modeling
Analysis
4
Real Analysis, LLCReal Estate Financial Modeling
Analysis

• Project Cash Flow ________________________________
  __
• A detailed projection comprised of actual and
  speculative
• assumptions for tenant rents, recoverable income,
  operating
• expenses, debt and capital related assumptions,
  usually for a
• period of ten years.
• Includes supporting schedules of tenant rents,
  recovery
• ratios, occupancy, as well as performance
  measurements
• ratios.
• Some applications of cash flow modeling are
• Budgeting
• Expansion and remerchandising
• Finance underwriting
• Acquisition analysis

5
Real Analysis, LLCReal Estate Financial Modeling
Analysis

• Pro forma ___________________________________
• A financial model, usually prepared for purposes
  of
• new development or expansion projects. Utilizing
• speculative assumptions based on a conceptual
• development plan. The components of the
• investment structure, development cost, financing
• terms, income, expense and capital related items,
  are
• presented in a cash flow format including
  analytical
• ratios
• Internal rate of return (IRR)
• Cash-on-cash
• Return on cost (ROC)
• Return on equity (ROE)
• Partnership distributions
• Debt service coverage ratio (DCR)

6
Real Analysis, LLCReal Estate Financial Modeling
Analysis

• Financial Due Diligence __________________________
  _
• The preparation of a financial analysis showing
  the
• potential return under different assumptions with
  respect
• to occupancy levels, rents and expenses.
  Includes
• review and confirmation of offering
  brochure/literature
• against the corresponding sellers financial
  model.
• Providing complete financial analysis utilizing
  the software
• solutions common in the real estate industry
• ARGUS
• DYNA

7
Real Analysis, LLCReal Estate Financial Modeling
Analysis

• Property Accounting and Reporting _______________
• Comprehensive property accounting which includes
  the
• benefit of customized reporting for a variety of
  property
• types retail and office buildings, apartments,
  home
• communities and storage facilities. Utilizing an
  
• all-inclusive accounting solution combined with
  both
• standard and customized property management
• features, providing informative tenant /unit
  related data
• such as, detailed rent roll and lease reporting,
  as well as
• general accounting reporting.
• Excel Templating ___________________________
• Customized Excel models to fit client-defined
• requirements. Designed for recurring reporting
• needs, such as supporting schedules or
  specialized
• project initiatives that require on-going
  updating
• or overwriting of financial information.

Other Services.
8
Real Analysis, LLCReal Estate Financial Modeling
Analysis Biographical Sketch
9
Real Analysis, LLCReal Estate Financial Modeling
Analysis
Academic Background ______________________________
____________ Towson University B.B.A. Business
Administration Certificate in Accounting CCIM
candidate
Sandra L. Peacock Principal

• Experience________________________________________
  _____________
• Sandra L. Peacock is the Principal of Real
  Analysis, LLC, a resource to provide
  professionals in the real estate industry,
  financial analytical services in the form of
  financial modeling, property accounting, as well
  as ad-hoc assignments.
• With over 15 years of experience in the
  commercial real estate financial industry, with
  concerted emphasis in cash flow modeling and
  analysis, Sandy holds degrees in both Business
  Administration and Accounting. Having worked as
  a Financial Analyst for Senior Management of The
  Rouse Company, previously one of the largest
  publicly held real estate development companies
  in the country, she is highly proficient in the
  capabilities of comprehensive forecasting and
  reporting tools, such as Argus and Excel. She
  was previously the Controller at Enterprise Real
  Estate Services of Columbia Maryland, overseeing
  all financial facets of the Accounting Department
  that was responsible for 35 entities, including
  numerous operating properties.
•  
• The financial modeling of a 1.2 million square
  foot retail mall in expansion and development
  over a period of 4 years, as well as a
  multi-venue new development project featuring
  retail, office, restaurants, entertainment and
  big box tenancy are just a couple key examples of
  her extensive modeling work.
•  
• She is a member of the Maryland Society of
  Accountants, National Society of Accountants,
  RealPulse.net (formerly ARGUS Community), as well
  as the CCIM Institute, where she is actively
  participating in the certification program.
• Professional Designations_________________________
  __________________________
• Member Maryland Society of Accountants
• Member National Society of Accountants
• CCIM Institute Candidate Membership

10
Real Analysis, LLCReal Estate Financial Modeling
Analysis

• Service Fees _____________________________________
  ____________
• Fees vary by project and type of service. More
  commonly a flat fee is defined based on the
  proposed
• objective and the scope of work. An hourly fee
  may be used for updating or modifying current
  Argus,
• Dyna or Excel models.
• A flat fee includes a complete analysis with
  detailed supporting reports and defined model
  updates.
• Outside the scope of the initial proposal terms,
  work will be structured on an hourly fee.
• A detailed proposal will define clearly and
  thoroughly each projects objectives and fee
  structure.
• Upon a signed proposal, a 20 deposit is
  required. The remaining fee will be due upon
  completion of
• the terms of the proposal.
• Please call for more information regarding your
  specific project need or for information on
  Property
• Accounting Fees.

11
Real Analysis, LLCReal Estate Financial Modeling
Analysis

• Dont disrupt your day-to-day
• accounting resources already in
• place, allow Real Analysis, LLC to
• be your financial partner.
• For information please contact
• Real Analysis, LLC
• 1128 Cherrytown Road
• Westminster, Maryland 21158
• 410.840.0172
• sandy_at_real-analysis.com
• www.real-analysis.com