You must decide whether to buy, build or lease a building for your business needs over the
Question:
You must decide whether to buy, build or lease a building for your business needs over the next 10 years. If you decide to build, you must determine if it is better to buy an existing building and modify it or buy land and build one to match your needs. Leasing an appropriate building will cost $10,000 per month with an annual increase of 3% per year and will require some retrofitting to suit your needs ($700,000). Empty land will cost $2,500,000 and the construction of a new building would be $3,000,000. You can buy an existing building for $2,500,000 but you will have to modify it to your needs at a cost of $1,200,000. However, the building itself is quite old and will be at the end of its useful life when the ten years are up. You estimate that the land alone is worth $2,000,000. There is a municipal election scheduled in the next months. The frontrunner, who has an estimated 70% chance of winning, is prioritizing core services and the environment. If they win, there is a 65% chance that they will enact strict regulations that will render your new property worthless (with or without a building).
Management Science The Art of Modeling with Spreadsheets
ISBN: 978-1118582695
4th edition
Authors: Stephen G. Powell, Kenneth R. Baker