write my assignment 15382
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 =
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
[email protected]% (again make 10% flexible)
IRR
AVP
NOI (net operating income = revenue – expenses on annual basis)