Sign In
Not register? Register Now!
Pages:
1 page/≈275 words
Sources:
Level:
APA
Subject:
Accounting, Finance, SPSS
Type:
Math Problem
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 4.68
Topic:

Preparing and Analyzing Financial Statements (Math Problem Sample)

Instructions:


Purpose: Prepare a well-written analysis of the financial statements.
Requirements:
A. Obtain the financial statements for the past four fiscal years for the company you selected. This may require using older annual reports that are available on the company’s website.
B. Prepare a MULTI-STEP income statement, classified balance sheet, and statement of cash flows in condensed format for the past four fiscal years. Condensed means some accounts are grouped into one summarized subtotal, but no numbers are left out of the computations. Each financial statement should total properly. 
C. Using the condensed financial statements, prepare a trend analyses for the income statement, trend analyses balance sheet, and the sources and uses of cash statement for the past four fiscal years. 
D. Using the condensed financial statements, preparecommon-sized financial statements for the income statement, balance sheet, and the sources and uses of cash statement for the past four fiscal years. 
E. Submit one page of written analysis. Comment on significant amounts, trends, and relationships. When appropriate, reference amounts from the trend analyses and common-size statements. 

source..
Content:

PREPARE AND ANALYZE FINANCIAL STATEMENTS - FROM THE TIM HORTONS ANALYSIS
Name:
Institution:
Date:
CASH FLOW INFORMATION

MULTI-STEP CONDENCED CASH FLOW

COMMON SIZE CASH FLOW

 

 

 

 

 

 

 

 

 

Year ended December 31 (millions)

2014

2013

2012

2011

2014

2013

2012

2011

Net Cash provided by continuing operations

1,815.6

1,559.8

1,203.0

685.5

12.71%

11.77%

10.16%

10.08%

Less:Net Cash used for investing activities

(848.3)

(2,087.7)

(487.9)

(2,024.3)

-5.94%

-15.75%

-4.12%

-29.78%

Net Cash provided by (used for) financing activities

(1,071.0)

(292.6)

(1,393.6)

2,933.8

-7.50%

-2.21%

-11.77%

43.15%

Effect of exchange rate changes on cash and cash equivalents

(25.9)

1.9

(7.3)

6.3

-0.18%

0.01%

-0.06%

0.09%

Increase (Decrease) in cash and cash equivalents

(129.6)

(818.6)

(685.8)

1,601.3

-0.91%

-6.18%

-5.79%

23.55%

Add:Cash and cash equivalents, beginning of year

339.2

1,157.8

1,843.6

242.3

2.38%

8.74%

15.57%

3.56%

Cash and cash equivalents, end of year

$ 209.6

$ 339.2

$ 1,157.8

$ 1,843.6

1.47%

2.56%

9.78%

27.12%

 

 

 

 

 

 


 




 



 

BALANCE SHEET INFORMATION

MULTI-STEP CONDENCED BALANCE SHEET

COMMON SIZE BALANCE SHEET

 

 

 

 

 

 

 

 

 

December 31 (millions, except per share)

2014

2013

2012

2011

2014

2013

2012

2011

 

 

 

 

 

 

 

 

 

Total current assets

4,871.1

4,698.4

4,892.0

5,396.0

25.02%

23.93%

27.84%

29.67%

Total fixed assets

14,595.6

14,938.1

12,680.3

12,788.7

74.98%

76.07%

72.16%

70.33%

Total assets

$ 19,466.7

$ 19,636.5

$ 17,572.3

$ 18,184.7

100.00%

100.00%

100.00%

100.00%

 

 

 

 

 

 

 

 

 

Liabilities and Equity

 

 

 

 

 

 

 

 

Total current liabilities

4,386.6

3,488.7

3,052.7

3,166.3

36.30%

28.53%

26.75%

25.45%

Total long term liabilities

7,698.0

8,738.4

8,359.5

9,277.3

63.70%

71.47%

73.25%

74.55%

Total liabilities

12,084.6

12,227.1

11,412.2

12,443.6

100.00%

100.00%

100.00%

100.00%

Total equity

7,382.1

7,409.4

6,160.1

5,741.1

37.92%

37.73%

35.06%

31.57%

Total liabilities and equity

$ 19,466.7

$ 19,636.5

$ 17,572.3

$ 18,184.7

100.00%

100.00%

100.00%

100.00%

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


 




 



 

STATEMENT OF INCOME INFORMATION

MULTI-STEP CONDENCED INCOME STATEMENT

COMMON SIZE INCOME STATEMENT

 

 

 

 

 

 

 

 

 

Year ended December 31 (millions, except per share, employees)

2014

2013

2012

2011

2014

2013

2012

2011

 

 

 

 

 

 

 

 

 

Sales

14,280.5

13,253.4

11,838.7

6,798.5

100.00%

100.00%

100.00%

100.00%

Less:Cost of sales

7,679.1

7,161.2

6,385.4

3,475.6

53.77%

54.03%

53.94%

51.12%

Gross Profit

6,601.4

6,092.2

5,453.3

3,322.9

46.23%

45.97%

46.06%

48.88%

Less:Expenses

4,646.4

4,531.6

Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:

Other Topics:

  • Math Problem: Accounting Equation
    Description: Show the effect of the above transactions on the accounting equation...
    1 page/≈275 words| APA | Accounting, Finance, SPSS | Math Problem |
  • Capital Budgeting-Asset Replacement Assignment
    Description: The Conch Republic Electronics mini-case will allow you to apply the cash flow models for evaluating capital decisions....
    3 pages/≈825 words| APA | Accounting, Finance, SPSS | Math Problem |
  • Cash Flow Statement
    Description: Cash Flow Statement Accounting Math Problem...
    1 page/≈275 words| APA | Accounting, Finance, SPSS | Math Problem |
Need a Custom Essay Written?
First time 15% Discount!