hw14

pdf

School

San Diego Mesa College *

*We aren’t endorsed by this school

Course

116A

Subject

Finance

Date

Apr 3, 2024

Type

pdf

Pages

10

Uploaded by GeneralTeamAardvark18

Report
1. PR.14.01B.ALGO (Algorithmic) Horizontal Analysis of Income Statement For 20Y2, Macklin Inc. reported a significant decrease in net income. At the end of the year, John Mayer, the president, is presented with the following condensed comparative income statement: Macklin Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $574,504 $484,000 Cost of goods sold (427,800) (310,000) Gross profit $146,704 $174,000 Selling expenses $(60,480) $(41,000) Administrative expenses (34,890) (26,000) Total operating expenses $(95,370) $(67,000) Operating income $51,334 $107,000 Other revenue 2,492 2,000 Income before income tax expense $53,826 $109,000 Income tax expense (15,100) (32,700) Net income $38,726 $76,300 Required: 1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Use the minus sign to indicate a decrease in the "Increase/(Decrease)" columns. If required, round percentages to one decimal place. Macklin Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Increase/ (Decrease) Amount Increase/ (Decrease) Percent Sales $574,504 $484,000 $ % Cost of goods sold (427,800) (310,000) % Gross profit $146,704 $174,000 $ % Selling expenses $(60,480) $(41,000) $ % Administrative expenses (34,890) (26,000) % Total operating expenses $(95,370) $(67,000) $ % Operating income $51,334 $107,000 $ % Other revenue
2. PR.14.02B 2,492 2,000 % Income before income tax expense $53,826 $109,000 $ % Income tax expense (15,100) (32,700) % Net income $38,726 $76,300 $ % 2. Net income has from 20Y1 to 20Y2. Sales have ; however, the cost of goods sold has at a faster rate than sales, causing the gross profit to . Vertical Analysis of Income Statement For 20Y2, Fielder Industries Inc. initiated a sales promotion campaign that included the expenditure of an additional $40,000 for advertising. At the end of the year, Leif Grando, the president, is presented with the following condensed comparative income statement: Fielder Industries Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $1,300,000 $1,180,000 Cost of goods sold (682,500) (613,600) Gross profit $617,500 $566,400 Selling expenses $(260,000) $(188,800) Administrative expenses (169,000) (177,000) Total operating expenses $(429,000) $(365,800) Operating income $188,500 $200,600 Other revenue 78,000 70,800 Income before income tax expense $266,500 $271,400 Income tax expense (117,000) (106,200) Net income $149,500 $165,200 Required: 1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in relationship to sales for each of the years. Round to one decimal place. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Fielder Industries Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 Amount 20Y2 Percent 20Y1 Amount 20Y1 Percent Sales $1,300,000 % $1,180,000 %
3. PR.14.03B Cost of goods sold (682,500) % (613,600) % Gross profit $617,500 % $566,400 % Selling expenses $(260,000) % (188,800) % Administrative expenses (169,000) % (177,000) % Total operating expenses $(429,000) % $(365,800) % Operating income $188,500 % $200,600 % Other revenue 78,000 % 70,800 % Income before income tax expense $266,500 % $271,400 % Income tax expense (117,000) % (106,200) % Net income $149,500 % $165,200 % 2. The net income as a percent of sales has . All the costs and expenses, other than selling expenses, have maintained their approximate cost as a percent of sales relationship between 20Y1 and 20Y2. Selling expenses as a percent of sales, however, have . Apparently, the new advertising campaign been successful. The increased expense produced sufficient sales to maintain relative profitability. Thus, selling expenses as a percent of sales have . Effect of Transactions on Current Position Analysis Data pertaining to the current position of Lucroy Industries Inc. are as follows: Cash $800,000 Marketable securities 550,000 Accounts and notes receivable (net) 850,000 Inventories 700,000 Prepaid expenses 300,000 Accounts payable 1,200,000 Notes payable (short-term) 700,000 Accrued expenses 100,000 Required: 1. Compute (a) the working capital , (b) the current ratio , and (c) the quick ratio . Round ratios to one decimal place. a. Working capital $ b. Current ratio
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
4. PR.14.05B c. Quick ratio 2. Compute the working capital, the current ratio, and the quick ratio after each of the following transactions, and record the results in the appropriate columns. Consider each transaction separately and assume that only that transaction affects the data given. Round ratios to one decimal place. Transaction Working Capital Current Ratio Quick Ratio a. Sold marketable securities at no gain or loss, $500,000. $ b. Paid accounts payable, $287,500. c. Purchased goods on account, $400,000. d. Paid notes payable, $125,000. e. Declared a cash dividend, $325,000. f. Declared a common stock dividend on common stock, $150,000. g. Borrowed cash from bank on a long-term note, $1,000,000. h. Received cash on account, $75,000. i. Issued additional shares of stock for cash, $2,000,000. j. Paid cash for prepaid expenses, $200,000. Solvency and Profitability Trend Analysis Crosby Company has provided the following comparative information: 20Y8 20Y7 20Y6 20Y5 20Y4 Net income $5,571,720 $3,714,480 $2,772,000 $1,848,000 $1,400,000 Interest expense 1,052,060 891,576 768,600 610,000 500,000 Income tax expense 1,225,572 845,222 640,320 441,600 320,000 Total assets (ending balance) 29,378,491 22,598,839 17,120,333 12,588,480 10,152,000 Total stockholders’ equity (ending balance) 18,706,200 13,134,480 9,420,000 6,648,000 4,800,000 Average total assets 25,988,665 19,859,586 14,854,406 11,370,240 8,676,000 Average total stockholders' equity 15,920,340 11,277,240 8,034,000 5,724,000 4,100,000 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years: 20Y4–20Y8 Return on total assets 19% Return on stockholders’ equity 26% Times interest earned 3.4 Ratio of liabilities to stockholders’ equity 1.4 Required:
1. Determine the following for the years 20Y4 through 20Y8 for each of the graphs below. Use the amounts given above in your calculations. Round to one decimal place. a. Return on total assets : 20Y8 % 20Y7 % 20Y6 % 20Y5 % 20Y4 % b. Return on stockholders’ equity :
20Y8 % 20Y7 % 20Y6 % 20Y5 % 20Y4 % c. Times interest earned :
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
20Y8 20Y7 20Y6 20Y5 20Y4 d. Ratio of liabilities to stockholders' equity :
5. PR.14.04B 20Y8 20Y7 20Y6 20Y5 20Y4 2. Refer to the selected industry ratios provided above. Overall, these ratios indicate financial performance coupled with use of debt (leverage). Measures of liquidity, Solvency and Profitability The comparative financial statements of Stargel Inc. are as follows. The market price of Stargel common stock was $119.70 on December 31, 20Y2. Stargel Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Retained earnings, January 1 $5,375,000 $4,545,000 Net income $900,000 $925,000 Dividends: On preferred stock (45,000) (45,000) On common stock (50,000) (50,000) Increase in retained earnings $805,000 $830,000 Retained earnings, December 31 $6,180,000 $5,375,000
Stargel Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $10,000,000 $9,400,000 Cost of goods sold (5,350,000) (4,950,000) Gross profit $4,650,000 $4,450,000 Selling expenses $(2,000,000) $(1,880,000) Administrative expenses (1,500,000) (1,410,000) Total operating expenses $(3,500,000) $(3,290,000) Operating income $1,150,000 $1,160,000 Other revenue and expense: Other revenue 150,000 140,000 Other expense (interest) (170,000) (150,000) Income before income tax expense $1,130,000 $1,150,000 Income tax expense (230,000) (225,000) Net income $900,000 $925,000 Stargel Inc. Comparative Balance Sheet December 31, 20Y2 and 20Y1 20Y2 20Y1 Assets Current assets: Cash $500,000 $400,000 Marketable securities 1,010,000 1,000,000 Accounts receivable (net) 740,000 510,000 Inventories 1,190,000 950,000 Prepaid expenses 250,000 229,000 Total current assets $3,690,000 $3,089,000 Long-term investments 2,350,000 2,300,000 Property, plant, and equipment (net) 3,740,000 3,366,000 Total assets $9,780,000 $8,755,000 Liabilities Current liabilities $900,000 $880,000 Long-term liabilities: Mortgage note payable, 10% $200,000 $0 Bonds payable, 10% 1,500,000 1,500,000 Total long-term liabilities $1,700,000 $1,500,000 Total liabilities $2,600,000 $2,380,000 Stockholders' Equity Preferred $0.90 stock, $10 par $500,000 $500,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Common stock, $5 par 500,000 500,000 Retained earnings 6,180,000 5,375,000 Total stockholders' equity $7,180,000 $6,375,000 Total liabilities and stockholders' equity $9,780,000 $8,755,000 Required: Determine the following measures for 20Y2, rounding to one decimal place, except dollar amounts which should be rounded to the nearest cent. Use the rounded answer of the requirement for subsequent requirement, if required. Assume 365 days a year. 1. Working capital $ 2. Current ratio 3. Quick ratio 4. Accounts receivable turnover 5. Number of days' sales in receivables days 6. Inventory turnover 7. Number of days' sales in inventory days 8. Ratio of fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders' equity 10. Times interest earned 11. Asset turnover 12. Return on total assets % 13. Return on stockholders’ equity % 14. Return on common stockholders’ equity % 15. Earnings per share on common stock $ 16. Price-earnings ratio 17. Dividends per share of common stock $ 18. Dividend yield %