Question: PLease help me forcast 2022 for my excel class X Module 5: Criti X y Starbucks Cor X Book 4.xlsx - M X Option #1:
PLease help me forcast 2022 for my excel class

X Module 5: Criti X y Starbucks Cor X Book 4.xlsx - M X Option #1: Per X onedrive.live.com/edit.aspx?action=editnew&resid=2A6D59930929EFDF!131&ithint=file%2cxlsx&action=editnew&wdNewAnd OpenCt=1654478010309&wd PreviousSe... Excel Book 4 - Saved to OneDrive O Search (Alt + Q) Buy Microsoft 365 Home Insert Draw Page Layout Formulas Data Review View Help Share Editing General Calibri 11 0 B D G Av ... Ev ab = ab .00 .0 v TV Ov .00 Y A2 X fx Pro-forma Income statment A B C D F H I L M N O P 1 Starbucks Corperations 2 Pro-forma Income statment 3 For year ended in 2021 4 2022* 5 Sales 6 Costs of goods sold 2021 2020 29,060,600 23,518,000 20,669,600 18,458,900 8,391,000 5,059,100 1,932,600 1,679,600 7 Gross profit Margin 8 Selling and G& A expenses 9 fixed expenses 24,403,400 22,000,100 10 Depreciation expense 1,441,700 1,431,300 5826700 1601400 11 EBIT 12 INtrest expense 469,800 437,000 13 Earning Before taxes 5,356,900 1,164,400 14 Taxes 1,156,600 239,700 15 Net Income 4,199,300 928,300 16 *forcast 17 18 Notes 19 Tax rate 20 Additional Depreciation 21 =Sheet1 + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft O C Chegg eReade C File Dv E O #V G Module 5: Criti x C An Expert Who x G how to find sa x | + 31 J K 6 : SK Comments Q - 100% + 9:01 X Module 5: Criti X y Starbucks Cor X Book 4.xlsx - M X Option #1: Per X onedrive.live.com/edit.aspx?action=editnew&resid=2A6D59930929EFDF!131&ithint=file%2cxlsx&action=editnew&wdNewAnd OpenCt=1654478010309&wd PreviousSe... Excel Book 4 - Saved to OneDrive O Search (Alt + Q) Buy Microsoft 365 Home Insert Draw Page Layout Formulas Data Review View Help Share Editing General Calibri 11 0 B D G Av ... Ev ab = ab .00 .0 v TV Ov .00 Y A2 X fx Pro-forma Income statment A B C D F H I L M N O P 1 Starbucks Corperations 2 Pro-forma Income statment 3 For year ended in 2021 4 2022* 5 Sales 6 Costs of goods sold 2021 2020 29,060,600 23,518,000 20,669,600 18,458,900 8,391,000 5,059,100 1,932,600 1,679,600 7 Gross profit Margin 8 Selling and G& A expenses 9 fixed expenses 24,403,400 22,000,100 10 Depreciation expense 1,441,700 1,431,300 5826700 1601400 11 EBIT 12 INtrest expense 469,800 437,000 13 Earning Before taxes 5,356,900 1,164,400 14 Taxes 1,156,600 239,700 15 Net Income 4,199,300 928,300 16 *forcast 17 18 Notes 19 Tax rate 20 Additional Depreciation 21 =Sheet1 + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft O C Chegg eReade C File Dv E O #V G Module 5: Criti x C An Expert Who x G how to find sa x | + 31 J K 6 : SK Comments Q - 100% + 9:01
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
