This week you are to create and use data tables to analyze the impact three variables on the NPV of last week's project: Price, Quantity and expected Selling Price of Building in year two. For each table center on the baseline value (selling price, quantity sold, etc) but go down and up 40% in 10% increments.

Which of these three variables seems to present the greatest impact on our expected NPV ON A PERCENTAGE BASIS? For example a 10% downward turn in which of those variables presents the most danger?

$300.00 500 $150.00 10.0% Selling Price NPV Selling Price per unit Annual Quantity Sold Variable Cost per unit WACC Reinvestment Rate Tax Rate Software Lense (sunk cost) $ $240.00 $270.00 $300.00 $330.00 $380.00 $ $ $3,047.93 $14,133.88 $31,315.70 $48,497.52 $65,679.34 Quantity NPV 250 300 350 400 450 500 -$11,638,84 -53,047,93 $5,542.98 $14,133.88 $22,724.79 $31,315.70 Year 2 MV Building NPV 34% 50 Year O 1 $100.000.00 $120,000.00 $20.000.00 $10,000.00 $ $0.00 550,000.00 $30,000.00 $30,000.00 $ $0.00 $30,000.00 $60,000.00 $80,000.00 $100,000.00 $120,000.00 $140,000.00 $1,41157 $9.497.52 $20,406.61 $31,315.70 $42.224.79 $ $ Muket Value Building Book Value Buliding WW Equip MV A NOW Quantity Sold impact on NPV Sales Revue $150,000.00 $150,000.00 Variable Cost $75,000.00 $75,000.00 Fixed cost $25,000.00 $25,000.00 Software Lease sunk cost) $0.00 $0.00 $0.00 Building Depreciation (incremental) $10,000.00 $10,000.00 Equipment Depreciation $10,000.00 $10,000.00 EBIT $30.000.00 $30,000.00 Taxes $10,200.00 $10,200.00 NI $19.800.00 $19,800.00 OCF-$152,800.00 $39,800.00 $179.000,00 PVOCF $152,800.00 $36,181.82 $147,933.88 NPV $31,315.70 $31,315.70 IRR 22.04% MERR 20.64% Pe $ 245.32 Q 318 $15.000.00 $10.000.00 $ 525.000.00 530,000.00 $15.000 $10,000.00 S500 $0.00 55,000.00 -$10.000.00 515.000.00 Selling Price vs. NPV $70,000.00 S000 250 30 400 450 $50,000.00 $40.000.00 $30.000.00 $20.000.00 $10.000.00 2 $0.00 Building Book Value ww Machine BV O 20,000 $ 50,000 $ $ $ 1 10,000 $ 40,000 $ $220.00 $20.00 $300.00 5330.00 5360.00 30,000 $10.000.00