Register
Quantum Logistics, Inc., a wholesale distributor, is considering the construction of a new warehouse to serve the southeastern geographic region near the Alabama-Georgia border. There are three cities
524,991 views
18 votes
18 votes
Quantum Logistics, Inc., a wholesale distributor, is considering the construction of a new warehouse to serve the southeastern geographic region near the Alabama-Georgia border. There are three cities being considered. After site visits and a budget analysis, the expected income and costs associated with locating in each of the cities has been determined. The life of the warehouse is expected to be 12 years, and MARR is 15%/year. Based on an internal rate of return analysis, which city should be recommended?

Initial Cost Net Annual Income
Clemson: $1,260,000 $480,000
Augusta: $1,000,000 $410,000
Beaufort: $1,620,000 $520,000

User Ipj
by
3.0k points

1 Answer

21 votes
21 votes

Answer: Augusta

Step-by-step explanation:

You can use Excel to calculate the IRRs of each of these cities.

Make a table in Excel that looks like the attachment.

Use the IRR formula to calculate each IRR by using the values of the city (note how Beaufort was done).

Initial investment should be a negative number.

City IRR

Clemson 37%

Augusta 40%

Beaufort 31%

The city with the highest IRR should be recommended and that city is Augusta.

Quantum Logistics, Inc., a wholesale distributor, is considering the construction-example-1
User Avojak
by
3.7k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

1.6m questions

2.0m answers

Other Questions

If the rate of inflation in Japan dramatically increases while the rate of inflation in the United States remains constant, then a. the demand curve for dollars shifts to the left. b. the demand curve
The market value of the equity of Hudgins, Inc., is $582,000. The balance sheet shows $21,000 in cash and $192,000 in debt, while the income statement has EBIT of $93,000 and a total of $137,000 in depreciation
Kylie is risk averse and has $1,000 with which to make a financial investment. She has three options. Option A is a risk-free government bond that pays 5 percent interest each year for two years. Option
Elroy Rocket is entering his senior year as an accounting major and has a number of options for his summer break. His options for the 3 month break follow: (1) Work full time at a local accounting firm
In January of the current year, Dora made a gift of stock to her granddaughter. At the time of the gift, the stock was worth $15,000. Several months later in the same year after the gift, a $500 dividend
Link Copied!