Question

In: Finance

(20 Marks) Homantin, Inc. is considering a project for opening a new sporting goods store in...

(20 Marks)

Homantin, Inc. is considering a project for opening a new sporting goods store in a suburban mall. Homantin will lease the needed space in the mall. Equipment and fixtures for the store will cost $600,000. It is the accounting policy of the company to depreciate equipment and fixtures over a 5-year period on a straight-line basis with no residual value. However, the manager expects equipment and fixtures to be sold at $20,000 at the end of 5 years. The new store will require Homantin to increase its net working capital by $200,000 when the project is launched. First-year sales are expected to be $1,000,000 and to increase at an annual rate of 7 percent over the expected 5-year life of the store. Operating expenses (including lease payments and excluding depreciation) are projected to be $800,000 during the first year and increase at a 6 percent annual rate. Homantin’s marginal tax rate is 35 percent and Homantin needs to pay capital gain tax. Assume that the required rate of return for Homantin is 15%.

Required:

(a)

Evaluate the initial outlay of the project.

(b)

Analyze the annual net cash flows for the first 4 years of the project. Please show your calculation steps in a table.

(c)

What is the annual net cash flow at the end of the project?

(d)

Discuss whether you would accept or reject the project if the required payback period is 4 years.

(e)

How about your decision if profitability index and internal rate of return are employed, respectively?

(f)

What would be your decision if the net present value rule is used?

Solutions

Expert Solution

Answer (a):

Initial outlay of the project = Cost of equipment and fixtures + increase in net working capital

= $600,000 +$200,000

= $800,000

Initial outlay of the project = $800,000

Answer (b):

Annual net cash flows for the first 4 years of the project:

Answer (c):

Annual net cash flow at the end of the project ( Year 5):

Answer (d):

As calculated above:

Payback period = 4.05 years

As such you would reject the project if the required payback period is 4 years.

Answer (e):

As calculated above:

Profitability index of the project = 0.97

IRR of the project = 13.94%

Project should be rejected since:

(i) Profitability index < 1

(ii) IRR < Required rate of return

Answer (e):

As calculated above (table in answer d above):

NPV = - $27,626.25

Project should be rejected if the net present value rule is used since NPV is negative.


Related Solutions

Benford Inc. is planning to open a new sporting goods store in a suburban mall. Benford...
Benford Inc. is planning to open a new sporting goods store in a suburban mall. Benford will lease the needed space in the mall. Equipment and fixtures for the store will cost $400,000 and be depreciated over a 5-year period on a straight-line basis to $0. The new store will require Benford to increase its net working capital by $375,000 at time 0. First-year sales are expected to be $1.2 million and to increase at an annual rate of 7...
Bill Thompson is the new manager of a retail sporting goods store in Vermont that is...
Bill Thompson is the new manager of a retail sporting goods store in Vermont that is part of a national chain. Bill, who is 25 years old, has been working for the company for four years. Before his promotion, he was the assistant manager for two years at a company store in Delaware. Last week his boss, the regional manager, briefly introduced him to the employees. The profit performance of this store is below average for its location, and Bill...
Cost of Reworked Units Warren’s Sporting Goods Store sells a variety of sporting goods and clothing....
Cost of Reworked Units Warren’s Sporting Goods Store sells a variety of sporting goods and clothing. In a back room, Warren’s has set up heat transfer equipment to personalize T-shirts for Little League teams. Typically, each team has the name of the individual player put on the back of the T-shirt. Last week, Shona Kohlmia, coach of the Terrors, brought in a list of names for her team. Her team consisted of 12 players with the following names: Mary Kate,...
Walmart is considering opening a small experimental store in New York City. A store is expected...
Walmart is considering opening a small experimental store in New York City. A store is expected to have a long economic life, but the valuation horizon is 15 years. The store in New York is likely to generate revenues of $36M in the first year and then it grows at 5.0%. But the costs of running the business are high because the margins on all the products sold are low. (It is a volume business!) The cost of goods sold...
Walmart is considering opening a small experimental store in New York City. A store is expected...
Walmart is considering opening a small experimental store in New York City. A store is expected to have a long economic life, but the valuation horizon is 19 years. The store in New York is likely to generate revenues of $30M in the first year and then it grows at 5.0%. But the costs of running the business are high because the margins on all the products sold are low. (It is a volume business!) The cost of goods sold...
Bold Bodybuilders, Inc. is a large sporting goods store. It has become the exclusive distributor of...
Bold Bodybuilders, Inc. is a large sporting goods store. It has become the exclusive distributor of the new bodybuilding equipment called Geni. After carrying the equipment for a year, Joe Sabatini, a manager of the supply chain, decided to analyze the company's inventory policy for Geni. On the basis of the past year's record, Joe has identified the following weekly demand data: Weekly Demand Occurrence, Week 95 8 96 2 97 6 98 10 99 8 100 6 101 6...
Ridgeland Inc. makes backpacks for large sporting goods chains that are sold under the customers' store...
Ridgeland Inc. makes backpacks for large sporting goods chains that are sold under the customers' store brand names. The Accounting Department has identified the following overhead costs and cost drivers for next year: Overhead Item Expected Cost Cost Driver Maximum Quantity Setup Cost 489,600 Number of Setups 7,200 Ordering Cost 130,000 Number of Orders 65,000 Maintenance 920,000 Number of Machine Hours 80,000 Power 88,000 Number of Kilowatt Hours 440,000 Total predicted direct labor hours for next year is 42,500. The...
Ridgeland Inc. makes backpacks for large sporting goods chains that are sold under the customers' store...
Ridgeland Inc. makes backpacks for large sporting goods chains that are sold under the customers' store brand names. The Accounting Department has identified the following overhead costs and cost drivers for next year: Ridgeland Inc. makes backpacks for large sporting goods chains that are sold under the customers' store brand names. The Accounting Department has identified the following overhead costs and cost drivers for next year: Overhead Item Expected Costs Cost Driver Maximum Quantity Setup costs $244,800 Number of setups...
Managers of CVS Pharmacy are considering a new project. This project would be a new store...
Managers of CVS Pharmacy are considering a new project. This project would be a new store in Odessa, Texas. They estimate the following expected net cash flows if the project is adopted. Year 0: ($1,250,000) Year 1: $200,000 Year 2: $500,000 Year 3: $400,000 Year 4: $300,000 Year 5: $200,000 Suppose that the appropriate discount rate for this project is 7.7%, compounded annually. Calculate the net present value for this proposed project. Do not round at intermediate steps in your...
Managers of CVS Pharmacy are considering a new project. This project would be a new store...
Managers of CVS Pharmacy are considering a new project. This project would be a new store in Odessa, Texas. They estimate the following expected net cash flows if the project is adopted. Year 0: ($1,250,000) Year 1: $200,000 Year 2: $500,000 Year 3: $400,000 Year 4: $300,000 Year 5: $200,000 Suppose that the appropriate discount rate for this project is 5.2%, compounded annually. Calculate the net present value for this proposed project. Do not round at intermediate steps in your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT