Resources from Realogic: Argus™ Modeling Tip #2
Reimbursable Expenses - Argus 2006 (ver. 13)
While Argus 2006 added a great deal of functionality and flexibility by introducing the concept of Expense Groups, it also opened the door for potential mistakes by Argus users.
In previous versions of Argus, if a user Copied or Inserted a Reimbursable Expense line item, the new Line item would be inserted into all previously created Detailed Reimbursement Mechanics. The Reimbursement Method applied to this new expense depended upon whether the new expense was Copied or Inserted. If the new expense was created by Copying an existing expense, then the Reimbursement Method was also replicated. If the new expense was created by Inserting a new row, then the Reimbursement Method would default "Not Reimbursed, Exclude".
In Argus 2006 (Version 13), if a user Copies or Inserts a Reimbursable Expense line item, the new Line item is not included in all previously created Detailed Reimbursement Mechanics or Expense Groups. The user needs to Add the new expense to the appropriate Expense Groups and/or Insert additional rows in the Detailed Recovery Mechanics.
Featured Realogic Services
Portfolio Underwriting and Due Diligence Services
Realogic offers a variety of services to help you manage your deal pipeline and enhance the profitability of your firm. Realogic offers the ability to quickly and efficiently size or analyze portfolio loans, and after application or accepted offer, help carry them through closing. We perform site inspections, 3rd party engagement & review, and financial testing on anywhere from 2 to 200+ assets. Plus, we make deals easier for you, handling as many tasks as you would like throughout the process, such as credit committee presentations, pitch books, and portfolio analysis. We have vast experience with all major product types.
For additional information please contact Jim Pettinger or Jonathan Weerts at 312-782-7325.
Case Studies
Underwriting Support
Situation
A client was involved in a 9 building industrial sale-leaseback transaction with a loan under application that had an extremely tight closing. The properties were scattered throughout the US.
Solution
Realogic provided the following services, which allowed the loan to close within the specified deadline.
- Performed site inspections on all assets
- Reviewed Phase I's, Phase II's, PCAs, PZRs, and Appraisals
- Coordinated and communicated valuation changes to portfolio
- Wrote committee pitch book for lender
- Created securitization data tape with summary of third party data and other borrower provided info
- Produced miscellaneous analyses for both borrower and lender to facilitate a timely closing
- Produced final deliverable of clean, finalized third party reports with correct collateral data and correct valuations.
Argus™ Training
Upcoming Training Opportunities
Scheduled Chicago Classes:
9/6
10/4
11/1
12/6
9/7
10/5
11/2
12/7
Dyna™ and Ellipsis® Training
Available upon request.
In addition to our monthly training classes, we also offer private classes to companies that have multiple people interested in training. Our private classes can be held in our Chicago offices or onsite, whichever is most convenient.
Additional training information:
- Follow our standard Beginner and/or Advanced training agendas
- Customize an agenda to cover the basics and focus on certain areas within the program based on client wishes.
- Flexible training date options
For more information, please contact John Johanson at jjohanson@realogicinc.com or call 312-782-7325
Welcoming New Personnel
Brian E. Goldman
Brian has joined Realogic as a Manager in the Capital Markets Services Group after spending the past 11 years with John Hancock as a Senior Investment Officer, originating and managing their Midwest commercial mortgage portfolio. Brian is an alumnus of the University of Chicago Graduate School of Business where he received his MBA in Finance and Economics.
Gretchen Mantz
Gretchen has joined Realogic Analytics as a Senior Analyst and comes to RLA with over 12 years of commercial real estate analysis experience. Gretchen is a graduate of the University of Wisconsin-Madison with a master?s degree in Real Estate.
Tom Kaveney
Tom recently joined Realogic as an Associate Analyst. His duties involve financial modeling, analysis, and due diligence and underwriting support. Tom graduated from Marquette University with a degree in Economics.
Jay Williams
Jay recently joined Realogic as a Senior Analyst. Prior to joining RLA, he was with GE Healthcare Financial Services, and has 5 years of experience in securities analysis, commercial finance, and health care real estate. Jay's current duties include performing market sensitivity analysis in Dyna, providing excel training and supporting the financial analysis team. Jay received a BA in Economics from University of Maryland in 2001.
Bradley Karfeld
Brad joined Realogic as a Senior Analyst in the Capital Markets Services Group whose primary responsibilities include underwriting and performing due diligence for Wall Street lenders.
Prior to Realogic, Brad was a Senior Analyst at Diversified Real Estate Capital, a private wealth investor vehicle specializing in acquisitions of office buildings and apartments. Brad completed his undergraduate work at Northwestern University, and received his MBA in Finance and Strategy at the University of Chicago Graduate School of Business
This newsletter is prepared and distributed courtesy of Realogic Analytics, Inc.. For additional information on any topic covered or to learn more about Realogic, contact Realogic at 312.782.7325 or via email at jjohanson@realogicinc.com If you would like to be on our mailing list for this newsletter, please visit http://www.realogicinc.com/archive.asp . To unsubscribe, please reply to this email with "Unsubscribe" in the subject line.