Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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 . a

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Capital Budgeting

Authors: Pamela P. Peterson

1st Edition

0471218332, 9780471218333

More Books

Students also viewed these Finance questions

Question

=+Provide an example of each method.

Answered: 1 week ago