Accounting Help

profileMeshariMK
course_project__jack_in_the_box_inc.docx

Acct 201 Course Project Assignment #1-IND for [insert company name] page 12

Template for Course Project Assignment #1-INDIVIDUAL[footnoteRef:1] due 11/5/13 [1: Robert Bowen and Jane Jollineau of the University of San Diego prepared this template. It borrows from a project prepared by Mark Judd. Revised: 9/12/13. ]

Learning about your Company, its Financial Statements & tracking its Stock Price

Your name

Other team member(s)

Section #

To begin, download your Company’s most recent SEC Form 10-K in pdf format from its investor relation’s site,[footnoteRef:2] and use it to answer the questions below in the space provided. You will need to complete one template for each company. [Search hint: every item you want may not be where you expect it. If you cannot find it, type in what you are looking for (e.g., “preferred stock”) into the upper right hand search window in the 10-K pdf file.] [2: To find SEC Form 10-K, go to your company’s investor relation’s site, e.g., http://investor.apple.com and look for “SEC Filings.” You can generally narrow this search by selecting “annual” under “forms.” If you get a choice of file formats to download, choose pdf format for readability and because the file can be searched. ]

Part 1: Basic data on your company

Company name

JACK IN THE BOX INC

Company stock ticker symbol

JACK (NASDAQ)

Company headquarters location

9330 BALBOA AVENUE, SAN DIEGO, CA

Industry name

quick-service restaurants

CEO (who signed the letter to shareholders)

LINDA A. LANG - Chief Executive Officer & Chairman of the Board

Company’s key Products or Services include:

Company operates and franchises more than 2,800 Jack in the Box® quick-service restaurants

(“QSR”) and Qdoba Mexican Grill ® fast-casual restaurants

Customers tend to be: (this of course will be a generalization; examples include: business, consumers, women, young professionals, teens, etc.)

General Public

Closest competitors are:

Quick Stuff convenience, McDonald’s, Yum Brands, Starbucks, Darden Restaurants

Part 2: Understanding the financial statements

Who is the Company’s auditor and where is the audit firm located?

KPMG LLP, San Diego, California

Does the Company follow a fiscal year or calendar year?

Fiscal year ended September 30

If they do not use a calendar year, why do you believe that is?

FORM 10-K filed FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 2012

Part 2A: The Balance Sheet

Find your Company’s Balance Sheet and answer the questions below:

Insert numbers and compute financial ratios

Most recent year available

1st Prior Year

What is the balance sheet date? (e.g., 9/30/12 and 9/30/11)

SEPTEMBER 30, 2012

October 2, 2011

What is the dollar amount of total assets?

1,463,725

1,432,322

What is the dollar amount of total liabilities?

1,051,780

1,026,366

What is the dollar amount of total shareholders’ equity?

411,945

405,956

Does A = L + OE? (Yes or No)

Yes

Yes

Name the Company’s largest asset? Is it “current” or “noncurrent”?

Building - Non current

Building - Non current

Does the Company have inventory? Why or why not?

Yes – it is required for the business

yes– it is required for the business

Name the Company’s largest liability? Is it “current” or “noncurrent”?

Long term debt – non current

Long term debt – non current

What is the dollar amount of contributed capital? (preferred stock + common stock + additional paid-in capital)

221,858

203,434

What is the dollar amount of earned capital? (retained earnings +/- other comprehensive income)

984,658

967,080

Is earned capital increasing or decreasing? Why?

Increasing – net income

Does contributed capital plus earned capital add up to total stockholders’ equity? If not, why not?

No – Treasury stock is deducted

No – Treasury stock is deducted

Calculate the current ratio (= current assets ÷ current liabilities) – see textbook p. 59

0.84:1

0.91:1

Based on the current ratio, did the Company become more or less liquid comparing its current year to the prior year?

Company became less liquid as the current ratio has decreased

Calculate the total debt to total assets ratio (= total liabilities ÷ total assets) – see textbook p. 60

0.72:1

0.72:1

Based on the total debt to total assets ratio computed above, is the Company better off or worse off in its ability to withstand long-term financial difficulties?

There is no change in debt to total assets ratio.

What is your overall assessment of your Company’s financial condition? Refer to any of the above numbers or ratios in your brief summary.

The company is financial stable and strong, as the company has been able to raise 72% of total invested funds. The company has invested its large amount in non-current assets. The biggest investment had been made in buildings.

Part 2B: The Income Statement

Find your Company’s Income Statement and answer the questions below:

What is the most recent year used for this analysis?

2012

How many years of comparative information are provided? (usually = 3)

3

Insert numbers and compute financial ratios

Most recent year available

1st Prior Year

What is the dollar amount of total Revenue?

1,545,026

1,662,339

Compute the % change in revenue [= (most recent year’s Revenue ÷ prior year’s Revenue) – 1]

(7.6%)

(12.49%)

What is the dollar amount of Gross Profit margin? (if given or possible to calculate, Gross Profit = sales revenue minus cost of goods sold)

343,279

321,172

Compute Gross Profit rate (= gross profit ÷ net sales revenue)

22.22%

16.9%

What is the dollar amount of Operating Income? (if given or possible to calculate, Operating Income is revenues minus expenses related to principal day-to-day operations and is generally shown as a subtotal in the report.)

112,489

145,061

Compute the % change in Operating Income [= (most recent year’s Op Inc ÷ prior year’s Op Inc) – 1]

(22.45%)

17.4%

What is the dollar amount of Net Income?

57,651

80,600

Compute the % change in Net Income = [(most recent year’s Net Income ÷ prior year’s Net Income) – 1]

(28.47)

14.80%

What is reported as basic earnings per share (EPS)? (look it up – no need to calculate)

1.31

1.63

What is your overall assessment of your Company’s performance? Refer to any of the above numbers or ratios in your brief summary.

The overall assessment of Income statement indicates that the performance of the company in current year has down, when compared with the previous year. Revenue has decreases and therefore the expense ratio has increased. This resulted in the decrease in profits.

Part 2C: The Statement of Cash Flows

Find your Company’s Statement of Cash Flows (SCF) and answer the questions below:

What is the most recent year used for this analysis?

2012

How many years of comparative information are provided in the SCF?

Three year

Insert the amounts requested below. Check the math by summing to the cash balance at the end of the year. Verify that the ending cash balance reported in the SCF is the same amount reported on the balance sheet for the most recent year available.

Insert numbers and compute ratios:

Most recent year available

1st Prior Year

Cash provided by operations

136,730

124,260

Cash from investing activities

(81,516)

(35,802)

Cash from financing activities

(58,169)

(87,641)

Change in cash (may be called “increase or decrease in cash & equivalents”)

(2,955)

817

Cash & equivalents balance at beginning of the year

11,424

10,607

Cash & equivalents balance at year end

8,469

11,424

Does the balance in Cash & equivalents at fiscal year end in the SCF match the amount shown in the Balance Sheet? (Yes or No)

yes

yes

Compute Free Cash Flow (net cash provided by operations – capital expenditures – cash dividends) – see textbook p. 61

55,214

88458

More Questions about the SCF

Most recent year available

1st Prior Year

Name the largest cash outflow and the largest cash inflow in the investing activities section of the SCF?

Purchases of property and equipment

Proceeds from the sale of company-operated restaurants

Purchases of property and equipment

Proceeds from the sale of company-operated restaurants

Name the largest cash inflow and the largest cash outflow in the financing activities section of the SCF?

Borrowings on revolving credit facilities

Repayments of borrowings on revolving credit facilities

Borrowings on revolving credit facilities

Repayments of borrowings on revolving credit facilities

Part 2D: Financial Statement Analysis -- Common-Size Income Statements

 

 

 

 

Fiscal Year

 

2012

2011

2010

2012

2011

2010

Revenues:

 

 

 

 

 

 

Company restaurant sales

12,19,214

13,80,273

16,68,527

78.91%

83.03%

87.84%

Franchise revenues

3,25,812

2,82,066

2,31,027

21.09%

16.97%

12.16%

Total revenues

15,45,026

16,62,339

18,99,554

100.00%

100.00%

100.00%

Operating costs and expenses, net:

 

 

 

 

 

 

Company restaurant costs:

 

 

 

 

 

 

Food and packaging (1)

4,00,012

4,60,790

5,30,613

25.89%

27.72%

27.93%

Payroll and employee benefits (1)

3,54,141

4,14,463

5,05,138

22.92%

24.93%

26.59%

Occupancy and other (1)

2,81,516

3,29,766

3,98,066

18.22%

19.84%

20.96%

Total company restaurant costs (1)

10,35,669

12,05,019

14,33,817

67.03%

72.49%

75.48%

Franchise costs (1)

1,66,078

1,36,148

1,04,845

10.75%

8.19%

5.52%

Selling, general and administrative expenses

2,27,003

2,24,653

2,43,453

14.69%

13.51%

12.82%

Impairment and other charges, net

32,932

12,583

48,864

2.13%

0.76%

2.57%

Gains on the sale of company-operated restaurants

-29,145

-61,125

-54,988

-1.89%

-3.68%

-2.89%

Earnings from operations

1,12,489

1,45,061

1,23,563

7.28%

8.73%

6.50%

What do you observe from the common-size analysis of your company?

The sales revenue of Franchise has shown increasing trend, while the resultant sales has shown decreasing trend.

The expenses has not been as per the increase / decrease of revenues. Hence the earnings from operations has shown changes in relation to revenue.

Part 2E: Insert your company’s financial statements here – this should fit on 4 or 5 pages

Include copies of the following financial statements from the Company’s 10-K – not abbreviated versions from Finance Yahoo or Google Finance:

· Balance sheet (may be on two pages)

· Income statement

· Statement of Cash Flows

· Statement of Changes in Stockholders’ Equity

All four statement are attached in Annual report

Part 3: Discussion of a news article about the Company

Insert your first article discussion for this company here – this should fit on one page. (You will submit a second article discussion for this company with your final project.) Please use a news article rather than an opinion piece from a blog such as Seeking Alpha.

Description of Article discussion

Include one article summary for each company in the group (for a total of four or six article summaries depending upon how many members are in your group). The articles should be dated no earlier than June 1, 2013. Summarize the article and its impact on your company or the industry (and perhaps the company’s stock price). Each article summary should include the following (at a minimum):

Citation: Title of article, author, source (e.g., WSJ, 7/29/13, p. B4), and link to article if possible

How: How does the article relate to the Company or to the industry?

Why: Your discussion of the article should highlight key points that relate to the company or the industry and hopefully to accounting

Effect: For example, did the stock price change after the event(s) described in the article?

Do NOT copy and paste from the article. Use you own words.

Part 4: Tracking your Company’s stock price

You are tracking your company’s stock price from 9/24/13 through 12/3/13. Thus, this first submission will only include a partially completed worksheet, e.g., you do not “sell” your stock. [Please insert your Stock Monitoring Worksheet here – this should fit on one page. See Blackboard for the actual Excel template.]

Stock Monitoring Worksheet

Student Name

 

 

 

 

 

 

 

Student Identification number

 

 

 

 

section

 

 

JACK IN THE BOX Inc.

Transaction Date

Ticker Symbol

Number of shares

Open

High

Low

Close

Adj Close

04-11-2013

JACK

306300

40.67

41.65

40.54

41.55

41.55

01-11-2013

JACK

283700

40.61

40.94

40.27

40.69

40.69

31-10-2013

JACK

160800

40.48

40.95

40.31

40.68

40.68

30-10-2013

JACK

114900

40.68

40.9

40.43

40.55

40.55

29-10-2013

JACK

229700

40.49

40.68

40.42

40.65

40.65

28-10-2013

JACK

176700

40.51

40.68

40.35

40.49

40.49

25-10-2013

JACK

270500

40.35

40.93

40.3

40.51

40.51

24-10-2013

JACK

235000

40.11

40.44

39.88

40.34

40.34

23-10-2013

JACK

176300

40.2

40.55

39.8

40.09

40.09

22-10-2013

JACK

338400

40.59

40.87

40.34

40.55

40.55

21-10-2013

JACK

237900

40.06

40.44

39.72

40.43

40.43

18-10-2013

JACK

243500

40.05

40.19

39.63

39.99

39.99

17-10-2013

JACK

316800

39.1

39.8

38.94

39.78

39.78

16-10-2013

JACK

192900

39.37

39.52

39.1

39.2

39.2

15-10-2013

JACK

174500

39.63

39.63

39.12

39.14

39.14

14-10-2013

JACK

161700

39.6

39.99

39.28

39.73

39.73

11-10-2013

JACK

154400

39.24

39.87

39.18

39.83

39.83

10-10-2013

JACK

188300

39.12

39.52

38.95

39.4

39.4

09-10-2013

JACK

239400

39.03

39.11

38.53

38.77

38.77

08-10-2013

JACK

197200

39.45

39.7

39.01

39.08

39.08

07-10-2013

JACK

260900

40.06

40.22

39.42

39.44

39.44

04-10-2013

JACK

152300

40.24

40.58

40.01

40.33

40.33

03-10-2013

JACK

300400

40.78

41

40.11

40.34

40.34

02-10-2013

JACK

292900

40.46

40.96

40.18

40.76

40.76

01-10-2013

JACK

244400

40

40.67

39.84

40.59

40.59

30-09-2013

JACK

224500

39.85

40.04

39.69

39.99

39.99

27-09-2013

JACK

280600

39.98

40.34

39.98

40.1

40.1

26-09-2013

JACK

345800

39.92

40.19

39.75

40.14

40.14

25-09-2013

JACK

259900

40.28

40.39

39.86

39.92

39.92

24-09-2013

JACK

242200

40.37

40.61

40.06

40.36

40.36

23-09-2013

JACK

300200

40.52

40.54

39.94

40.37

40.37

20-09-2013

JACK

655000

40.47

40.8

40.42

40.58

40.58

19-09-2013

JACK

222200

40.41

40.57

40.27

40.52

40.52

18-09-2013

JACK

221300

40.5

40.56

39.91

40.41

40.41

17-09-2013

JACK

300500

40.15

40.53

39.92

40.49

40.49

16-09-2013

JACK

153800

40.47

40.69

40.2

40.23

40.23

13-09-2013

JACK

254600

40.45

40.5

40.08

40.16

40.16

12-09-2013

JACK

257900

40.3

40.5

40.16

40.25

40.25

11-09-2013

JACK

403300

40.28

40.53

40.17

40.23

40.23

10-09-2013

JACK

340500

39.99

40.39

39.8

40.38

40.38

09-09-2013

JACK

368600

38.95

39.83

38.95

39.75

39.75