Question

In: Finance

The Arbors at Los Brisos and Ranch Pointe are being considered for investment. Our initial investment...

The Arbors at Los Brisos and Ranch Pointe are being considered for investment. Our initial investment in the two properties are:

   The Arbors at Los Brisos $2,000,000
   Ranch Pointe $2,750,000


The cost of capital for our firm is 12%


We need to rank the projects according to the profitability index.


The Arbors at Los Brisos Ranch Pointe
   Initial Investment    -$2,000,000 -$2,750,000
Year 1    $450,000 $300,000
Year 2    $600,000 $500,000
Year 3    $750,000 $750,000
Year 4    $700,000 $875,000
Year 5    $700,000 $950,000


Which of the two should be ranked higher based upon profitability index?

The Arbors at Los Brisos

Ranch Pointe

Neither because the profitability is less than 1.0

Not enough information available to determine.

Solutions

Expert Solution

Answer: The Arbors at Los Brisos should be ranked higher based upon profitability index.

Initial investment for "The Arbors at Los Brisos"=$2,000,000
Initial investment for "Ranch Pointe"=$2,750,000

Cash flows for "The Arbors at Los Brisos":
Year 0:$2,000,000
Year 1:$450,000
Year 2:$600,000
Year 3:$750,000
Year 4:$700,000
Year 5:$700,000

Profitability index=(Present value of future cash flows)/(Initial investment)

Present value of future cash flows= (Cash flow in year 1)/(1+cost of capital)^1+(Cash flow in year 2)/(1+cost of capital)^2+(Cash flow in year 3)/(1+cost of capital)^3+(Cash flow in year 4)/(1+cost of capital)^4+(Cash flow in year 5)/(1+cost of capital)^5
Present value of future cash flows=450000/(1+12%)^1+600000/(1+12%)^2+750000/(1+12%)^3+700000/(1+12%)^4+700000/(1+12%)^5
=450000/(1.12)^1+600000/(1.12)^2+750000/(1.12)^3+700000/(1.12)^4+700000/(1.12)^5
=450000/1.12+600000/1.2544+750000/1.404928+700000/1.57351936+700000/1.762341683
=401785.7143+478316.3265+533835.1859+444862.6549+397198.799
=2255998.681
Profitability index for "The Arbors at Los Brisos"=2255998.681/2000000=1.127999341 or 1.23 (Rounded to two decimal places)


Cash flows for "Ranch Pointe":
Year 0:$2,750,000
Year 1:$300,000
Year 2:$500,000
Year 3:$750,000
Year 4:$875,000
Year 5:$950,000
Present value of future cash flows=300000/(1+12%)^1+500000/(1+12%)^2+750000/(1+12%)^3+875000/(1+12%)^4+950000/(1+12%)^5
=300000/(1.12)^1+500000/(1.12)^2+750000/(1.12)^3+875000/(1.12)^4+950000/(1.12)^5
=300000/1.12+500000/1.2544+750000/1.404928+875000/1.57351936+950000/1.762341683
=267857.1429+398596.9388+533835.1859+556078.3186+539055.513
=2295423.099
Profitability index=(Present value of future cash flows)/(Initial investment)
=2295423.099/2750000=0.834699309 or 0.83 (Rounded to two decimal places)

The Arbors at Los Brisos should be ranked higher based on profitability index because its profitability index is 1.23 which is higher than that of Ranch Pointe.


Related Solutions

A new computer network system is being considered for an organization. The initial cost of the...
A new computer network system is being considered for an organization. The initial cost of the system is $400,000. Annual maintenance and operating costs would be $25,000 per year. After 6 years, the system is expected to be worth $65,000. The desired ROI is 15% for it's projects. Determine the equivalent annual cost of the system.
In our construction of the savings and investment model, we considered government spending to be immediate...
In our construction of the savings and investment model, we considered government spending to be immediate spending. In other words, there was no “investment” component to government spending. Let’s change up that assumption. Suppose government spending comes in two types: investment spending (new airports, for example) as well as government consumption (snow plowing, for example). Call the first GI and the second GCE. a. Derive the savings and investment equations under this new assumption and prove, once again, that in...
An expansion project being considered by your firm has an initial cost of $8,000,000 and expected...
An expansion project being considered by your firm has an initial cost of $8,000,000 and expected net cash flows of $1,500,000 per year for the first 2 years, 1,800,000 for the third and fourth years, and $1,900,000 per year for the fifth and sixth years. All cash flows will occur at the end of each year. Assume that the project will be terminated at the end of the sixth year. Your firm’s cost of capital is 11%. Calculate the Net...
1. An expansion project being considered by your firm has an initial cost of $8,000,000 and...
1. An expansion project being considered by your firm has an initial cost of $8,000,000 and expected net cash flows of $1,500,000 per year for the first 2 years, 1,800,000 for the third and fourth years, and $1,900,000 per year for the fifth and sixth years. All cash flows will occur at the end of each year. Assume that the project will be terminated at the end of the sixth year. Your firm’s cost of capital is 11%. Calculate the...
Two currently owned machines are being considered for the production of a part. The capital investment...
Two currently owned machines are being considered for the production of a part. The capital investment associated with the machines is about the same and can be ignored. The important differences between the machines are their production capacities (production rate × available production hours) and their reject rates (percentage of parts produced that cannot be sold). Consider the following table: Machine A Machine B Production rate 100 parts/hour 130 parts/hour Hours available for production 7 hours/day 6 hours/day Percent parts...
The following portfolios are being considered for investment. During the period under consideration, RFR = 0.07....
The following portfolios are being considered for investment. During the period under consideration, RFR = 0.07. Portfolio Return Beta σi P 0.17 1.00 0.06 Q 0.19 1.10 0.07 R 0.11 0.70 0.04 S 0.23 1.30 0.10 Market 0.14 1.00 0.05 Compute the Sharpe measure for each portfolio and the market portfolio. Round your answers to three decimal places. Portfolio Sharpe measure P __________ Q __________ R __________ S __________ Market Compute the Treynor measure for each portfolio and the market...
Three mutually exclusive investment alternatives are being considered. The estimated cash flows for each alternative are...
Three mutually exclusive investment alternatives are being considered. The estimated cash flows for each alternative are given below. The study period is 30 years and the​ firm's MARR is 17% per year. Assume repeatability and reinvestment of positive cash balances at 17​% per year. a. What is the simple payback period for Alternative​ 1? b. What is the annual worth of Alternative​ 2? c. What is the IRR of the incremental cash flows of Alternative 2 compared to Alternative​ 1?...
Three mutually exclusive investment alternatives are being considered. The estimated cash flows for each alternative are...
Three mutually exclusive investment alternatives are being considered. The estimated cash flows for each alternative are given below. The study period is 30 years and the​ firm's MARR is 10​% per year. Assume repeatability and reinvestment of positive cash balances at 10​% per year. a. What is the simple payback period for Alternative​ 1? b. What is the annual worth of Alternative​ 2? c. What is the IRR of the incremental cash flows of Alternative 2 compared to Alternative​ 1?...
Suppose that a certain member of the Los Angeles Clippers is considered a streaky player. That...
Suppose that a certain member of the Los Angeles Clippers is considered a streaky player. That is, many people believe that his shots are not independent. If he makes a shot, they believe he is more likely to make his next shot and vice-versa. As evidence, people point to a recent game where this player took 30 shots and had a streak of 6 made shots in a row. Is this evidence of streakiness or could it have occurred simply...
A new type of commuter airplane is being manufactured for private use requires an initial investment...
A new type of commuter airplane is being manufactured for private use requires an initial investment of $4,500,000 that will be depreciated straight-line to zero over 8 years. The price of the plane will be $25,000 and the variable costs are $17,500 per plane. The fixed costs are $850,000. Using the financial BE methodology which delivers NPV = $0, what is the BE operating cash flow needed if the required return = 10%?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT