Question

% Current Year 2019 $ Amounts 5267132 2796599 2470533 Previous Year 43465 $ Amounts 5193185 2852714 2340471 100.00 53.10 46.90 100 54.9 45.1 Revenue Cost of Revenue Gross Profit Operating expenses Selling, General, and Administration Total Operating Expenses Operating Income or (Loss) 2233763 2233763 236770 42.00 42.00 4.90 2182339 2182339 158132 42 42 3.1 Total other income/Expenses net Income Before Tax Income Tax Expense Income from Continuing Operations Other (plug) Net Income Net income available to common stockholders EBITDA -5688 209842 70024 92139 -274178 92139 92139 423195 0.00 0.08 0.03 0.04 -0.11 -192352 -67788 -20552 -46302 280692 -46302 -46302 339900 -0.04 -0.01 0.00 -0.01 0.05 -0.01 -0.01 0.04 0.04

I'm not very sure of calculating the percentages. Did I do them correctly?

Answer 1

From the question i believe this is a common size income statement for CY and PY we will keep revenue as the denominator for all income statement items.

I have notices some variations. please update as listed below

For the year 2019

Selling, general admin exp = 2,233,763 / 5,267,132 x 100= 42.41 %

Total operating exp = 42.41 %

operating income = 236,770 / 5,267,132 x 100 = 4.50 % ( rounded off from 4.495 )

Total other income and expenses ( net ) -5,688 / 5,267,132 x 100 = - 0.11 %

Income before taxes = 209,842 / 5,267,132 x 100 = 3.98 %

Income tax Expenses = 70,024 / 5,267,132 x 100 = 1.33 %

Income from continuing ops = 92,139 / 5,267,132 x 100 = 1.75 %

Other ( Plug ) = -274,178 / 5,267,132 x 100 = - 5.21 %

Net Income = 92,139 / 5,267,132 x 100 = 1.75 %

Net income available to stockholders = 1.75%

EBITDA = 432,195 / 5,267,132 x 100 = 8.21 %

For the year 2018 ( using similar calculation as in 2019 )

Total other income and expenses ( net ) = -3.70 %

Income before taxes = - 1.31 %

Income tax Expenses = - 0.40 %

Income from continuing ops = - 0.89 %

Other ( Plug ) = 5.40 %

Net Income = - 0.89 %

Net income available to stockholders = - 0.89 %

EBITDA = 6.55 %

For any other line items which are excluded here. the existing calculations are correct. just update these numbers and you can understand its calculation for the ones shown in year 2019. for 2018 the same method applies. Hope the answer is clear for you. Thank you for the question.