Question

In: Finance

Seabreeze Properties is evaluating a real estate investment of Green Hills Estates. Management plans to buy...

Seabreeze Properties is evaluating a real estate investment of Green Hills Estates. Management plans to buy the property today and sell it 12 years from today. The initial cost of the property is $7 million and the expected sale price is $19 million. What is the IRR of the investment? Enter your answer as a percentage and rounded to 2 DECIMAL PLACES. Do not include the percentage sign in your answer. ​

Enter your response below.

​%

Solutions

Expert Solution

IRR(internal Rate of Return) is the rate at which the NPV =0.

Here IRR can be found using the excel function=IRR()

The initial investment=$7,000,000

The Sale price is $19,000,000 (year 12 inflow)

The formula used=IRR(B2:B14) We get IRR as 8.68% or 8.68


Related Solutions

Seabreeze Properties is evaluating a real estate investment of Green Hills Estates. Management plans to buy...
Seabreeze Properties is evaluating a real estate investment of Green Hills Estates. Management plans to buy the property today and sell it 12 years from today. The initial cost of the property is $7 million and the expected sale price is $19 million. What is the IRR of the investment? Enter your answer as a percentage and rounded to 2 DECIMAL PLACES. Do not include the percentage sign in your answer. ​ Enter your response below. ​%
Kaimalino Properties (KP) is evaluating six real estate investments. Management plans to buy the properties today...
Kaimalino Properties (KP) is evaluating six real estate investments. Management plans to buy the properties today and sell them five years from today. The following table summarizes the initial cost and the expected sale price for each property, as well as the appropriate discount rate based on the risk of each venture. Project Cost Today Discount Rate​(%) Expected Sale Price in Year 5       Mountain Ridge 3,000,000    15 18,000,000.                Ocean Park Estates 15,000,000   15 75,500,000   Lakeview 9,000,000   15 50,000,000   Seabreeze 6,000,000  ...
Kartman Corporation is evaluating four different real estate investments. Management plans to buy the properties today...
Kartman Corporation is evaluating four different real estate investments. Management plans to buy the properties today and sell them three years from today. The annual discount rate for these investments is 12%. The following table summarizes the initial cost and the sale price in three years for each​ property: Cost Today Sale Price in Year 3 Parkside Acres $550,000 $1,050,000 Real Property Estates 920,000 1,520,000 Lost Lake Properties 540,000 940,000 Overlook 50,000     250,000 Kartman has a total capital budget of...
Kartman Corporation is evaluating four different real estate investments. Management plans to buy the properties today...
Kartman Corporation is evaluating four different real estate investments. Management plans to buy the properties today and sell them three years from today. The annual discount rate for these investments is 16%. The following table summarizes the initial cost and the sale price in three years for each​ property: Cost Today Sale Price in Year 3 Parkside Acres $540,000 $1,040,000 Real Property Estates 810,000 1,410,000 Lost Lake Properties 530,000 930,000 Overlook 40,000     240,000 Kartman has a total capital budget of...
Kartman Corporation is evaluating four different real estate investments. Management plans to buy the properties today...
Kartman Corporation is evaluating four different real estate investments. Management plans to buy the properties today and sell them three years from today. The annual discount rate for these investments is 13%. The following table summarizes the initial cost and the sale price in three years for each​ property: Cost Today Sale Price in Year 3 Parkside Acres $610,000 $1,110,000 Real Property Estates 970,000 1,570,000 Lost Lake Properties 600,000 1,000,000 Overlook 110,000     310,000 Kartman has a total capital budget of...
Kartman Corporation is evaluating four different real estate investments. Management plans to buy the properties today...
Kartman Corporation is evaluating four different real estate investments. Management plans to buy the properties today and sell them three years from today. The annual discount rate for these investments is 16%. The following table summarizes the initial cost and the sale price in three years for each​ property: Cost Today Sale Price in Year 3 Parkside Acres $590,000 $1,090,000 Real Property Estates 880,000 1,480,000 Lost Lake Properties 580,000 980,000 Overlook 90,000     290,000 Kartman has a total capital budget of...
Kaimalino Properties​ (KP) is evaluating six real estate investments. Management plans to buy the properties today and sell them five years from today. The following table summarizes the initial cost and the expected sale price for each​ property, as well
Kaimalino Properties (KP) is evaluating six real estate investments. Management plans to buy the properties today and sell them five years from today. The following table summarizes the initial cost and the expected sale price for each property, as well as the appropriate discount rate based on the risk of each venture..ProjectCost TodayDiscount Rate (%)Expected SalePrice in Year 5Mountain Ridge$3,000,000  15$18,000,000  Ocean Park Estates15,000,000  1575,500,000  Lakeview9,000,000  1550,000,000  Seabreeze6,000,000  835,500,000  Green Hills3,000,000  810,000,000  West Ranch9,000,000  846,500,000  KP has a total capital budget of $18,000,000...
An analyst is assigned the task of evaluating a real estate investment project. Purchase price is...
An analyst is assigned the task of evaluating a real estate investment project. Purchase price is $700,000. Using the information in the table below, calculate the after-tax cash flow for the sale of the property. After-tax cash flow without property sale $33 546 Straight-line depreciation $18 700 Mortgage Payment $59 404 Cumulative Mortgage principle repayments until year 5 $20 783 80% financing at 10% interest rate Marginal income tax rate 31% Capital gains tax rate 20% Forecasted sales price $927...
Selected accounts of Piotroski Properties, a real estate management firm, are shown below as of January...
Selected accounts of Piotroski Properties, a real estate management firm, are shown below as of January 31, before any accounts have been adjusted. Debits Credits Prepaid Insurance $19,980 Supplies 5,790 Office Equipment 17,856 Unearned Rent Revenue $15,750 Salaries Expense 9,300 Rent Revenue 45,000 Piotroski Properties prepares monthly financial statements. Using the following information, adjust the accounts as necessary on January 31 using the financial statements effect template. (a) Prepaid insurance represents a three-year premium paid on January 1. (b) Supplies...
Gulf Real Estate Properties, Inc., is a real estate firm in southwest Florida. The company monitors...
Gulf Real Estate Properties, Inc., is a real estate firm in southwest Florida. The company monitors condominium sales by collecting data on location, list price, sale price, and the number of days it takes to sell each unit. Each condo is classified as Gulf View if it is located directly on the Gulf of Mexico or No Gulf View if it is located on the bay or a golf course. The data set contains sales data for 40 Gulf View...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT