Home Suppliers, Inc. This project will give you an opportunity to evaluate financial statements and to...

Transcribed Image Text:

Home Suppliers, Inc. This project will give you an opportunity to evaluate financial statements and to make decisions based on the information presented in the financial statements of Home Suppliers, Inc. Introduction Home Suppliers, Inc. sells a variety of consumer products. Its comparative income statement and balance sheet for the years 2022 and 2021 are presented on the Req 1 tabs. The Retained Earnings balance on January 1, 2021, was $188,442. Also, Preferred Stockholder cash dividends of $5,000 were paid each year, as was $50,000 in dividends paid to Common Stockholders each year. Required: 1. Prepare a horizontal and a vertical analysis of the comparative income statement and balance sheet. 2. Calculate the following ratios for each year: a. The rate of return on net sales. b. The rate of return on common stockholders' equity. Preferred dividends are $5,000 for both years. (Remember that dividend requirements on preferred stock must be deducted from net income after taxes to obtain income available to common stockholders.) c. The earnings per share of common stock, assuming that the preferred stock is nonparticipating, noncumulative, and has no liquidation value. The number of outstanding shares of common stock remained constant at 100,000 throughout all of 2021 and 2022. d. The price-earnings ratio on common stock. The market values were $4.00 in 2021 and $3.00 in 2022. e. The rate of return on total assets. f. The ratio of stockholders' equity to total liabilities. g. The current ratio. h. The acid-test ratio. 1. The merchandise inventory turnover. Inventory was $75,000 at January 1, 2021. j. The accounts receivable turnover. Credit sales were $1,400,000 for 2022 and $1,300,000 for 2021. The beginning accounts receivable balance for 2021 was $123,500. Req 1 Comp Req 1 Comp Inc Stmt Bal Sheet Req 2A and 28 Req 2C and 20 Req 2E and 2F Req 2G and Req 21 and 2) 2H Calculate the following ratios for each year: a. The rate of return on net sales. b. The rate of return on common stockholders' equity. Preferred dividends are $5,000 for both years. (Remember that dividend requirements on preferred stock must be deducted from net income after taxes to obtain income available to common stockholders.) 2022 2021 b 2022 2021 Choose Numerator Rate of Return on Net Sales Choose Denominator Rate of return on net sales a 0% 0% Rate of Return on Common Stockholders' Equity Rate of return on common stockholders' equity 0% 0% Req 1 Comp Bal Sheet Req 20 and 20 > Show less A Home Suppliers, Inc. This project will give you an opportunity to evaluate financial statements and to make decisions based on the information presented in the financial statements of Home Suppliers, Inc. Introduction Home Suppliers, Inc. sells a variety of consumer products. Its comparative income statement and balance sheet for the years 2022 and 2021 are presented on the Req 1 tabs. The Retained Earnings balance on January 1, 2021, was $188,442. Also, Preferred Stockholder cash dividends of $5,000 were paid each year, as was $50,000 in dividends paid to Common Stockholders each year. Required: 1. Prepare a horizontal and a vertical analysis of the comparative income statement and balance sheet. 2. Calculate the following ratios for each year: a. The rate of return on net sales. b. The rate of return on common stockholders' equity. Preferred dividends are $5,000 for both years. (Remember that dividend requirements on preferred stock must be deducted from net income after taxes to obtain income available to common stockholders.) c. The earnings per share of common stock, assuming that the preferred stock is nonparticipating, noncumulative, and has no liquidation value. The number of outstanding shares of common stock remained constant at 100,000 throughout all of 2021 and 2022. d. The price-earnings ratio on common stock. The market values were $4.00 in 2021 and $3.00 in 2022. e. The rate of return on total assets. f. The ratio of stockholders' equity to total liabilities. g. The current ratio. h. The acid-test ratio. 1. The merchandise inventory turnover. Inventory was $75,000 at January 1, 2021. j. The accounts receivable turnover. Credit sales were $1,400,000 for 2022 and $1,300,000 for 2021. The beginning accounts receivable balance for 2021 was $123,500. Req 1 Comp Req 1 Comp Inc Stmt Bal Sheet Req 2A and 28 Req 2C and 20 Req 2E and 2F Req 2G and Req 21 and 2) 2H Calculate the following ratios for each year: a. The rate of return on net sales. b. The rate of return on common stockholders' equity. Preferred dividends are $5,000 for both years. (Remember that dividend requirements on preferred stock must be deducted from net income after taxes to obtain income available to common stockholders.) 2022 2021 b 2022 2021 Choose Numerator Rate of Return on Net Sales Choose Denominator Rate of return on net sales a 0% 0% Rate of Return on Common Stockholders' Equity Rate of return on common stockholders' equity 0% 0% Req 1 Comp Bal Sheet Req 20 and 20 > Show less A