Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help to Build an excel model for real estate valuation: (please make the inputs dynamic - i.e. can change the numbers)... Inputs: Land

I need help to Build an excel model for real estate valuation: (please make the inputs dynamic - i.e. can change the numbers)...

Inputs:

Land size 1000 SQM

Land price = 400 QAR/sq.ft

Land commission= 1% of total land value; this is an expense

Number of villas=2

Total build up area = 1000 SQM (500 per villa)

Construction cost: 3000 per SQM.... This is a typical cost, if you want to make high-end villas you will spend more , but off course you will have ask for higher rent

Construction period = 2 years

Construction spent = 50% each year

Engineering cost = 2.5% of total construction cost

Rent per villa per month = 18,000 (rent increases by 5% every 3 years)

Rent commission = 2 weeks rent per villa every 2 years (this is an expense)

Maintenance cost = 2.5% of rent, this is an expense

Case 1 = total equity zero debt model

Case 2 = bank will offer 60% financing on construction cost at a cost of debt of 4% (build the model that I can change this) / repayment over 10 years (2 years grace period = meaning you start paying the bank when you rent = year 3)

Please Build a 15 year (annual) model

Output

NPV@10% (again make 10% flexible)

IRR

AVP

NOI (net operating income = revenue - expenses on annual basis)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Principles and Application

Authors: Arthur J. Keown, J. William Petty, David F. Scott, Jr.

10th edition

536514119, 536514110, 978-0536514110

More Books

Students also viewed these Finance questions