Please help me solve Please help me solve Kaimalino Properties (KP) is evaluating six real

Please help me solve

 

 

Please help me solve

 

Transcribed Image Text:

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. (Click on the following icon in order to copy its contents into a spreadsheet.) 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 Seabreeze 9,000,000 15% 50,000,000 6,000,000 8% 35,500,000 Green Hills West Ranch 3,000,000 8% 10,000,000 9,000,000 8% 46,500,000 KP has a total capital budget of $18,000,000 to invest in properties. a. What is the IRR of each investment? a. What is the IRR of each investment? Fill in the IRR of each investment in the table below: (Round to two decimal places.) Discount Rate Expected Sale Project Cost Today (%) Price in Year 5 IRR 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 8 35,500,000 % Green Hills 3,000,000 8 10,000,000 % West Ranch 9,000,000 8 46,500,000 % 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. (Click on the following icon in order to copy its contents into a spreadsheet.) 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 Seabreeze 9,000,000 15% 50,000,000 6,000,000 8% 35,500,000 Green Hills West Ranch 3,000,000 8% 10,000,000 9,000,000 8% 46,500,000 KP has a total capital budget of $18,000,000 to invest in properties. a. What is the IRR of each investment? a. What is the IRR of each investment? Fill in the IRR of each investment in the table below: (Round to two decimal places.) Discount Rate Expected Sale Project Cost Today (%) Price in Year 5 IRR 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 8 35,500,000 % Green Hills 3,000,000 8 10,000,000 % West Ranch 9,000,000 8 46,500,000 %