Project L: This project requires an initial investment of $2,000,000 in equipment which will cost an additional $75,000 to install. The firm will use the attached MACRS depreciation schedule to expense this equipment. Once the equipment is installed, the company will need to increase net working capital by $100,000. The project will last 6 years at which time the market value for the equipment will be $180,000. The project will project a product with a sales price of $32.00 per unit and the variable cost per unit will be $11.00. The fixed costs would be $110,000 per year. Because this project is very close to current products sold by the business, management wants you to apply the WACC as the discount rate to the project. Years 2014 2015 2016 2017 2018 2019 Forecasted Units Sold 32,000 45,000 48,000 58,000 75,000 90,000

Scenario Analysis (Price) -- (10% of total grade) Create a second valuation spreadsheet of the projects provided by your instructor. This should measure the sensitivity of the project as reflected by a 10% reduction in price. Evaluate both projects according to the following valuation method: Net Present Value of Discounted Cash Flow (use WACC number for discount rate) Internal Rate of Return Provide a synopsis evaluation of each project and provide a clear recommendation of which project management will accept for its capital expenditures budget based on textbook decision rules. Scenario Analysis (Volume) -- (10% of total grade) Create a second valuation spreadsheet of the projects provided by your instructor. This should measure the sensitivity of the project as reflected by a 10% reduction in units sold. Evaluate both projects according to the following valuation method: Net Present Value of Discounted Cash Flow (use WACC number for discount rate) Internal Rate of Return Provide a synopsis evaluation of each project and provide a clear recommendation of which project management will accept for its capital expenditures budget based on textbook decision rules.

Bonds	60,000	Preferred Stock		Common Stock
Periods left until Maturity	15 years	Stock Par Value	$ 100.00	Current market price per share	$ 17.00
Coupon Rate	10%	Dividend Per Share	$ 9.00	Last Dividend paid	$ 0.65
Semiannual Payment	$ 50.00	Current market price per share	$ 90.00	Dividend Growth Rate	10%
Current Price	$ 874.78			Risk free rate	6%
Face Value	$ 1,000.00			Stock market return	13%
				Firm's Beta	1.22
Tax Rate	40.0%			Cost of Equity: CAPM Method	14.54%
Cost of Debt (BT)	11.80%	Cost of Preferred Stock		Cost of Equity: DDM Method	14.21%
				Cost of Common Equity (Avg)	14.38%
	Market Values	Market Weights
Total Bonds	$ 52,486,800	0.36%		Weighted Average Cost of Capital	11.50%
Total Preferred Stock	$ 85,000,000	0.58%
Total Common Stock	$ 9,000,000	0.06%
Total Firm Value	$ 146,486,800	1

PRICE REDUCTION SCENARIO
Initial Cost	$ 2,000,000	Price	$ 28.80	Tax Rate	40%
Installation Cost	$ 75,000	Variable Cost	$11.00	Required Return	0.00%
Increase in NWC	$ 100,000	Fixed Cost	$ 110,000
Salvage Value	$ 180,000
		Year 1	Year 2	Year 3	Year 4	Year 5	Year 6
Units sold		32,000	45,000	48,000	58,000	75,000	90,000
Depreciation Rate		20.0%	32.0%	19.0%	12.0%	11.0%	6.0%
Years		1	2	3	4	5	6
Sales		$921,600	$1,296,000	$1,382,400	$1,670,400	$2,160,000	$2,592,000
Variable Cost		$352,000	$495,000	$528,000	$638,000	$825,000	$990,000
Fixed Cost		$110,000	$110,000	$110,000	$110,000	$110,000	$110,000
EBITDA		$459,600	$691,000	$744,400	$922,400	$1,225,000	$1,492,000
Depreciation		$400,000	$640,000	$380,000	$240,000	$220,000	$120,000
EBIT		$59,600	$51,000	$364,400	$682,400	$1,005,000	$1,372,000
Tax Expense		$23,840	$20,400	$145,760	$272,960	$402,000	$548,800
Net Income		$35,760	$30,600	$218,640	$409,440	$603,000	$823,200
	Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6
Operating Cash Flow	-1,975,000
Capital Spending Cash Flow
Net Working Capital Cash Flow
Total Cash Flows
Total Cumulative Cash Flows
Internal Rate of Return			Payback Period
Net Present Value	$ (397,249.55)		Profitability Index
VOLUME REDUCTION SCENARIO
Initial Cost		Price		Tax Rate
Installation Cost		Variable Cost		Required Return
Increase in NWC		Fixed Cost
Salvage Value
		Year 1	Year 2	Year 3	Year 4	Year 5	Year 6
Original Volume Sold
Reduced Volume Sold
Depreciation Rate
Years		1	2	3	4	5	6
Sales
Variable Cost
Fixed Cost
EBITDA
Depreciation
EBIT
Tax Expense
Net Income
	Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6
Operating Cash Flow
Capital Spending Cash Flow
Net Working Capital Cash Flow
Total Cash Flows
Total Cumulative Cash Flows
Internal Rate of Return			Payback Period
Net Present Value			Profitability Index