Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please do a cost-benefit analysis with the details and assumptions below in excel. Please also show the formulas behind them. Background: The cost of land
Please do a cost-benefit analysis with the details and assumptions below in excel. Please also show the formulas behind them.
Background: The cost of land is 2 million dollars The cost of construction is 15 million dollars and construction is instant! You take out a loan (when buying the land) for 75% of land and construction costs The interest rate on your loan is 5% and you will pay it back over 30 years The building will be 100 units (50 one bedrooms and 50 two bedrooms) One bedrooms rent for $1500 each month and two bedrooms for $2000 each month starting two years after you buy the land After the building opens, it will cost 30% of revenue to run (this covers taxes, staffing, maintenance) Thirty years after it is built, you will sell the building for twenty times the annual rent As an alternative, you could invest your money in a bond returning 3% per year . aStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started