Question: i need help finding the excel equations Instructions: Create formulas for each of the gray boxes in the questions below. These should only have cell

 i need help finding the excel equations Instructions: Create formulas for

each of the gray boxes in the questions below. These should onlyi need help finding the excel equations

Instructions: Create formulas for each of the gray boxes in the questions below. These should only have cell references rather than making intermediate calculations first and including those in these cells. 5. Create a common size income statement for the financial statement below (both years) and calculate the percentage change or growth for the dollar values from 2019 to 2020. Change in Dollar Values (%) 2019 to 2020 Fiscal Year 1-Feb-20 Common Size 2-Feb-19 Common Size Revenue $ 43,638 $ 42,879 Cost of sales 33,590 32,981 Gross profit 11,048 9,961 7,998 8,015 Operating expenses Restructuring charges Operating income 41 56 $ 2,009 $ 1,900 Other income (expense): Gain on sale of investments Investment income and other 1 12 47 49 Interest expense EBT (64) 1,993 (73) 1,888 $ $ 452 424 Income tax expense Net earnings $ 1,541 $ 1,464

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!