Originally published: 29/07/2020 15:40
Publication number: ELQ-82476-1

Real Estate - Financial Model for an Industrial Warehouse Development Project

Case study PDF and Excel File for the Financial Model.

by Padmashri V
Finance Professional

7 reviews237 views|Start the discussion!|Add to cart - $10.00

finance real estate case study financial model excel cre

Description
Enclosed are 2 files
1. The pdf file for case study along with a basic explanation for the key technical concepts used in the model.
This enables the user of the financial model to understand the context and logic upon which the model is built.

2. Excel Financial Model.
The excel comprises of 2 sheets, first is for "Inputs and Summary" and the second is the detailed monthly financial model.

This is a financial model template in excel for Real estate professionals who are looking for some intuitive guidance on building their own financial models.

The fundamental concepts of Finance as well as Real Estate are quite universal. I am sure the user will find many takeaways from the file to apply in their own work or may even readily use this template with some smart edits on custom formatting, for example, to use any other currency in place of rupee, millions in place of crores.

In India, 10 million is equal to 1 crore. Normally, money is expressed in crore terms. Wherever you see the term "Cr", note that I have divided the total number by 10^7. In case you deal in millions, you can divide your calculations by 10^6 to express in millions.

All inputs are in blue font, reference from another cell in green font and calculations in black font.

This Best Practice includes
1. Case study pdf and 2. Excel file for financial model

Acquire business license for $10.00

Add to cart

Add to bookmarks

Discuss

Further information

Objectives

Case study file is intended to provide the instructions which have been intuitively modeled out in the accompanying excel file. The financial model is built in most dynamic manner so that any change in the inputs will carry out the necessary changes in calculations and the Model summary without frequent changes required to be made in the formulas.

Use it if

This template is suitable for professionals looking for application of best practice concepts as covered in the Case study file in CRE - Warehouse development project.

Don't use it if

This template is not useful for those who are completely oblivious to the basic concepts of finance/ basics of excel/ basics of real estate.

Reviews

Rate this Downloadable Best Practice
Write a review
Julia Inam(last updated: 05/01/2021 12:37)
Wail Hilal(last updated: 30/12/2020 06:52)
Hetal Khuman(last updated: 17/12/2020 18:20)
Real estate - financial model
This template is very very helpful for fundamental concepts of Finance and people at ease can decide to invest with the automated formulas applied in the excel sheet. Great work with par excellence to help us build our own financial models. Much appreciated, thank you!
mithun amin(last updated: 30/09/2020 04:58)
Exhaustive financial model covering all the important parameters applicable in the real estate secto
It was really ease to use the model and fully automated.
Jh3416(last updated: 30/09/2020 04:55)
sunny bhatia(last updated: 27/09/2020 11:19)
Hannah McKeown(last updated: 30/07/2020 08:23)