I need help filling out the cash flow for persistence sneaker. Template attached with information

Effective tax rate 40% Persistence Project life 3 years Wholesale price 90 Hiking segment during 2013 350 million Annual growth rate 15% Market share projections for Persistence Year 2013 2014 2015 Market 15% 18% 20% Overhead allocation I.8 million per year Firm would still incur these costs if the project were not undertaken BUT this section would be idle for the life of th eproject if the Persistence project were not undertaken. Manufacturing equipment purchased (2102) 8 million Depreciation rates Year 2013 2014 2015 20.0% 32.0% 19.0% Sale of equipment at end of project 2.32 Increase in inventory and AR in 2012 25 million Recovered at end of project (2015) Increase in AP balance in 2012 10 million Recovered at end of project (2015) Variable costs 38%% of shoe's sales General and administrative costs Year 2013 2014 2015 % of revenue 12.0% 10.0% 8.0% Adv and prom 3.00 2.00 2.00 Federal and state marginal tax rate 40% Cost of purchasing design technology and mig specs 50 million Annual interest costs on debt 0.6 million Cost of capital for the hiking shoe 14%Persistence 2013 Projected Project Cash Flow Statements ($ millions) 2012 2013 2014 2015 2016 2017 2018 Revenues Cannibalization Net revenues 10 Variable costs SG&A 12 Endorsement 13 Other advertising & prom 14 Other 15 Factory depreciation 16 Equipment depreciation 7 Income before taxes 18 Taxes 19 Net income after taxes 50 Add back factory depr. ignore tax shield Add back equpment depr ignore tax shield 52 WC change $3 New factory ignore tax gain (loss) 54 Equpment ignore tax gain (loss) 55 Net cash flows 56 Cum cash flow Present Value $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 58 SUM = NPV IRR #NUM! 60 Payback Pd #DIV/01 years 61 Working capital: 63 AR 64 Inventory 65 AP 66 Net WC 67 Cash impact 39 70