Input area:

$\backslash$table$[[\backslash$table$[[$Initial cost$],[$Unit sales$],[$Price$/$unit$],[$Variable cost$/$unit$],[$Fixed costs$],[$Project life$]],\backslash$table$[[$Required return$],[$Tax rate$],[$Unit sales uncertainty$],[$Variable cost uncertainty$],[$Fixed cost uncertainty$]],-],[$Question $1,,?],[$Best Case,Worst Case$]]$

Unit sales

Variable cost$/$unit

Fixed costs

Sales

Variable cost

Fixed cost

Depreciation

EBIT

Taxes $(21\%)$

Net income

OCF

NPV

Question $2$

Accounting break$-$even

$\backslash$table$[[,]]$

Question $3$

Cash break$-$even

Question $4$

OCF at financial$-$break even Financial break$-$even

$$

Question $5$

Degree of operating leverage

$\backslash$table$[[($ignoring Taxes$)]]$

$\backslash$table$[[($ignoring Taxes$),($with Taxes$)]]$

$\backslash$table$[[($ignoring Tax$$s$),($with Taxes$)],[,]]$

Question $6$

Draw graph of "Sensitivity of NPV to changes in unit price"

$\backslash$table$[[$Unit Price$],[],[5,500],[5,750],[6,000],[6,250],[6,500],[6,750],[7,000],[7,250],[7,500],[7,750],[8,000]]$

please provide excel formulas