The Ballpark Company is evaluating the market potential of brightly colored bowling balls. The results of an initial questionnaire that Ballpark has conducted in major markets six months ago and cost $50,000 were positive. A more comprehensive market test study that will cost an additional $250,000 was just completed and affirmed at least a 15% of the total bowling ball market. Ballpark has not yet paid for this study.

Now Ballpark is at the point where it is considering investing in the assets needed to produce the colored balls. The balls would be produced in a building owned by the firm. The building, which was bought by Ballpark 20 years ago for $60,000, is currently vacant but it can be sold for $160,000. The value of the building on Ballparks books is $32,000. Ballpark can depreciate this $32,000 over four years on a straight-line basis. In order to estimate the market value of the building at projects end, the company assumes that the price change will follow the trend experienced in the last 20 years. The land on which the building sits was bought for $51,000 twenty years ago and it is valued at $136,000 today. The expected appreciation in the land value is 4% per year over the coming ten-year period. Ballpark assumes that it will be able to sell both the building and the land together at their expected values at the end of the projects life. The price of the new equipment needed is $912,000. It will require an additional $48,000 in shipping and installation costs. The useful life of the machine is 15 years but the company intends to use it for only the ten years that is the life of the project and then sell it at the termination of the project. It estimates its salvage value at $512,000. Production is estimated to be 37,500 units in the first year, rising by 17% per year for the following five years then falling by 7% per year for the remaining life of the project. The price of the balls in the first year will be $28. The bowling ball market is highly competitive and Ballpark believes that the price will increase by 3.5% per year. However, the plastic used to produce bowling balls is rapidly becoming more expensive. Variable production costs that will be $11 per unit in the first year will rise by 14% per year for the next four years then by 8% per year for the following five years. Total fixed costs excluding depreciation expense is assumed to stay constant at $480,000 per year for the life of the project. In addition, Ballpark is aware of the fact that some of the demand for its colored balls will be the result of shifting demand from its sales of the old black balls. It estimates that the new production will replace 3,200 units per year that bring in an after-tax EBIT of $13 per unit. The marginal tax rate applicable to this project is 25%. Ballpark anticipates that it will maintain an investment in working capital equal to $48,000 initially (at time point zero) and rising by 4% per year in the first seven years then declining by 16% in each of years eight and nine before is completely retrieved in year ten. Ballpark uses the straight line depreciation for all its depreciable assets.

This is all of the information that is needed to calculate the following.

I) On an Excel spreadsheet, estimate the following:

1. Initial net investment (NINV) (show it clearly in one box)

2. Total after-tax salvage value (ATSV) for all assets (clearly show details for each salvageable asset in another box)

3. The annual depreciation schedule

4. The annual incremental investment in NWC

5. Annual free cash flows (FCF) At this point in the project, assume that the required rate of return on Ballparks project of similar risk is 15%.