Create an excel worksheet for the company Starbucks Corporation.

Create a Pro Forma Income Statement. Include a list of assumptions please $---$

$1.$forecast the dollar amounts, for each part of your proforma, for the next two years.

Make $9$ columns. Three columns per year for $2022($or $2023>>$take the numbers from the company's last year report$),2023,2024.$

First column is dollars $($your forecast$),$ the second column is the percent those dollars changed from prior year, the third column is the percent of those dollars to total revenue.

All the way down to profit before tax, depreciation, interest, etc. Just go to operating profit.

so$,$ for example

$20232024$

$ $/\%$change$/\%$ of revenue $ $/\%$change $/\%$ of revenue

Marketing $$10$m$/+5\%/8\%$ $$11$m$/+10\%/8\%$

$2$ Explain in detail: what are your assumptions and how did you make them?

Tell me why your numbers for each item went up$,$ down, or stayed flat.

What are your assumptions for the future?

Where did you get your data? Spend time finding info.

$3.$ How does profit look. two sentences is fine.