Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

calculate Price Earnings Ratio Earnings per share (EPS) Free Cash Flow Stock Price at 1/1 of each year. Dividends per year Rate of Return on

calculate

Price Earnings Ratio

Earnings per share (EPS)
Free Cash Flow
Stock Price at 1/1 of each year.
Dividends per year

Rate of Return on your investment each year in detail and which cells were used to solve these 6 steps

Annual Income Statement (values in 000's)Get Quarterly Data
Period Ending: 12/31/2016 12/31/2015 12/31/2014 12/31/2013
Cash and Cash Equivalents $ 7,826,000.00 $ 7,686,000.00 $ 8,476,000.00 $ 10,716,000.00
Short-Term Investments $ 701,000.00 $ 508,000.00 $ - $ 350,000.00
Net Receivables $ 29,245,000.00 $ 28,554,000.00 $ 31,831,000.00 $ 33,487,000.00
Inventory $ 1,553,000.00 $ 1,551,000.00 $ 2,103,000.00 $ 2,310,000.00
Other Current Assets $ 4,564,000.00 $ 4,205,000.00 $ 4,967,000.00 $ 4,488,000.00
Total Current Assets $ 43,888,000.00 $ 42,504,000.00 $ 47,377,000.00 $ 51,350,000.00
Long-Term Investments $ 13,606,000.00 $ 15,200,000.00 $ 16,629,000.00 $ 17,394,000.00
Fixed Assets $ 10,830,000.00 $ 10,727,000.00 $ 10,771,000.00 $ 13,821,000.00
Goodwill $ 36,199,000.00 $ 32,021,000.00 $ 30,556,000.00 $ 31,184,000.00
Intangible Assets $ 4,688,000.00 $ 3,487,000.00 $ 3,104,000.00 $ 3,871,000.00
Other Assets $ 3,034,000.00 $ 1,734,000.00 $ 2,160,000.00 $ 5,551,000.00
Deferred Asset Charges $ 5,224,000.00 $ 4,822,000.00 $ 6,675,000.00 $ 3,051,000.00
Total Assets $ 117,470,000.00 $ 110,495,000.00 $ 117,271,000.00 $ 126,223,000.00
Accounts Payable $ 17,726,000.00 $ 16,788,000.00 $ 21,973,000.00 $ 20,735,000.00
Short-Term Debt / Current Portion of Long-Term Debt $ 7,513,000.00 $ 6,461,000.00 $ 5,731,000.00 $ 6,862,000.00
Other Current Liabilities $ 11,035,000.00 $ 11,021,000.00 $ 11,877,000.00 $ 12,557,000.00
Total Current Liabilities $ 36,275,000.00 $ 34,269,000.00 $ 39,581,000.00 $ 40,154,000.00
Long-Term Debt $ 34,655,000.00 $ 33,428,000.00 $ 34,991,000.00 $ 32,856,000.00
Other Liabilities $ 24,547,000.00 $ 24,603,000.00 $ 26,994,000.00 $ 26,176,000.00
Deferred Liability Charges $ 3,600,000.00 $ 3,771,000.00 $ 3,691,000.00 $ 4,108,000.00
Misc. Stocks $ - $ - $ - $ -
Minority Interest $ 146,000.00 $ 162,000.00 $ 146,000.00 $ 137,000.00
Total Liabilities $ 99,224,000.00 $ 96,233,000.00 $ 105,403,000.00 $ 103,431,000.00
Common Stocks $ 53,935,000.00 $ 53,262,000.00 $ 52,666,000.00 $ 51,594,000.00
Capital Surplus $ - $ - $ - $ -
Retained Earnings $ 152,759,000.00 $ 146,124,000.00 $ 137,793,000.00 $ 130,042,000.00
Treasury Stock $ (159,050,000.00) $ (155,518,000.00) $ (150,715,000.00) $ (137,242,000.00)
Other Equity $ (29,398,000.00) $ (29,607,000.00) $ (27,875,000.00) $ (21,602,000.00)
Total Equity $ 18,246,000.00 $ 14,262,000.00 $ 11,868,000.00 $ 22,792,000.00
Total Liabilities & Equity $ 117,470,000.00 $ 110,495,000.00 $ 117,271,000.00 $ 126,223,000.00
Annual Income Statement (values in 000's) Get Quarterly Data
Period Ending: 12/31/2016 12/31/2015 12/31/2014 12/31/2013
Total Revenue $ 79,919,000.00 $ 81,741,000.00 $ 92,793,000.00 $ 98,367,000.00
Cost of Revenue $ 41,625,000.00 $ 41,057,000.00 $ 46,386,000.00 $ 49,683,000.00
Gross Profit $ 38,294,000.00 $ 40,684,000.00 $ 46,407,000.00 $ 48,684,000.00
Research and Development $ 5,751,000.00 $ 5,247,000.00 $ 5,437,000.00 $ 5,743,000.00
Sales, General and Admin. $ 19,438,000.00 $ 19,748,000.00 $ 22,438,000.00 $ 22,629,000.00
Non-Recurring Items $ - $ - $ - $ -
Other Operating Items $ - $ - $ - $ -
Operating Income $ 13,105,000.00 $ 15,689,000.00 $ 18,532,000.00 $ 20,312,000.00
Add'l income/expense items $ (145,000.00) $ 724,000.00 $ 1,938,000.00 $ 333,000.00
Earnings Before Interest and Tax $ 12,960,000.00 $ 16,413,000.00 $ 20,470,000.00 $ 20,646,000.00
Interest Expense $ 630,000.00 $ 468,000.00 $ 484,000.00 $ 402,000.00
Earnings Before Tax $ 12,330,000.00 $ 15,945,000.00 $ 19,986,000.00 $ 20,244,000.00
Income Tax $ 449,000.00 $ 2,581,000.00 $ 4,234,000.00 $ 3,363,000.00
Minority Interest $ - $ - $ - $ -
Equity Earnings/Loss Unconsolidated Subsidiary $ - $ - $ - $ -
Net Income-Cont. Operations $ 11,881,000.00 $ 13,364,000.00 $ 15,751,000.00 $ 16,881,000.00
Net Income $ 11,872,000.00 $ 13,190,000.00 $ 12,022,000.00 $ 16,483,000.00
Net Income Applicable to Common Shareholders $ 11,872,000.00 $ 13,190,000.00 $ 12,022,000.00 $ 16,483,000.00
Period Ending: 12/31/2016 12/31/2015 12/31/2014 12/31/2013
Net Income $11,872,000 $13,190,000 $12,022,000 $16,483,000
Depreciation $4,381,000 $3,855,000 $4,492,000 $4,678,000
Net Income Adjustments ($526,000) $2,407,000 $2,121,000 ($1,232,000)
Accounts Receivable $712,000 $812,000 $1,270,000 ($1,407,000)
Changes in Inventories ($14,000) $133,000 ($39,000) ($57,000)
Other Operating Activities $282,000 ($3,448,000) ($1,886,000) ($747,000)
Liabilities $251,000 $59,000 ($1,111,000) ($235,000)
Net Cash Flow-Operating $16,958,000 $17,008,000 $16,868,000 $17,485,000
Capital Expenditures ($3,567,000) ($3,579,000) ($3,740,000) ($3,623,000)
Investments ($1,116,000) ($629,000) ($923,000) ($798,000)
Other Investing Activities ($6,292,000) ($3,952,000) $1,662,000 ($2,904,000)
Net Cash Flows-Investing ($10,976,000) ($8,159,000) ($3,001,000) ($7,326,000)
Sale and Purchase of Stock ($3,298,000) ($4,287,000) ($12,970,000) ($12,785,000)
Net Borrowings $2,763,000 $19,000 $1,783,000 $6,961,000
Other Financing Activities $0 $0 $0 $0
Net Cash Flows-Financing ($5,791,000) ($9,166,000) ($15,452,000) ($9,883,000)
Effect of Exchange Rate ($51,000) ($473,000) ($655,000) $28,000
Net Cash Flow $140,000 ($790,000) ($2,240,000) $304,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Process To Profits Strategic Planning For A Growing Business

Authors: William Lasher

1st Edition

0324223870, 9780324223873

More Books

Students also viewed these Finance questions

Question

Define Management or What is Management?

Answered: 1 week ago

Question

What do you understand by MBO?

Answered: 1 week ago