Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started