Horizontal analysis of income statement and balance

Assignment Help Corporate Finance
Reference no: EM13381766

Horizontal Analysis of Income Statement and Balance Sheet

Prepare a three-year horizontal analysis of the income statement and balance sheet of your selected company. Discuss the importance and meaning of horizontal analysis. Discuss both the positive and negative trends presented in your company.

Ratio Analysis
Calculate the current ratio, quick ratio, cash to current liabilities ratio, over a two-year period. Discuss and interpret the ratios that you calculated. Discuss potential liquidity issues based on your calculations of the current and quick ratios. Are there any factors that could be erroneously influencing the results of the ratios? Discuss liquidity issues of competitive companies within the same industry.

Recommendation
Based on your analysis would you recommend an individual invest in this company? What strengths do you see? What risks do you see? It is perfectly acceptable to state that you would recommend avoiding this company as long as you provide support for your position.

 Income Statement

Period Ending

Sep 28, 2012

Sep 23, 2011

Sep 24, 2010

Total Revenue

156,508,000

108,249,000

65,225,000

Cost of Revenue

87,846,000

64,431,000

39,541,000


Gross Profit

68,662,000

43,818,000

25,684,000



Operating Expenses


Research Development

3,381,000

2,429,000

1,782,000


Selling General and Administrative

10,040,000

7,599,000

5,517,000


Non Recurring

-

-

-


Others

-

-

-




Total Operating Expenses

-

-

-






Operating Income or Loss

55,241,000

33,790,000

18,385,000





Income from Continuing Operations



Total Other Income/Expenses Net

522,000

415,000

155,000



Earnings Before Interest And Taxes

55,763,000

34,205,000

18,540,000



Interest Expense

-

-

-



Income Before Tax

55,763,000

34,205,000

18,540,000



Income Tax Expense

14,030,000

8,283,000

4,527,000



Minority Interest

-

-

-





Net Income From Continuing Ops

41,733,000

25,922,000

14,013,000





Non-recurring Events



Discontinued Operations

-

-

-



Extraordinary Items

-

-

-



Effect Of Accounting Changes

-

-

-



Other Items

-

-

-






Net Income

41,733,000

25,922,000

14,013,000


Preferred Stock And Other Adjustments

-

-

-




Net Income Applicable To Common Shares

41,733,000

25,922,000

14,013,000


Currency in USD.

Balance Sheet

Period Ending

Sep 29, 2012

Sep 24, 2011

Sep 25, 2010


Assets

Current Assets


Cash And Cash Equivalents

10,746,000

9,815,000

11,261,000


Short Term Investments

18,383,000

16,137,000

14,359,000


Net Receivables

21,275,000

13,731,000

11,560,000


Inventory

791,000

776,000

1,051,000


Other Current Assets

6,458,000

4,529,000

3,447,000


Total Current Assets

57,653,000

44,988,000

41,678,000

Long Term Investments

92,122,000

55,618,000

25,391,000

Property Plant and Equipment

15,452,000

7,777,000

4,768,000

Goodwill

1,135,000

896,000

741,000

Intangible Assets

4,224,000

3,536,000

342,000

Accumulated Amortization

-

-

-

Other Assets

5,478,000

3,556,000

2,263,000

Deferred Long Term Asset Charges

-

-

-


Total Assets

176,064,000

116,371,000

75,183,000


Liabilities

Current Liabilities


Accounts Payable

32,589,000

23,879,000

17,738,000


Short/Current Long Term Debt

-

-

-


Other Current Liabilities

5,953,000

4,091,000

2,984,000


Total Current Liabilities

38,542,000

27,970,000

20,722,000

Long Term Debt

-

-

-

Other Liabilities

16,664,000

10,100,000

5,531,000

Deferred Long Term Liability Charges

2,648,000

1,686,000

1,139,000

Minority Interest

-

-

-

Negative Goodwill

-

-

-


Total Liabilities

57,854,000

39,756,000

27,392,000


Stockholders' Equity

Misc Stocks Options Warrants

-

-

-

Redeemable Preferred Stock

-

-

-

Preferred Stock

-

-

-

Common Stock

16,422,000

13,331,000

10,668,000

Retained Earnings

101,289,000

62,841,000

37,169,000

Treasury Stock

-

-

-

Capital Surplus

-

-

-

Other Stockholder Equity

499,000

443,000

(46,000)


Total Stockholder Equity

118,210,000

76,615,000

47,791,000


Net Tangible Assets

112,851,000

72,183,000

46,708,000

Currency in USD.

Cash Flow

Period Ending

Sep 29, 2012

Sep 24, 2011

Sep 25, 2010

Net Income

41,733,000

25,922,000

14,013,000


Operating Activities, Cash Flows Provided By or Used In

Depreciation

3,277,000

1,814,000

1,027,000

Adjustments To Net Income

6,145,000

4,036,000

2,319,000

Changes In Accounts Receivables

(6,965,000)

(1,791,000)

(4,860,000)

Changes In Liabilities

9,843,000

8,664,000

8,302,000

Changes In Inventories

(15,000)

275,000

(596,000)

Changes In Other Operating Activities

(3,162,000)

(1,391,000)

(1,610,000)


Total Cash Flow From Operating Activities

50,856,000

37,529,000

18,595,000


Investing Activities, Cash Flows Provided By or Used In

Capital Expenditures

(8,295,000)

(4,260,000)

(2,005,000)

Investments

(38,427,000)

(32,464,000)

(11,075,000)

Other Cash flows from Investing Activities

(1,505,000)

(3,695,000)

(774,000)


Total Cash Flows From Investing Activities

(48,227,000)

(40,419,000)

(13,854,000)


Financing Activities, Cash Flows Provided By or Used In

Dividends Paid

(2,488,000)

-

-

Sale Purchase of Stock

665,000

831,000

912,000

Net Borrowings

-

-

-

Other Cash Flows from Financing Activities

(1,226,000)

(520,000)

(406,000)


Total Cash Flows From Financing Activities

(1,698,000)

1,444,000

1,257,000

Effect Of Exchange Rate Changes

-

-

-


Change In Cash and Cash Equivalents

931,000

(1,446,000)

5,998,000

Currency in USD.

 

Reference no: EM13381766

Questions Cloud

1 explain in your own words when and how the composition of : 1. explain in your own words when and how the composition of capital the mix of debt and equity does not affect the
1 why did microsoft decide in 2004 to double its cash : 1. why did microsoft decide in 2004 to double its cash dividend and buy back up to 30 billion of the companys stock
Research these companies dividend payment policies you : research these companies dividend payment policies you should use both your own analysis of dividend payment policy and
A new cardiac catheterization lab was constructed at havea : a new cardiac catheterization lab was constructed at havea heart hospital. the investment for the lab was 450000 in
Horizontal analysis of income statement and balance : horizontal analysis of income statement and balance sheetprepare a three-year horizontal analysis of the income
1 use working knowledge of personal finance to construct a : 1. use working knowledge of personal finance to construct a financial plan considering life-stage adjustments.2.use
1 calculate company as weighted average cost of debt given : 1. calculate company as weighted average cost of debt given the following information a tax rate 25 b average price of
Part a - accounting for issuance and forfeiture of : part a - accounting for issuance and forfeiture of sharesabc ltd needed funds to finance the expansion of its
1for each pair of funds listed below identify which fund is : 1.for each pair of funds listed below identify which fund is likely to have a relatively higher level of risk. briefly

Reviews

Write a Review

Corporate Finance Questions & Answers

  Today many companies face budgetary challenges on a

today many companies face budgetary challenges on a continual basis. two critical aspects that businesses lack are

  Discuss the concepts of capital and capital maintenance

When, in your view, should the financial capital concept in terms of purchasing power of invested capital and the physical capital concept be adopted?

  Create a cvp chart for requirement

How many attendees need to attend for the banquet to net EXACTLY $955 in profit and Format attendees to 5 decimal places -

  Discuss the characteristics of resort business

The estimation of Kitty (Hawk Food), Inc., a restaurant food wholesaler in eastern Carolina. The company is experiencing difficulty paying trade debt & collecting trade receivables on time,

  Evaluate the payback period and npv

You are considering a project that will require an initial outlay of $54,200 - Evaluate the payback period, NPV, PI, and IRR.

  Create the loan amortization schedule

Create the loan amortization schedule and create the depreciation schedule - create the schedule that combines interest expenses and depreciation expenses.

  Discuss the credit process with companies

Discuss the credit process with companies looking to borrow money. What credit application criteria do you think banks give the most consideration? How hard is it for a new company to get a loan?

  Evaluation of alternative projects

Evaluation of alternative projects - Time Value of money and What do your results suggest as a general rule for approaching such problems?

  Compute the unit contribution margin

Coastal Carolina Company produces a single product. the projected income statement for the coming year, based on sales of 100,000 units, is as follows: Sales 2,000,000 Less:Variable costs 1,000,000 contribution margin 900,000 less: fixed costs 765..

  Prepare a common-sized income statement

Convert the vertical profit and loss account of the company into multi-step form to the extent possible and prepare a common-sized income statement.

  Question 1 when a corporation uses the financial markets to

question 1 when a corporation uses the financial markets to raise new funds the sale of securities is said to be made

  Determine forms of market efficiency

Do empirical studies support or reject notion that corporate insiders earn abnormal benefits on their trades? What about outside investors who mimic their trades?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd