Build a 10-year discounted cash flow model based on the provided data to analyze the opportunity. Using the provided data calculate the WACC and use this as your discount rate. Build a base case based on the provided data, analyze the results. Build an optimistic case based on the provided data, analyze the results. Build a pessimistic case based on the provided data, analyze the results. Run sensitivity analysis on the key variables to this business, analyze the results. Run a break-even analysis on the key variables and analyze the results. Determine NPV, IRR, PI, Payback Period for each case analyze the results REALLY JUST NEED THE NPV, IRR,PI AND PAYBACK PERIOD BASE CASE SCARVES Dallas/Ft Worth OPTIMISTIC CASE SAME AS BASE PESSIMISTIC SAME AS BASE SAME AS BASE SAME AS BASE Retail Outlets / Malls SAME AS BASE SAME AS BASE yes SAME AS BASE SAME AS BASE $18.05 SAME AS BASE SAME AS BASE 3.5% SAME AS BASE SAME AS BASE 455000 Product being produced Target Market Primary Sales Channel Online Presence Price of the product (year 1) Annual growth rate on price Number of items sold (year 1) Annual growth rate on units sold Variable cost per unit Variable cost increase each year Fixed Costs Fixed costs increasing each year Depreciation Method (all CAPEX) Depreciation period (all CAPEX) Tax rate 2.75% $5.75 4.25% $3,550,000 3.25% 490000 SAME AS BASE $4.90 SAME AS BASE $3,275,000 SAME AS BASE 375000 SAME AS BASE $6.10 SAME AS BASE $4,100,000 SAME AS BASE straight line SAME AS BASE SAME AS BASE 5 years SAME AS BASE SAME AS BASE 21% Initital Working Capital $550,000 Add'tnl Working Capital One time (year 4) $150,000 Initial Investmnet for Equipment (year 0) $9,500,000 Suplemental Capital Required (year 3) $1,500,000 SAME AS BASE SAME AS BASE $475,000 SAME AS BASE $8,575,000 SAME AS BASE $615,000 SAME AS BASE $9,800,000 SAME AS BASE Market Vale of All Equipment Year 10 $2,000,000 SAME AS BASE SAME AS BASE Risk Free Rate (rfr) Beta (b) S&P 500 Avg Return (MR) Cost on Debt Tax Shield Eligible % of Equity in Cap Structure % of Debt in Cap Structure 3.50% SAME AS BASE SAME AS BASE 1.05 SAME AS BASE SAME AS BASE 11% SAME AS BASE SAME AS BASE 7% SAME AS BASE SAME AS BASE Yes SAME AS BASE SAME AS BASE 75% SAME AS BASE SAME AS BASE 25% SAME AS BASE SAME AS BASE