$x$

AutoSave

Off

Ch$09$ Spreadsheets $($compl$...-$ Saved to this PC $$

Search

C$30$

Data:

Asset Purchase

Asset Sale

Length of Project

CCA Rate, $d$

Corporate Tax Rate, Tc

Opportunity Cost of Capital

Revenues per year

Costs $($excluding CCA$)$ per ye

Net Working Capital Items

Cash required for the projec

Inventory

Accounts Receible

Accounts Payable

$$600,000\mathrm{.}00$

C $xvvfx$ A B

$5$

Net Horking Capital Required:

Change in NHC:

$$100,000\mathrm{.}00$

Year $0$

$5$ Years

$($Reu$-$Co $-$ CapEs

Change in $NWW$

CCA effects excluded

FCF exoluding CCA

NPV of above

PVCCA tax shields

NPY

Pl$($assuming capital rationing$)$

$$

Financing Cash Flows

NWC impact on FCF

CCA Calculations by Year

NPV sheet

Self$-$study

Ready

Accessibility: Investigate