computation

7
Revenue Growth Formula: CurrentNetSales-PreviousNetSales PreviousNetSales 2012: ( 1160976283910182852748 ) 10182852748 100=14.01 % 2013: ( 12787581909 11609762839 ) 11609762839 100=10 . 15% 2014: ( 66715313985844449916) 5844449916 100= 14.15% Operating Profit Growth Formula: CurrentOperating Incom e -PreviousOperating Incom e *100 PreviousOperating Incom e 2012: ( 630230443 324470835) 324470835 100=94.23 % 2013: ( 917072846 630230443) 630230443 100=45.51 % 2014: ( 924939088 371696909) 371696909 100=14 8.84 % Net Profit Growth Formula: CurrentNetIncom e -PreviousNetIncom e *100 PreviousNetIncom e 2012: ( 462140497 264180536) 264180536 100=74.93 %

Upload: arvin-jay-solomon

Post on 17-Feb-2016

212 views

Category:

Documents


0 download

DESCRIPTION

a

TRANSCRIPT

Page 1: Computation

Revenue GrowthFormula:

Current Net Sales - Previous Net SalesPrevious Net Sales

*100

2012:(11609762839−10182852748 )

10182852748∗100=14.01%

2013:(12787581909−11609762839)

11609762839∗100=10 .15%

2014:(6671531398−5844449916)

5844449916∗100=14 .15%

Operating Profit Growth

Formula:Current Operating Income - Previous Operating Income

*100Previous Operating Income

2012:(630230443−324470835)

324470835∗100=94.23%

2013:(917072846−630230443)

630230443∗100=45.51%

2014:(924939088−371696909)

371696909∗100=148.84%

Net Profit GrowthFormula:

Current Net Income - Previous Net Income*100

Previous Net Income

2012:(462140497−264180536)

264180536∗100=74.93%

2013:(613743093−462140497)

462140497∗100=32.80%

Page 2: Computation

2014:(486285217−294762291)

294762291∗100=64.98%

Goss Profit MarginFormula:

Current Gross Profit *100

Current Net Sales

2012:509949998111609762839

∗100=43.92%

2013:629199822112787581909

∗100=49.20%

2014:37866950816671531398

∗100=56.76%

Operating Profit MarginFormula:

Current Operating Income*100

Current Net Sales

2012:63023044311609762839

∗100=5.43%

2013:91707284612787581909

∗100=7.17%

2014:9249390886671531398

∗100=13.86%

Net Profit MarginFormula:

Current Net Income*100

Current Net Sales

2012:46214049711609762839

∗100=3.98%

Page 3: Computation

2013:61374309312787581909

∗100=4.80%

2014:4862852176671531398

∗100=7.29%

Return on Average EquityFormula:

Previous Net Income*100

(Previous Total Equity + Current Total Equity)/2

2012:264180536

((985902901+1389907080) /2)∗100=22.24%

2013:462140497

((1389907080+2766508425)/2)∗100=22.24%

2014:486285217

((3134074944+2766508425)/2)∗100=16.48%

Inventory Turnover

Formula: Cost of Goods Sold

(Current Inventory+Previous Inventory)/2

2012:6510262858

((5394140577+4651662778)/2)=1.30

2013:6495583688

((5898907758+5394140577) /2)=1.15

2014:2884836317

((6943002368+5898907758) /2)=.45

Inventory Days

Formula:365

Inventory Turnover

2012:

Page 4: Computation

3651.30

=281.61

2013:3651.15

=317.29

2014:181.45

=402.86

Receivables Turnover

Formula: Net Sales

(Current Receivable+Previous Receivable)/2

2012:11609762839

((375611359+273570927)/2)=35.77

2013:36512.49

=29.23

2014:18111.21

=16.15

Average Collection Period

Formula:(Current Receivable+Previous Receivable)/2

Net Sales*365

2012:((375611359+273570927)/2)

11609762839∗365=10.20

2013:((499297538+375611359)/2)

12787581909∗365=12.49

2014:((499297538+327033910)/2)

6671531398∗181=11.21

Page 5: Computation

Current Ratio

Formula:Total Current Assets

Total Current Liabilities

2012:72589077537418180160

=.98

2013:78732732377649887101

=1.03

2014:87792987818581634128

=1.02

Quick Ratio

Formula:(Total Current Assets-Inventory-Prepayments)

Total Current Liabilities

2012:(7258907753−5394140577−226621151)

7418180160=.22

2013:(7873273237−5898907758−331649745)

7649887101=.21

2014:(8779298781−6943002368−535303285)

8581634128= .15

Debt to Equity Ratio

Formula:Total Liabilities

Total Equity

2012:81719133871389907080

=5.88

Page 6: Computation

2013:91114103392766508425

=3.29

2014:109648669133134074944

=3.50

Times Interest Earned

Formula:Operating IncomeInterest Expense

2012:630230443(21506046)

=29.30

2013:917072846(92226440)

=9.94

2014:924939088

(124580716)=7.42