Fill in the empty spreadsheet

The Can-Do Co. is analyzing a proposed project. The company expects to sell 12,000 units. The sale price is estimated at $14 a unit. The expected variable cost per unit is $7 and the expected fixed cost is $36,000. The depreciation expense is $30,000. The tax rate is 34%. Other information: Capital expenditure is $100,000; the project will last for 5 years, and the company's WACC is 12% You have just finished calculating the NPV of this project as follow when you are informed that some input numbers have changed. Situation 1: (For students whose the last digit of the student ID is an odd number) The sale figure and price both increased by 10% while the fixed and variable cost estimates decreased by 6%. What are the new NPV? Please show your work by filling in the empty spreadsheet. INPUT Quantity 12,000 Price 14 Variable Cost Fixed Cost 36,000 Depreciation 30,000 100,000 Capital Exp Project Life 34% Tax 12% WACC OUTPUT BASE 1 0 to 5 Year Cap. Exp. -100,000 Sales Variable Cost 168,000 84,000 36,000 30,000 Fixed Cost Depreciation EBIT 18,000 Tax 6,120 Net Income 11,880 Depreciation 30,000 Operating CF 41,880 CFO -100,000 41,880.00 NPV= $50,968.03 INPUT Quantity Price Variable Cost Fixed Cost Depreciation Capital Exp Project Life Tax WACC OUTPUT Year Cap. Exp. Sales Variable Cost Fixed Cost Depreciation EBIT Tax Net Income Depreciation Operating CF CFO NPV=