Question: You are planning to purchase an empty block upon which you are considering developing a residential villa complex. The assumptions are: The land will cost

You are planning to purchase an empty block upon which you are considering developing a residential villa complex. The assumptions are:
The land will cost $ 5.2 million to purchase.
Council contribution fees will be $800000.
The properties that we develop will be 6,000 square metres in total.
Building costs will be $1,600 per square metre.
We will sell the properties for $3,500 per square metre.
Sales commission to the estate agent will be 1.5 percent of the sale price. Create a working model for this business situation using a Data Validation Drop-Down in excel or create a built-in scenario analysis model for the situatio Use the two input variables 'building cost'

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!