Prepare and Analysis Financial Statement (Other (Not Listed) Sample)
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, prepare common-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.
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
Other Topics:
- Monitoring as a Motivation for IPO Under PricingDescription: During an Initial Public Offer (IPO), insiders make several considerations that would enable them meet their goals. One of the considerations made by the insiders is under-pricing of the Issue. Under-pricing generates excess demand, which leads to biased rationing against large investors who usually have ...1 page/≈275 words| APA | Literature & Language | Other (Not Listed) |
- Monitoring as a Motivation for IPO Underpricing (Essay #2)Description: During an Initial Public Offer (IPO), insiders make several considerations that would enable them meet their goals...1 page/≈275 words| APA | Literature & Language | Other (Not Listed) |
- Experimental DesignsDescription: Some of the concepts discussed in the paper include Analysis of Variance (ANOVA),probabilistic equivalence,and independent variables amomg others....5 pages/≈1375 words| APA | Literature & Language | Other (Not Listed) |