I can not get the formulas correct, can I get some help, please? I am trying to
ID: 2616285 • Letter: I
Question
I can not get the formulas correct, can I get some help, please? I am trying to catch up on 2 class missed due to a medical issue and try to keep up with my normal classes. thank you
This is the data question at the end of Chapter 2 in Fundamentals of corporate finance fourth edition. Ford/ Microsoft
2015-12
2014-12
2013-12
2012-12
Ratios
(TTM)
(TTM)
(TTM)
(TTM)
Revenue
149558
144077
146917
134252
Cost of revenue
126495
126215
128094
115693
Stock Price
Gross profit
23063
17862
18823
18559
Operating expenses
Valuation
Sales, General and administrative
14999
14117
13176
12182
Price-Earnings
Other operating expenses
208
86
Total operating expenses
14999
14117
13384
12268
Market to Book
Operating income
8064
3745
5439
6291
Interest Expense
773
810
829
713
Enterprise / EBITDA
Other income (expense)
2961
1407
2391
2142
Income before taxes
10252
4342
7001
7720
Profitability
Provision for income taxes
2881
1156
-147
2056
Operating Margin
Net income from continuing operations
7371
3186
7148
5664
Other
2
1
7
1
Net Profit Margin
Net income
7373
3187
7155
5665
Net income available to common shareholders
7373
3187
7155
5665
Return on Equity
Earnings per share
Basic
1.86
0.81
1.82
1.48
Financial Strength
Diluted
1.84
0.8
1.76
1.42
Current Ratio
Weighted average shares outstanding
Shares Outstanding
3969
3912
3935
3815
Book Debt-Equity
Diluted
4002
4045
4087
4015
EBITDA
18991
12575
14286
13637
Mkt Debt-Equity
2015-12
2014-12
2013-12
2012-12
Interest Coverage
(TTM)
(TTM)
(TTM)
(TTM)
Assets
Enterprise Value
Current assets
Cash
Cash and cash equivalents
14272
10757
14468
15659
Short-term investments
47997
43610
42084
36735
Total cash
62269
54367
56552
52394
Receivables
101975
92819
87309
82338
Inventories
8319
7866
7708
7362
Total current assets
172563
155052
151569
142094
Non-current assets
Property, plant and equipment
Gross property, plant and equipment
57629
59260
59092
57777
Accumulated Depreciation
-27466
-29134
-31476
-32835
Net property, plant and equipment
30163
30126
27616
24942
Equity and other investments
3224
3357
3679
3246
Intangible assets
87
Deferred income taxes
11509
13639
13315
15185
Other long-term assets
7466
6353
5847
5000
Total non-current assets
52362
53475
50457
48460
Total assets
224925
208527
202026
190554
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt
42998
39172
38063
38762
Accrued liabilities
2385
2987
2682
2577
Deferred revenues
4559
3923
2817
2796
Other current liabilities
31320
31059
30569
29293
Total current liabilities
81262
77141
74131
73428
Non-current liabilities
Long-term debt
89856
79999
76625
66296
Deferred taxes liabilities
502
570
598
470
Accrued liabilities
2260
3500
Deferred revenues
2833
2686
2534
1893
Pensions and other benefits
9541
15712
14790
24798
Minority interest
15
27
33
42
Other long-term liabilities
12274
7587
4672
4180
Total non-current liabilities
115021
106581
101512
101179
Total liabilities
196283
183722
175643
174607
Stockholders' equity
Common stock
41
40
40
40
Additional paid-in capital
21421
21089
21422
20976
Retained earnings
14414
24556
23658
18077
Treasury stock
-977
-848
-506
-292
Accumulated other comprehensive income
-6257
-20032
-18231
-22854
Total stockholders' equity
28642
24805
26383
15947
Total liabilities and stockholders' equity
224925
208527
202026
190554
2015-12
2014-12
2013-12
2012-12
Cash Flows From Operating Activities
Net income
7371
3186
7155
5665
Depreciation & amortization
7966
7423
6456
5204
Investments losses (gains)
-719
-105
Stock based compensation
199
180
159
140
Accounts receivable
-3563
-2897
-1969
-1622
Inventory
-1155
-875
-572
-1401
Accounts payable
-595
Other working capital
7758
5734
485
Other non-cash items
-2406
1756
529
679
Net cash provided by operating activities
16170
14507
10444
9045
Cash Flows From Investing Activities
Investments in property, plant, and equipment
-7196
-7463
-6597
-5488
Acquisitions, net
9
257
Purchases of investments
-41279
-48694
-119993
-95135
Sales/Maturities of investments
40766
50264
118247
93749
Other investing activities
-18453
-15231
-11397
-7673
Net cash used for investing activities
-26162
-21124
-19731
-14290
Cash Flows From Financing Activities
Debt issued
48860
40043
40543
32436
Debt repayment
-33358
-28859
-27953
-29210
Common stock repurchased
-129
-1964
-213
-125
Dividend paid
-2380
-1952
-1574
-763
Other financing activities
1329
-3845
-2670
1367
Net cash provided by (used for) financing activities
14322
3423
8133
3705
Effect of exchange rate changes
-815
-517
-37
51
Net change in cash
3515
-3711
-1191
-1489
Cash at beginning of period
10757
14468
15659
17148
Cash at end of period
14272
10757
14468
15659
Free Cash Flow
Operating cash flow
16170
14507
10444
9045
Capital expenditure
-7196
-7463
-6597
-5488
Free cash flow
8974
7044
3847
3557
Last columns sorry;
Ratios
Dec-15
Dec-14
Dec-13
Dec-12
Industry
Stock Price
14.09
15.5
15.43
12.95
Valuation
Price-Earnings
22.24
Market to Book
2.78
Enterprise / EBITDA
Profitability
Operating Margin
6.54%
Net Profit Margin
7.62%
Return on Equity
12.67%
Financial Strength
Current Ratio
1.33
Book Debt-Equity
71.68
Mkt Debt-Equity
Interest Coverage
1.01
Enterprise Value
2015-12
2014-12
2013-12
2012-12
Ratios
(TTM)
(TTM)
(TTM)
(TTM)
Revenue
149558
144077
146917
134252
Cost of revenue
126495
126215
128094
115693
Stock Price
Gross profit
23063
17862
18823
18559
Operating expenses
Valuation
Sales, General and administrative
14999
14117
13176
12182
Price-Earnings
Other operating expenses
208
86
Total operating expenses
14999
14117
13384
12268
Market to Book
Operating income
8064
3745
5439
6291
Interest Expense
773
810
829
713
Enterprise / EBITDA
Other income (expense)
2961
1407
2391
2142
Income before taxes
10252
4342
7001
7720
Profitability
Provision for income taxes
2881
1156
-147
2056
Operating Margin
Net income from continuing operations
7371
3186
7148
5664
Other
2
1
7
1
Net Profit Margin
Net income
7373
3187
7155
5665
Net income available to common shareholders
7373
3187
7155
5665
Return on Equity
Earnings per share
Basic
1.86
0.81
1.82
1.48
Financial Strength
Diluted
1.84
0.8
1.76
1.42
Current Ratio
Weighted average shares outstanding
Shares Outstanding
3969
3912
3935
3815
Book Debt-Equity
Diluted
4002
4045
4087
4015
EBITDA
18991
12575
14286
13637
Mkt Debt-Equity
2015-12
2014-12
2013-12
2012-12
Interest Coverage
(TTM)
(TTM)
(TTM)
(TTM)
Assets
Enterprise Value
Current assets
Cash
Cash and cash equivalents
14272
10757
14468
15659
Short-term investments
47997
43610
42084
36735
Total cash
62269
54367
56552
52394
Receivables
101975
92819
87309
82338
Inventories
8319
7866
7708
7362
Total current assets
172563
155052
151569
142094
Non-current assets
Property, plant and equipment
Gross property, plant and equipment
57629
59260
59092
57777
Accumulated Depreciation
-27466
-29134
-31476
-32835
Net property, plant and equipment
30163
30126
27616
24942
Equity and other investments
3224
3357
3679
3246
Intangible assets
87
Deferred income taxes
11509
13639
13315
15185
Other long-term assets
7466
6353
5847
5000
Total non-current assets
52362
53475
50457
48460
Total assets
224925
208527
202026
190554
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt
42998
39172
38063
38762
Accrued liabilities
2385
2987
2682
2577
Deferred revenues
4559
3923
2817
2796
Other current liabilities
31320
31059
30569
29293
Total current liabilities
81262
77141
74131
73428
Non-current liabilities
Long-term debt
89856
79999
76625
66296
Deferred taxes liabilities
502
570
598
470
Accrued liabilities
2260
3500
Deferred revenues
2833
2686
2534
1893
Pensions and other benefits
9541
15712
14790
24798
Minority interest
15
27
33
42
Other long-term liabilities
12274
7587
4672
4180
Total non-current liabilities
115021
106581
101512
101179
Total liabilities
196283
183722
175643
174607
Stockholders' equity
Common stock
41
40
40
40
Additional paid-in capital
21421
21089
21422
20976
Retained earnings
14414
24556
23658
18077
Treasury stock
-977
-848
-506
-292
Accumulated other comprehensive income
-6257
-20032
-18231
-22854
Total stockholders' equity
28642
24805
26383
15947
Total liabilities and stockholders' equity
224925
208527
202026
190554
2015-12
2014-12
2013-12
2012-12
Cash Flows From Operating Activities
Net income
7371
3186
7155
5665
Depreciation & amortization
7966
7423
6456
5204
Investments losses (gains)
-719
-105
Stock based compensation
199
180
159
140
Accounts receivable
-3563
-2897
-1969
-1622
Inventory
-1155
-875
-572
-1401
Accounts payable
-595
Other working capital
7758
5734
485
Other non-cash items
-2406
1756
529
679
Net cash provided by operating activities
16170
14507
10444
9045
Cash Flows From Investing Activities
Investments in property, plant, and equipment
-7196
-7463
-6597
-5488
Acquisitions, net
9
257
Purchases of investments
-41279
-48694
-119993
-95135
Sales/Maturities of investments
40766
50264
118247
93749
Other investing activities
-18453
-15231
-11397
-7673
Net cash used for investing activities
-26162
-21124
-19731
-14290
Cash Flows From Financing Activities
Debt issued
48860
40043
40543
32436
Debt repayment
-33358
-28859
-27953
-29210
Common stock repurchased
-129
-1964
-213
-125
Dividend paid
-2380
-1952
-1574
-763
Other financing activities
1329
-3845
-2670
1367
Net cash provided by (used for) financing activities
14322
3423
8133
3705
Effect of exchange rate changes
-815
-517
-37
51
Net change in cash
3515
-3711
-1191
-1489
Cash at beginning of period
10757
14468
15659
17148
Cash at end of period
14272
10757
14468
15659
Free Cash Flow
Operating cash flow
16170
14507
10444
9045
Capital expenditure
-7196
-7463
-6597
-5488
Free cash flow
8974
7044
3847
3557
Last columns sorry;
Ratios
Dec-15
Dec-14
Dec-13
Dec-12
Industry
Stock Price
14.09
15.5
15.43
12.95
Valuation
Price-Earnings
22.24
Market to Book
2.78
Enterprise / EBITDA
Profitability
Operating Margin
6.54%
Net Profit Margin
7.62%
Return on Equity
12.67%
Financial Strength
Current Ratio
1.33
Book Debt-Equity
71.68
Mkt Debt-Equity
Interest Coverage
1.01
Enterprise Value
Explanation / Answer
Above table shows all the formula that you require.
Ratio Formula Price-Earnings Stock Price / Basic Earnings per Share Market to Book (Total Number of Shares * Stock Price per Share) / (Total Asset - Total Liability) Enterprise / EBITDA Enterprise Value / EBITDA Operating Margin Operating Income / Revenue Net Profit Margin Net Income / Revenue Return on Equity Net Income / Shareholder's Equity Current Ratio Current Assets / Current Liability Book Debt-Equity Book Value of debt / Total Equity Mkt Debt-Equity Market Value of debt / Total Equity Interest Coverage EBIT / Net Income Enterprise Value Market value of common stock + Market value of preferred equity + Market value of debt + Minority interest - Cash and investmentsRelated Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.