pls tell me the answer

Question 1.120 marks) You just graduated from Humber Colleges Marketing Management Postgraduate certificate program and were immediately hired by Kellogg's to work as the Associate Brand manager for Rice Krispies Your first project is to determine if it would be a worthwhile endeavor to launch a new Rice Krispies with Strawberries product. After conducting a thorough market research program which cost $ 78,230, you develop a five- year forecast (The assumption is that this product will only be sold for five years and then replaced with a new version) Below are the number of cereal boxes forecasted for sale for the next 5 years 2022 2023 2024 2025 2026 110,000 150,000 200,000 140,000 100.000 The assumption below will be used in your new product launch analysis Price percental box $2.35 Cost of Goods 31.25. Advertising expense $50,000 per year. Depreciation expenso $40,000 per year. Tax Rute 40% The company will need to purchase now equipment costing $200,000 to manufacture this product. This equement will be sold for $17.000 at the end of 2026 as scrap. The OCA rate for this equipment is 20%. The company will be required to initially purchase $30,000 worth of strawberries as inventory The company's required rate of return is 20% 1. Create an income statement for this new product for each of the 5 years 2. Calotate the NPV of this project Include in your analysis the Operating Cashflows (EBITDEPRECIATION - Taxes), CCA tax shold Working Capital, Salvage value, and equipment costs. Should the company accept this project? 3. Calculate IRR, Payback Discounted Payback and Profitability Index 4. When presenting to the executive management team what types of questions should you anticipe from them? Also explain to the management team why you should not include the Market Research expenses in your analysis