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 Mountain Ridge Ocean Park Estates Lakeview Seabreeze Green Hills West Ranch Cost Today $3,000,000 15,000,000 9,000,000 6,000,000 3,000,000 9,000,000 Discount Rate 15% 15% 15% 8% 8% 8% Expected Sale Price in Year 5 $18,000,000 75,500,000 50,000,000 35,500,000 10,000,000 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? b. What is the NPV of each investment? c. Given its budget of $18,000,000, which properties should KP choose? d. Explain why the profitability index method could not be used if KP's budget were $12,000,000 instead. Which properties should KP choose in this case?

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 Mountain Ridge Ocean Park Estates Lakeview Seabreeze Green Hills West Ranch Cost Today $3,000,000 15,000,000 9,000,000 6,000,000 3,000,000 9,000,000 Discount Rate 15% 15% 15% 8% 8% 8% Expected Sale Price in Year 5 $18,000,000 75,500,000 50,000,000 35,500,000 10,000,000 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? b. What is the NPV of each investment? c. Given its budget of $18,000,000, which properties should KP choose? d. Explain why the profitability index method could not be used if KP's budget were $12,000,000 instead. Which properties should KP choose in this case?

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Meman
Written report with the following content: • Appendix1: Leasing Explain the calculations. Your recommendations Objective: Should FFT lease or construct their own production facility Option 1: Construct Costs to incur: Buying land, construct building and getting ready for use (FFT has these funds available in their bank account today so no mortgage is needed) $ 1,200,000 Taxes, insurance, and repairs (per year) $110,000 Intended years of use 15 Projected market value in 15 years $ 1,250,000 Option 2: Lease Intended years of use 15 Deposit required today (this deposit will be returned to FFT when the lease contract is complete is 15 years) $ 100,000 Annual lease payment $ 160,000 Property taxes (annual) to be paid by FFT $ 15,000 Insurance (annual) to be paid by FFT $ 15,000 Required rate of return 8% Methodology: The consulting team is proposing to perform a NPV analysis and determine the benefit to leasing or construction. Based on the analysis, they will recommend the preferred option…
find the expected return for investing in buildings in a metro area where the following three buildings are for sale: The cost of the building is $4 million, the total rents are $500,000 and the total expenses are $300,000. The cost of the building is $90 million, the total rents are $35 million and the total expenses are $24 million. The cost of the building is $21 million, the total rents are $6 million and the total expenses are $3 million..
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 $520,000 $1,020,000 Parkside Acres 870,000 1,470,000 Real Property Estates Lost Lake Properties 910,000 510,000 220,000 Overlook 20,000 Kartman has a total capital budget of $540,000 to invest in properties. Which properties should it choose? ... The profitability index for Parkside Acres is (Round to two decimal places.)
can you solve in the excel file please. Thanks 2. ABC Lottery Corporation runs the "Millionaire Life" lottery. The winner of the Grand Prize can choose either $1,000,000 per year for 25 years or a single cash payment of $17,000,000. Which option should be chosen if the payments are made at the beginning of each year and, on low-risk investments, money can earn 3.2% compounded annually?
A city is considering buying a piece of land for $500,000 and constructing an office complex on it. Their planning horizon is 20 years. Three mutually exclusive building designs (shown below) have been drawn up by an architectural firm. Use the modified benefit-cost ratio method and a MARR of 10% per year to determine which alternative, if any, should be recommended to the city council.
Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows: (Future Value of $1. Present Value of $1. Future Value Annuity of $1. Present Value Annuity of $1.) Note: Use appropriate factor(s) from the tables provided. Initial investment (for two hot air balloons) Useful life Salvage value Annual net income generated BBS's cost of capital Assume straight line depreciation method is used. Required: Help BBS evaluate this project by calculating each of the following: 1. Accounting rate of return. Note: Round your answer to 2 decimal places. 2. Payback period. $ 423,000 9 years $ 45,000 $ 38,493 98 Note: Round your answer to 2 decimal places. 3. Net present value (NPV). Note: Do not round intermediate calculations. Negative amount should be indicated by a minus sign. Round the final answer to nearest whole dollar. 4, Recalculate the NPV assuming BBS's cost of…
A real-estate development firm, Peterson and Johnson, is considering five possible development projects. Using units of millions of dollars, the following table shows the estimated long-run profit (net present value) that each project would generate, as well as the amount of investment required to undertake the project. Project 1 Project 2 Project 3 Project 4 Project 5 Estimated profit ($million) 1 1.8 1.6 0.8 1.4 Capital Required for Project ($million) Capital Available ($million) Project 1 Project 2 Project 3 Project 4 Project 5 Capital 6 12 10 4 8 20 Click here for the Excel Data File The owners of the firm, Dave Peterson and Ron Johnson, have raised $20 million of investment capital for these projects. Dave and Ron now want to select the combination of projects that will maximize their total estimated long-run profit (net present value) without investing more than $20 million. Formulate and solve this model on a spreadsheet. Determine the combination of…
Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows: (Future Value of $1, Present Value of $1, Future Value Annulty of $1, Present Value Annuity of $1.) Note: Use appropriate factor(s) from the tables provided. Initial investment (for two hot air balloons) Useful life Salvage value Annual net income generated BBS's cost of capital Assume straight line depreciation method is used. Required: Help BBS evaluate this project by calculating each of the following: 1. Accounting rate of return. Note: Round your answer to 2 decimal places. $ 319,000 6 years $ 55,000 $ 25,839 8%
Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows: (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1.) Note: Use appropriate factor(s) from the tables provided. Initial investment (for two hot air balloons) Useful life Salvage value Annual net income generated BBS's cost of capital Assume straight line depreciation method is used. Required: Help BBS evaluate this project by calculating each of the following: 1. Accounting rate of return. Note: Round your answer to 2 decimal places. 2. Payback period. Note: Round your answer to 2 decimal places. 3. Net present value (NPV). $ 533,000 9 years $ 56,000 $ 47,970 7% Note: Do not round intermediate calculations. Negative amount should be indicated by a minus sign. Round the final answer to nearest whole dollar. 4. Recalculate the NPV assuming BBS's cost of…
3. The city of Oak Ridge is evaluating three mutually exclusive landscaping plans for refurbishing a public greenway. Benefits to the community have been estimated by a landscaping committee, and the costs of planting trees and shrubbery, as well as maintaining the greenway, are summarized below. The city’s cost of capital is 8% per year,and the planning horizon is 10 years. Which landscaping plan will you recommend based on B/C ratio analysis?
2

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS