Carlson Development owns a prime parcel of land that can be developed into a residential, commercial,...

Carlson Development owns a prime parcel of land that can be developed into a residential, commercial, or industrial complex. Carlson plans to manage each of the projects for seven years and then cash out. After considerable research, Carlson estimates that cash flows from the three alternative projects are as follows:

Cash Flows In Millions

Project	Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7
Residential	(25.0)	2.0	2.0	2.0	2.0	2.0	2.0	52.0
Commercial	(26.6)	6.0	6.0	6.0	6.0	6.0	6.0	16.0
Industrial	(21.0)	4.0	4.0	4.0	4.0	4.0	4.0	14.0

Calculate the NPV and IRR on the three projects identify which (if any) project should Carlson select?

Solutions

Expert Solution

To calculate IRR use the formula

Cash flow at Year 0 = Sum(Cash flow at Year t/(1+IRR)^t)

In this problem we have the following cash flows. We calculate IRR using hit and trail in the above formula. Alternatively, we can use IRR function in excel.

	Residental	Commerical	Industrial
Year 0	-25	-26.6	-21
Year 1	2	6	4
Year 2	2	6	4
Year 3	2	6	4
Year 4	2	6	4
Year 5	2	6	4
Year 6	2	6	4
Year 7	52	16	14
IRR	16.60%	17.30%	14.20%

Based on IRR, Carlson should select the land for Commerical usage.

NPV of a project is sum of the present and discounted future cash flows. For discounting we can choose current inflation rate ie 8%.

NPV = CF at year 0 + (Cash flow at Year t/(1+r)^t)

					Discounted cash flows
	Residental	Commerical	Industrial	Discounting factor @ 8%	Residental	Commerical	Industrial
Year 0	-25	-26.6	-21	1	-25.00	-26.60	-21.00
Year 1	2	6	4	0.93	1.85	5.56	3.70
Year 2	2	6	4	0.86	1.71	5.14	3.43
Year 3	2	6	4	0.79	1.59	4.76	3.18
Year 4	2	6	4	0.74	1.47	4.41	2.94
Year 5	2	6	4	0.68	1.36	4.08	2.72
Year 6	2	6	4	0.63	1.26	3.78	2.52
Year 7	52	16	14	0.58	30.34	9.34	8.17
				NPV	14.59	10.47	5.66

Based on NPV, Carlson should select the land for Residential usage.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

A parcel of land is proposed for residential house development. The land is situated beside a...

A parcel of land is proposed for residential house development. The land is situated beside a river and so flooding is suspected to occur. Outline how you would go about assessing if the land is subject to flooding. If you assess that the land does flood, outline how you would go about determining the flood levels at the property. In this case the principal objective of the assessment is to determine the flood elevation in a 100 yr ARI flood...

Project A: This is a project for the use of commercial land the financier already owns....

Project A: This is a project for the use of commercial land the financier already owns. There are three mutually exclusive alternatives. A1: Sell the land for $500,000 A2: Lease the property for a car-washing business. An annual income, after all costs (property taxes, etc.) of $98,700 would be received at the end of each year for 20 years. At the end of the 20 years, it is believed that the property could be sold for $750,000. A3: Construct an...

Manufacturing Corp. owns a five-acre parcel of land. Its factory takes up one acre of this...

Manufacturing Corp. owns a five-acre parcel of land. Its factory takes up one acre of this land, and there is a mall on the other four acres. Manufacturing Corp. rents out retail space in the mall. To get rid of a troublemaker shareholder, Manufacturing Corp. wants to put all of the land into a subsidiary, sign a long-term lease for its own factory, and then split off this subsidiary by transferring it to the troublemaker shareholder in complete redemption of...

During 2020, Waldo Inc. sold 10 acres of prime commercial zoned land to a builder for...

During 2020, Waldo Inc. sold 10 acres of prime commercial zoned land to a builder for $5,000,000. The builder gave Waldo a $1,000,000 down payment and will pay the remaining balance of $4,000,000 to Waldo in 202 Waldo purchased the land in 2011 for $2,000,000. Using the installment method, how much profit will Waldo report for 2020? $600,000 $1,000,000 $3,000,000 Using the same information as in the preceding question, how much profit will Waldo report for 2020 using the cost...

Tax incentives offered by local governments make the most sense For commercial and residential development b....

Tax incentives offered by local governments make the most sense For commercial and residential development b. For industrial and technology development c. When agglomeration economies are present d. For relatively small jurisdictions in metropolitan areas

Garrix Animal Supplies wanted to purchase a parcel of land from Sinatra Trash Can Company as...

Garrix Animal Supplies wanted to purchase a parcel of land from Sinatra Trash Can Company as the future site for a storage facility. Sinatra Trash Can Company listed the land at a price of $310,000. Garrix Animal Supplies was convinced that the land was worth $285,000, a price that was supported by an independent appraiser. The companies eventually agreed to a price of $298,750. Garrix closed the deal on March 14, 2016 at which time it incurred a broker commission...

The Tinsley Company exchanged land that it had been holding for future plant expansion for a more suitable parcel located farther from residential areas.

The Tinsley Company exchanged land that it had been holding for future plant expansion for a more suitable parcel located farther from residential areas. Tinsley carried the land at its original cost of $30,000. According to an independent appraisal, the land currently is worth $72,000. Tinsley paid $14,000 in cash to complete the transaction. Required: 1. What is the fair value of the new parcel of land received by Tinsley? 2. Prepare the journal entry to record the exchange...

TapsiCo is a manufacturer of soft drinks. TapsiCo owns a land in Georgia that can be...

TapsiCo is a manufacturer of soft drinks. TapsiCo owns a land in Georgia that can be used for building a Distribution Center (DC). The company has estimated that it will cost $1M to build a high technology DC, which will lead to cost savings of 250 thousand dollars per year. The company is planning to use the DC for only 3 years and sell it at book value at the end of the third year. The DC has a life-time...

TapsiCo is a manufacturer of soft drinks. TapsiCo owns a land in Georgia that can be...

TapsiCo is a manufacturer of soft drinks. TapsiCo owns a land in Georgia that can be used for building a Distribution Center (DC). The company has estimated that it will cost $1M to build a high technology DC, which will lead to cost savings of 170 thousand dollars per year. The company is planning to use the DC for only 3 years and sell it at book value at the end of the third year. The DC has a life-time...

An entrepreneur owns some land that he wishes to develop. He identifies two development options: build...

An entrepreneur owns some land that he wishes to develop. He identifies two development options: build condominiums or build apartment buildings. Accordingly, he reviews public records and derives the following summary measures concerning annual profitability based on a random sample of 35 for each such local business venture. For the analysis, he uses a historical (population) standard deviation of $21,800 for condominiums and $19,600 for apartment buildings. Use Table 1. Sample 1 represents condominiums and Sample 2 represents apartment buildings....

Subjects