//Portfolio Valuation & Real Estate (Eng)

Portfolio Valuation & Real Estate (Eng)

This course focuses on the detailed modeling of the valuation of a portfolio of real estate assets; for which we provide a theoretical introduction by the hand of our expert in the subject.

350,00

Category:

Description

 

Over the last few years in Spain, there have been transactions involving large portfolios of real estate assets resulting from the obligatory cleaning of bank balance sheets. Large investment funds have positioned themselves in this sector and there is currently a frenetic activity that will last a few years.

This course focuses on the detailed modeling of the valuation of a portfolio of real estate assets, for which we provide a theoretical introduction by the hand of our expert in the subject.

DETAILS OF THE COURSE

Our intention is that at the end of this course you can:

  • Understand the key terms and definitions of real estate portfolio management
  • Know how to introduce key hypotheses in a financial model
  • Prepare the three financial statements (profit and loss account, balance sheet, cash flow)
  • Perform cash flow discount and business DCF valuation

In the course we will include financial model templates that you can download for your own use. Each portfolio is unique and you can adjust the design, but the important thing is that you have acquired the necessary modeling skills to work on any business.

Ernesto Ferrer-Bonsoms

Ernesto Ferrer-Bonsoms has a degree in Law and Business Administration from the Autonomous University of Madrid (UAM). He started his professional career as a Research Analyst at the IESE Business School and later developed his professional career in M & A and Private Equity in London and Madrid. Currently working at Acquisitions & Portfolio Management at Altamira Asset Management.

 

Perfil Linkedin

Program of the online Real Estate Business Valuation Course

 

Chapter 1- Introduction

A brief introduction to the course and its objectives.

Duration: 7:29

Chapter 2 – Overview of the Model

Global model view to have a general perspective.

Duration: 5:17

Chapter 3 – Datatape

Review of the information available in the file shared by the seller’s advisor.

Duration: 2:49

Chapter 4 – Assets: Information on assets

Creation of the Assets tab and introduction of the descriptive information of the assets.

Duration: 8:22

Chapter 5 – Assets: Valuation of assets

Calculation of the sale value of the assets.

Duration: 10:25

Chapter 6 – Assets: Liquidity Population

Calculation of the liquidity of the assets according to the number of inhabitants per municipality.

Duration: 4:11

Chapter 7 – Assets: Liquidity Transactions

Calculation of the liquidity of the assets according to the number of real estate transactions by municipality.

Duration: 5:51

Chapter 8 – Assets: Liquidity Typology

Calculation of the liquidity of assets according to the types of assets.

Duration: 5:27

Chapter 9 – Assets: Final Liquidity

With the previous inputs, final calculation of the liquidity of the assets.

Duration: 4:08

Chapter 10 – Assets: Sales Timing

Calculation of the number of months that we estimate that it will take to sell per asset.

Duration: 7:50

Chapter 11 – Assets: Costs Holding and Capex

Estimation of the maintenance and capex costs of the assets to be acquired.

Duration: 8:20

Chapter 12 – Assets: Costs Marketing

Investment and marketing strategy throughout the life of the portfolio.

Duration: 2:03

Chapter 13 – Assets: Costs Sales Costs

Cost incurred from the sale of the assets.

Duration: 3:17

Chapter 14 – Assets: Costs Closing Costs

Costs associated with the purchase of the portfolio, both advisory and tax.

Duration: 6:55

Chapter 15 – Sales Curves

Creation of the sale curves of the promotions according to their liquidity (1st part).

Duration: 7:29

Chapter 16 – Sales Curves

Creation of sales curves for promotions based on their liquidity (2nd part).

Duration: 9:32

Chapter 17 – CFby Unit Curves

Creation of the cash flow tab per unit, starts moving the sales curves per asset.

Duration: 7:20

Chapter 18 – CFby Unit Sales and Costs

Sales and portfolio costs per asset and per month based on sales curves.

Duration: 8:16

Chapter 19 – CFby Unit Sales Costs

Costs associated with the sale of assets calculated according to the time of sale.

Duration: 6:45

Chapter 20 – CFby Unit Management Fee

Management fee for the marketing of the portfolio.

Duration: 7:44

Chapter 21 – Output CFTotal Intro and P & L

Financial statements of the portfolio: introduction and P & L.

Duration: 5:30

Chapter 22 – Output CFTotal Debt and Equity

Financial statements of the portfolio: debt and equity balance items.

Duration: 5:36

Chapter 23 – Output CFTotal CIT Unlevered

Financial statements of the portfolio: calculation of the Corporation Tax without the financed portfolio.

Duration: 9:26

Chapter 24 – Output CFTotal CIT Levered

Financial statements of the portfolio: calculation of Corporation Tax with the portfolio financed.

Duration: 4:13

Chapter 25 – Output CFTotal Balance and CF

Financial statements of the portfolio: balance and cash flow completed.

Duration: 8:59

Chapter 25 – Output CFTotal Balance and CF

Financial statements of the portfolio: balance and cash flow completed.

Duration: 8:59

Chapter 26 – Output CF Development

Financial statements of the portfolio by promotion.

Duration: 8:41

Chapter 27 – Output Summary PL and Net Cashflow

Summary of the main magnitudes of the portfolio.

Duration: 6:34

Chapter 28 – Output Summary Investment Metrics

Summary of the main investment ratios of the portfolio.

Duration: 11:05

Chapter 29 – Output

Graph with the main magnitudes of the portfolio.

Duration: 7:00

 

The classes are all practical and contain reference and study material. (Excel sheets with LBO files and solutions)
As a bonus, the video of a Henry Kravis (KKR) conference on LBOs is added.

Who is this online course for?

This module is taught with a more advanced conceptual level, we assume that you have knowledge of finance and financial modeling, and if this is not the case, you can review our introductory course before entering the valuation course of real estate portfolios.

It is a course aimed at analysts and managers dedicated to corporate and underwriting processes of real estate portfolios. Especially focused on real estate investment funds, real estate consultants, servicers, Big Four or any player in the market interested in valuing a portfolio of assets. Throughout the course, the necessary tools will be acquired to value the investment of a portfolio of assets from a financial point of view.

icono-telefono+34 91 057 97 69 icono-whatssup+34 619 817 391 +info@modelandum.com