I Want You To Build Me A Excel Model For Real Estate Valuation I Can Change The

/in /by

I want you to build me a excel model for real estate valuation: (please make the inputs dynamic – i.e. I 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),,,usually you will get this from market study, just like an oil forecast, but assume this for now

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 me a 15 year (annual) model (do not go crazy on terminal value)

Output

NPV@10% (again make 10% flexible)

IRR

AVP

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

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW