Excel Activity: Issues in Capital Budgeting

units per year.

$x$

Download spreadsheet Ch$13$ P$18$ Build a Model$-06$f$3$ab$,$xlsx

NPV $

IRR $\%$

Regular payback period

years

answers to the nearest dollar. Use a minus sign to enter a negative value, if any.

$\%$ Deviation from

NPV with Variables at Different Deviations from Base

Choose the correct graph.

The correct graph is $].$

negative value, if any.

Scenario

NPV

Worst Case $

Expected NPV $

Standard Deviation $

Coefficient of Variation

negative value, if any.

Risk$-$adjusted NPV

Risk$-$adjusted IRR

$

Risk$-$adjusted regular payback period

$\%$

years