f

profilekhaled000
milestone3.xlsx
Home>Business & Finance homework help>Management homework help>f

basic

income statement comman size index trends (2016) %changes
2018 2,017.00 2016 2018 2017 2016 average 2018 2017 2018 2017 average
sales 500,343.00 485,873.00 482,130.00 100.00% 100.00% 100.00% 100.00% 103.78% 100.78% 2.98% 0.78% 1.88% 5.18%
cost of sales 373,396.00 361,256.00 360,984.00 74.63% 74.35% 74.87% 74.62% 103.44% 100.08% 3.36% 0.08% 1.72%
Op . Ex 106,510.00 101,853.00 97,041.00 21.29% 20.96% 20.13% 20.79% 109.76% 104.96% 4.57% 4.96% 4.77%
Op . IN 20,437.00 22,764.00 24,105.00 4.08% 4.69% 5.00% 4.59% 84.78% 94.44% -10.22% -5.56% -7.89%
intrest
debit 1,978.00 2,044.00 2,027.00 0.40% 0.42% 0.42% 0.41% 97.58% 100.84% -3.23% 0.84% -1.20%
Capital lease 352.00 323.00 521.00 0.07% 0.07% 0.11% 0.08% 67.56% 62.00% 8.98% -38.00% -14.51%
Intrest income (152.00) (100.00) (81.00) -0.03% -0.02% -0.02% -0.02% 187.65% 123.46% 52.00% 23.46% 37.73%
net intrest 2,178.00 2,267.00 2,467.00 0.44% 0.47% 0.51% 0.47% 88.29% 91.89% -3.93% -8.11% -6.02%
Loss on extinguishment of debt 3,136.00 0.63% 0.63%
taxable income 15,123.00 20,497.00 21,638.00 3.02% 4.22% 4.49% 3.91% 69.89% 94.73% -26.22% -5.27% -15.75%
income tax 4,600.00 6,204.00 6,558.00 0.92% 1.28% 1.36% 1.19% 70.14% 94.60% -25.85% -5.40% -15.63%
Consolidated net income 10,523.00 14,293.00 15,080.00 2.10% 2.94% 3.13% 2.72% 69.78% 94.78% -26.38% -5.22% -15.80%
attributable to noncontrolling interest (661.00) (650.00) (386.00) -0.13% -0.13% -0.08% -0.12% 171.24% 168.39% 1.69% 68.39% 35.04%
net income 9,862.00 13,643.00 14,694.00 1.97% 2.81% 3.05% 2.61% 67.12% 92.85% -27.71% -7.15% -17.43%

scenario

2019 2020 2021
regular scenario
sales 509,735.67 519,304.66 529,053.28
cost of sales 379,810.66 386,335.52 392,972.47
Op . Ex 111,585.74 116,903.36 122,474.39
Op . IN 18,339.27 16,065.78 13,606.43
intrest - 0 - 0
debit 1,954.36 1,931.00 1,907.92
Capital lease 300.92 257.24 219.91
Intrest income (209.35) (288.33) (397.11)
net intrest 2,045.93 1,899.92 1,730.72
Loss on extinguishment of debt - 0 - 0 -
taxable income 16,293.34 14,165.87 11,875.70
income tax 3,881.20 3,274.72 2,763.00
Consolidated net income 12,412.15 10,891.15 9,112.70
attributable to noncontrolling interest (892.63) (1,205.44) (1,627.86)
net income 11,519.51 10,891.15 7,484.83
best scenario
2019 2020 2021
sales 526,260.48 553,520.47 582,192.51
cost of sales 391,284.87 411,553.20 432,871.42
Op . Ex 105,923.39 111,410.16 117,181.14
Op . IN 29,052.22 30,557.10 32,139.95
intrest
debit 2,080.46 2,188.23 2,301.57
Capital lease 370.23 367.97 387.03
Intrest income (159.87) (113.92) (119.82)
net intrest 2,290.82 2,442.27 2,568.78
Loss on extinguishment of debt
taxable income 26,761.40 28,114.83 29,571.16
income tax 4,838.28 5,088.90 5,352.50
Consolidated net income 21,923.12 23,025.93 24,218.66
attributable to noncontrolling interest (421.33) (443.16) (466.11)
net income 21,501.79 22,582.78 23,752.55
worst scenario
2019 2020 2021
sales 504,227.40 508,141.95 512,086.89
cost of sales 379,810.66 386,335.52 392,972.47
Op . Ex 111,585.74 116,903.36 122,474.39
Op . IN 12,831.00 4,903.08 (3,359.96)
intrest
debit 1,954.36 1,931.00 1,650.76
Capital lease 300.92 257.24 219.91
Intrest income (209.35) (288.33) -397.11
net intrest 2,045.93 1,899.92 1,473.56
Loss on extinguishment of debt
taxable income 10,785.07 3,003.16 -4,833.52
income tax 3,881.20 3,274.72 2,763.00
Consolidated net income 6,903.88 (271.56) -7,596.53
attributable to noncontrolling interest (892.63) (1,205.44) -1,627.86
net income 6,011.24 (1,477.00) -9,224.39