Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please make a comparison between four potential real estate development projects. Conduct a cost-benefit analysis of this Simple Cost-Benefit Analysis Data.xlsx . Project 1 Project

Please make a comparison between four potential real estate development projects. Conduct a cost-benefit analysis of this Simple Cost-Benefit Analysis Data.xlsx.

image text in transcribed
Project 1 Project 2 Project 3 Project 4 Project Duration (Years) Cost and Benefit Example only Total Units to be Constructed 500 400 300 200 Project 1 Project 2 Project 3 Project 4 Units For Sale 400 350 250 180 1600 Bebefits 1234 1345 965 1120 Units For Rent 100 50 50 20 1400 Cost 1024 1256 834 1080 Rental Period of Units (Years) 20 15 20 15 1200 Units For Sale after Rental Period 100 50 50 20 1000 Construction Cost for Each Unit (USD) 100,000 90,000 70,000 60,000 800 Cost Sales Office Cost (USD) 2,000,000 3,000,000 2,000,000 1,500,000 600 Sales Personnel Cost Per Year (USD) 300,000 250,000 200,000 150,000 400 Financing Cost Per Year (USD) 3,000,000 2,500,000 2,000,000 1,500,000 200 Sale Price of Each Unit (USD) 120,000 135,000 135000 120000 o Income Sale Price of Each Unit After Rental Period( USD) 70,000 80,000 30000 70000 200 400 600 BOO 1000 1200 1400 Rental Price of Each Unit Per Year (USD) 4,000 4,500 4500 400 Cos project 1 .project 2 . Project 3 . Project 4 Project Costs Project 1 Project 2 Project 3 Project 4 Total Construction Cost Cost Total Sales Office Cost Total Sales Personnel Cost during Project Duration Total Financing Cost during Project Duration TOTAL Project Benefits Project 1 Project 2 Project 3 Project 4 total Sale of Units Income Total Sales of Units After Rental Period Total Rental from Rental Period TOTAL Project 1 Project 2 Project 3 Project 4 Bebefits Cost Profit Benefit-Cost Ratio Total return during the 1st five years after project completion ROI of the 1st five years after project completion

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

The Restaurant From Concept To Operation

Authors: John R Walker

5th Edition

0471740578, 9780471740575

More Books

Students also viewed these General Management questions