For the following project, calculate the annual cash flow.

Year $012345$

Unit Price $-$ $$105$ $$110$ $$115$ $$120$ $$125$

Units Sold $-9001000110012001300$

Net Sales $-$

Variable Costs $-$ $$54,000$ $$60,000$ $$66,000$ $$72,000$ $$78,000$

Fixed Costs $-$ $$15,000$ $$15,750$ $$16,538$ $$17,364$ $$18,233$

Depreciation $-$ $$10,000$ $$10,000$ $$10,000$ $$10,000$ $$10,000$

PBIT $-$

Tax@$40\%-$

NOPAT $-$

Adjustments:

Add back Depreciation $-$

CapEx $-$$$100,000-----$

Salvage value $-----$ $$40,000$

Net cash flow

Cumulative cash flow

Use an Excel spreadsheet to graph the cumulative cash flow.