Publication
Real Estate Valuation Using Regression Analysis – A Tutorial
https://www.toptal.com/finance/real-estate/real-estate-valuation
Daniel is available for hire
Hire DanielDaniel Barr, CFA, CAIA
Verified Expert in Finance
Finance Expert
Location
Daniels, WV, United States
Toptal Member Since
January 15, 2018
Dan led a team of controllers responsible for $185+ billion in assets at Credit Suisse and previously managed the acquisition/development of luxury home communities. He is passionate about helping small and mid-size businesses access the same tools employed by large corporations. Utilizing his financial knowledge and coding experience he has helped companies build financial models, automate processes, and bridge the gap between finance and IT.
Career Highlights
Consultant
Freelance
Principal/CFO
Barr Development
Education Highlights
Bachelor's Degree
Southern Methodist University
Certification Highlights
Chartered Financial Analyst (CFA)
CFA Institute
Chartered Alternative Investment Analyst
CAIA Association
Industry Expertise
Software Expertise
Other Expertise
Work Experience
Consultant
2011 - PRESENT
Freelance
- Built a multivariable regression model to predict rents for multifamily properties across ten US cities in the Sunbelt, leading to an acquisition of a $30 million project in Florida.
- Developed financial models for a startup using partial equity ownership as an alternative to foreclosure for mortgages.
- Served as the interim CFO, establishing financial procedures for a new real estate fund prior to launch, including setting up a chart of accounts in QuickBooks, providing financial analysis, and documenting accounting operations for the bookkeeper.
- Created a dynamic cryptocurrency index tracking a large universe of assets for a hedge fund specializing in digital assets using Power BI.
- Assisted a serial entrepreneur in performing due diligence on purchasing a startup eCommerce business. Discrepancies identified in the review of the financial records led to further investigation uncovering the past criminal history of the seller.
- Developed courses on derivatives and financial statement analysis for Smartly MBA. Also provided the final review for dozens of courses covering stocks, bonds, valuation techniques, investment decision-making, and capital budgeting.
- Advised BB&T, Community One, and Life Store Bank on the completion and rehabilitation of foreclosed commercial and residential projects, leading to the recovery of over three million dollars after the housing crisis.
- Conducted a survey of rental rates across seven county areas for the Northwest Regional Housing Authority and implemented a new cloud-based system to track 1,800+ Section eight rental units.
- Provided advice to a private equity portfolio company on mortgage alternatives to the sale and lease-back of a behavioral health facility.
Focus areas: Commercial Real Estate, Big Data, Financial Modeling, Microsoft Power BI, Cryptocurrency, CFO, Due Diligence, Data Analysis, Valuation, Finance, Real Estate, Statistics, Statistical Analysis
Director of Finance and Analytics
2022 - 2022
The Wildcat Group
- Recapitalized a $48 million multifamily project in Florida after a $7 million construction budget overrun.
- Found a solution for a $15 million cash-out refinance on a multifamily property in Arizona that allowed the owner to lock in a long-term fixed rate and provide liquidity for other projects.
- Reviewed financials prepared by the controller and produced monthly reports for lenders and investors.
- Built a Power BI data model that created automated proforma for multifamily projects in 200+ US cities.
Focus areas: Financial Modeling, Accounting, Analytics, Regression Modeling, Project Finance, Fundraising, Statistics
Business Analyst Manager
2020 - 2021
Intertrust Group
- Managed a business optimization and data quality team split between the Cayman Islands, Delaware, and Chennai, India, covering over 25,000 client entities domiciled in five countries across the US.
- Designed automated solutions for collecting data from clients and reporting regulatory information to appropriate jurisdictions.
- Built new analytical tools for business users and other support groups using Microsoft Power BI.
Focus areas: Financial Services, Big Data, Project Management, Data Analytics, Business Intelligence (BI), Data Governance, Data Migration, Business Operations, Business Analysis
Finance Analyst
2018 - 2020
Intertrust
- Built automated model using SQL and Power BI to evaluate outstanding client receivables for the provisioning process, forecast future write-offs, and provide targets for collection efforts based on probability of success.
- Created automated bottom-up revenue forecast for 50+ service offerings across 17,000 client entities used in quarterly forecasts and 3-year budget.
- Leveraged SQL, Power BI, and VBA to create an automated process for producing and distributing individually-customized, daily MIS reports for the regional head, managing directors, and 60+ relationship managers.
- Established monthly process for reviewing receivables, collating outstanding bills, and delivering email reminders via VBA macros to thousands of clients leading to a 15% increase in cash collections year-over-year.
Focus areas: Financial Services, Financial Modeling, Credit Risk, Credit Collection, Process Automation, BI Reporting, Financial Planning & Analysis (FP&A)
External Contractor
2018 - 2018
Deutsche Bank
- Engaged by Deutsche Bank to manage the novation and termination process for its Corporate Services business in the Cayman Islands.
- Built an Excel-based system using Power Query that centralized data on various workstreams. The system allowed users to continue using their existing processes uninterrupted while enabling local management and a central project team in London to have real-time data on the current progress on approximately 500 deals.
- Created over 40 templates in Word to leverage centralized data in the automated production of novation and termination documents. As a result, 1,500+ documents were produced and executed in a 45-day period resulting in a completion rate 3x greater than the next closest office.
Focus areas: Financial Services, Structured Finance Documentation, Data Analysis, Distressed/Special Situations
Assistant Vice President - Legal Entity Accounting and Reporting
2016 - 2017
Credit Suisse
- Supervised team of legal entity controllers for U.S. broker-dealers as well as mortgage and derivative entities with $185+ billion in total assets.
- Provided monthly/quarterly commentary and variance analysis of balance sheet movements and P&L drivers used for investor reporting and business planning.
- Served as IB Americas Subject Matter Expert on Securities and Prime Brokerage, providing training and expertise on securities and institutional trading to employees within the CFO division.
- Led working group to automate the processing of servicer remits for over 40,000 distressed residential mortgages in order to correctly account for $100+ million in annual expenses.
- Coordinated with teams across six countries to appropriately resolve consolidation breaks between 20+ global affiliates before the close.
- Prepared regulatory reports and answered questions from regulators for derivatives and mortgage entities.
- Reviewed approximately 150,000 open and failed security trades each month to ensure compliance with US GAAP.
Focus areas: Commercial Real Estate, Financial Services, CFO, Accounting, Financial Regulations, Analysis of Variance (ANOVA), Controller, Financial Reporting
Assistant Vice President - Product Control
2016 - 2016
Credit Suisse
- Supervised daily P&L reconciliations for 100+ bankers and traders covering private label MBS issuance, mortgage trading, and derivatives hedging with annual revenue of $1+ billion.
- Centralized the daily/monthly revenue reconciliations of commercial and residential mortgages previously performed by three separate teams.
- Oversaw the migration of $10+ billion in revolving credit facilities from Credit Suisse USA to Cayman Islands Branch.
- Identified solutions for reporting 50+ loan-level attributes on mortgages, which is required by the Federal Reserve under a new Intermediate Holding Company structure.
Focus areas: Commercial Real Estate, Financial Services, Commercial Mortgage-backed Securities (CMBS), Project Finance, Asset-backed Securities (ABS), Financial Reporting, Profit & Loss (P&L)
Senior Product Controller
2013 - 2015
Credit Suisse
- Established standard procedures for daily and monthly reconciliations of the relaunch of a commercial mortgage business, originating $10+ billion in loans in two years.
- Designed reports for commercial real estate team to analyze deal-level P&L, balance sheet utilization, derivatives hedging, funding costs, and profit-sharing agreements.
- Reviewed mortgage warehousing master repurchase agreements for revenue recognition under U.S. GAAP and trading/banking book capital treatment.
- Maintained commitment receivables and fee amortization schedule on 50+ mortgage warehouse facilities.
- Performed daily front and back-office reconciliation of trade breaks, inventory, and P&L for desks trading asset-backed securities, derivatives, futures, and mortgages.
Focus areas: Commercial Real Estate, Financial Services, Asset-backed Securities (ABS), Project Finance, Finance, Real Estate, Commercial Mortgage-backed Securities (CMBS), Financial Reporting, Profit & Loss (P&L)
Principal/CFO
2005 - 2013
Barr Development
- Planned, designed, and managed the development of five luxury home communities between 15-65 acres in size.
- Built cash flow models, P&L forecasts, and market absorption studies to analyze dozens of potential projects.
- Created business plans and presentations used to raise over $5 million in capital.
- Produced reports for limited partners, summarizing their investments, analyzing current market conditions, and projecting future sales.
- Maintained financial records, prepared operational budgets, and performed bookkeeping activities including paying vendors and reconciling bank statements using QuickBooks.
- Created geospatial models using SQL and ArcGIS to identify properties suitable for development in a 4-county area based on location, topography, and MLS sales data.
- Oversaw marketing efforts including online marketing and direct mail campaigns, hiring an ad agency and maintaining relationships with local realtors.
Focus areas: Statistical Analysis, Big Data, Financial Modeling, Project Management, CFO, Business Planning, Fundraising, Cash Flow Modeling, Market Research, Financial Planning & Analysis (FP&A), Revenue & Expense Projections, Cash Flow Forecasting, Investment Decision-making, Construction, Real Estate, Statistics
Research Analyst
2004 - 2005
Buxton
- Built multivariate regression models to predict store sales for Pizza Hut, FedEx Office, Restoration Hardware, 99 Cents Only, A.C. Moore, and GameStop.
- Prepared research reports for retailers, economic development corporations, and commercial developers to predict performance of retail locations nationwide.
- Created model using SQL and ArcGIS to measure the urbanization of every Zip+4 postal code in the U.S. using statistical analysis of household and business densities.
- Developed AutoID product to identify potential opportunities for car dealerships based on a leakage analysis of new car sales.
Focus areas: Statistical Analysis, Big Data, Market Opportunity Analysis, Market Research, Finance, Real Estate, Revenue Modeling, Statistics
Other Experience
Education
2000 - 2004
Bachelor's Degree in Economics
Southern Methodist University - Texas
Certifications
AUGUST 2019 - PRESENT
Chartered Financial Analyst (CFA)
CFA Institute
MAY 2017 - PRESENT
Chartered Alternative Investment Analyst
CAIA Association
NOVEMBER 2011 - PRESENT
SAS Certified Base Programmer for SAS 9
SAS
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring