Your goal is to calculate the NPV of this 5 year project while filling in the missing boxes of information.

Year 1 Year 2 Year 3 Year 4 FIN4030 Cash Budgeting Case Template Proposed capital investment Sunglass project ales Volume Year 1 Year 2 $1,000,000 1,000.000 $ 100,000 50,000 2.300.000 ash Flows Initial Investment Purchase of machine Year $1,000,000 $100,000 In $50,000 Revenue 1,150,000 Variable costs Installation epreciable basis (Machine 1 & 2 Annual depreciation (st. line Salvage value Unit sales (initia Sales growth rice (initial) Price increase Unit cost (initia xed costs epreciation BT axes dd back depreciation perating Cash Flow 100,000 1,000,000 10.00% 5% 3.00 WC apital cash flows ale of machine nnual Cash Flow ion ost in Fixed costs Utilities cost Utilities inflation Employee training 30,000 $2,000 10% $10,000 $70,000 2% 1,460,000 NPV IRR MIRR PI mployee salary Salary inflation Loan from Bank of Viva ax Rate Cost of Capital NWC needs (% of coming year sales Capacity APR of the Loan 10% 5.00 1,000,000 090 Step 2 Annual depreciation % Annual depreciatlon Accumulated depreciation 20.00% $460,000 32.00% 736,000 52% 11.52% 5.76% ok value (Residua