Using the data from the previous problem:

Data from previous 1.

Using the data presented below: 

a. Create a common-size income statement for 2019 and 2020. This statement should be created on a separate worksheet with all formulas linked directly to the income statement.

b. Create a common-size balance sheet for 2019 and 2020. This statement should be created on a separate worksheet with all formulas linked directly to the balance sheet.

c. Create a common-size statement of cash flows for 2020 that can be switched between using sales and the 2019 cash balance in the denominator.

Transcribed Image Text:

Sales Cost of Goods Gross Profit Big Rock Candy Mountain Mining Co. Income Statements For the Years 2019 and 2020 2020 Depreciation Selling & Admin. Expense Other Operating Expense Net Operating Income Interest Expense Earnings Before Taxes Taxes Net Income Notes: Tax Rate Shares Earnings per Share $412,500 318,786 93,714 29,800 26,250 1,210 36,454 8,582 27,872 6,968 20,904 71 25.00% 52,100 $0.40 2019 $398,600 315,300 83,300 29,652 24,550 1,245 27,853 8,457 19,396 4,849 14,547 25.00% 52,100 $0.28