Sugar Land Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by a MBA student. The production line would be set up in unused space (Market Value Zero) in Sugar Land main plant. Total cost of the machine is $330,000. The machinery has an economic life of 4 years and will be depreciated using MACRS for 3-year property class. The machine will have a salvage value of $35,000 after 4 years. The new line will generate Sales of 2,000 units per year for 4 years and the variable cost per unit is $114 in the first year. Each unit can be sold for $220 in the first year. The sales price and variable cost are expected to increase by 3% per year due to inflation. Further, to handle the new line, the firms net working capital would have to increase by $30,000 at time zero (No change in NWC in years 1 through 3 and the NWC will be recouped in year 4). The firms tax rate is 40% and its weighted average cost of capital is 11%. NOTE: Please be sure to properly label your answers and where appropriate, please copy and paste the table into the answer submission box.

a. What are the annual depreciation expenses for years 1 through 4? (10 points)

	Year 1	Year 2	Year 3	Year 4
Depreciation

b. Calculate the annual sales revenues and variable costs (other than depreciation), for years 1 through 4. (10 points)

	Year 1	Year 2	Year 3	Year 4
$ Total Sales
$ Total Variable costs

c. Estimate annual (Year 1 through 4) operating cash flows (15 points)

	Year 1	Year 2	Year 3	Year 4
Tot Sales
Var. Cost
Depreciation
EBIT
Taxes
Net Income
Depreciation
OCF

d. Estimate the after-tax salvage cash flow (5 points) e. Estimate the net cash flow of this project (15 points)

	Year zero	Year 1	Year 2	Year 3	Year4
Net CF of the project

f. Estimate the NPV, IRR, MIRR, and profitability Index of the project. (20 points)

NPV =
IRR =
MIRR =
PI