Financial modeling – Real Estate Sector:

This course is very useful for the people who are into equity research and financial modeling domain – including students and professionals. This course gives a brief idea about valuing the companies in real estate sector, the revenue and cost drivers, forecasting the future financials and the stock price recommendation. Furthermore, it gives an idea how to prepare a report on the sector and companies.

This course gives a career prospect to the students who are planning to get a financial analyst job in any brokerage and KPOs. Since real estate is a booming sector from past ten years, and real estate prices have shoot up multi fold in past couple of years, knowledge about valuation of a real estate company and report writing would give the student an edge over the competitors. Also it boosts sector expertise of the seasoned professionals who are already working in the financial service domain.

The course is structured into two parts – first is, building a financial model from the scratch and second is, writing an equity research report or sector research report on the real estate sector. In the first section, we go step by step about how to prepare a financial model, starting from data punching to forecasting the future numbers, valuation of the stock and arriving at a target price. In the second part we give a brief idea about how to write an equity research report from the scratch, its sections and how to conclude the report. Also, we talk about sector and economic research reports and their components.

Materials included in the course are company financials, which are taken from the company websites. Apart from that, we have explained the steps in Microsoft power point and used Microsoft excel for building the financial model.

Course Objective:

• To study a promising sector like real estate and valuation of that sector
• To study steps of building financial model and equity or sector report
• To enhance the sector expertise

Target Customers:

• Basic knowledge of financial accounting, ratios
• Concepts of financial management, valuation methodologies
• Basic knowledge on Microsoft excel and word

Pre-Requisites:

• Any graduate having legal, medical and management background
• Basic Computer Knowledge
• Passion to learn about Insurance concepts

For any query call/miss call-

Mob-+918587999769

Section 1: Introduction to Financial Modeling of Real Estate sector

1              Introduction

2              Steps of Financial Modeling

Section 2: Financial Modeling Approach and Formatting

3              Explaining Approaches and Formatting Part 1

4              Explaining Approaches and Formatting Part 2

Section 3: Populating the Historical Figures

5              Punching Income Statement Part 1

6              Punching Income Statement Part 2

7              Punching Balance Sheet and Cash Flow Part 1

8              Punching Balance Sheet and Cash Flow Part 2

9              Taking Assumptions

10           Taking Appropriate Assumptions in Real Estate Models

11           Drivers and Income statement with linkage

12           Forecasting income statement

13           Balance Sheet and Cash Flow Forecasting

14           Ratio Analysis

15           How to Value a Real Estate Model

16           How to Value a Real Estate Model Continue

Section 4: Report Writing

17           Report Writing

18           Investment Thesis

19           How to Write a Real Estate Equity Report

Here is a sample for the course completion certificate which you will receive after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.

Mail us at: [email protected] with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address

Course Certificate:-