The Ebitts Field Corp. manufactures baseball gloves. Charlie Botz, the company's top salesman, has recommended expanding into the baseball bat business. He has put together a project proposal including the following information in support of his idea.

• New production equipment will cost $75,000, and will be depreciated straight line over five years.
• Overheads and expenses associated with the project are estimated at $20,000 per year during the first two years and $40,000 per year thereafter.
• There is enough unused space in the factory for the bat project. The space has no alternative use or value.
• Setting up production and establishing distribution channels before getting started will cost $300,000 (tax deductible).
• Aluminum and Wood bats will be produced and sold to sporting goods retailers. Wholesale prices and incremental costs per unit (direct labor and materials) are as follows:

Aluminum Wood

Price $18 $12

Cost 11 9

Gross Margin $ 7 $ 3

Charlie provides the following unit sales forecast is (000):

Year 1 2 3 4 5 6

Aluminum 6 9 15 18 20 22

Wood 8 12 14 20 22 24

• The sixth year sales level is expected to hold indefinitely.
• Receivables will be collected in 30 days, inventories will be the cost of one month's production, and payables are expected to be half of inventories. Assume no additional cash or accruals are necessary. (Use 1/12 of the current year's revenue and cost for receivables and inventory.)
• Ebitts Field's marginal tax rate is 35% and its cost of capital is 12%.

a. Develop a six-year cash flow estimate for Charlie's proposal. Work to the nearest $1,000.

b. Calculate the payback period for the project.

c. Calculate the projects NPV, assuming a six-year life. Is the project acceptable?

d. Is the cost of capital an appropriate discount rate for the project considering its likely risk relative to that of the rest of the business? Why?

e. What is the project's NPV if the planning horizon is extended to eight years? (Add the incremental PV from two more years at year 6's cash flow.)

f. What is the NPV if management is willing to look at an indefinitely long time horizon? (Hint: Think of the cash flows in years 6 and beyond as a perpetuity.)

g. Comment on the results of parts e. and f.

PLEASE SHOW FORMULAS USING GOOGLE SHEETS