CP13-2 Analyzing Comparative Financial Statements Using Selected Ratios [LO 13-4
ID: 2592167 • Letter: C
Question
CP13-2 Analyzing Comparative Financial Statements Using Selected Ratios [LO 13-4, LO 13-5] The comparative financial statements prepared at December 31 for Golden Corporation showed the following summarized data: Current Previous Income Statement Sales revenue $ 260,000 $ 229,000 Cost of goods sold 142,000 132,000 Gross profit 118,000 97,000 Operating expenses 69,300 63,200 Interest expense 4,300 4,200 Income before income taxes 44,400 29,600 Income tax expense 13,320 4,600 Net income $ 31,080 $ 25,000 Balance Sheet Cash $ 7,480 $ 9,600 Accounts receivable (net) 35,000 31,000 Inventory 56,000 51,000 Property and equipment (net) 61,000 54,000 $ 159,480 $ 145,600 Current liabilities $ 16,000 $ 30,200 Note payable (long-term) 61,000 61,000 Common stock (par $5) 39,600 39,600 Additional paid-in capital 8,200 6,600 Retained earnings* 34,680 8,200 $ 159,480 $ 145,600 *During the current year, cash dividends of $4,600 were declared and paid. Required: 1-a. Compute the gross profit percentage for the current and previous years. (Round your answers to 1 decimal place.) 1-b. Are the current year results better, or worse, than those for the previous year? Better Worse 2-a. Compute the net profit margin for the current and previous years. (Round your answers to 1 decimal place.) 2-b. Are the current year results better, or worse, than those for the previous year? Better Worse 3-a. Compute the earnings per share for the current and previous years. TIP: To calculate EPS, use the balance in Common Stock to determine the number of shares outstanding. Common Stock equals the par value per share times the number of shares. (Round your answers to 2 decimal places.) 3-b. Are the current year results better, or worse, than those for the previous year? Better Worse 4-a. Stockholders’ equity totaled $39,600 at the beginning of the previous year. Compute the return on equity (ROE) ratios for the current and previous years. (Round your answers to 1 decimal place.) 4-b. Are the current year results better, or worse, than those for the previous year? Better Worse 5-a. Net property and equipment totaled $43,000 at the beginning of the previous year. Compute the fixed asset turnover ratios for the current and previous years. (Round your answers to 2 decimal places.) 5-b. Are the current year results better, or worse, than those for the previous year? Better Worse 6-a. Compute the debt-to-assets ratios for the current and previous years. (Round your answers to 2 decimal places.) 6-b. Is debt providing financing for a larger or smaller proportion of the company’s asset growth? Larger Proportion Smaller Proportion 7-a. Compute the times interest earned ratios for the current and previous years. (Round your answers to 1 decimal place.) 7-b. Are the current year results better, or worse, than those for the previous year? Better Worse 8-a. After Golden released its current year’s financial statements, the company’s stock was trading at $46. After the release of its previous year’s financial statements, the company’s stock price was $34 per share. Compute the P/E ratios for both years. (Round your intermediate calculations and final answers to 2 decimal places.) 8-b. Does it appear that investors have become more (or less) optimistic about Golden’s future success? More Optimistic Less Optimistic
FIRST NUMBERS ARE CURRENT SECOND ARE PREVIOUS. I have first 2 answers, the rest i do not. Please help! I will give thumbs up if correct :)
Explanation / Answer
current year
gross profit ratio
previous year
gross profit ratio
1-
gross profit ratio
gross profit/ sales
118000/260000
45.38%
97000/229000
42.36%
it is better than previous year
2-
net profit ratio
net profit/sales
31080/260000
12.0%
25000/229000
10.9%
it is better than previous year
3-
EPS
NET INCOME/NO OF SHARES
31080/7920
3.924242
25000/7920
3.1565657
it is better than previous year
NO OF SHARE
39600/5
7920
4-
RETURN ON EQUITY
NET INCOME/AVERAGE SHARE HOLDERS EQUITY
31080/68440
45.41%
25000/47000
53.19%
IT IS WORSE THAN PREVIOUS YEAR
AVERAGE SHARE HOLDER EQUITY = (OPENING + CLOSING)/2
68440
47000
5-
FIXED ASSET TURNOVER RATIO
SALES / AVERAGE FIXED ASSETS
260000/56000
4.642857
229000/48500
4.7216495
IT IS WORSE THAN PREVIOUS YEAR
AVERAGE FIXED ASSETS = (OPENING + CLOSING)/2
56000
48500
6-
DEBT TO ASSET RATIO
TOTAL OF LIABILITIES/TOTAL OF ASSETS
(16000+61000)/159480
0.482819
(30200+61000)/145600
0.6263736
SMALLER PORTION
7-
TIMES INTEREST EARNED
EBIT/INTEREST
(118000-69300)/4300
11.32558
(132000-63200)/4200
16.380952
IT IS WORSE THAN PREVIOUS YEAR
8-
PE RATIO
MARKET PRICE/EPS
46/3.92
11.73469
34/3.156
10.773131
OPTIMISTIC
current year
gross profit ratio
previous year
gross profit ratio
1-
gross profit ratio
gross profit/ sales
118000/260000
45.38%
97000/229000
42.36%
it is better than previous year
2-
net profit ratio
net profit/sales
31080/260000
12.0%
25000/229000
10.9%
it is better than previous year
3-
EPS
NET INCOME/NO OF SHARES
31080/7920
3.924242
25000/7920
3.1565657
it is better than previous year
NO OF SHARE
39600/5
7920
4-
RETURN ON EQUITY
NET INCOME/AVERAGE SHARE HOLDERS EQUITY
31080/68440
45.41%
25000/47000
53.19%
IT IS WORSE THAN PREVIOUS YEAR
AVERAGE SHARE HOLDER EQUITY = (OPENING + CLOSING)/2
68440
47000
5-
FIXED ASSET TURNOVER RATIO
SALES / AVERAGE FIXED ASSETS
260000/56000
4.642857
229000/48500
4.7216495
IT IS WORSE THAN PREVIOUS YEAR
AVERAGE FIXED ASSETS = (OPENING + CLOSING)/2
56000
48500
6-
DEBT TO ASSET RATIO
TOTAL OF LIABILITIES/TOTAL OF ASSETS
(16000+61000)/159480
0.482819
(30200+61000)/145600
0.6263736
SMALLER PORTION
7-
TIMES INTEREST EARNED
EBIT/INTEREST
(118000-69300)/4300
11.32558
(132000-63200)/4200
16.380952
IT IS WORSE THAN PREVIOUS YEAR
8-
PE RATIO
MARKET PRICE/EPS
46/3.92
11.73469
34/3.156
10.773131
OPTIMISTIC