Use my Excel Spreadsheet for Chapter 12 and build on that.

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?

Selling Price NPV $240.00 $270.00 $3,047.99 $14,133.38 $300.00 $31,3 15.70 $330.00 $380.00 $48,497.52 $65,679.34 $15.70 Selling Price per unit Annuel Quantity Sold Variable Cast per unit WACC Reinvestment Rate Tax Rule Software Link Bot $300.00 500 $ 150.00 10.09 9.0% 34% Cuantity NPN 250 300 531,357 -511,638.84 $11,638.84 -53,047.93 350 400 450 500 $5.542.98 $14,133.88 $22,724.79 $31, 315.70 $ Year Year 2 MV Building NPV $312.0 $60,000.00 $80,000.00 $100,000.00 $120,000.00 $140,000.00 $1,411.57 $9.497.52 $20,406.61 $31,315.70 542,224.79 $ 1 0 3100,000.00 $20,000.00 $50,000.00 $30,000.00 Market Value Burg ReakVALA Ruding WWEquip MV NCWC S10 000 00 2 $120.000.00 $0.00 $30,000.00 $30,000.00 . NOMIC $0.00 $ Quantity Sold impact on NPV $30,000.00 5: 53.0 Sales Revue Variable Cast Fixed cost Software Lease sunk cost S0.00 Building Depreciation incrementall Equipment Depreciation EDIT Takes NI OCF $ 152,800.00 PVOCF $152,800.00 NPV $31,315.70 IRR 22.04% MIRR 20.545 Por $ 245.32 319 $150,000.00 $150,000.00 $75,000.00 $75,000.00 $25,000.00 $25,000.00 $0.00 $0.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $30,000.00 $30,000.00 $10,200.00 $10,200.00 $19,800.00 $19,800.00 $39,800.00 $179,000.00 $36 18! $147,933.88 $31,315.70 $20,000.00 $15/113.30 S10,000.00 SENDO.cn 5000 Selling Price vs. NPV $70,000. 290 450 501 sro nam $10,000.00 $50,000.00 - DILDO $40,000.00 2 $30,000 $20,000.00 $10,000.00 2 SODO 0 20,000 $ 50,000 $ $310.00 1 10,000 40,000 $ 5270.00 Building Book Vale WW Machine RV 5300.00 S 5 $38000 $260.00 30 000 -SERIE 1 Selling Price NPV $240.00 $270.00 $3,047.99 $14,133.38 $300.00 $31,3 15.70 $330.00 $380.00 $48,497.52 $65,679.34 $15.70 Selling Price per unit Annuel Quantity Sold Variable Cast per unit WACC Reinvestment Rate Tax Rule Software Link Bot $300.00 500 $ 150.00 10.09 9.0% 34% Cuantity NPN 250 300 531,357 -511,638.84 $11,638.84 -53,047.93 350 400 450 500 $5.542.98 $14,133.88 $22,724.79 $31, 315.70 $ Year Year 2 MV Building NPV $312.0 $60,000.00 $80,000.00 $100,000.00 $120,000.00 $140,000.00 $1,411.57 $9.497.52 $20,406.61 $31,315.70 542,224.79 $ 1 0 3100,000.00 $20,000.00 $50,000.00 $30,000.00 Market Value Burg ReakVALA Ruding WWEquip MV NCWC S10 000 00 2 $120.000.00 $0.00 $30,000.00 $30,000.00 . NOMIC $0.00 $ Quantity Sold impact on NPV $30,000.00 5: 53.0 Sales Revue Variable Cast Fixed cost Software Lease sunk cost S0.00 Building Depreciation incrementall Equipment Depreciation EDIT Takes NI OCF $ 152,800.00 PVOCF $152,800.00 NPV $31,315.70 IRR 22.04% MIRR 20.545 Por $ 245.32 319 $150,000.00 $150,000.00 $75,000.00 $75,000.00 $25,000.00 $25,000.00 $0.00 $0.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $30,000.00 $30,000.00 $10,200.00 $10,200.00 $19,800.00 $19,800.00 $39,800.00 $179,000.00 $36 18! $147,933.88 $31,315.70 $20,000.00 $15/113.30 S10,000.00 SENDO.cn 5000 Selling Price vs. NPV $70,000. 290 450 501 sro nam $10,000.00 $50,000.00 - DILDO $40,000.00 2 $30,000 $20,000.00 $10,000.00 2 SODO 0 20,000 $ 50,000 $ $310.00 1 10,000 40,000 $ 5270.00 Building Book Vale WW Machine RV 5300.00 S 5 $38000 $260.00 30 000 -SERIE 1