C funding to ask for in exchange for how much ownership you'll give up$.$

following $2$ Notes apply!

NOTE $1$: You must show ALL your work. Either your computations are in the cell behind your res or you must place them out to the right on the Forecasted Financials tab. If you choose to show your work out to the right, show all steps and label your work clearly so it can be understood.

NOTE $2$: Do not round computations until you have found your final answer. Then, round your result to the nearest dollar. No pennies!

EMENTS:

TONE $1$: Sales & Gross Profit Forecast $(40$ points$)$

DUE: WEEK $3$

It's currently January $1,2023,$ and you'll be going on Shark Tank in $2$ weeks. Using the information below, create your $5-$year Sales, Cost of Goods Sold $($COGS$),$ and Gross Profit forecast for the years $2023-2027.$

Information:

$1$ Actual annual sales in the past:

$\backslash$table$[[,2020,2021,2022],[$Actual SALES,########$,$#################$,]]$

$2$ Because you feel your most recent sales are the best predictor of future sales, you weight your sales as follows: $w_1=0\mathrm{.}2$ and $w_2=0\mathrm{.}8$

$3$ You are certain you can get volume discounts on your parts and materials now that your Sales are expected to increase. So$,$ you estimate your COGS will be $52\%$ of Sales, which is less than it has been in the past.

Required:

Scenario & Requirements

Milestone $1$ Sales Forecast

Milestone $1$ Questions

Grading $R$

RUBRIC

ff Accessibility: Investigate

Type here to search