Ta Year 1 350,000 150,000 100,000 Year 2 500,000 175,000 100,000 34% 10% Year 3 650.000 225,000 100,000 Year 4 600,000 210,000 100,000 a) Complete this table to find the Cash Flows from Operations (2 marks) Use Excel functions and/or formulas to complete the following Sales Variable Costs Fixed Costs EBT CF from Operations (Excluding CCA) PV of Operating Cash Flows b) Calculate Initial Investment (1 mark) Equipment cost Investment in Net Working Capital (NWC) Initial Investment (575,000.00) (25,000.00) c) What is the PV of CCA Tax Shield (1 mark) 575,000.00 20.00% C = Capital Cost d =CCA rate for asset class T=Corporate Tax rate r = cost of capital (WACC) rate S = salvage value of asset n = years PV of CCA Tax Shield 30,000.00 loo not adjust this formula d) What is the PV of the ending cash flows? (1 mark) Salvage Value Return of Networking capital Ending Cash Flows (CF) PV of Ending C 30,000.00 25,000.00 e) What is the project NPV? (1 mark) Initial Investment NPV of CF Opns After Tax (Excluding CCA) PV of Ending Cash flows PV of CCA Tax Shield NPV of Project Proceed with project? (yes or No) Yes/No because NPV>