Selected data taken from a recent year’s financial statements of trading card company Topps Company, Inc. are as follows (in millions).
Net sales
$326.7
Current liabilities, beginning of year
41.1
Current liabilities, end of year
62.4
Net cash provided by operating activities
10.4
Total liabilities, beginning of year
65.2
Total liabilities, end of year
73.2
Capital expenditures
3.7
Cash dividends
6.2
Compute these ratios: current cash debt coverage ratio, cash debt coverage ratio, and free cash flow. Provide a brief interpretation of your results. (Round answers to 2 decimal places, e.g. 0.12.)
Current cash debt coverage ratio
Vertical analysis (common-size) percentages for Vallejo Company’s sales, cost of goods sold, and expenses are listed here.
Vertical Analysis
2012
2011
2010
Sales
100
%
100
%
100
%
Cost of goods sold
62.9
64.3
65.2
Expenses
24.1
27.7
28.7
Did Vallejo’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period? Provide numerical support for your answer.
Using these data from the comparative balance sheet of Rosalez Company, perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.)
Dec. 31, 2012
Dec. 31, 2011
Amount
Percentage
Amount
Percentage
Accounts receivable
$ 549,400
[removed]
%
$ 372,000
[removed]
%
Inventory
$ 748,300
[removed]
%
$ 571,200
[removed]
%
Total assets
$3,100,600
[removed]
%
$2,763,400
[removed]
%
Using these data from the comparative balance sheet of Rosalez Company, perform horizontal analysis. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 0 decimal places, e.g. 12%.)
20
0 comments