make sure to answer with clear formulas

1. Read Case: Sneaker 2013 2. Download the Sneaker 2013 template 1. Watche Sneaker 2013 022) for an overview pertaining to edities in preparing the Sneaker 2013 ne sy tignment 4. Watch Intro to Capital Budgeting 3523 for an explanation of the cameras tot by the authors Use the facts provided in the Guto complete the Sneaker 2011 tab in the template out the mons provided in the case for each year of the project The mote contain several tungtion De not sume that the template contains all of the motions nee that will of the assumptions provided in the template should be used to the whom te b.toms in the bottom portion of the template to call at the proforma come tente congetworking crita en el conte sending in order to ever 6. Use the coded in the came to come here to the utions de theme for each year the The manomber of the im De note that the template contains all of the mount or that all of the common provided in the template huld be me instructions beste forma in the timom portion of the wodate to calculate the proforma income moment to change time we can het out sounding to co in Oston Responses to the engin the B D E H This template is designed to provide a framework to analyze the Sneaker 2013 project DO NOT ASSUME THAT ALL OF THE LINE ITEMS BELOW REPRESENT WHAT SHOULD BE INCLUDED IN THE ANALYSIS IF A LINE ITEM IS NOT INCLUDED IT SHOULD BE ADDED - IF A LINE ITEM IS NOT APPLICABLE DO NOT INPUT VARIABU 0 1 2 3 4 5 6 2012 2013 2014 2015 2016 2017 2018 Sales units Sale price per unit 1 Lost sales 2 Variable costs 3 SG&A 14 Endorsement 15 Adv & promotion 16 Research & development 17 Interest costs 18 Accounts receivable 19 Inventory 20 Accounts payable 21 Factory 22 Factory - MACRS % 23 Equipment 24 Equipment- MACRS % 25 Tax rate 26 Discount rate 27 28 UTILIZE THIS SECTION TO PREPARE THE PROJECT ANALYSIS 29 INCLUDE FORMULAS TO REFERENCE THE VARIABLES IN THE ASSUMPTIONS SECTION ABOVE 30 SNEAKER 2013 - Project Cash Flows 31 S millions 82 0 1 2 3 4 5 6 33 2012 2013 2014 2015 2016 2017 2018 34 Revenues 35 36 Include the necessary line items to arrive at EBIT 37 38 EBIT 39 Taxes 40 NOPAT (NI) 41 Add: Depreciation 42 (OCF 43 B c E F G Factory - MACRS % Equipment Equipment - MACRS % Tax rate Discount rate 6 2010 2018 3 UTILIZE THIS SECTION TO PREPARE THE PROJECT ANALYSIS 9 INCLUDE FORMULAS TO REFERENCE THE VARIABLES IN THE ASSUMPTIONS SECTION ABOVE E SNEAKER 2013 - Project Cash Flows 31 Smillions 32 0 2 3 4 5 33 2012 2013 2014 2015 2016 2017 34 Revenues 35 36 Include the necessary line items to arrive at EBIT 37 38 EBIT 39 Taxes 40 NOPAT (=NI) 41 Add: Depreciation 42 OCF 43 44 Change in NWC 46 Net capital spending 47 48 Project cash flows 49 51 NPV 52 RR 53 Payback period 54 55 57 60 01