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)